Database model
links
link_id: int PRIMARY KEY IDENTITY(1,1)
link: varchar(2000) NULL
hash: varchar(2000)  NULL
created: datetime NULL
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_AbuseReport
AbuseReportID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ContactID: int
Message: nvarchar(4000) NULL
GroupMessageID: int
CompanyID: int
tbl_AptCancel
AptCancelID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
MemberIDs: varchar(MAX) NULL
ClientChildID: int NULL
AptDate: datetime NULL
AptEndDate: datetime NULL
Notes: varchar(MAX) NULL
CompanyID: int
tbl_CareTeamRole
CareTeamRoleID: int PRIMARY KEY IDENTITY(1,1)
CareTeamRole: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_CheckIn
CheckInID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
RoleID: int NULL
ChildID: int NULL
CareTeamID: int NULL
Room: nvarchar(15) NULL
CheckInStatusID: int NULL
PickedUpByID: int NULL
DroppedOffByID: int NULL
SignInTime: datetime NULL
SignOutTime: datetime NULL
ScheduleLocationID: int NULL
RoomID: int NULL
Notes: varchar(MAX) NULL
InNotes: varchar(MAX) NULL
CompanyID: int
tbl_CheckInStatus
CheckInStatusID: int PRIMARY KEY IDENTITY(1,1)
CheckInStatus: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_Client
ClientID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(30) NULL
LastName: nvarchar(30) NULL
Email: nvarchar(30) NULL
Phone: nvarchar(15) NULL
AlternatePhone: nvarchar(15) NULL
ImagePath: nvarchar(512) NULL
ContactID: int NULL
CompanyID: int
tbl_ClientChild
ClientChildID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ChildName: nvarchar(30) NULL
ImagePath: nvarchar(512) NULL
ClientID: int
tbl_ClientMember
ClientMemberID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CareTeamRoleID: int NULL
JoinedOnDate: datetime NULL
MemberID: int NULL
ClientChildID: int NULL
ClientID: int
tbl_ClientPickup
ClientPickupID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(30) NULL
LastName: nvarchar(30) NULL
Relation: nvarchar(50) NULL
ImagePath: nvarchar(512) NULL
ClientID: int
CompanyID: int
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_CompanyCalendar
CompanyCalendarID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CompanyID: int NULL
ClientID: int NULL
MemberID: int NULL
CompanyCalendarTypeID: int NULL
CompanyCalendarDurationID: int NULL
StartDate: date NULL
StartTime: time NULL
Notes: nvarchar(4000) NULL
tbl_CompanyCalendarDuration
CompanyCalendarDurationID: int PRIMARY KEY IDENTITY(1,1)
CompanyCalendarDuration: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_CompanyCalendarType
CompanyCalendarTypeID: int PRIMARY KEY IDENTITY(1,1)
CompanyCalendarType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_CompanyWorkingHours
CompanyWorkingHoursID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ContactID: int NULL
DayName: nvarchar(30) NULL
DayStartTime: datetime NULL
DayEndTime: datetime NULL
WorkingDay: bit NULL
CompanyID: int NULL
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
FirebaseToken: nvarchar(2000)
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_Country
CountryID: int PRIMARY KEY IDENTITY(1,1)
Country: nvarchar(40) NULL
tbl_Department
DepartmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Department: nvarchar(64) NULL
IsEnabled: bit NULL
CompanyID: int
tbl_DirectMessage
DirectMessageID: int PRIMARY KEY IDENTITY(1,1)
DateTime: datetime
FromID: int
SystemID: int NULL
ToID: int
Msg: nvarchar(2000)
IsRead: bit NULL
tbl_Documentation
DocumentationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
DocumentationName: nvarchar(1024)
PhysicalLocation: nvarchar(1024)
OriginalFileName: nvarchar(1024)
Description: nvarchar(2048) NULL
IsPublic: bit DEFAULT 0
DocumentationCategoryID: int NULL
CompanyID: int NULL
tbl_DocumentationCategory
DocumentationCategoryID: int PRIMARY KEY IDENTITY(1,1)
DocumentationCategory: nvarchar(64) NULL
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CompanyID: int
tbl_Group
GroupID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
GroupName: nvarchar(128) NULL
CompanyID: int
tbl_GroupMember
GroupMemberID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ContactID: int
GroupID: int
CompanyID: int
tbl_GroupMessage
GroupMessageID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Message: nvarchar(4000) NULL
ParentMessageID: int NULL
Reported: int NULL
Likes: int NULL
GroupID: int
CompanyID: int
tbl_GroupMessageLike
GroupMessageLikeID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
GroupMessageID: int
Answer: int
tbl_Member
MemberID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
FirstName: nvarchar(30) NULL
LastName: nvarchar(30) NULL
Email: nvarchar(30) NULL
Phone: nvarchar(15) NULL
Credentials: nvarchar(2000) NULL
Bio: nvarchar(2000) NULL
PersonalStatement: nvarchar(2000) NULL
ImagePath: nvarchar(512) NULL
DepartmentID: int NULL
ReportsToID: int NULL
SystemRoleID: int NULL
ContactID: int NULL
CompanyID: int
tbl_Role
RoleID: int PRIMARY KEY IDENTITY(1,1)
Role: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_ScheduleItem
ScheduleItemID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ClientID: int NULL
ClientChildID: int NULL
MemberID: int NULL
DateTime: datetime NULL
Duration: int NULL
ScheduleLocationID: int NULL
ScheduleItemStatus: int DEFAULT 1
IsParentScheduled: int DEFAULT 0
ScheduleItemToken: nvarchar(64) NULL
ScheduleTypeID: int NULL
Notes: nvarchar(4000) NULL
CompanyID: int
tbl_ScheduleLocation
ScheduleLocationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
LocationName: nvarchar(512)
Address: nvarchar(512) NULL
Phone: nvarchar(512) NULL
Notes: nvarchar(4000) NULL
CompanyID: int
tbl_ScheduleReports
ReportID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ScheduleItemID: int NULL
ClientID: int NULL
ClientChildID: int NULL
MemberID: int NULL
DateTime: datetime NULL
Duration: int NULL
ScheduleLocationID: int NULL
ScheduleItemStatus: int DEFAULT 1
IsParentScheduled: int DEFAULT 0
ScheduleTypeID: int NULL
Notes: nvarchar(4000) NULL
EventTrigger: nvarchar(40) NULL
CompanyID: int NULL
tbl_ScheduleType
ScheduleTypeID: int PRIMARY KEY IDENTITY(1,1)
ScheduleType: nvarchar(64) NULL
IsEnabled: bit NULL
IsStaff: bit DEFAULT 1
IsClient: bit DEFAULT 1
tbl_State
StateID: int PRIMARY KEY IDENTITY(1,1)
StateAbbreviation: nvarchar(2) NULL
State: nvarchar(50) NULL
ArchivedDate: datetime 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
tbl_Support
SupportID: int PRIMARY KEY IDENTITY(1,1)
CreateDate: datetime NULL
Name: nvarchar(60) NULL
Email: nvarchar(100) NULL
PhoneNumber: varchar(12) NULL
AddressName: nvarchar(128) NULL
Description: nvarchar(2000) NULL
SupportType: nvarchar(150) NULL
CompanyID: int NULL