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)