DMOJ
Tables (90)
auth_group
- id — int(11) — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — int(11) — Primary key — NOT NULL
- group_id — int(11) — Foreign key → auth_group.id — NOT NULL
- permission_id — int(11) — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- content_type_id — int(11) — Foreign key → django_content_type.id — NOT NULL
- codename — varchar(100) — NOT NULL
auth_user
- id — int(11) — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- username — varchar(150) — NOT NULL
- first_name — varchar(150) — NOT NULL
- last_name — varchar(150) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
auth_user_groups
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → auth_user.id — NOT NULL
- group_id — int(11) — Foreign key → auth_group.id — NOT NULL
auth_user_user_permissions
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → auth_user.id — NOT NULL
- permission_id — int(11) — Foreign key → auth_permission.id — NOT NULL
django_admin_log
- id — int(11) — Primary key — NOT NULL
- action_time — datetime(6) — NOT NULL
- object_id — longtext
- object_repr — varchar(200) — NOT NULL
- action_flag — smallint(5) — NOT NULL
- change_message — longtext — NOT NULL
- content_type_id — int(11) — Foreign key → django_content_type.id
- user_id — int(11) — Foreign key → auth_user.id — NOT NULL
django_content_type
- id — int(11) — Primary key — NOT NULL
- app_label — varchar(100) — NOT NULL
- model — varchar(100) — NOT NULL
django_flatpage
- id — int(11) — Primary key — NOT NULL
- url — varchar(100) — NOT NULL
- title — varchar(200) — NOT NULL
- content — longtext — NOT NULL
- enable_comments — tinyint(1) — NOT NULL
- template_name — varchar(70) — NOT NULL
- registration_required — tinyint(1) — NOT NULL
django_flatpage_sites
- id — int(11) — Primary key — NOT NULL
- flatpage_id — int(11) — Foreign key → django_flatpage.id — NOT NULL
- site_id — int(11) — Foreign key → django_site.id — NOT NULL
django_migrations
- id — int(11) — Primary key — NOT NULL
- app — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- applied — datetime(6) — NOT NULL
django_redirect
- id — int(11) — Primary key — NOT NULL
- site_id — int(11) — Foreign key → django_site.id — NOT NULL
- old_path — varchar(200) — NOT NULL
- new_path — varchar(200) — NOT NULL
django_session
- session_key — varchar(40) — Primary key — NOT NULL
- session_data — longtext — NOT NULL
- expire_date — datetime(6) — NOT NULL
django_site
- id — int(11) — Primary key — NOT NULL
- domain — varchar(100) — NOT NULL
- name — varchar(50) — NOT NULL
impersonate_impersonationlog
- id — int(11) — Primary key — NOT NULL
- session_key — varchar(40) — NOT NULL
- session_started_at — datetime(6)
- session_ended_at — datetime(6)
- impersonating_id — int(11) — Foreign key → auth_user.id — NOT NULL
- impersonator_id — int(11) — Foreign key → auth_user.id — NOT NULL
judge_blogpost
- id — int(11) — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- slug — varchar(50) — NOT NULL
- visible — tinyint(1) — NOT NULL
- sticky — tinyint(1) — NOT NULL
- publish_on — datetime(6) — NOT NULL
- content — longtext — NOT NULL
- summary — longtext — NOT NULL
- og_image — varchar(150) — NOT NULL
judge_blogpost_authors
- id — int(11) — Primary key — NOT NULL
- blogpost_id — int(11) — Foreign key → judge_blogpost.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_class
- id — int(11) — Primary key — NOT NULL
- name — varchar(128) — NOT NULL
- slug — varchar(128) — NOT NULL
- description — longtext — NOT NULL
- is_active — tinyint(1) — NOT NULL
- access_code — varchar(7)
- organization_id — int(11) — Foreign key → judge_organization.id — NOT NULL
judge_class_admins
- id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → judge_class.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_class_members
- id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → judge_class.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_comment
- id — int(11) — Primary key — NOT NULL
- time — datetime(6) — NOT NULL
- page — varchar(30) — NOT NULL
- score — int(11) — NOT NULL
- body — longtext — NOT NULL
- hidden — tinyint(1) — NOT NULL
- lft — int(10) — NOT NULL
- rght — int(10) — NOT NULL
- tree_id — int(10) — NOT NULL
- level — int(10) — NOT NULL
- author_id — int(11) — Foreign key → judge_profile.id — NOT NULL
- parent_id — int(11) — Foreign key → judge_comment.id
- revisions — int(11) — NOT NULL
judge_commentlock
- id — int(11) — Primary key — NOT NULL
- page — varchar(30) — NOT NULL
judge_commentvote
- id — int(11) — Primary key — NOT NULL
- score — int(11) — NOT NULL
- comment_id — int(11) — Foreign key → judge_comment.id — NOT NULL
- voter_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest
- id — int(11) — Primary key — NOT NULL
- key — varchar(20) — NOT NULL
- name — varchar(100) — NOT NULL
- description — longtext — NOT NULL
- start_time — datetime(6) — NOT NULL
- end_time — datetime(6) — NOT NULL
- time_limit — bigint(20)
- is_visible — tinyint(1) — NOT NULL
- is_rated — tinyint(1) — NOT NULL
- use_clarifications — tinyint(1) — NOT NULL
- rate_all — tinyint(1) — NOT NULL
- is_private — tinyint(1) — NOT NULL
- hide_problem_tags — tinyint(1) — NOT NULL
- run_pretests_only — tinyint(1) — NOT NULL
- og_image — varchar(150) — NOT NULL
- logo_override_image — varchar(150) — NOT NULL
- user_count — int(11) — NOT NULL
- summary — longtext — NOT NULL
- access_code — varchar(255) — NOT NULL
- format_name — varchar(32) — NOT NULL
- format_config — longtext
- rating_ceiling — int(11)
- rating_floor — int(11)
- is_organization_private — tinyint(1) — NOT NULL
- problem_label_script — longtext — NOT NULL
- points_precision — int(11) — NOT NULL
- scoreboard_visibility — varchar(1) — NOT NULL
- locked_after — datetime(6)
- hide_problem_authors — tinyint(1) — NOT NULL
- show_short_display — tinyint(1) — NOT NULL
- tester_see_scoreboard — tinyint(1) — NOT NULL
- limit_join_organizations — tinyint(1) — NOT NULL
- tester_see_submissions — tinyint(1) — NOT NULL
judge_contest_authors
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_banned_users
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_classes
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- class_id — int(11) — Foreign key → judge_class.id — NOT NULL
judge_contest_curators
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_join_organizations
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- organization_id — int(11) — Foreign key → judge_organization.id — NOT NULL
judge_contest_organizations
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- organization_id — int(11) — Foreign key → judge_organization.id — NOT NULL
judge_contest_private_contestants
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_rate_exclude
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_spectators
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_tags
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- contesttag_id — int(11) — Foreign key → judge_contesttag.id — NOT NULL
judge_contest_testers
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_view_contest_scoreboard
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contest_view_contest_submissions
- id — int(11) — Primary key — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_contestmoss
- id — int(11) — Primary key — NOT NULL
- language — varchar(10) — NOT NULL
- submission_count — int(10) — NOT NULL
- url — varchar(200)
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
judge_contestparticipation
- id — int(11) — Primary key — NOT NULL
- start — datetime(6) — NOT NULL
- score — double — NOT NULL
- cumtime — int(10) — NOT NULL
- virtual — int(11) — NOT NULL
- format_data — longtext
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- user_id — int(11) — Foreign key → judge_profile.id — NOT NULL
- is_disqualified — tinyint(1) — NOT NULL
- tiebreaker — double — NOT NULL
judge_contestproblem
- id — int(11) — Primary key — NOT NULL
- points — int(11) — NOT NULL
- partial — tinyint(1) — NOT NULL
- is_pretested — tinyint(1) — NOT NULL
- order — int(10) — NOT NULL
- output_prefix_override — int(11)
- max_submissions — int(11)
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
judge_contestsubmission
- id — int(11) — Primary key — NOT NULL
- points — double — NOT NULL
- is_pretest — tinyint(1) — NOT NULL
- participation_id — int(11) — Foreign key → judge_contestparticipation.id — NOT NULL
- problem_id — int(11) — Foreign key → judge_contestproblem.id — NOT NULL
- submission_id — int(11) — Foreign key → judge_submission.id — NOT NULL
judge_contesttag
- id — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- color — varchar(7) — NOT NULL
- description — longtext — NOT NULL
judge_judge
- id — int(11) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- created — datetime(6) — NOT NULL
- auth_key — varchar(100) — NOT NULL
- is_blocked — tinyint(1) — NOT NULL
- online — tinyint(1) — NOT NULL
- start_time — datetime(6)
- ping — double
- load — double
- description — longtext — NOT NULL
- last_ip — char(39)
- is_disabled — tinyint(1) — NOT NULL
judge_judge_problems
- id — int(11) — Primary key — NOT NULL
- judge_id — int(11) — Foreign key → judge_judge.id — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
judge_judge_runtimes
- id — int(11) — Primary key — NOT NULL
- judge_id — int(11) — Foreign key → judge_judge.id — NOT NULL
- language_id — int(11) — Foreign key → judge_language.id — NOT NULL
judge_language
- id — int(11) — Primary key — NOT NULL
- key — varchar(6) — NOT NULL
- name — varchar(20) — NOT NULL
- short_name — varchar(10)
- common_name — varchar(10) — NOT NULL
- ace — varchar(20) — NOT NULL
- pygments — varchar(20) — NOT NULL
- template — longtext — NOT NULL
- info — varchar(50) — NOT NULL
- description — longtext — NOT NULL
- extension — varchar(10) — NOT NULL
judge_languagelimit
- id — int(11) — Primary key — NOT NULL
- time_limit — double — NOT NULL
- memory_limit — int(11) — NOT NULL
- language_id — int(11) — Foreign key → judge_language.id — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
judge_license
- id — int(11) — Primary key — NOT NULL
- key — varchar(20) — NOT NULL
- link — varchar(256) — NOT NULL
- name — varchar(256) — NOT NULL
- display — varchar(256) — NOT NULL
- icon — varchar(256) — NOT NULL
- text — longtext — NOT NULL
judge_miscconfig
- id — int(11) — Primary key — NOT NULL
- key — varchar(30) — NOT NULL
- value — longtext — NOT NULL
judge_navigationbar
- id — int(11) — Primary key — NOT NULL
- order — int(10) — NOT NULL
- key — varchar(10) — NOT NULL
- label — varchar(20) — NOT NULL
- path — varchar(255) — NOT NULL
- regex — longtext — NOT NULL
- lft — int(10) — NOT NULL
- rght — int(10) — NOT NULL
- tree_id — int(10) — NOT NULL
- level — int(10) — NOT NULL
- parent_id — int(11) — Foreign key → judge_navigationbar.id
judge_organization
- id — int(11) — Primary key — NOT NULL
- name — varchar(128) — NOT NULL
- slug — varchar(128) — NOT NULL
- short_name — varchar(20) — NOT NULL
- about — longtext — NOT NULL
- creation_date — datetime(6) — NOT NULL
- is_open — tinyint(1) — NOT NULL
- slots — int(11)
- access_code — varchar(7)
- logo_override_image — varchar(150) — NOT NULL
- class_required — tinyint(1) — NOT NULL
judge_organization_admins
- id — int(11) — Primary key — NOT NULL
- organization_id — int(11) — Foreign key → judge_organization.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_organizationrequest
- id — int(11) — Primary key — NOT NULL
- time — datetime(6) — NOT NULL
- state — varchar(1) — NOT NULL
- reason — longtext — NOT NULL
- organization_id — int(11) — Foreign key → judge_organization.id — NOT NULL
- user_id — int(11) — Foreign key → judge_profile.id — NOT NULL
- request_class_id — int(11) — Foreign key → judge_class.id
judge_problem
- id — int(11) — Primary key — NOT NULL
- code — varchar(20) — NOT NULL
- name — varchar(100) — NOT NULL
- description — longtext — NOT NULL
- time_limit — double — NOT NULL
- memory_limit — int(10) — NOT NULL
- short_circuit — tinyint(1) — NOT NULL
- points — double — NOT NULL
- partial — tinyint(1) — NOT NULL
- is_public — tinyint(1) — NOT NULL
- is_manually_managed — tinyint(1) — NOT NULL
- date — datetime(6)
- og_image — varchar(150) — NOT NULL
- summary — longtext — NOT NULL
- user_count — int(11) — NOT NULL
- ac_rate — double — NOT NULL
- is_organization_private — tinyint(1) — NOT NULL
- group_id — int(11) — Foreign key → judge_problemgroup.id — NOT NULL
- license_id — int(11) — Foreign key → judge_license.id
- is_full_markup — tinyint(1) — NOT NULL
- submission_source_visibility_mode — varchar(1) — NOT NULL
judge_problem_allowed_languages
- id — int(11) — Primary key — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- language_id — int(11) — Foreign key → judge_language.id — NOT NULL
judge_problem_authors
- id — int(11) — Primary key — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_problem_banned_users
- id — int(11) — Primary key — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_problem_curators
- id — int(11) — Primary key — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_problem_organizations
- id — int(11) — Primary key — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- organization_id — int(11) — Foreign key → judge_organization.id — NOT NULL
judge_problem_testers
- id — int(11) — Primary key — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_problem_types
- id — int(11) — Primary key — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- problemtype_id — int(11) — Foreign key → judge_problemtype.id — NOT NULL
judge_problemclarification
- id — int(11) — Primary key — NOT NULL
- description — longtext — NOT NULL
- date — datetime(6) — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
judge_problemdata
- id — int(11) — Primary key — NOT NULL
- zipfile — varchar(100)
- generator — varchar(100)
- output_prefix — int(11)
- output_limit — int(11)
- feedback — longtext — NOT NULL
- checker — varchar(10) — NOT NULL
- checker_args — longtext — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- nobigmath — tinyint(1)
- unicode — tinyint(1)
judge_problemgroup
- id — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- full_name — varchar(100) — NOT NULL
judge_problempointsvote
- id — int(11) — Primary key — NOT NULL
- points — int(11) — NOT NULL
- note — longtext — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- voter_id — int(11) — Foreign key → judge_profile.id — NOT NULL
- vote_time — datetime(6) — NOT NULL
judge_problemtestcase
- id — int(11) — Primary key — NOT NULL
- order — int(11) — NOT NULL
- type — varchar(1) — NOT NULL
- input_file — varchar(100) — NOT NULL
- output_file — varchar(100) — NOT NULL
- generator_args — longtext — NOT NULL
- points — int(11)
- is_pretest — tinyint(1) — NOT NULL
- output_prefix — int(11)
- output_limit — int(11)
- checker — varchar(10) — NOT NULL
- checker_args — longtext — NOT NULL
- dataset_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- batch_dependencies — longtext — NOT NULL
judge_problemtranslation
- id — int(11) — Primary key — NOT NULL
- language — varchar(7) — NOT NULL
- name — varchar(100) — NOT NULL
- description — longtext — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
judge_problemtype
- id — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- full_name — varchar(100) — NOT NULL
judge_profile
- id — int(11) — Primary key — NOT NULL
- about — longtext
- timezone — varchar(50) — NOT NULL
- points — double — NOT NULL
- performance_points — double — NOT NULL
- problem_count — int(11) — NOT NULL
- ace_theme — varchar(30) — NOT NULL
- last_access — datetime(6) — NOT NULL
- ip — char(39)
- display_rank — varchar(10) — NOT NULL
- mute — tinyint(1) — NOT NULL
- is_unlisted — tinyint(1) — NOT NULL
- rating — int(11)
- user_script — longtext — NOT NULL
- math_engine — varchar(4) — NOT NULL
- is_totp_enabled — tinyint(1) — NOT NULL
- totp_key — longblob
- notes — longtext
- current_contest_id — int(11) — Foreign key → judge_contestparticipation.id
- language_id — int(11) — Foreign key → judge_language.id — NOT NULL
- user_id — int(11) — Foreign key → auth_user.id — NOT NULL
- api_token — varchar(64)
- is_webauthn_enabled — tinyint(1) — NOT NULL
- data_last_downloaded — datetime(6)
- scratch_codes — longblob
- last_totp_timecode — int(11) — NOT NULL
- username_display_override — varchar(100) — NOT NULL
- is_banned_from_problem_voting — tinyint(1) — NOT NULL
- site_theme — varchar(10) — NOT NULL
judge_profile_organizations
- id — int(11) — Primary key — NOT NULL
- sort_value — int(11) — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
- organization_id — int(11) — Foreign key → judge_organization.id — NOT NULL
judge_rating
- id — int(11) — Primary key — NOT NULL
- rank — int(11) — NOT NULL
- rating — int(11) — NOT NULL
- last_rated — datetime(6) — NOT NULL
- contest_id — int(11) — Foreign key → judge_contest.id — NOT NULL
- participation_id — int(11) — Foreign key → judge_contestparticipation.id — NOT NULL
- user_id — int(11) — Foreign key → judge_profile.id — NOT NULL
- mean — double — NOT NULL
- performance — double — NOT NULL
judge_runtimeversion
- id — int(11) — Primary key — NOT NULL
- name — varchar(64) — NOT NULL
- version — varchar(64) — NOT NULL
- priority — int(11) — NOT NULL
- judge_id — int(11) — Foreign key → judge_judge.id — NOT NULL
- language_id — int(11) — Foreign key → judge_language.id — NOT NULL
judge_solution
- id — int(11) — Primary key — NOT NULL
- is_public — tinyint(1) — NOT NULL
- publish_on — datetime(6) — NOT NULL
- content — longtext — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
judge_solution_authors
- id — int(11) — Primary key — NOT NULL
- solution_id — int(11) — Foreign key → judge_solution.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_submission
- id — int(11) — Primary key — NOT NULL
- date — datetime(6) — NOT NULL
- time — double
- memory — double
- points — double
- status — varchar(2) — NOT NULL
- result — varchar(3)
- error — longtext
- current_testcase — int(11) — NOT NULL
- batch — tinyint(1) — NOT NULL
- case_points — double — NOT NULL
- case_total — double — NOT NULL
- is_pretested — tinyint(1) — NOT NULL
- judged_on_id — int(11) — Foreign key → judge_judge.id
- language_id — int(11) — Foreign key → judge_language.id — NOT NULL
- problem_id — int(11) — Foreign key → judge_problem.id — NOT NULL
- user_id — int(11) — Foreign key → judge_profile.id — NOT NULL
- contest_object_id — int(11) — Foreign key → judge_contest.id
- judged_date — datetime(6)
- locked_after — datetime(6)
- rejudged_date — datetime(6)
judge_submissionsource
- id — int(11) — Primary key — NOT NULL
- source — longtext — NOT NULL
- submission_id — int(11) — Foreign key → judge_submission.id — NOT NULL
judge_submissiontestcase
- id — int(11) — Primary key — NOT NULL
- case — int(11) — NOT NULL
- status — varchar(3) — NOT NULL
- time — double
- memory — double
- points — double
- total — double
- batch — int(11)
- feedback — varchar(50) — NOT NULL
- extended_feedback — longtext — NOT NULL
- output — longtext — NOT NULL
- submission_id — int(11) — Foreign key → judge_submission.id — NOT NULL
judge_ticket
- id — int(11) — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- time — datetime(6) — NOT NULL
- notes — longtext — NOT NULL
- object_id — int(10) — NOT NULL
- is_open — tinyint(1) — NOT NULL
- content_type_id — int(11) — Foreign key → django_content_type.id — NOT NULL
- user_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_ticket_assignees
- id — int(11) — Primary key — NOT NULL
- ticket_id — int(11) — Foreign key → judge_ticket.id — NOT NULL
- profile_id — int(11) — Foreign key → judge_profile.id — NOT NULL
judge_ticketmessage
- id — int(11) — Primary key — NOT NULL
- body — longtext — NOT NULL
- time — datetime(6) — NOT NULL
- ticket_id — int(11) — Foreign key → judge_ticket.id — NOT NULL
- user_id — int(11) — Foreign key → judge_profile.id — NOT NULL
and 10 more tables