The User_Details table holds information about the users. The information held is the one-off information aboit the user, such as names, logins and company associations.
| Column Name | Field Type | Field Length | Nullable | Auto Incement | Default Value | Foreign Key | Indexed | Additional Info | Comment |
|---|---|---|---|---|---|---|---|---|---|
| user_id | Integer | 8 | Not Null | Yes | 0 | Yes | Yes | Unsigned, ZeroFill | A synthetic user id |
| logon_id | Varchar | 20 | Not Null | No | ““ | Yes | Yes | The user's login id. Either this field or the email field can be used for user authentication | |
| email_address | Varchar | 45 | Not Null | No | ”“ | Yes | Yes | The user's email address. Either this field or the login field can be used for user authentication | |
| salutation | Varchar | 10 | Null | No | Null | Yes | Yes | The user's greeting | |
| forename | Varchar | 20 | Not Null | No | Null | Yes | Yes | The user's forename | |
| surname | Varchar | 45 | Not Null | No | Null | Yes | Yes | The user's surname | |
| user_pass | Varchar | 50 | Not Null | No | ”“ | Yes | Yes | The secure form of the user's password | |
| company_id | Integer | 5 | Not Null | No | 0 | Yes | Yes | The user's company | |
| division_id | Integer | 5 | Not Null | No | 0 | Yes | Yes | The user's division in the company | |
| team_id | Integer | 5 | Not Null | No | 0 | Yes | Yes | The user's team in the company |
| Index Name | Index Kind | Index Type | Fields |
|---|---|---|---|
| Primary | Primary | BTree | user_id |
| logon_idx | Unique | Btree | logon_id |
| email_idx | Unique | Btree | email_address |
| Foreign Key Name | Action Trigger | Reference Table | Reference Column |
|---|---|---|---|