Database model
perm_group_to_resource
resource_id: int NULL
group_id: int NULL
perm: int
perm_resources
resource_id: int NOT NULL PRIMARY KEY auto_increment
resource_name: varchar(256)
resource_description: varchar(512) NULL
perm_roles_to_resource
role_id: int
resource_id: int
perm: int
perm_roles
role_id: int NOT NULL PRIMARY KEY auto_increment
role_name: varchar(256) NULL
resource_restrict: bit NULL
external_role: bit NULL
starting_page: varchar(256) NULL
perm_user_to_resource
resource_id: int NULL
user_id: int NULL
perm: int
perm_user_to_role
role_id: int NULL
user_id: int NULL
tbl_Company
CompanyID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CompanyName: nvarchar(64) NULL
AddressName: nvarchar(128) NULL
AddressName2: nvarchar(128) NULL
CityName: nvarchar(128) NULL
StateID: int NULL
PostalCode: nvarchar(32) NULL
CountryID: int NULL
AreaCode: varchar(5) NULL
PhoneNumber: varchar(12) NULL
PhoneExtension: varchar(10) NULL
CompanyLogoUrl: nvarchar(512) NULL
LineOfBusiness: varchar(80) NULL
ImagePath: nvarchar(512) NULL
DefaultEmail: nvarchar(64) NULL
Password: nvarchar(64) NULL
SMTPServer: nvarchar(64) NULL
Port: varchar(16) NULL
tbl_Contact
ContactID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(20)
LastName: nvarchar(30)
Email: nvarchar(50)
PhoneNumber: nvarchar(50) NULL
IsEnabled: int NULL
Notes: nvarchar(1000) NULL
DepartmentID: int NULL
ServiceAreaID: int NULL
IsSystemUser: int NULL
UserID: int NULL
UserType: int
Timezone: nvarchar(64) DEFAULT 'UTC'
DateTimeFormat: nvarchar(64) DEFAULT 'MM/DD/YYYY h:mm A'
CompanyID: int
ImagePath: nvarchar(512) NULL
LastAccessed: datetime NULL
tbl_ContactGroups
ContactGroupID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
ArchivedDate: datetime NULL
CreateUpdateDate: datetime NULL
CompanyID: int
ContactGroupName: nvarchar(64) NULL
ContactGroupDesc: nvarchar(2048) NULL
ContactID: int NULL
tbl_ContactInGroup
ContactGroupID: int
ContactID: int
tbl_DashboardReport
DashboardReportID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CompanyID: int
DepartmentID: int
Description: nvarchar(255) NULL
DueDate: datetime NULL
CompleteDate: datetime NULL
DashboardReportStatusID: int
tbl_DashboardReportEntry
DashboardReportEntryID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
DashboardReportID: int
ServiceAreaID: int
ServiceAreaShift: nvarchar(256)
Accessibility: int NULL
Timeliness: int NULL
Accuracy: int NULL
Attitude: int NULL
Operations: int NULL
EntryNotes: nvarchar(256)
tbl_DashboardReportStatus
DashboardReportStatusID: int NOT NULL PRIMARY KEY auto_increment
DashboardReportStatus: nvarchar(32)
CompanyID: int NULL
tbl_Department
DepartmentID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CompanyID: int
DepartmentName: nvarchar(64) NULL
StartDate: datetime NULL
IsEnabled: int NULL
Notes: nvarchar(1000) NULL
tbl_Role
RoleID: int NOT NULL PRIMARY KEY auto_increment
Role: nvarchar(64) NULL
IsEnabled: int NULL
tbl_ServiceAreas
ServiceAreaID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CompanyID: int
ArchivedDate: datetime NULL
ServiceAreaName: nvarchar(255) NULL
StartDate: datetime NULL
Contact: nvarchar(255) NULL
ContactPhone: nvarchar(255) NULL
ContactEmail: nvarchar(255) NULL
IsEnabled: bit DEFAULT 0
Notes: nvarchar(1000) NULL
DirectorManagerName: nvarchar(255) NULL
DirectorManagerPhone : nvarchar(255) NULL
OperationsContact: nvarchar(255) NULL
OperationsContactPhone: nvarchar(255) NULL
OperationsAfterHoursContact: nvarchar(255) NULL
EmergencyContact: nvarchar(255) NULL
tbl_Subscription
SubscriptionID: int NOT NULL PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
SubscriptionStatusID: int NULL
CompanyID: int
PaymentReference: nvarchar(512)
PaymentProvider: int