| 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) | |