favourite

0 rows

Description

Stores the relationship between an arbitrary item (itemtype,

Columns

Related columns Constraint Comments

Search:

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

favo_con2_fkR

userid

BIGINT

19

null

favo_use2_fkR

ordering

BIGINT

19

√

null

timecreated

BIGINT

19

null

timemodified

BIGINT

19

null

Showing 1 to 9 of 9 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation