Table: Print_Option
Columns
Name | Type | Constraints | Description
print_option_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 | The staff these print option are for.
output_to_printer | bit | NOT NULL | Output reports to printer.
output_to_fcs | bit | NOT NULL | Output reports to FileCabinet Solution.
output_to_file | bit | NOT NULL | Output reports to file.
output_to_email | bit | NOT NULL | Output reports to email.
printer_name | nvarchar (260) | NOT NULL | Printer name to print to.
number_of_copies | int | NOT NULL | Number of copies to print.
collate_copies | bit | NOT NULL | Collate copies.
fcs_data_location | nvarchar (260) | NOT NULL | FileCabinet Solution data location to output to.
fcs_firm_data | bit | NOT NULL | Send to firm drawer.
fcs__staff_KEY | int |  | The staff whose drawer reports will be output to.
fcs__client_KEY | int |  | The client whose drawer reports will be output to.
file_output_type | int | NOT NULL | The type of file format to output reports to.
file_destination | nvarchar (260) | NOT NULL | The path to output reports to.
email_output_type | int | NOT NULL | The type of file format to email reports in.
email_recipients | nvarchar (-1) | NOT NULL | The email recipients.
create_date_utc | datetime | NOT NULL |
output_labels_to_printer | bit | NOT NULL | Output labels to printer.
label_printer_name | nvarchar (260) | NOT NULL | Printer name to print labels to.
label__report_definition_KEY | int |  | The label format to use when printing labels.
output_to_gofileroom | bit | NOT NULL | Determines if output will be sent to GoFileRoom
gofileroom_output_type | int | NOT NULL | The type of file format to export to GoFileRoom.
output_letters_to_printer | bit | NOT NULL | Output letters to printer.
letter__report_definition_KEY | int |  | The letter format to use when printing letters.
output_to_online_bill_pay | bit | NOT NULL | Output reports to Online Bill Pay.
email_save_drafts | bit | NOT NULL | Save e-mails to Drafts folder (do not send).
fcs_file_by_type | int | NOT NULL | How to file a report (e.g., by the firm's current-year-end date).
fcs_create_link | bit | NOT NULL |
gofileroom_create_link | bit | NOT NULL |
file_create_link | bit | NOT NULL |

Primary key
Name | Columns | Description
PK_Print_Option$print_option_KEY | print_option_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Print_Option$staff_KEY | staff_KEY |
Indexes
Name | Columns | Description
IX_Print_Option$fcs__client_KEY | fcs__client_KEY | Index supports foreign key FK_Print_Option__Client__fcs__client_KEY
IX_Print_Option$fcs__staff_KEY | fcs__staff_KEY | Index supports foreign key FK_Print_Option__Staff__fcs__staff_KEY
IX_Print_Option$label__report_definition_KEY | label__report_definition_KEY | Index supports foreign key FK_Print_Option__Report_Definition__label__report_definition_KEY
IX_Print_Option$letter__report_definition_KEY | letter__report_definition_KEY | Index supports foreign key FK_Print_Option__Report_Definition__letter__report_definition_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_Option__Client__fcs__client_KEY | fcs__client_KEY | Client | on delete set null;
FK_Print_Option__Report_Definition__label__report_definition_KEY | label__report_definition_KEY | Report_Definition |
FK_Print_Option__Report_Definition__letter__report_definition_KEY | letter__report_definition_KEY | Report_Definition |
FK_Print_Option__Staff__fcs__staff_KEY | fcs__staff_KEY | Staff |
FK_Print_Option__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;