CodingTest-SideProject
Tables (7)
Problem (CopyOfUntitled)
- id (bigint) — bigint — Primary key — NOT NULL
- Problem_Num (Field) — bigint
- Title (Field2)
- tier_level (Field3)
- solved_count (Field4)
- time_limit (Field6)
- memory_limit (Field7)
- submission_count (제출수)
- accepted_count (맞은 제출 수)
- attempt_count (총 시도한 사람 수)
- is_multilingual (다국어 여부)
- is_special_judge (스페셜 저지)
- is_partial_score (부분점수)
- created_at (Field5)
- updated_at (Field8)
ProblemTag (CopyOfCopyOfUntitled2)
- problem_id (bigint) — bigint — Foreign key → Problem.id — NOT NULL
- tag_id (Key2) — Foreign key → Tag.id — NOT NULL
Submission (CopyOfUntitled4)
- id (Key) — Primary key — NOT NULL
- user_id (bigint) — Foreign key → User.id — NOT NULL
- problem_id (bigint2) — bigint — Foreign key → Problem.id — NOT NULL
- language (Field)
- result (Field2)
- source_code (Field3)
- code_length (Field4)
- runtime_ms (Field5)
- memory_kb (Field6)
- solving_time (Field7)
- submitted_at (Field8)
- created_at (Field9)
- updated_at (Field10)
Tag (CopyOfUntitled2)
- id (Key) — Primary key — NOT NULL
- code (Field)
- name (Field2)
TestCase (CopyOfUntitled6)
- Key — Primary key — NOT NULL
- problem_id (bigint) — bigint — Foreign key → Problem.id — NOT NULL
- user_id (bigint2) — Foreign key → User.id — NOT NULL
- input (Field2)
- expected_output (Field3)
- source (Field4)
- description (Field5)
- display_order (Field6)
- created_at (Field7)
- updated_at (Field8)
User (Untitled)
- id (bigint) — Primary key — NOT NULL
- loginId (Field)
- password (Field2)
- role (Field3)
- provider (Field4)
- providerId (Field5)
- email (Field6)
- created_at (Field7)
- updated_at (Field8)
UserProblem (CopyOfUntitled5)
- user_id (bigint2) — Foreign key → User.id — NOT NULL
- problem_id (bigint3) — bigint — Foreign key → Problem.id — NOT NULL
- status (Field)
- try_count (Field2)
- created_at (Field3)
- updated_at (Field4)
- is_bookmarked (Field5)
- first_solved_at (Field6)
- Field7