Tables [dbo].[Patient_Alert]
Patient Alert details from Patient Query
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Patient_Alert_PatientID_QueryID: PatientID\QueryIDIndexes XA1_Patient_AlertForeign Keys FK_Patient_Alert_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient ID. Link to Person.ID
Cluster Primary Key PK_Patient_Alert_PatientID_QueryID: PatientID\QueryIDIndexes XA1_Patient_AlertForeign Keys FK_Patient_Alert_QueryID_Query_ID: [dbo].[Query].QueryIDQueryID[dbo].[uniqueid]9NOT NULLQuery ID. Link to Query.ID
AlertDTTMdatetime8NOT NULLAlerted Date and Time