웹 챗
테이블 (6)
chat_rooms
- room_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- is_active — bit(1) — NOT NULL
- max_participants — int — NOT NULL
- name — varchar(255)
- password — varchar(255)
- room_type — enum('PRIVATE_CHAT','PROTECTED_GROUP','PUBLIC_GROUP') — NOT NULL
friendships
- friendship_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- status — enum('ACCEPTED','BLOCKED','PENDING')
- from_user_idx — bigint — 외래 키 → users.user_idx
- to_user_idx — bigint — 외래 키 → users.user_idx
message_attachments
- id — bigint — 기본 키 — NOT NULL
- name — varchar(255)
- type — varchar(255)
- url — varchar(255)
- message_id — bigint — 외래 키 → messages.message_id
messages
- message_id — bigint — 기본 키 — NOT NULL
- content — varchar(255) — NOT NULL
- created_at — datetime(6)
- expires_at — datetime(6)
- room_id — bigint — 외래 키 → chat_rooms.room_id
- sender_id — bigint — 외래 키 → users.user_idx
room_participants
- participant_id — bigint — 기본 키 — NOT NULL
- joined_at — datetime(6)
- last_read_time — datetime(6)
- room_id — bigint — 외래 키 → chat_rooms.room_id
- user_idx — bigint — 외래 키 → users.user_idx
users
- user_idx — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255)
- user_id — varchar(255) — NOT NULL