reportbuilder_report

0 rows


Description

Table to represent a report

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
reportbuilder_audience.reportid repoaudi_rep2_fkR
reportbuilder_column.reportid repocolu_rep2_fkR
reportbuilder_filter.reportid repofilt_rep2_fkR
reportbuilder_schedule.reportid reposche_rep2_fkR
name VARCHAR 255 √ null
source VARCHAR 255
type TINYINT 3 0
uniquerows BIT 1 0
conditiondata LONGTEXT 2147483647 √ null
settingsdata LONGTEXT 2147483647 √ null
contextid BIGINT 19 null
context.id reporepo_con2_fkR
component VARCHAR 100
area VARCHAR 100
itemid BIGINT 19 0
usercreated BIGINT 19 0
user.id reporepo_use3_fkR
usermodified BIGINT 19 0
user.id reporepo_use4_fkR
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
reporepo_con2_ix Performance Asc contextid
reporepo_use3_ix Performance Asc usercreated
reporepo_use4_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation