ㅁ
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')