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