EN | FR | DE | IT
home | previous | index | search

Database

LionsBase is using many database relations between tables such as a member and her 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 Multi-District LionsBase Master without adapting the code itself to keep the semantic of the application.

Clubs

Types of clubs

Constant Value
CLUB_TYPE_LIONS 1
CLUB_TYPE_LEO_ALPHA 3
CLUB_TYPE_LEO_OMEGA 4
CLUB_TYPE_SPECIAL 254

Accepted Genders

Constant Value
GENDER_TYPE_UNKNOWN 0
GENDER_TYPE_MEN 1
GENDER_TYPE_WOMEN 2
GENDER_TYPE_MIXED 3

Relation to a Member

Constant Value
RELATION_GUIDING_LION 1
RELATION_ADVISOR 2

Members

Statuses

Constant Value Type
STATUS_ACTIVE 1 valid
STATUS_PASSIVE 2 valid
STATUS_HONOURING 3 valid
STATUS_PRIVILEGED 4 valid
STATUS_LIFETIME 5 valid
STATUS_ASSOCIATED 6 valid
STATUS_AFFILIATED 7 valid
STATUS_RESIGNED 8 terminated
STATUS_TRANSFERED 9 terminated
STATUS_DECEASED 10 terminated
STATUS_SERVICE 70 service
STATUS_FUNCTIONAL 80 functional
STATUS_DUPLICATE 99 duplicate

Types of Functions

Constant Value Description
FUNCTION_BOARD 1 Executive board
FUNCTION_OFFICER 2 Officer of the executive board
FUNCTION_AUDITOR 3 Auditor of the executive board

Natures of Functions

Constant Value
FUNCTION_NATURE_LEADERSHIP 0
FUNCTION_NATURE_OTHER 1
FUNCTION_NATURE_INTERNAL 2

Social Activities

Constant Value
ACTIVITY_PLANNED 0
ACTIVITY_CONFIRMED 1

Events

Types of Events

Constant Value Description
EVENT_SIMPLE 0 Simple event
EVENT_REGISTRATION 1 Event with registration
EVENT_QUESTIONS 2 Event with registration and questions

Natures of Events

Constant Value Description
NATURE_DEFAULT 0 Default
NATURE_CLOSED 1 Closed event (invitation only)
NATURE_NATIONAL_CONVENTION 2 National Convention
NATURE_FORMATION 3 Formation

Types of Questions

Constant Value Description
QUESTION_TYPE_HEADER 1 Title
QUESTION_TYPE_RADIO 2 Radio buttons (single choice)
QUESTION_TYPE_CHECKBOX 3 Checkboxes (yes/no answers)
QUESTION_TYPE_TEXT 4 Single line of text
QUESTION_TYPE_NUMERIC 5 Numeric field
QUESTION_TYPE_TEXTAREA 6 Remark text area
QUESTION_TYPE_DESCRIPTION 7 Description
Documentation created using Sphinx 1.8.3 and integrated in TYPO3 with restdoc.