The ARF_USER table contains information from the user’s profile.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | int | No | Identifier; primary key. | |
NUSER_ID | varchar | 40 | No | Natural key of user. |
LOGIN | varchar | 40 | No | User’s login. |
FIRST_NAME | varchar | 40 | Yes | User’s first name. |
MIDDLE_NAME | varchar | 40 | Yes | User’s middle name. |
LAST_NAME | varchar | 40 | Yes | User’s last name. |
varchar | 255 | Yes | User’s email address. | |
DATE_OF_BIRTH | date | Yes | User’s date of birth. | |
LANG_ID | smallint | No | Identifier of language from the ARF_LANGUAGE table. | |
GENDER_ID | tinyint | No | Identifier of gender from the ARF_GENDER table. | |
MARITAL_STATUS_ID | tinyint | No | Identifier of marital status from the ARF_MARITAL_STATUS table. | |
HOME_REGION_ID | smallint | No | Identifier of the region of the user’s home address, from the ARF_GEO_REGION table. | |
RECORD_LAST_UPDATE | timestamp | Yes | Date the record was last updated. | |
RECORD_START_DATE | timestamp | Yes | Date when the information in this warehouse record became effective | |
RECORD_END_DATE | timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
MOST_RECENT | one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes | |
DELETED | one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |