Report Builder Columns Table Schema (report_builder_columns)


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 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