Report Builder Settings Table Schema (report_builder_settings)


Description

Contains settings for individual reports

report_builder_settings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
reportid BIGINT 19 null
report_builder.id repobuilsett_rep2_fk R

ID of the report the setting belongs to

type VARCHAR 100

Component of report builder that the setting is for

name VARCHAR 100

Name of the setting

value VARCHAR 255 √ null

Value of the setting

Table contained -1 rows

report_builder_settings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilsett_rep_ix Performance Asc reportid
repobuilsett_reptypnam_uix Must be unique Asc/Asc/Asc reportid + type + name

report_builder_settings table relationships