Report Builder Columns Table Schema (report_builder_columns)


Description

Defines columns belonging to each report

report_builder_columns table columns

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

ID of the report this column belongs to
type VARCHAR 255

Type of column, used with value to identify the column option
value VARCHAR 255

Value of column, used with type to identify the column option
transform VARCHAR 30 √ null

Column transform function, null means none
aggregate VARCHAR 30 √ null

Aggregation type, null means none
heading VARCHAR 1024 √ null

Visible heading describing the column to report users
sortorder BIGINT 19 null

Determines the order that the columns appear in the report
hidden SMALLINT 5 0

If non zero then column is hidden from users by default
customheading SMALLINT 5 0

Indicates whether the user has customised a heading or if they are still using the default column heading value

Table contained -1 rows

report_builder_columns table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilcolu_rep_ix Performance Asc reportid

report_builder_columns table relationships

Close relationships within degrees of separation