Report Builder Graph Table Schema (report_builder_graph)


Report graphs

report_builder_graph table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
reportid BIGINT 19 null repobuilgrap_rep2_fk R

ID of the report this graph belongs to

type VARCHAR 20

Type of graph, empty means none

stacked BIT 1 0

Stack data series? Only some types support this.

maxrecords BIGINT 19 500

Maximum of records used in a graph?

category VARCHAR 255

none,reversed or name of one column

legend VARCHAR 255

name of one column, used when axis are reversed

series LONGTEXT 2147483647 null

Series info encoded in json format

settings LONGTEXT 2147483647 null

Custom graph configuration in INI format

timemodified BIGINT 19 0

udpated when graph changes

Table contained -1 rows

report_builder_graph table indexes

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

report_builder_graph table relationships