contentbank_content

Columns

Related columns Constraint Comments

Search:

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

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

Showing 1 to 10 of 11 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
contcont_con2_ix	Performance	Asc	contextid
contcont_conconins2_ix	Performance	Asc/Asc/Asc	contextid + contenttype + instanceid
contcont_nam2_ix	Performance	Asc	name
contcont_use3_ix	Performance	Asc	usermodified
contcont_use4_ix	Performance	Asc	usercreated

Showing 1 to 6 of 6 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation