DT_MEMBER - Record members information. Information are mandatory for system contraints, such identification.
Code | Type | Description |
MEB_ID | Number | Identifier - Auto-generated |
ORG_ID | Foreign Key | Link to organisation |
ROL_CD | System | Role in the organisation |
GND_CD | System | Gender |
MEB_VA_LOGIN | String(50) | Login, unique within the organisation and mandatory |
MEB_VA_PASSWORD | String(50) | Encrypted password |
MEB_VA_FIRSTNAME | String(255) | First name |
MEB_VA_LASTNAME | String(255) | Last name, mandatory |
MEB_DT_BIRTH | Date | Birth date, mandatory |
MEB_VA_EMAIL | String(50) | |
MEB_VA_PHONE | String(50) | Phone |
MEB_VA_BUSINESSPHONE | String(50) | Business phone |
MEB_VA_MOBILE | String(50) | Mobile |
MEB_BL_VALID | Boolean | Member base information are valid |