Table: dbo.Report_Profile
This table holds the primary key, description and report type of every client report profile. Client report profiles are overrides on a per-client basis of a global report profile. Therefore, this table also holds a client key to tell us for which client this client profile is intended.
Columns
Name | Type | Constraints | Description
report_profile_KEY | int (4) | NOT NULL | Primary key
description | nvarchar (200) | NOT NULL | The report profile description
client_KEY | int (4) | NOT NULL | Client key
restrict_from_client_access | bit (1) | NOT NULL | Contains the Restriction for client access application Selection: 1 = Restrict Report profile in ACSClientAccess, 0 = Do not

Primary key
Name | Columns | Description
PK_Report_Profile | report_profile_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Report_Profile__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Global_Report_Profile_N_Report_Profile__Report_Profile__report_profile_KEY | report_profile_KEY | Global_Report_Profile_N_Report_Profile |
FK_Report_Profile_Element__Report_Profile__report_profile_KEY | report_profile_KEY | Report_Profile_Element |