IDE

Tables (8)

ChatMessage (Chat_Message)

  • id — BigInt — Primary key — NOT NULL
  • writerName (writer_name) — varchar
  • creationDate (creation_date) — DATE

Code

  • id — BigInt — Primary key — NOT NULL
  • myProblem (my_problem_id) — BigInt — Foreign key → MyProblem.id — NOT NULL
  • language — varchar
  • myCode (my_code) — varchar

DefaultCode (Default_Code)

  • id — BigInt — Primary key — NOT NULL
  • myProblem (my_problem_id) — BigInt — Foreign key → MyProblem.id — NOT NULL
  • language — varchar
  • defualtCode (default_code) — varchar

Grass

  • id — BigInt — Primary key — NOT NULL
  • member (member_id) — varchar — Foreign key → Member.id — NOT NULL
  • date — DATE
  • solvedCount (solved_count) — BigInt

Member

  • id — varchar — Primary key — NOT NULL
  • password — varchar
  • nickname — varchar
  • email — varchar
  • tier — varchar

MyProblem (My_Problem)

  • id — BigInt — Primary key — NOT NULL
  • solvedMember (solved_member_id) — varchar — Foreign key → Member.id — NOT NULL
  • favoriteMember (favorite_member_id) — varchar — Foreign key → Member.id — NOT NULL
  • problem (problem_id) — BigInt — Foreign key → Problem.id — NOT NULL

Problem

  • id — BigInt — Primary key — NOT NULL
  • name — varchar
  • content — varchar
  • inputContent (input_content) — varchar
  • outputContent (output_content) — varchar
  • tier — varchar
  • timeLimit (time_limit) — BigInt
  • memoryLimit (memory_limti) — BigInt
  • algorithm (algorithmA) — varchar

TestCase (Test_Case)

  • id — BigInt — Primary key — NOT NULL
  • problem (problem_id) — BigInt — Foreign key → Problem.id — NOT NULL
  • testCaset (test_case) — varchar
  • answera (answer) — varchar