favourite

0 rows


Description

Stores the relationship between an arbitrary item (itemtype,

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
component VARCHAR 100
itemtype VARCHAR 100
itemid BIGINT 19 null
contextid BIGINT 19 null
context.id favo_con2_fkR
userid BIGINT 19 null
user.id favo_use2_fkR
ordering BIGINT 19 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
favo_comiteiteconuse2_uix Must be unique Asc/Asc/Asc/Asc/Asc component + itemtype + itemid + contextid + userid
favo_con4_ix Performance Asc contextid
favo_use4_ix Performance Asc userid

Relationships