app_report_builder_filters

0 rows


Description

Defines filters belonging to each report

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_report_builder_filters_id_seq'::regclass)
reportid int8 19 null
app_report_builder.id Defined in XML R
type varchar 255 ''::character varying
value varchar 255 ''::character varying
sortorder int8 19 null
filteringrequired int2 5 0
advanced int2 5 0
filtername varchar 1024 null
customname int2 5 0
region int2 5 0
defaultvalue text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
app_repobuilfilt_id_pk Primary key Asc id
app_repobuilfilt_rep_ix Performance Asc reportid

Check Constraints

Constraint Name Constraint
app_report_builder_filtersfilteringrequired_enum ((filteringrequired = ANY (ARRAY[0, 1])))

Relationships