The ARF_USER
table contains information from the user’s profile.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| int | No | Identifier; primary key. | |
| varchar | 40 | No | Natural key of user. |
| varchar | 40 | No | User’s login. |
| varchar | 40 | Yes | User’s first name. |
| varchar | 40 | Yes | User’s middle name. |
| varchar | 40 | Yes | User’s last name. |
| varchar | 255 | Yes | User’s email address. |
| date | Yes | User’s date of birth. | |
| smallint | No | Identifier of language from the | |
| tinyint | No | Identifier of gender from the | |
| tinyint | No | Identifier of marital status from the | |
| smallint | No | Identifier of the region of the user’s home address, from the | |
| integer | No | Identifier of the user’s organization. Foreign key to the | |
| timestamp | Yes | Date the record was last updated. | |
| timestamp | Yes | Date when the information in this warehouse record became effective | |
| timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
| one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes | |
| one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |