Table: dbo.Report_Profile_Type
This table contains the different types of report profiles. Profiles of type firm can only hold firm level reports. Profiles of type client can only hold client level reports.
Columns
NameTypeConstraintsDescription
report_profile_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (60)NOT NULLThe report profile type description.
Primary key
NameColumnsDescription
PK_Report_Profile_Typereport_profile_type_KEY
Unique constraints
NameColumnsDescription
UK_Report_Profile_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Global_Report_Profile__Report_Profile_Type__report_profile_type_KEYreport_profile_type_KEYGlobal_Report_Profile

Schema diagram