ㅇ
Tables (13)
collab_comments
- comment_id — BIGINT
- collab_id — BIGINT — Foreign key → collabs.collab_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- message — TEXT
- language — VARCHAR(20)
- code — LONGTEXT
- version — INT
- created_at — DATETIME
collab_members
- collab_id — BIGINT — Foreign key → collabs.collab_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- joined_at — DATETIME
collabs
- collab_id — BIGINT
- title — VARCHAR(200)
- problem_id — BIGINT — Foreign key → problems.problem_id
- owner_id — BIGINT — Foreign key → users.user_id
- visibility — VARCHAR(10)
- password — VARCHAR(255)
- created_at — DATETIME
comments
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- author_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- parent_id — BIGINT — Foreign key → comments.comment_id
- created_at — DATETIME
friend_messages
- message_id — BIGINT
- sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
- receiver_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
friend_requests
- request_id — BIGINT
- sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
- receiver_id — BIGINT — Foreign key → users.user_id — NOT NULL
- status — VARCHAR(20)
- created_at — DATETIME
friends
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- friend_id — BIGINT — Foreign key → users.user_id — NOT NULL
- memo — VARCHAR(100)
- is_blocked — BOOLEAN
- updated_at — DATETIME
home_news
- news_id — BIGINT
- title — VARCHAR(200)
- url — VARCHAR(255)
- created_at — DATETIME
post_likes
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- created_at — DATETIME
posts
- post_id — BIGINT
- author_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT
- like_count — INT
- created_at — DATETIME
- updated_at — DATETIME
problems
- problem_id — BIGINT
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- input_description — TEXT
- output_description — TEXT
- sample_input — TEXT
- sample_output — TEXT
- constraints — TEXT
- time_limit — INT
- memory_limit — INT
- difficulty_id — INT
- created_at — DATETIME
submissions
- submission_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- problem_id — BIGINT — Foreign key → problems.problem_id — NOT NULL
- language — VARCHAR(20)
- code — LONGTEXT
- status — VARCHAR(20)
- execution_time — INT
- memory_usage — INT
- submitted_at — DATETIME
- INDEX — idx_user_problem
users
- user_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- bio — TEXT
- github_url — VARCHAR(255)
- is_solved_public — BOOLEAN
- total_solved — INT
- last_active_at — DATETIME
- created_at — DATETIME