Introduction
This page covers all relevant details to the data model. It will be split out by section to provide easier readability.
User
The user which represents the real person logging into the portal.
| Property | Data Type | Description |
| ID | int | Autogenerated by Rails |
| FirstName | string | |
| LastName | string | |
| Email | string | Required |
| Password Salt | string | Salt for Encryption |
| Password Hash | string | Fully Encrypted Password |
| Timezone | string | This should be GMT-X |
| DateCreated | date | Audit Data |
| LastLogin | date | Audit Data / Inactive User Measurement |
| LastIP | string | Security? |
Related Objects
- Character
- Permissions
- ContactType
UserContact
Relationship model between User and ContactType.
| Property | Data Type | Description |
| UserID | int | FK to User |
| ContactTypeID | int | FK to ContactType |
| Value | string | Store all values as string |
ContactType
Houses different contact methods. These can include AIM names, telephone numbers, addresses, blog sites, etc.
| Property | Data Type | Description |
| ID | int | Autogenerated by Rails |
| Description | string | |