contentbank_content

0 rows


Description

This table stores content data in the content bank.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
name VARCHAR 255
contenttype VARCHAR 100
contextid BIGINT 19 null
context.id contcont_con2_fkR

References context.id.

visibility BIT 1 1
instanceid BIGINT 19 null
configdata LONGTEXT 2147483647 null
usercreated BIGINT 19 null
user.id contcont_use4_fkR

The original author of the content

usermodified BIGINT 19 null
user.id contcont_use3_fkR
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
contcont_con_ix Performance Asc contextid
contcont_conconins_ix Performance Asc/Asc/Asc contextid + contenttype + instanceid
contcont_nam_ix Performance Asc name
contcont_use2_ix Performance Asc usercreated
contcont_use_ix Performance Asc usermodified

Relationships