My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
DataModel  
Data Model for Guild Resource Center
Featured, Phase-Design
Updated Feb 29, 2008 by rwilso...@gmail.com

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
IDintAutogenerated by Rails
FirstNamestring
LastNamestring
EmailstringRequired
Password SaltstringSalt for Encryption
Password HashstringFully Encrypted Password
TimezonestringThis should be GMT-X
DateCreateddateAudit Data
LastLogindateAudit Data / Inactive User Measurement
LastIPstringSecurity?

Related Objects

  • Character
  • Permissions
  • ContactType

UserContact

Relationship model between User and ContactType.

Property Data Type Description
UserIDintFK to User
ContactTypeIDintFK to ContactType
ValuestringStore all values as string


ContactType

Houses different contact methods. These can include AIM names, telephone numbers, addresses, blog sites, etc.

Property Data Type Description
IDintAutogenerated by Rails
Descriptionstring


Powered by Google Project Hosting