report

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('reporter.report_id_seq'::regclass)
schedule.report schedule_report_fkey R
owner int4 10 null
usr.id report_owner_fkey R
create_time timestamptz 35,6 now()
name text 2147483647 ''::text
description text 2147483647 ''::text
template int4 10 null
template.id report_template_fkey R
data text 2147483647 null
folder int4 10 null
report_folder.id report_folder_fkey R
recur bool 1 false
recurrence interval 49,6 √ null

Indexes

Constraint Name Type Sort Column(s)
report_pkey Primary key Asc id
rpt_rpt_fldr_idx Performance Asc folder
rpt_rpt_owner_idx Performance Asc owner
rtp_report_folder_once_idx Must be unique Asc/Asc name + folder

Relationships

Close relationships within degrees of separation