|
 | Admin Ind | char(1) | NotNull | Provides the security group for the user.
N - no admin rights
Y - administrator with the ability to add, update and delete person, companies, invoices and payments
S - superuser who can also add users and reset passwords |
| First Name | varchar(30) | NotNull | The person's given name. |
| Last Name | varchar(30) | NotNull | Person's surname or family name. |
| Person Id | INTEGER | Null | A generated number to identify a person. |
| Pwd | varchar(40) | NotNull | Encrypted password. |
| Pwd Change Ind | ENUM('Y','N') | Null | If set to Y then a password change will be forced the next time that the user logs in. |
| Title | varchar(40) | Null | Job title e.g. Data Architect |
| User Id | integer | NotNull | A generated number to identify a user. |
| User Name | varchar(15) | NotNull | The name of the relevant user as used for logging into the system, e.g jtench. |