reportbuilder_user_filter

0 rows


Description

Defines user report filter

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
reportid BIGINT 19 0
reportbuilder_report.id repouserfilt_rep2_fkR
filterdata LONGTEXT 2147483647 null
usercreated BIGINT 19 0
user.id repouserfilt_use3_fkR
usermodified BIGINT 19 0
user.id repouserfilt_use4_fkR
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repouserfilt_rep2_ix Performance Asc reportid
repouserfilt_repuse2_uix Must be unique Asc/Asc reportid + usercreated
repouserfilt_use3_ix Performance Asc usercreated
repouserfilt_use4_ix Performance Asc usermodified

Relationships