Tables [dbo].[FDAMedicalDevices]
Medical devices Master
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_FDAMedicalDevices_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the FDAMedicalDevices table
Cluster Key CIX_FDAMedicalDevices_DeviceID: DeviceIDDeviceIDvarchar(30)30NOT NULLMedical device Identifier
DeviceXMLCompressedvarbinary(max)maxNOT NULLDevice XML in compressed format
CreateDTTMdatetime8NOT NULL Created date and time
LastUpdateDTTMdatetime8NOT NULLLast updated date and time