Tables [dbo].[Item_Site]
Associates a Site to an Order Item. Although not FK the SiteDE points to the Site_DE.ID. Also the ItemID is not FK to the associated Order table but does point to the ID of the table. i.e ItemType = Immunization will then point the ItemID to the Item_Immunization.ID
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Key IX_Item_Site: ItemID\ItemTypeIndexes TWstat_Item_Site_ItemType_ItemID, TWstat_Item_Site_RecordedDTTM_ItemID_ItemType(2)ItemID[dbo].[uniqueid]9NOT NULLThis is the Item ID associated to the particular Order
Cluster Key IX_Item_Site: ItemID\ItemTypeIndexes TWstat_Item_Site_ItemType_ItemID, TWstat_Item_Site_RecordedDTTM_ItemID_ItemType(2)ItemTypevarchar(50)50NOT NULLThis is a character description of the type of Order associated to the record. i.e Problem, Medication, Immunization etc.
Indexes TWstat_Item_Site_SiteDESiteDE[dbo].[dict_id]5NOT NULLSite. Link to Site_DE.ID
Indexes TWstat_Item_Site_RecordedDTTM_ItemID_ItemTypeRecordedDTTMdatetime8NOT NULLRecorded Date and Time
UserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
Primary Key PK_item_site: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key ti the Item_Site table