items


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
attempts.root_item_id fk_attempts_root_item_id_items_id N
group_item_additional_times.item_id fk_group_item_additional_times_item_id_items_id C
groups.root_activity_id fk_groups_root_activity_id_items_id N
groups.root_skill_id fk_groups_root_skill_id_items_id N
item_dependencies.dependent_item_id fk_item_dependencies_dependent_item_id_items_id C
item_dependencies.item_id fk_item_dependencies_item_id_items_id C
items_ancestors.ancestor_item_id fk_items_ancestors_ancestor_item_id_items_id R
items_ancestors.child_item_id fk_items_ancestors_child_item_id_items_id C
items_items.child_item_id fk_items_items_child_item_id_items_id C
items_items.parent_item_id fk_items_items_parent_item_id_items_id R
items_propagate.id fk_id C
items_strings.item_id fk_items_strings_item_id_items_id C
permissions_generated.item_id fk_permissions_generated_item_id_items_id C
permissions_granted.item_id fk_permissions_granted_item_id_items_id C
permissions_propagate.item_id fk_permissions_propagate_item_id_items_id C
results.item_id fk_results_item_id_items_id C
results_recompute_for_items.item_id fk_results_propagate_items_to_items C
threads.item_id fk_threads_item_id_items_id C
items_strings.item_id fk_items_id_default_language_tag_items_strings_item_language_tag R
url VARCHAR 2048 √ null

Url of the item, as will be loaded in the iframe
options TEXT 65535 √ null

Options passed to the task, formatted as a JSON object
platform_id INT 10 √ null
platforms.id fk_items_platform_id_platforms_id R

Platform that hosts the item content. Auto-generated from url by triggers.
text_id VARCHAR 200 √ null

Unique string identifying the item, independently of where it is hosted
repository_path TEXT 65535 √ null
type enum('Chapter', 'Task', 'Skill') 7 null
title_bar_visible TINYINT UNSIGNED 3 1

Whether the title bar should be visible initially when this item is loaded
display_details_in_parent TINYINT UNSIGNED 3 0

If true, display a large icon, the subtitle, and more within the parent chapter
uses_api BIT 1 1

Whether the item uses the task integration API, at the minimum the load and getHeight functions.
read_only BIT 1 0

Prevents any modification of the scores for this item (typically, to display a contest item after the end date of the contest)
full_screen enum('forceYes', 'forceNo', 'default') 8 default

Whether the item should be loaded in full screen mode (without the navigation panel and most of the top header). By default, tasks are displayed in full screen, but not chapters.
hints_allowed BIT 1 0

Whether hints are allowed for tasks accessed through this chapter (currently unused)
fixed_ranks BIT 1 0

If true, prevents users from changing the order of the children by drag&drop and auto-calculation of the order of children. Allows for manual setting of the order, for instance in cases where we want to have multiple items with the same order (check items_items.child_order).
validation_type enum('None', 'All', 'AllButOne', 'Categories', 'One', 'Manual') 10 All

Criteria for this item to be considered validated, based on the status of the children. Ex: "All" means all children should be validated. Categories means items of the "Validation" category need to be validated.
supported_lang_prog VARCHAR 200 √ null

Comma-separated list of programming languages that this item can be solved with; not currently used.
default_language_tag VARCHAR 6 null
items_strings.language_tag fk_items_id_default_language_tag_items_strings_item_language_tag R

Default language tag of this task (the reference, used when comparing translations)
requires_explicit_entry BIT 1 0

Whether this item requires an explicit entry to be started (create an attempt)
entry_participant_type enum('User', 'Team') 4 User

For explicit-entry items, the type of participants who can enter
entry_min_admitted_members_ratio enum('All', 'Half', 'One', 'None') 4 None

The ratio of members in the team (a user alone being considered as a team of one) who needs the “can_enter” permission so that the group can enter
entering_time_min DATETIME 19 1000-01-01 00:00:00

Lower bound on the entering time. Has the priority over given can_enter_from/until permissions.
entering_time_max DATETIME 19 9999-12-31 23:59:59

Upper bound on the entering time. Has the priority over given can_enter_from/until permissions.
entry_frozen_teams BIT 1 0

Whether teams require to have frozen_membership for entering
participants_group_id BIGINT 19 √ null

Group to which all the entered participants (users or teams) belong. Must not be null for an explicit-entry item.
entry_max_team_size INT 10 0

The maximum number of members a team can have to enter
allows_multiple_attempts BIT 1 0

Whether participants can create multiple attempts when working on this item
duration TIME 8 √ null

Not NULL if time-limited item. If so, how long users have to work on it.
show_user_infos BIT 1 0

Always show user infos in title bar of all descendants. Allows the teacher to see who is working on what (e.g., during an exam).
children_layout enum('List', 'Grid') 4 √ List

How the children list are displayed (for chapters and skills)
no_score BIT 1 0

Whether this item should not have any score displayed / propagated to the parent.
prompt_to_join_group_by_code BIT 1 0

Whether the UI should display a form for joining a group by code on the item page

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_items_id_default_language_tag_items_strings_item_language_tag Performance Asc/Asc id + default_language_tag
fk_items_platform_id_platforms_id Performance Asc platform_id
unique_text_id_unique Must be unique Asc text_id

Relationships

Close relationships within degrees of separation