ㅁ

Tables (5)

lunchmate (런치메이트_글목록)

  • lunchmate_list_id — INT — Primary key — NOT NULL — PK
  • host_user_id — INT — Foreign key → user.user_id — NOT NULL — 작성자(FK)
  • type — ENUM('LUNCH', 'DINNER')
  • scheduled_at — DATETIME
  • max_member — INT
  • menu — VARCHAR(100)
  • location — VARCHAR(255)
  • comment — TEXT

participants (참가자들)

  • participants_id — INT — Primary key — NOT NULL — PK
  • lunchmate_list_id — INT — Foreign key → lunchmate.lunchmate_list_id — NOT NULL — 참여한 모임(FK)
  • user_id — INT — Foreign key → user.user_id — NOT NULL — 참여한 회원(FK)
  • status — VARCHAR(20) — 참여/취소 등 상태

talk_comment (익명의_수다방_댓글)

  • comment_id — INT — Primary key — NOT NULL — PK
  • board_id — INT — Foreign key → talkroom.board_id — NOT NULL — 원글 ID(FK)
  • commenter_user_id — INT — Foreign key → user.user_id — NOT NULL — 댓글쓴이(FK)
  • content — VARCHAR(500) — 댓글 내용
  • like_count — INT
  • created_at — DATETIME

talkroom (익명의_수다방_글)

  • board_id — INT — Primary key — NOT NULL — PK
  • writer_user_id — INT — Foreign key → user.user_id — NOT NULL — 글쓴이(FK)
  • content — TEXT — 본문 내용
  • like_count — INT — 좋아요 수
  • created_at — DATETIME

user (회원)

  • user_id — INT — Primary key — NOT NULL — PK
  • employee_number — INT
  • password — VARCHAR(255)
  • name — VARCHAR(50)
  • team — VARCHAR(50)
  • location — ENUM('SEOUL', 'BUSAN')