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
NameTypeConstraintsDescription
report_profile_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (200)NOT NULLThe report profile description
client_KEYint (4)NOT NULLClient key
restrict_from_client_accessbit (1)NOT NULLContains the Restriction for client access application Selection: 1 = Restrict Report profile in ACSClientAccess, 0 = Do not
Primary key
NameColumnsDescription
PK_Report_Profilereport_profile_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Profile__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Profile_Element__Report_Profile__report_profile_KEYreport_profile_KEYReport_Profile_Element
FK_Global_Report_Profile_N_Report_Profile__Report_Profile__report_profile_KEYreport_profile_KEYGlobal_Report_Profile_N_Report_Profile

Schema diagram