reports

136 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
batch_report_items.report_id fk_batch_report_items_report_id C
print_form.report_id fk_print_form_report_id N
property_reports.report_id property_reports_report_id_fk C
report_name text 2147483647 null
category t_report_category 24 √ null

category for report form_types for print_form
report_type t_report_types 14 null
options json 2147483647 √ null
path_url text 2147483647 √ null
report_filename text 2147483647 √ null

name of file name report - Use store report name in report service - Referent in frontend
permission_code bpchar 5 √ ('8'::text || lpad((id)::text, 4, '0'::text))
permission.code Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
reports_pk Primary key Asc id
reports_category_idx Performance Asc category
reports_report_name_idx Performance Asc report_name

Relationships

Close relationships within degrees of separation