Tables [dbo].[CaseRegistry_Details_SubmittingFor]
Case registry to clinical item linkage
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_CRDS_CaseRegistryDetailID_ItemType_SubmittingFor: CaseRegistryDetailID\ItemType\SubmittingForForeign Keys FK_CaseRegistry_Details_SubmittingFor_CaseRegistryDetailID: [dbo].[Case_Registry_Details].CaseRegistryDetailIDCaseRegistryDetailID[dbo].[uniqueid]9NOT NULLCase Registry Detail. Link to Case_Registry_Detail.ID
Cluster Primary Key PK_CRDS_CaseRegistryDetailID_ItemType_SubmittingFor: CaseRegistryDetailID\ItemType\SubmittingForItemTypevarchar(10)10NOT NULLItem Type (e.g. Problem)
Cluster Primary Key PK_CRDS_CaseRegistryDetailID_ItemType_SubmittingFor: CaseRegistryDetailID\ItemType\SubmittingForSubmittingFor[dbo].[uniqueid]9NOT NULLClinical Item (e.g. Problem_Header.ID)
OnsetDTTMdatetime8NULL allowedOnset date and time
ResolvedDTTMdatetime8NULL allowedResolved date and time