Table: dbo.Client_N_Report_Folder
Linker/Dictionary table that associates Client records with Report_Folder records.
Columns
NameTypeConstraintsDescription
client_n_report_folder_KEYint (4)NOT NULLPrimary Key for this table.
client_KEYint (4)NOT NULLForeign key to Client table.
report_folder_KEYint (4)NOT NULLForeign key to Report_Folder table.
Primary key
NameColumnsDescription
PK_Client_N_Report_Folderclient_n_report_folder_KEY
Unique constraints
NameColumnsDescription
UK_Client_N_Report_Folder$client_KEY$report_folder_KEYclient_KEY, report_folder_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_N_Report_Folder__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_N_Report_Folder__Report_Folder__report_folder_KEYreport_folder_KEYReport_Folder (report_folder_KEY)

Schema diagram