output_folder

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('reporter.output_folder_id_seq'::regclass)
output_folder.parent output_folder_parent_fkey R
schedule.folder schedule_folder_fkey R
parent int4 10 √ null
output_folder.id output_folder_parent_fkey R
owner int4 10 null
usr.id output_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 output_folder_share_with_fkey R

Indexes

Constraint Name Type Sort Column(s)
output_folder_pkey Primary key Asc id
rpt_output_fldr_owner_idx Performance Asc owner
rpt_output_folder_once_idx Must be unique Asc/Asc/Asc name + owner + simple_reporter
rpt_output_folder_once_parent_idx Must be unique Asc/Asc name + parent

Relationships

Close relationships within degrees of separation