Tables [dbo].[Patient_Past_Diagnosis]
Table containing Patient Past Diagnosis data
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key PK_Patient_Past_Diagnosis_PatID_ICD_ProbDE: PatientID\ICD9code\ProblemDEIndexes TWstat_Patient_Past_Diagnosis_ICD9code_PatientIDForeign Keys FK_Patient_Past_Diagnosis_Person: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Cluster Key PK_Patient_Past_Diagnosis_PatID_ICD_ProbDE: PatientID\ICD9code\ProblemDEIndexes TWstat_Patient_Past_Diagnosis_ICD9code_PatientIDICD9codechar(10)10NOT NULLICD9 Code
Cluster Key PK_Patient_Past_Diagnosis_PatID_ICD_ProbDE: PatientID\ICD9code\ProblemDEProblemDE[dbo].[dict_id]5NOT NULL((0))Problem Dictionary Entry. Link to Problem_DE.ID