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