app_report_builder_saved

0 rows


Description

Stores saved searches for reports

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_report_builder_saved_id_seq'::regclass)
app_report_builder_schedule.savedsearchid Defined in XMLR
reportid int8 19 null
app_report_builder.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
name varchar 255 ''::character varying
search text 2147483647 √ null
ispublic int2 5 0
timemodified int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_repobuilsave_id_pk Primary key Asc id
app_repobuilsave_rep2_ix Performance Asc reportid
app_repobuilsave_rep_ix Performance Asc reportid
app_repobuilsave_use2_ix Performance Asc userid
app_repobuilsave_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation