Table: dbo.Magnetic_Media_File_Client_Type
Table to store the various types of Magnetic Media Clients that can exist in a magnetic media file
Columns
NameTypeConstraintsDescription
magnetic_media_file_client_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (24)NOT NULLDescription of the magnetic media client type.
Primary key
NameColumnsDescription
PK_Magnetic_Media_File_Client_Typemagnetic_media_file_client_type_KEY
Unique constraints
NameColumnsDescription
UK_Magnetic_Media_File_Client_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Magnetic_Media_File_Client__Magnetic_Media_File_Client_Type__magnetic_media_file_client_type_KEYmagnetic_media_file_client_type_KEYMagnetic_Media_File_Client

Schema diagram