Table: dbo.Client_N_Report_Folder | |||
Linker/Dictionary table that associates Client records with Report_Folder records. | |||
Columns | |||
Name | Type | Constraints | Description |
client_n_report_folder_KEY | int (4) | NOT NULL | Primary Key for this table. |
client_KEY | int (4) | NOT NULL | Foreign key to Client table. |
report_folder_KEY | int (4) | NOT NULL | Foreign key to Report_Folder table. |
Primary key | |||
Name | Columns | Description | |
PK_Client_N_Report_Folder | client_n_report_folder_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Client_N_Report_Folder$client_KEY$report_folder_KEY | client_KEY, report_folder_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Client_N_Report_Folder__Client__client_KEY | client_KEY | Client (client_KEY) | |
FK_Client_N_Report_Folder__Report_Folder__report_folder_KEY | report_folder_KEY | Report_Folder (report_folder_KEY) |