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