Database model
tbl_Document
DocumentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
Description: nvarchar(2048) NULL
DocumentName: nvarchar(1024) NULL
DocumentTypeID: int NULL
CompanyID: int
PhysicalLocation: nvarchar(1024) NULL
OriginalFileName: nvarchar(1024) NULL
links
link_id: int PRIMARY KEY IDENTITY(1,1)
link: varchar(2000) NULL
hash: varchar(2000)  NULL
created: datetime NULL
oauth_access_tokens
access_token: varchar(80)
client_id: varchar(80) NULL
user_id: varchar(80) NULL
expires: datetime NULL
scope: varchar(4000) NULL
oauth_authorization_codes
authorization_code: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
redirect_uri: varchar(2000)
expires: datetime NOT NULL
scope: varchar(4000)
id_token: varchar(1000)
oauth_clients
client_id: varchar(80)
client_secret: varchar(80) NULL
redirect_uri: varchar(2000) NULL
grant_types: varchar(80) NULL
scope: varchar(4000) NULL
user_id: varchar(80) NULL
oauth_ip_logins
ip_login_id: int PRIMARY KEY IDENTITY(1,1)
ip: varchar(128)
user_agent: varchar(512)
login_time: datetime
user_id: varchar(4000)
access_token: varchar(4000)
location: varchar(4000)
success: bit NULL
oauth_jwt
client_id: varchar(80)
subject: varchar(80) NULL
public_key: varchar(2000)
oauth_public_keys
client_id: varchar(80)
private_key: varchar(8000)
public_key: varchar(8000)
encryption_algorithm: varchar(80) DEFAULT 'RS256'
oauth_refresh_tokens
refresh_token: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
expires: datetime NOT NULL
scope: varchar(4000) NULL
oauth_scopes
is_default: tinyint NULL
scope: varchar(80)
oauth_users
user_id: int  PRIMARY KEY IDENTITY(1,1)
username: varchar(40)
password: varchar(80)
email: varchar(4000) NULL
email_verified: tinyint NULL
scope: varchar(80) NULL
activate_token: varchar(200) NULL
reset_token: varchar(200) NULL
last_login: datetime NULL
first_name: varchar(512) NULL
last_name: varchar(512) NULL
external_id: int 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_Ailment
AilmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
CompanyID: int
Ailment: nvarchar(64) NULL
Summary: nvarchar(2000) NULL
Details: nvarchar(2000) NULL
PartOfBodyID: int NULL
tbl_AilmentDiet
AilmentDietID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AilmentID: int NULL
DietTypeID: int NULL
Description: nvarchar(2000) NULL
tbl_AilmentHomework
AilmentHomeworkID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AilmentID: int NULL
HomeworkTypeID: int NULL
Frequency: nvarchar(128) NULL
Description: nvarchar(2000) NULL
tbl_AilmentIndication
AilmentIndicationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AilmentID: int NULL
SubPartOfBodyID: int NULL
SubPlacePartOfBodyID: int NULL
SubPartOfBodyWhenID: int NULL
SubPartOfBodyVisualID: int NULL
SubPartOfBodyPalpateID: int NULL
Indication: nvarchar(128) NULL
Description: nvarchar(2000) NULL
tbl_AilmentSupplements
AilmentSupplementsID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AilmentID: int NULL
SupplementTypeID: int NULL
Frequency: nvarchar(128) NULL
Description: nvarchar(2000) NULL
tbl_AilmentTraining
AilmentTrainingID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AilmentID: int NULL
TrainingTypeID: int NULL
Frequency: nvarchar(128) NULL
Grade: nvarchar(128) NULL
Description: nvarchar(2000) NULL
tbl_AilmentTreatment
AilmentTreatmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AilmentID: int NULL
TreatmentTypeID: int NULL
Frequency: nvarchar(128) NULL
Grade: nvarchar(128) NULL
Description: nvarchar(2000) NULL
tbl_AppointmentStatus
AppointmentStatusID: int PRIMARY KEY IDENTITY(1,1)
AppointmentStatus: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_AppointmentType
AppointmentTypeID: int PRIMARY KEY IDENTITY(1,1)
AppointmentType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_AssessmentType
AssessmentTypeID: int PRIMARY KEY IDENTITY(1,1)
AssessmentType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_BodyScanArea
BodyScanAreaID: int PRIMARY KEY IDENTITY(1,1)
BodyScanArea: 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
Birthdate: datetime NULL
GenderID: int NULL
MartialStatusID: int NULL
NumberOfChildren: int NULL
Address1: nvarchar(2000) NULL
Address2: nvarchar(2000) NULL
City: nvarchar(30) NULL
StateID: int NULL
Zip: nvarchar(15) NULL
Registered: bit NULL
PrimaryPhysicianID: int NULL
MembershipLevelID: int NULL
LocationID: int NULL
Notes: nvarchar(2000) NULL
ContactID: int NULL
CompanyID: int
tbl_ClientAilment
ClientAilmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AilmentID: int NULL
AilmentDate: datetime NULL
Active: int NULL
Description: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientAllergy
ClientAllergyID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Allergy: nvarchar(60) NULL
Reaction: nvarchar(2000) NULL
Notes: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientAppointment
ClientAppointmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AppointmentTypeID: int NULL
AppointmentDate: datetime NULL
AppointmentStatusID: int NULL
Cost: nvarchar(30) NULL
Description: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientAppointmentNote
ClientAppointmentNoteID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
NoteTitle: nvarchar(64) NULL
Description: nvarchar(2000) NULL
IsVisibleToClient: int NULL
ClientAppointmentID: int NULL
tbl_ClientAssessment
ClientAssessmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
AssessmentTypeID: int NULL
PartOfBodyID: int NULL
SurveyID: int NULL
Provider: int NULL
Summary: nvarchar(2000) NULL
ClientAppointmentID: int NULL
ClientID: int NULL
ClientAssessmentStatusID: int DEFAULT 1
tbl_ClientAssessmentBodyScan
ClientAssessmentBodyScanID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
BodyScanAreaID: int NULL
Assessment: nvarchar(2000) NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentConcussion
ClientAssessmentConcussionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
Dizziness: int NULL
Nausea: int NULL
LossOfBalance: int NULL
Pain: int NULL
AboveTheEyes: int NULL
GeneralHeadache: int NULL
BlurredVision: int NULL
SensitivityToLight: int NULL
SensitivityToScreens: int NULL
NeckStiffness: int NULL
Fatigue: int NULL
Disorientation: int NULL
RingingInEars: int NULL
SlurredSpeech: int NULL
LossOfFocusConcentration: int NULL
Iritableness: int NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentConcussionAilment
ClientAssessmentConcussionAilmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
DiagnoseDate: datetime NULL
ProviderID: int NULL
Summary: nvarchar(2000) NULL
AilmentIDs: nvarchar(2000) NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentConcussionQuestion
ClientAssessmentConcussionQuestionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
PartOfBodyID: int NULL
SubPartOfBodyID: int NULL
SubPlacePartOfBodyID: int NULL
SubPartOfBodyWhenID: int NULL
SubPartOfBodyVisualID: int NULL
SubPartOfBodyPalpateID: int NULL
SubPartOfBodyNeurology: nvarchar(512) NULL
ConcussionType: nvarchar(32) NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentInitial
ClientAssessmentInitialID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ObserveID: int NULL
RightCheck: bit NULL
LeftCheck: bit NULL
Assessment: nvarchar(2000) NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentOneOffQuestion
ClientAssessmentOneOffQuestionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
Notes: nvarchar(4000) NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentPain
ClientAssessmentPainID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
PainLevelToday: int NULL
HowActive: int NULL
PainLevelDaily: int NULL
HowActiveBeforePain: int NULL
MoveThroughPain: int NULL
PainThreshold: int NULL
PainWorsePosition: int NULL
PainWorseTimeOfDay: int NULL
PainWorseActive: int NULL
PainProvoke: nvarchar(2000) NULL
PainCannotDo: nvarchar(2000) NULL
StressLevel: int NULL
HappinessLevel: int NULL
PainTried: nvarchar(2000) NULL
PainWhatWorks: nvarchar(2000) NULL
PainFrequency: nvarchar(2000) NULL
Vision: int NULL
Balance: int NULL
Coordination: int NULL
BodyChanges: int NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentPainAilment
ClientAssessmentPainAilmentID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
DiagnoseDate: datetime NULL
ProviderID: int NULL
Summary: nvarchar(2000) NULL
AilmentIDs: nvarchar(2000) NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentPainQuestion
ClientAssessmentPainQuestionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
SubPartOfBodyID: int NULL
SubPlacePartOfBodyID: int NULL
SubPartOfBodyWhenID: int NULL
SubPartOfBodyVisualID: int NULL
SubPartOfBodyPalpateID: int NULL
SubPartOfBodyNeurology: nvarchar(512) NULL
ClientAssessmentID: int NULL
tbl_ClientAssessmentPerformance
ClientAssessmentPerformanceID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
WhatCantYouDo: nvarchar(2000) NULL
WhyCantYouDoIt: nvarchar(2000) NULL
DidYouHitYourHeadOrGetWhiplash: bit NULL
WhatHappenedToCauseThis: nvarchar(2000) NULL
WhatWereSymptomsAfterTheIncident: nvarchar(2000) NULL
HowLongDidItTakeForSymptomsToTakeEffect: nvarchar(2000) NULL
ClientAssessmentID: int NULL
tbl_ClientMedicalFamilyHistory
ClientMedicalFamilyHistoryID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ConditionTypeID: int NULL
Mother: bit NULL
Father: bit NULL
Brother: bit NULL
Sister: bit NULL
Child: bit NULL
MGM: bit NULL
MGF: bit NULL
PGM: bit NULL
PGF: bit NULL
Notes: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientMedicalHistory
ClientMedicalHistoryID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
ConditionTypeID: int NULL
CurrentCondition: bit NULL
PastCondition: bit NULL
Notes: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientMedication
ClientMedicationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Medication: nvarchar(60) NULL
Dose: nvarchar(10) NULL
TimesPerDay: int NULL
Notes: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientNote
ClientNoteID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
NoteTitle: nvarchar(64) NULL
Description: nvarchar(2000) NULL
IsVisibleToClient: int NULL
ClientID: int NULL
tbl_ClientPlan
ClientPlanID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
PlanTypeID: int NULL
PlanDate: datetime NULL
PlanFrequency: int NULL
PlanStatusID: int NULL
Description: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientSurgery
ClientSurgeryID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Surgery: nvarchar(60) NULL
Date: datetime NULL
Location: nvarchar(60) NULL
Notes: nvarchar(2000) NULL
ClientID: int NULL
tbl_ClientTest
ClientTestID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
TestTypeID: int NULL
TestDate: datetime NULL
Summary: nvarchar(2000) NULL
ClientID: int NULL
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
tbl_ConditionType
ConditionTypeID: int PRIMARY KEY IDENTITY(1,1)
ConditionType: nvarchar(64) NULL
IsEnabled: bit 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
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_ContactNotification
ContactID: int NULL
NotificationChannelID: int NULL
NotificationLevelID: int NULL
Value: int NULL
tbl_Country
CountryID: int PRIMARY KEY IDENTITY(1,1)
Country: nvarchar(40) NULL
tbl_DietType
DietTypeID: int PRIMARY KEY IDENTITY(1,1)
DietType: nvarchar(128) NULL
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_DocumentType
DocumentTypeID: int PRIMARY KEY IDENTITY(1,1)
DocumentType: nvarchar(40) NULL
ArchivedDate: datetime NULL
ParentID: int NULL
CompanyID: int NULL
tbl_Gender
GenderID: int PRIMARY KEY IDENTITY(1,1)
Gender: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_HomeworkType
HomeworkTypeID: int PRIMARY KEY IDENTITY(1,1)
HomeworkType: nvarchar(128) NULL
tbl_HowCommon
HowCommonID: int PRIMARY KEY IDENTITY(1,1)
HowCommon: nvarchar(64) NULL
tbl_Location
LocationID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
LocationName: nvarchar(60) NULL
Address1: nvarchar(2000) NULL
Address2: nvarchar(2000) NULL
City: nvarchar(30) NULL
StateID: int NULL
Zip: nvarchar(15) NULL
Notes: nvarchar(2000) NULL
CompanyID: int
tbl_MartialStatus
MartialStatusID: int PRIMARY KEY IDENTITY(1,1)
MartialStatus: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_MediaType
MediaTypeID: int PRIMARY KEY IDENTITY(1,1)
MediaType: nvarchar(64) NULL
IsVideoType: bit NULL
IsEnabled: bit NULL
tbl_MembershipLevel
MembershipLevelID: int PRIMARY KEY IDENTITY(1,1)
MembershipLevel: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_NotificationChannel
NotificationChannelID: int PRIMARY KEY IDENTITY(1,1)
NotificationChannel: varchar(20) NULL
tbl_NotificationLevel
NotificationLevelID: int PRIMARY KEY IDENTITY(1,1)
NotificationLevel: varchar(20) NULL
tbl_Observe
ObserveID: int PRIMARY KEY IDENTITY(1,1)
Observe: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_PartOfBody
PartOfBodyID: int PRIMARY KEY IDENTITY(1,1)
PartOfBody: nvarchar(40) NULL
tbl_Physician
PhysicianID: 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
GenderID: int NULL
Birthdate: datetime NULL
LocationIDs: nvarchar(15) NULL
Address1: nvarchar(2000) NULL
Address2: nvarchar(2000) NULL
City: nvarchar(30) NULL
StateID: int NULL
Zip: nvarchar(15) NULL
ContactID: int NULL
CompanyID: int
tbl_PlanStatus
PlanStatusID: int PRIMARY KEY IDENTITY(1,1)
PlanStatus: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_PlanType
PlanTypeID: int PRIMARY KEY IDENTITY(1,1)
PlanType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_State
StateID: int PRIMARY KEY IDENTITY(1,1)
StateAbbreviation: nvarchar(2) NULL
State: nvarchar(50) NULL
ArchivedDate: datetime NULL
tbl_SubPartOfBody
SubPartOfBodyID: int PRIMARY KEY IDENTITY(1,1)
SubPartOfBody: nvarchar(128) NULL
PartOfBodyID: int NULL
X: decimal(38,17) NULL
Y: decimal(38,17) NULL
R: decimal(38,17) NULL
Side: int NULL
tbl_SubPartOfBodyPalpate
SubPartOfBodyPalpateID: int PRIMARY KEY IDENTITY(1,1)
SubPartOfBodyPalpate: nvarchar(128) NULL
SubPlacePartOfBodyID: int NULL
tbl_SubPartOfBodyVisual
SubPartOfBodyVisualID: int PRIMARY KEY IDENTITY(1,1)
SubPartOfBodyVisual: nvarchar(128) NULL
SubPartOfBodyID: int NULL
tbl_SubPartOfBodyWhen
SubPartOfBodyWhenID: int PRIMARY KEY IDENTITY(1,1)
SubPartOfBodyWhen: nvarchar(128) NULL
SubPartOfBodyID: int NULL
tbl_SubPlacePartOfBody
SubPlacePartOfBodyID: int PRIMARY KEY IDENTITY(1,1)
SubPlacePartOfBody: nvarchar(128) NULL
SubPartOfBodyID: 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
tbl_SupplementType
SupplementTypeID: int PRIMARY KEY IDENTITY(1,1)
SupplementType: nvarchar(128) NULL
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
tbl_Survey
SurveyID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
Survey: nvarchar(2048) NULL
Description: nvarchar(2048) NULL
CompanyID: int
tbl_SurveyAnswers
SurveyAnswersID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
Answer: nvarchar(2048) NULL
SurveyQuestionID: int
SurveyID: int
EntityID: int
tbl_SurveyQuestion
SurveyQuestionID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ArchivedDate: datetime NULL
SurveyQuestion: nvarchar(2048)
SurveyQuestionTypeID: int
Instructions: nvarchar(2048) NULL
DesiredAnswer: nvarchar(2048) NULL
RankingPoints: int NULL
OrderNum: int NULL
SurveyID: int
CompanyID: int
tbl_SurveyQuestionItem
SurveyQuestionItemID: int PRIMARY KEY IDENTITY(1,1)
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
SurveyQuestionItemName: nvarchar(2048)
ItemOrderNum: int NULL
SurveyQuestionID: int
tbl_SurveyQuestionType
SurveyQuestionTypeID: int PRIMARY KEY IDENTITY(1,1)
SurveyQuestionType: nvarchar(64)
IsEnabled: bit DEFAULT 1
tbl_TestType
TestTypeID: int PRIMARY KEY IDENTITY(1,1)
TestType: nvarchar(64) NULL
IsEnabled: bit NULL
tbl_TrainingType
TrainingTypeID: int PRIMARY KEY IDENTITY(1,1)
TrainingType: nvarchar(128) NULL
tbl_TreatmentType
TreatmentTypeID: int PRIMARY KEY IDENTITY(1,1)
TreatmentType: nvarchar(128) NULL