Tables [dbo].[Patient_List_Membership]
Linkage of Queries to patient lists.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Patient_List_Membership_PatientID_ListID_QueryID: PatientID\ListID\QueryIDIndexes XA1_PAT_LIST_MEMForeign Keys FK_Patient_List_Membership_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Cluster Primary Key PK_Patient_List_Membership_PatientID_ListID_QueryID: PatientID\ListID\QueryIDIndexes XA1_PAT_LIST_MEM, TWstat_Patient_List_Membership_QueryID(2)Foreign Keys FK_Patient_List_Membership_QueryID_Query_ID: [dbo].[Query].QueryIDQueryID[dbo].[uniqueid]9NOT NULLQuery. Link to Query.ID
Cluster Primary Key PK_Patient_List_Membership_PatientID_ListID_QueryID: PatientID\ListID\QueryIDIndexes XA1_PAT_LIST_MEMForeign Keys FK_Patient_List_Membership_ListID_Patient_List_ID: [dbo].[Patient_List].ListIDListID[dbo].[uniqueid]9NOT NULLPatient List. Link to Patient_List.ID