report_folder

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('reporter.report_folder_id_seq'::regclass)
report.folder report_folder_fkey R
report_folder.parent report_folder_parent_fkey R
parent int4 10 √ null
report_folder.id report_folder_parent_fkey R
owner int4 10 null
usr.id report_folder_owner_fkey R
create_time timestamptz 35,6 now()
name text 2147483647 null
shared bool 1 false
simple_reporter bool 1 false
share_with int4 10 √ null
org_unit.id report_folder_share_with_fkey R

Indexes

Constraint Name Type Sort Column(s)
report_folder_pkey Primary key Asc id
rpt_report_folder_once_idx Must be unique Asc/Asc/Asc name + owner + simple_reporter
rpt_report_folder_once_parent_idx Must be unique Asc/Asc name + parent
rpt_rpt_fldr_owner_idx Performance Asc owner

Relationships

Close relationships within degrees of separation