Database¶
LionsBase is using many database relations between tables such as a member and their associated functions but some fields are not relations but simple constants. The rationale is that they are part of the core domain model of LionsBase and cannot be manually updated by a Multiple District LionsBase Master without adapting the code itself to keep the semantic of the application.
Clubs¶
Types of clubs¶
Constant |
Value |
|---|---|
|
1 |
|
3 |
|
4 |
|
254 |
Accepted Genders¶
Constant |
Value |
|---|---|
|
0 |
|
1 |
|
2 |
|
3 |
Relation to a Member¶
Constant |
Value |
|---|---|
|
1 |
|
2 |
Members¶
Statuses¶
Constant |
Value |
Type |
|---|---|---|
|
1 |
valid |
|
2 |
valid |
|
3 |
valid |
|
4 |
valid |
|
5 |
valid |
|
6 |
valid |
|
7 |
valid |
|
8 |
terminated |
|
9 |
terminated |
|
10 |
terminated |
|
70 |
|
|
80 |
|
|
99 |
Types of Functions¶
Constant |
Value |
Description |
|---|---|---|
|
1 |
Executive board |
|
2 |
Officer of the executive board |
|
3 |
Auditor of the executive board |
Natures of Functions¶
Constant |
Value |
|---|---|
|
0 |
|
1 |
|
2 |
Events¶
Types of Events¶
Constant |
Value |
Description |
|---|---|---|
|
0 |
Simple event |
|
1 |
Event with registration |
|
2 |
Event with registration and questions |
Natures of Events¶
Constant |
Value |
Description |
|---|---|---|
|
0 |
Default |
|
1 |
Closed event (invitation only) |
|
2 |
National Convention |
|
3 |
Formation |
Types of Questions¶
Constant |
Value |
Description |
|---|---|---|
|
1 |
Title |
|
2 |
Radio buttons (single choice) |
|
3 |
Checkboxes (yes/no answers) |
|
4 |
Single line of text |
|
5 |
Numeric field |
|
6 |
Remark text area |
|
7 |
Description |
Social Activities¶
Constant
Value
ACTIVITY_PLANNED0
ACTIVITY_CONFIRMED1