item_dependencies


Columns

Column Type Size Nulls Auto Default Children Parents Comments
item_id BIGINT 19 null
items.id fk_item_dependencies_item_id_items_id C
dependent_item_id BIGINT 19 null
items.id fk_item_dependencies_dependent_item_id_items_id C
score INT 10 100

Score of the item from which the dependent item is unlocked (if grant_content_view is true), i.e. can_view:content is given
grant_content_view BIT 1 1

Whether obtaining the required score at the item grants content view to the dependent item

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc item_id + dependent_item_id
fk_item_dependencies_dependent_item_id_items_id Performance Asc dependent_item_id

Relationships

Close relationships within degrees of separation