bireport


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
bireportaccess.biReportId fk_biAccessReport R
bireportaccess_aud.biReportId Implied Constraint R
biScriptId INT 10 null
biscript.id FKqpcpk3a5chegdrf5etdo6b06va R
data LONGTEXT 2147483647 null
params JSON 1073741824 null
name VARCHAR 64 null
description LONGTEXT 2147483647 null
widget TINYINT 3 0
dateLastModified DATETIME 26 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKqpcpk3a5chegdrf5etdo6b06va Performance Asc biScriptId
UKqq9aeidsb8w2vxm8sx3498dnt7 Must be unique Asc name

Relationships