Table: Staff_Report_Definition
Columns
Name | Type | Constraints | Description
staff_report_definition_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
staff_KEY | int | NOT NULL | Key to the staff to whom these default options belong.
report_definition_KEY | int | NOT NULL | Key to a Report Definition to which these default options belong.
default_options | nvarchar (-1) | NOT NULL | The default report options in serialized XML format.
create_date_utc | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Staff_Report_Definition$staff_report_definition_KEY | staff_report_definition_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Staff_Report_Definition$report_definition_KEY | report_definition_KEY | Index supports foreign key FK_Staff_Report_Definition__Report_Definition__report_definition_KEY
IX_Staff_Report_Definition$staff_KEY | staff_KEY | Index supports foreign key FK_Staff_Report_Definition__Staff__staff_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Report_Definition__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition | on delete cascade;
FK_Staff_Report_Definition__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;