skku_codding_flatform

Tables (25)

AcmContestRank (acm_contest_rank)

  • Contest (contest) — FK — Foreign key → Contest.Object — NOT NULL
  • User (user) — FK — Foreign key → User.User ID — NOT NULL
  • SubmissionNumber (submission_number)
  • AcceptedNumber (accepted_number)
  • TotalTime (total_time)
  • SubmissionInfo (submission_info)

Announcement (announcement)

  • CreatedBy (created_by) — FK — Foreign key → User.User ID — NOT NULL
  • Title (title)
  • Content (content)
  • CreateTime (create_time)
  • Visible (visible)

Answer (answer)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (question_id) — bigint(20) — Foreign key → Question.Key — NOT NULL

Assignment (assignment)

  • Key (assignment_id) — bigint(20) — Primary key — NOT NULL
  • Key (lecture_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

AuthGroup (auth_group)

  • Name (name) — PK — Primary key — NOT NULL

AuthGroupPermissions (auth_group_permissions)

  • Permission (permission) — FK — Foreign key → AuthPermission.Object — NOT NULL
  • Group (group) — FK — Foreign key → AuthGroup.Name — NOT NULL

AuthPermission (auth_permission)

  • Object (object) — PK — Primary key — NOT NULL
  • ContentType (content_type) — FK — Foreign key → DjangoContentType.Object — NOT NULL
  • Codename (codename) — FK — NOT NULL

Contest (contest)

  • Object (object) — PK — Primary key — NOT NULL
  • CreatedBy (created_by) — FK — Foreign key → User.User ID — NOT NULL
  • Title (title)
  • Description (description)
  • RealTimeRank (real_time_rank)
  • Password (password)
  • RuleType (rule_type)
  • StartTime (start_time)
  • EndTime (end_time)
  • CreateTime (create_time)
  • LastUpdateTime (last_update_time)
  • Visible (visible)
  • AllowedIpRanges (allowed_ip_ranges)

ContestAnnouncement (contest_announcement)

  • CreatedBy (created_by) — FK — Foreign key → User.User ID — NOT NULL
  • Contest (contest) — FK — Foreign key → Contest.Object — NOT NULL
  • Title (title)
  • CreateTime (create_time)
  • Visible (visible)

DjangoContentType (django_content_type)

  • Object (object) — PK — Primary key — NOT NULL
  • AppLabel (app_label) — FK — NOT NULL
  • Model (model) — FK — NOT NULL

DjangoDramatiqTask (django_dramatiq_task)

  • Id (id) — PK — Primary key — NOT NULL
  • Status (status)
  • CreatedAt (created_at)
  • UpdatedAt (updated_at)
  • MessageData (message_date)
  • ActorName (actor_name)
  • QueueName (queue_name)

DjangoMigrations (django_migrations)

  • App (app)
  • Name (name)
  • Applied (applied)

DjangoSession (django_session)

  • SessionKey (session_key) — PK — Primary key — NOT NULL
  • SessionData (session_data)
  • ExpireDate (expire_date)

JudgeServer (judge_server)

  • Hostname (hostname)
  • Ip (ip)
  • JudgerVersion (judger_version)
  • CpuCore (cpu_core)
  • MemoryUsage (memory_usage)
  • CpuUsage (cpu_usage)
  • LastHeartbeat (last_heartbeat)
  • CreateTime (create_time)
  • TaskNumber (task_number)
  • ServiceUrl (service_url)
  • IsDisabled (Field)

OiContestRank (oi_contest_rank)

  • Contest (contest) — FK — Foreign key → Contest.Object — NOT NULL
  • User (user) — FK — Foreign key → User.User ID — NOT NULL
  • SubmissionNumber (submission_number)
  • TotalScore (total_score)
  • SubmissionInfo (Field)

OptionsSysoptions (options_sysoptions)

  • Key (key) — PK — Primary key — NOT NULL
  • Value (Field)

Problem (problem)

  • Object (problem_id) — bigint(20) — Primary key — NOT NULL
  • Contest (contest) — PK — Foreign key → Contest.Object — NOT NULL
  • CreatedBy (created_by) — FK — Foreign key → User.User ID — NOT NULL
  • FieldId (field_id) — FK — NOT NULL
  • Title (title)
  • Description (description)
  • InputDescription (input_description)
  • OutputDescription (output_description)
  • Samples (samples)
  • TestCaseId (test_case_id)
  • TestCaseScore (test_case_score) — JSON
  • Hint (hint)
  • Languages (languages)
  • Template (template)
  • CreateTime (create_time)
  • LastUpdateTime (last_update_time)
  • TimeLimit (time_limit)
  • MemoryLimit (memory_limit)
  • Spj (spj)
  • SpjLanguage (spj_language)
  • SpjCode (spj_code)
  • SpjVersion (spj_version)
  • RuleType (rule_type)
  • Visible (visible)
  • Difficulty (difficulty)
  • Source (source)
  • SubmissionNumber (submission_number)
  • AcceptedNumber (accepted_number)
  • StatisticInfo (statistic_info)
  • TotalScore (total_score)
  • IsPublic (is_public)
  • SpjCompileOk (spj_compile_ok)
  • IoMode (io_mode)
  • ShareSubmission (share_submission)
  • Key (assignment_id) — bigint(20) — Foreign key → Assignment.Key — NOT NULL
  • Key (lecture_id) — bigint(20) — Foreign key → Assignment.Key — NOT NULL

ProblemTag (problem_tag)

  • Name (name) — PK — Primary key — NOT NULL
  • Object (Key) — Primary key — NOT NULL

ProblemTags (problem_tags)

  • Problem (problem) — FK — Foreign key → Problem.Object — NOT NULL
  • ProblemTag (problem_tag) — FK — Foreign key → ProblemTag.Name — NOT NULL
  • Key — Foreign key → ProblemTag.Object — NOT NULL

Question (question)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (lecture_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Submission (submission)

  • Id (id) — PK — Primary key — NOT NULL
  • Contest (contest) — FK — Primary key — NOT NULL
  • Problem (problem) — FK — Primary key — NOT NULL
  • CreateItem (create_item)
  • UserId (user_id)
  • Code (code)
  • Result (result)
  • Info (info)
  • Language (language)
  • Shared (shared)
  • StatisticInfo (statistic_info)
  • Username (username)
  • Ip (ip)

Untitled (lecture)

  • Key (lecture_id) — bigint(20) — Primary key — NOT NULL

Untitled (user_lecture)

  • Key (lecture_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • User ID (user_id) — bigint(20) — Foreign key → User.User ID — NOT NULL

User (user)

  • User ID (user_id) — bigint(20) — Primary key — NOT NULL
  • Password (password) — longtext
  • LastLogin (last_login) — longtext
  • Username (username) — longtext
  • Email (email) — longtext
  • CreateTime (create_time) — datetime
  • AdminType (admin_type) — longtext
  • ResetPasswordToken (reset_password_token) — longtext
  • ResetPasswordTokenExpireTime (reset_password_token_expire_time) — datetime
  • IsDisabled (is_disabled) — bit(1)
  • ProblemPermission (problem_permission) — longtext
  • SessionKeys (session_keys) — longtext
  • Major (major) — longtext
  • EmailAuthToken (email_auth_token) — longtext
  • HasEmailAuth (has_email_auth) — longtext

UserProfile (user_profile)

  • User (user) — FK — Foreign key → User.User ID — NOT NULL
  • AcmProblemsStatus (acm_problems_status)
  • Avatar (avatar)
  • AcceptedNumber (accepted_number)
  • TotalScore (total_score)
  • OiProblemsStatus (oi_problems_status)
  • RealName (real_name)
  • Language (language)