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 Multiple 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 4.3.2 and integrated in TYPO3 with restdoc.