template_folder

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('reporter.template_folder_id_seq'::regclass)
template.folder template_folder_fkey R
template_folder.parent template_folder_parent_fkey R
parent int4 10 √ null
template_folder.id template_folder_parent_fkey R
owner int4 10 null
usr.id template_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 template_folder_share_with_fkey R

Indexes

Constraint Name Type Sort Column(s)
template_folder_pkey Primary key Asc id
rpt_template_folder_once_idx Must be unique Asc/Asc/Asc name + owner + simple_reporter
rpt_template_folder_once_parent_idx Must be unique Asc/Asc name + parent
rpt_tmpl_fldr_owner_idx Performance Asc owner

Relationships

Close relationships within degrees of separation