Database model
perm_group_to_resource
resource_id: int NULL
group_id: int NULL
perm: int
perm_resources
resource_id: int PRIMARY KEY IDENTITY(1,1)
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 PRIMARY KEY IDENTITY(1,1)
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_Assessment
AssessmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ContactID: int
AssessmentLevel: int NULL
AssessmentTypeID: int NULL
AssessmentDescription: nvarchar(2048) NULL
AssessmentMilestone: int NULL
AssessmentName: nvarchar(2048) NULL
AssessmentOperantID: int NULL
AssessmentExample: nvarchar(2048) NULL
AssessmentObjective: nvarchar(2048) NULL
AssessmentScoringZero: nvarchar(2048) NULL
AssessmentScoringOne: nvarchar(2048) NULL
AssessmentScoringHalf: nvarchar(2048) NULL
AssessmentTry: int NULL
AssessmentImagesQuantity: int NULL
SetID: int
tbl_AssessmentHistory
AssessmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ContactID: int
AssessmentLevel: int NULL
AssessmentTypeID: int NULL
AssessmentDescription: nvarchar(2048) NULL
AssessmentMilestone: int NULL
AssessmentName: nvarchar(2048) NULL
AssessmentOperantID: int NULL
AssessmentExample: nvarchar(2048) NULL
AssessmentObjective: nvarchar(2048) NULL
AssessmentScoringZero: nvarchar(2048) NULL
AssessmentScoringOne: nvarchar(2048) NULL
AssessmentScoringHalf: nvarchar(2048) NULL
AssessmentTry: int NULL
AssessmentImagesQuantity: int NULL
SetID: int NULL
tbl_AssessmentType
AssessmentTypeID: int PRIMARY KEY IDENTITY(1,1)
ArchivedDate: datetime NULL
AssessmentType: nvarchar(256) NULL
tbl_Client
ClientID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ContactID: int
ArchivedDate: datetime NULL
LocationIDs: nvarchar(256) NULL
LocationID: int NULL
ClientFirstName: nvarchar(32)
ClientLastName: nvarchar(32)
ClientNotes: nvarchar(128) NULL
ClientLastSeen: datetime NULL
ClientBirthday: datetime NULL
ClientGuardianFirstName: nvarchar(32) NULL
ClientGuardianLastName: nvarchar(32) NULL
ClientGuardianTelephone: nvarchar(32) NULL
tbl_ClientLocations
LocationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ClientID: int
Location: nvarchar(64)
tbl_Company
CompanyID: int PRIMARY KEY IDENTITY(1,1)
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
SSL: bit
tbl_Contact
ContactID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(20)
LastName: nvarchar(30)
Email: nvarchar(50)
IsSystemUser: int NULL
UserID: int NULL
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 PRIMARY KEY IDENTITY(1,1)
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_Location
LocationID: int PRIMARY KEY IDENTITY(1,1)
ArchivedDate: datetime NULL
Location: nvarchar(1024) NULL
tbl_Operant
OperantID: int PRIMARY KEY IDENTITY(1,1)
ArchivedDate: datetime NULL
Operant: nvarchar(256) NULL
tbl_Quiz
QuizID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ReportID: int
QuizComment: nvarchar(2048) NULL
QuizObservationalScore: int NULL
QuizScore: int NULL
tbl_Report
ReportID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ContactID: int
ClientID: int
SetID: int NULL
ReportStatusID: int NULL
ReportComment: nvarchar(2048) NULL
ReportObservationalScore: nvarchar(256) NULL
ReportTry: int NULL
ReportImagesQuantity: int NULL
ReportScore: int NULL
ReportCurrentTries: int NULL
ReportAnswers: nvarchar(4000) NULL
ReportExample: nvarchar(2048) NULL
ReportObjective: nvarchar(2048) NULL
ReportScoringZero: nvarchar(2048) NULL
ReportScoringOne: nvarchar(2048) NULL
ReportScoringHalf: nvarchar(2048) NULL
ReportMilestone: int NULL
ReportOperantID: int NULL
ReportTypeID: int NULL
ReportDate: datetime NULL
ParentReportID: int NULL
ReportGroupID: int NULL
tbl_ReportDocument
ReportDocumentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
DocumentName: nvarchar(1024) NULL
DocumentDate: datetime NULL
ClientID: int
PhysicalLocation: nvarchar(1024) NULL
OriginalFilename: nvarchar(1024) NULL
Description: nvarchar(2048) NULL
tbl_ReportGroup
ReportGroupID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ReportGroupName: nvarchar(1024) NULL
ClientID: int NULL
tbl_SetQuestions
SetQuestionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
SetID: int
QuestionTypeID: int
QuestionContent: nvarchar(4000)
tbl_Sets
SetID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ContactID: int
SetLevel: int
SetName: nvarchar(128)
SetLabel: nvarchar(128)
SetOperantID: int NULL
tbl_Subscription
SubscriptionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
SubscriptionStatusID: int NULL
CompanyID: int
PaymentReference: nvarchar(512)
PaymentProvider: int