Contentbank Content Table Schema (contentbank_content)


Description

This table stores content data in the content bank.

contentbank_content table 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_fk R

References context.id.
instanceid BIGINT 19 √ null
configdata LONGTEXT 2147483647 √ null
usercreated BIGINT 19 null
user.id contcont_use4_fk R

The original author of the content
usermodified BIGINT 19 √ null
user.id contcont_use3_fk R
timecreated BIGINT 19 0
timemodified BIGINT 19 √ 0

Table contained -1 rows

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

contentbank_content table relationships

Close relationships within degrees of separation