Table: dbo.Magnetic_Media_File_N_Tax_Agent
Table a link between magnetic media files and tax agents.
Columns
NameTypeConstraintsDescription
magnetic_media_file_KEYint (4)NOT NULLPrimary key and Foreign key into the Magnetic_Media_File table.
tax_agent_KEYint (4)NOT NULLForeign key into the Tax_Agent table.
Primary key
NameColumnsDescription
PK_Magnetic_Media_File_N_Tax_Agent$magnetic_media_file_KEYmagnetic_media_file_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Magnetic_Media_File_N_Tax_Agent__Magnetic_Media_File__magnetic_media_file_KEYmagnetic_media_file_KEYMagnetic_Media_File (magnetic_media_file_KEY)
FK_Magnetic_Media_File_N_Tax_Agent__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent (tax_agent_KEY)

Schema diagram