DT_MEMBER - Record members information. Information are mandatory for system contraints, such identification.

Columns

CodeTypeDescription
MEB_IDNumberIdentifier - Auto-generated
ORG_IDForeign KeyLink to organisation
ROL_CDSystemRole in the organisation
GND_CDSystemGender
MEB_VA_LOGINString(50)Login, unique within the organisation and mandatory
MEB_VA_PASSWORDString(50)Encrypted password
MEB_VA_FIRSTNAMEString(255)First name
MEB_VA_LASTNAMEString(255)Last name, mandatory
MEB_DT_BIRTHDateBirth date, mandatory
MEB_VA_EMAILString(50)Email
MEB_VA_PHONEString(50)Phone
MEB_VA_BUSINESSPHONEString(50)Business phone
MEB_VA_MOBILEString(50)Mobile
MEB_BL_VALIDBooleanMember base information are valid

References