| 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 | ![]() | ![]() |