SXC Database Schema

⇧Table dbo.ACCOUNT_TYPES

Table ID: 149575571; Created: July 30, 2012, 11:21:41
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
account_description varchar (255) ☐
account_name varchar (50) ☐
active smallint ☐

⇧Table dbo.AUDIT_STATUS

Table ID: 539864990; Created: October 03, 2012, 12:38:48
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
status nvarchar (16) ☐

⇧Table dbo.ERROR_CODES

Table ID: 491864819; Created: October 03, 2012, 12:38:48
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
error_code nvarchar (10) ☐
label nvarchar (64) ☐
description nvarchar (255) ☐
recovery_amount nvarchar (50) ☐
addressable ntext ☐

⇧Table dbo.LOG_TYPE

Table ID: 1762105318; Created: August 17, 2012, 14:17:15
Name Type NULL Comment
◆zz_row_id smallint ☐ IDENTITY
name varchar (50) ☐

⇧Table dbo.LOGS

Table ID: 1154103152; Created: August 17, 2012, 12:34:56
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
typeid smallint ☐
created_by_userid int ☐
created_on datetime ☐
message text ☐
active smallint ☒ DEFAULT (1)

⇧Table dbo.NOTIFICATION_CATEGORIES

Table ID: 1926297922; Created: September 19, 2012, 15:13:17
Name Type NULL Comment
◆zz_row_id smallint ☐ IDENTITY
name varchar (50) ☐

⇧Table dbo.NOTIFICATION_GROUP_MEMBERS

Table ID: 2034106287; Created: August 18, 2012, 07:40:58
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
userid int ☐
account_type int ☐
groupid int ☐
active smallint ☒ DEFAULT (1)

⇧Table dbo.NOTIFICATION_GROUPS

Table ID: 978102525; Created: August 17, 2012, 12:15:57
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
name varchar (50) ☐
created_on datetime ☐
created_by_userid int ☐
active smallint ☒ DEFAULT (1)

⇧Table dbo.NOTIFICATION_MESSAGES

Table ID: 498816839; Created: September 26, 2012, 11:42:15
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
category_id int ☐ DEFAULT (5)
type_id int ☐
group_id int ☐
created_on datetime ☐
created_by_userid int ☐
created_for_userid int ☒
active smallint ☒ DEFAULT (1)
picked_up smallint ☒ DEFAULT (0)
picked_up_on datetime ☒
viewed smallint ☒ DEFAULT (0)
viewed_on datetime ☒
message text ☒

⇧Table dbo.NOTIFICATION_TYPES

Table ID: 1010102639; Created: August 17, 2012, 12:15:57
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
name varchar (50) ☐

⇧Table dbo.SETTINGS

Table ID: 2066106401; Created: August 18, 2012, 07:41:27
Name Type NULL Comment
◆zz_row_id smallint ☐ IDENTITY
row_id smallint ☐
setting_key varchar (255) ☐
setting_value varchar (255) ☐
active smallint ☐ DEFAULT (1)
settings_group varchar (64) ☐

⇧Table dbo.USER_SETTINGS

Table ID: 1878297751; Created: September 17, 2012, 17:47:49
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
userid int ☐
setting_key varchar (255) ☐
setting_value varchar (255) ☐
active smallint ☐ DEFAULT (1)

⇧Table dbo.USERS

Table ID: 1947870006; Created: January 24, 2013, 08:14:36
Name Type NULL Comment
◆userid int ☐ IDENTITY
account_creation_date datetime ☐ DEFAULT (getdate())
active smallint ☐ DEFAULT (1)
address varchar (100) ☒
email varchar (100) ☐
name varchar (50) ☐
password varchar (50) ☐
phone varchar (20) ☒
username varchar (50) ☐
password_expiration_date datetime ☐
password_set_date datetime ☐
previous_password varchar (50) ☒
previous_password1 varchar (50) ☒
previous_password2 varchar (50) ☒
previous_password3 varchar (50) ☒
previous_password4 varchar (50) ☒
previous_password5 varchar (50) ☒
eula smallint ☐ DEFAULT (0)
account_type smallint ☐ DEFAULT (0)
last_login datetime ☒ DEFAULT (null)
auditor_id varchar (16) ☒
Generated by DB>doc on July 13, 2015, 14:13:05