User system : database schema

Jump to bottom Edit New page

elplatt edited this page Dec 12, 2012 · 2 revisions

The user system defines the following tables.

user

A user who can log into the CRM

cid (integer) The user's ID from the Contact Module
username (string) The user's name
hash (string) An sha1 hash of the salt and password
salt (string) A random string of characters used to secure password hashes

role

A class of users that have the same permissions (e.g. director, treasurer, member, etc.)

rid (integer) A unique id for the role
name (string) The name of the role

user_role

Associate users with their roles

cid (integer) The user's ID from the Contact Module
rid (integer) The role's ID