객패
테이블 (6)
chat_room
- chat_room_id — INTEGER
- chat_room_name — VARCHAR(100) — NOT NULL
- is_group_chat — BOOLEAN
- created_at — TIMESTAMP
- last_message_time — TIMESTAMP
- last_message_preview — VARCHAR(255)
chat_room_member
- chat_room_id — INTEGER — 기본 키 — NOT NULL
- member_id — INTEGER — 기본 키 — NOT NULL
- joined_at — TIMESTAMP
friend
- member_id — INTEGER — 기본 키 — NOT NULL
- friend_id — INTEGER — 기본 키 — NOT NULL
- created_at — TIMESTAMP
friend_request
- request_id — INTEGER
- sender_id — INTEGER — NOT NULL
- receiver_id — INTEGER — NOT NULL
- message — VARCHAR(255)
- status — VARCHAR(20)
- created_at — TIMESTAMP
member
- member_id — INTEGER
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- status — VARCHAR(20)
- role — VARCHAR(20)
message
- message_id — INTEGER
- chat_room_id — INTEGER — NOT NULL
- sender_id — INTEGER — NOT NULL
- message_content — TEXT — NOT NULL
- created_at — TIMESTAMP