Name |
Definition |
Datatype |
Required |
Is PK |
Is FK |
Account Identifier |
An Account Identifier is a unique value assigned to represent a certain database account that has special priviledges needed by the Staff to maintain the Application Database. |
INTEGER |
Yes |
Yes |
No |
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
Yes |
No |
Yes |
User Identifier |
A User Identifier is an alphanumeric value used to depict a Staff or an Application which must access the database. |
VARCHAR(25) |
Yes |
No |
No |
Account Description |
An Account Description is the free form text that describes the Account or User Identifier |
VARCHAR(150) |
Yes |
No |
No |
Password Text |
The Password Text is an encrypted value that is a given account's secret code for logging onto the database. |
VARCHAR(50) |
Yes |
No |
No |