Schema Browser
Database schema from Prisma introspection. 267 tables, 5734 columns, 201 relations.
267
Tables
5734
Columns
201
Relations
267 of 267 tables
AdministeredMedicine
27 columns
2 relations
Agency
32 columns
4 relations
AgencyCustomComplianceForm
62 columns
2 relations
AgencyCustomComplianceFormComponent
30 columns
2 relations
AgencyStaff
22 columns
2 relations
AgencyStaffRequirement
9 columns
2 relations
Allergy
14 columns
AlternateWorkWeekType
13 columns
Announcement
9 columns
1 relations
AnnouncementRecipient
7 columns
1 relations
ApplicantDocument
12 columns
AppModule
3 columns
AppointmentTracking
24 columns
ApprovedLocationTracking
12 columns
ArchiveDocument
14 columns
AspNetRoles
2 columns
2 relations
AspNetUserClaims
4 columns
1 relations
AspNetUserLogins
3 columns
1 relations
AspNetUserRoles
2 columns
2 relations
AspNetUsers
12 columns
3 relations
AssessmentTracking
12 columns
AssignedAgencyCustomComplianceForm
13 columns
2 relations
Attachment
34 columns
2 relations
AttachmentPath
5 columns
1 relations
AttachmentType
8 columns
1 relations
AttHistory
27 columns
AttTreeLevel2
4 columns
AttTreeLevel3
4 columns
AttTreeRootLevel
5 columns
Benefit
27 columns
1 relations
BenefitDependent
14 columns
BonusStructure
7 columns
1 relations
BonusStructurePosition
9 columns
1 relations
BranchOffice
4 columns
2 relations
Category
10 columns
Client
290 columns
11 relations
ClientAssessment
8 columns
1 relations
ClientAssessmentCleaning
197 columns
ClientAssessmentServiceComponent
7 columns
ClientComplianceFormBuilder
11 columns
ClientComplianceFormBuilderComponent
13 columns
ClientDailyServiceNote
28 columns
2 relations
ClientDailyServiceNoteComponent
24 columns
1 relations
ClientDevice
6 columns
ClientDream
12 columns
ClientDSNActivity
21 columns
2 relations
ClientDSNActivityComponent
19 columns
2 relations
ClientDSNActivityForm
20 columns
4 relations
ClientDSNActivitySchedule
15 columns
1 relations
ClientDSNActivitySubComponentOutcome
9 columns
1 relations
ClientDSNActivityTrip
14 columns
2 relations
ClientDSNActivityTripDestination
11 columns
1 relations
ClientDSNSummarization
7 columns
ClientIHSSProvider
12 columns
ClientImmunizationClearance
10 columns
ClientLink
8 columns
ClientQualityAssurance
76 columns
1 relations
ClientQualityAssuranceAction
16 columns
ClientQualityAssuranceAnnualChecklist
8 columns
ClientQualityAssuranceConcern
10 columns
ClientQualityAssuranceHomeLogCaseFile
11 columns
ClientQualityAssuranceMedication
10 columns
ClientQualityAssurancePhoto
8 columns
1 relations
ClientReferralStage
14 columns
4 relations
ClientReferralStep
12 columns
3 relations
ClientServiceType
43 columns
2 relations
ClientServiceTypeHistory
40 columns
ClientServiceTypeWageHistory
15 columns
ClientSupportHistory
10 columns
ClientTraining
38 columns
ClientTrainingGuide
55 columns
2 relations
CompCoinHistory
12 columns
CompCoinReason
9 columns
ComplianceFormBuilder
14 columns
ComplianceFormBuilderProviderOffice
3 columns
ConsecutiveClocking
21 columns
ConsentMedTreatment
14 columns
ConsentReleaseInfo
25 columns
Contact
59 columns
ConvertLevel
1 columns
CounterTable
4 columns
CustomComplianceForm
27 columns
3 relations
CustomComplianceFormCategory
8 columns
2 relations
CustomComplianceFormComponent
20 columns
3 relations
CustomHoliday
5 columns
CustomImmunizationClearance
7 columns
CustomReport
8 columns
CustomReportField
12 columns
CustomServiceType
23 columns
2 relations
CustomServiceTypeRateOfPay
12 columns
CustomTrainingSkill
7 columns
DailyServiceNoteForm
17 columns
DailyServiceNoteFormComponent
20 columns
DailyServiceNoteFormProviderOffice
3 columns
DashboardNotice
12 columns
2 relations
DashboardNoticeOffice
3 columns
1 relations
DashboardNoticeTracking
5 columns
2 relations
Diagnoses
11 columns
Doctor
14 columns
DocumentTreeFolder
18 columns
EmailNotificationSubcategories
49 columns
EmailNotifyMaint
41 columns
EmergDetail
6 columns
EmployeeAssignedPOS
12 columns
EmployeeBonusPayment
11 columns
EmployeeBonusType
9 columns
EmployeeClientCustomROP
11 columns
1 relations
EmployeeClientCustomROPHistory
11 columns
1 relations
EmployeeClientROP
9 columns
1 relations
EmployeeClientROPHistory
13 columns
1 relations
EmployeeClientTraining
13 columns
EmployeeCompliance
15 columns
1 relations
EmployeeComplianceDocumentation
9 columns
EmployeeComplianceResult
14 columns
1 relations
EmployeeConnect
31 columns
1 relations
EmployeeTraining
63 columns
1 relations
EmployeeTrainingQuiz
14 columns
2 relations
EmployeeTrainingQuizOption
11 columns
1 relations
EmployeeTrainingSkill
12 columns
EmploymentHistory
12 columns
EVVClient
32 columns
1 relations
EVVClientPayer
19 columns
1 relations
EVVEmployee
16 columns
EVVJurisdiction
8 columns
EVVPayer
9 columns
EVVReasonCode
9 columns
EVVService
14 columns
EVVUploadError
11 columns
EVVVisit
43 columns
2 relations
EVVVisitCall
19 columns
1 relations
EVVVisitChange
14 columns
1 relations
EVVVisitHistory
9 columns
FileManagerFile
12 columns
FinalizedTracking
10 columns
FinalizePayroll
17 columns
FIR
28 columns
FIRPhoto
8 columns
Followup
47 columns
GeneralContact
35 columns
Group
7 columns
GroupMember
5 columns
GroupMessage
12 columns
GroupMessageReadStatus
5 columns
HBServiceLevel
8 columns
HiringApplicant
70 columns
5 relations
HiringApplicantAvailability
13 columns
1 relations
HiringApplicantComment
8 columns
1 relations
HiringApplicantEmail
14 columns
1 relations
HiringApplicantSchedule
17 columns
1 relations
HiringApplicantSource
8 columns
HiringDecision
7 columns
1 relations
HiringDecisionReason
7 columns
1 relations
HiringJobOpening
14 columns
1 relations
HiringJobOpeningStage
15 columns
1 relations
HiringMatchingTag
7 columns
HiringPipeline
7 columns
1 relations
HiringPipelineStage
15 columns
1 relations
HomeVisit
157 columns
1 relations
HomeVisitCategoryItem
12 columns
HomeVisitCategoryItemAction
17 columns
HomeVisitPhoto
10 columns
1 relations
IdealSchedule
39 columns
IdealScheduleEmployee
26 columns
IHSSNOATracking
10 columns
ISP
123 columns
ISPServiceComponent
109 columns
ISPServiceComponentObjective
9 columns
ISPTemplate
11 columns
1 relations
ISPTemplateComponent
9 columns
1 relations
JobDescription
10 columns
JobOffer
34 columns
5 relations
JobOfferBonusHousehold
16 columns
1 relations
JobOfferClientHour
11 columns
1 relations
JobOfferClientSchedule
20 columns
1 relations
JobOfferLinkedShiftROPIncrease
9 columns
1 relations
JobOfferRateOfPay
13 columns
1 relations
JobSyncApiLog
8 columns
LinkedShiftROPIncrease
13 columns
LockSchedule
10 columns
Logs
6 columns
MasterMedicationList
7 columns
Medicine
65 columns
2 relations
MedicineSchedule
11 columns
2 relations
MigrationHistory
4 columns
OpenJobs
23 columns
2 relations
OpenJobsAdditionalQuestions
6 columns
OpenShiftActivity
26 columns
OptionList
12 columns
PayPeriod
10 columns
PayrollChangeNotice
23 columns
1 relations
PayrollChangeNoticeRemark
8 columns
PayrollChangeNoticeService
8 columns
1 relations
PCN
52 columns
PerfEval
5 columns
Permission
5 columns
1 relations
PrintQueueParameter
5 columns
PrintQueueStatus
14 columns
ProviderForm
15 columns
ProviderGroup
28 columns
ProviderOffice
20 columns
2 relations
PTOSetting
16 columns
PushNotification
14 columns
PushNotificationError
10 columns
QSClockServiceType
5 columns
QSPForm
19 columns
QSPFormDetail
15 columns
QSPFormProviderOffice
3 columns
QSPFormTracking
16 columns
QSPFormTrackingDetail
17 columns
QSPPlanPermission
4 columns
QualityAssuranceChecklist
6 columns
QualityAssuranceType
8 columns
ReceivedApplication
12 columns
1 relations
ReferralComment
8 columns
1 relations
ReferralDetermination
7 columns
1 relations
ReferralDeterminationReason
7 columns
1 relations
ReferralDocument
11 columns
ReferralEmail
14 columns
1 relations
ReferralPipeline
7 columns
2 relations
ReferralPipelineStage
10 columns
3 relations
ReferralPipelineStep
10 columns
2 relations
ReferralProgramOpening
12 columns
4 relations
ReferralProgramOpeningStage
11 columns
4 relations
ReferralProgramOpeningStep
11 columns
4 relations
ReportFilter
14 columns
ReportSelection
11 columns
RolePermission
3 columns
2 relations
ROPTracking
18 columns
Schedule
108 columns
1 relations
ScheduleArchive
108 columns
ScheduleGeofenceTracking
21 columns
ScheduleReq
83 columns
ScheduleRevisionHistory
62 columns
SecurityMaint
8 columns
ServiceBus
25 columns
ServiceRecord
11 columns
1 relations
ServiceRecordActivity
21 columns
2 relations
ShiftObjective
14 columns
ShiftSubCode
17 columns
SignatureDisclaimer
7 columns
SIR
97 columns
SysAppCfg
5 columns
TempServMaint
18 columns
TestingSite
20 columns
TextMessageError
7 columns
TimesheetArchive
11 columns
TimesheetArchiveImage
7 columns
TrackingHistory
34 columns
Training
55 columns
2 relations
TrainingCourse
11 columns
1 relations
TrainingCourseLesson
11 columns
1 relations
TrainingLearningPath
12 columns
1 relations
TrainingLearningPathCourse
11 columns
1 relations
TrainingLesson
33 columns
1 relations
TrainingLessonQuiz
12 columns
2 relations
TrainingLessonQuizOption
10 columns
1 relations
USCounty
6 columns
UserCFG
4 columns
UserEmployee_NotificationPreferences
9 columns
UserLoginHistory
16 columns
UserMessage
15 columns
UsersEmployee
247 columns
7 relations
UsersEmployeeServiceType
18 columns
2 relations
UsersEmployeesReq
196 columns
WorkPref
59 columns
WorkWeek
24 columns
1 relations
WorkweekActivities
10 columns
2 relations