Tables [dbo].[Patient_Directives]
Advance Directives associated with the Patient
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Patient_Directives: PatientID\OrganizationIDIndexes TWstat_Patient_Directives_DirectivesDE_PatientID_OrganizationID, TWstat_Patient_Directives_OrganizationID_PatientID(2)Foreign Keys FK_Patient_Directives_PatientID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLThe Patient ID - FK to the Person.ID
Cluster Primary Key PK_Patient_Directives: PatientID\OrganizationIDIndexes TWstat_Patient_Directives_DirectivesDE_PatientID_OrganizationID, TWstat_Patient_Directives_OrganizationID_PatientID(2)Foreign Keys FK_Patient_Directives_OrganizationID: [dbo].[Organization].OrganizationIDOrganizationID[dbo].[dict_id]5NOT NULLThe Organization ID - FK to the Organization.ID
Indexes TWstat_Patient_Directives_DirectivesDE_PatientID_OrganizationIDForeign Keys FK_Patient_Directives_DirectivesDE: [dbo].[Directives_DE].DirectivesDEDirectivesDE[dbo].[dict_id]5NOT NULLthe associated Directive - FK to the Directives_DE.ID
Instructionsvarchar(255)255NULL allowedInstructions associated with the Directive