===== Details on User_Details =====

==== Table Purpose ====

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.

==== Table Structure ====

^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|

==== Indicies ====

^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 Keys / Constraints ====

^Foreign Key Name^Action Trigger^Reference Table^Reference Column^
| | | | |