Report Builder Saved Table Schema (report_builder_saved)


Description

Stores saved searches for reports

report_builder_saved table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
report_builder_schedule.savedsearchid repobuilsche_sav2_fk R
reportid BIGINT 19 null
report_builder.id repobuilsave_rep3_fk R

ID of the report this saved search belongs to
userid BIGINT 19 null
user.id repobuilsave_use3_fk R

User who saved the search
name VARCHAR 255

A name describing the saved search
search LONGTEXT 2147483647 √ null

Serialized data containing the search details
ispublic SMALLINT 5 0

If none zero, the saved search is visible to all users, not just the creator
timemodified BIGINT 19 0

udpated when saved changes

Table contained -1 rows

report_builder_saved table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilsave_rep2_ix Performance Asc reportid
repobuilsave_rep_ix Performance Asc reportid
repobuilsave_use2_ix Performance Asc userid
repobuilsave_use_ix Performance Asc userid

report_builder_saved table relationships

Close relationships within degrees of separation