Table: systemuser
Records details of a user authorised to use JCR
Columns
Name	Type	Constraints	Description
systemid	INTEGER	NOT NULL	System-generated primary key
username	VARCHAR (20)	NOT NULL	The name by which the user is identified to the system. Must be unique
name	VARCHAR (50)	NOT NULL	Full name of the user
issuperuser	CHAR (1)	NOT NULL	Contains Y if this is the sole superuser, otherwise N
password	VARCHAR (32)	NOT NULL	User's password, salted with the username and MD5 hashed
email	VARCHAR (100)		User's email address (currently not used)
enabled	CHAR (1)	NOT NULL	Contains Y if the user may log in, otherwise N
Primary key
Name	Columns		Description
pk_systemuser	systemid
Incoming foreign keys
Name	Columns	Referencing table	Description
fk_fileset_systemuser	owner	fileset
fk_project_systemuser	owner	project
fk_projectstatus_changedBy	changedby	projectstatus
fk_projectthread_systemuser	owner	projectthread
fk_projectcomment_systemuser_owner	owner	projectcomment
fk_projectcom_systemuser_reviewer	reviewer	projectcomment
fk_projectcom_systemuser_revaction	reviewactionowner	projectcomment
fk_projectcom_systemuser_actioner	actioner	projectcomment
fk_filecomment_systemuser_owner	owner	filecomment
fk_filecom_systemuser_reviewer	reviewer	filecomment
fk_filecom_systemuser_revaction	reviewactionowner	filecomment
fk_filecom_systemuser_actioner	actioner	filecomment