ㅇ

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