Project Data Tables Database > td Schema : td.USERS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
US_ID | The record ID. | int | 4 | ||||
US_USERNAME | The user name. | varchar | 60 | ||||
US_MAIL_ADDRESS | Not in use. Retained in schema for backward compatibility. | varchar | 255 | ||||
US_PASSWORD | Not in use. Retained in schema for backward compatibility. | varchar | 100 | ||||
US_GROUP | A bit mask that specifies the groups to which the user belongs. If bit X is set, the user belongs to the group identified with GROUPS.GR_GROUP_ID = X. | varchar | 512 | ||||
US_ADDRESS | Not in use. Retained in schema for backward compatibility. | varchar | 16 | ||||
US_PHONE | Not in use. Retained in schema for backward compatibility. | varchar | 20 | ||||
US_FULLNAME | Not in use. Retained in schema for backward compatibility. | varchar | 255 |
Index | Description | Primary | Unique |
---|---|---|---|
US_PRIMARYKEY |