여기모여
테이블 (12)
chat_messages
- id — CHAR(36) — 기본 키 — NOT NULL
- room_id — CHAR(36) — NOT NULL
- sender_uuid — CHAR(36)
- message — TEXT — NOT NULL
- sent_at — TIMESTAMP
chat_room_members
- room_id — CHAR(36) — 기본 키 — NOT NULL
- user_uuid — CHAR(36) — 기본 키 — NOT NULL
- joined_at — TIMESTAMP
chat_rooms
- id — CHAR(36) — 기본 키 — NOT NULL
- type — ENUM('group', 'schedule', 'dm') — NOT NULL
- group_uuid — CHAR(36)
- schedule_uuid — CHAR(36)
- created_at — TIMESTAMP
friends
- user_uuid — CHAR(36) — 기본 키 — NOT NULL
- friend_uuid — CHAR(36) — 기본 키 — NOT NULL
- status — ENUM('pending', 'accepted', 'blocked') — NOT NULL
- created_at — TIMESTAMP
group_info
- uuid — CHAR(36) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- visibility — ENUM('public', 'private')
- group_leader_uuid — CHAR(36)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
group_invites
- uuid — CHAR(36) — 기본 키 — NOT NULL
- group_uuid — CHAR(36) — NOT NULL
- invited_email — VARCHAR(255) — NOT NULL
- invited_by_uuid — CHAR(36)
- status — ENUM('pending', 'accepted', 'declined')
- invited_at — TIMESTAMP
group_members
- group_uuid — CHAR(36) — 기본 키 — NOT NULL
- user_uuid — CHAR(36) — 기본 키 — NOT NULL
- role — ENUM('leader', 'member', 'planner')
- joined_at — TIMESTAMP
schedule_details
- uuid — CHAR(36) — 기본 키 — NOT NULL
- schedule_uuid — CHAR(36) — NOT NULL
- event_date — DATE — NOT NULL
- event_start_time — TIME — NOT NULL
- event_end_time — TIME
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- location — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
schedule_participants
- schedule_uuid — CHAR(36) — 기본 키 — NOT NULL
- user_uuid — CHAR(36) — 기본 키 — NOT NULL
- role — ENUM('attendee', 'planner', 'driver', 'host')
schedules
- uuid — CHAR(36) — 기본 키 — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- location — VARCHAR(255)
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- type — ENUM('personal', 'group') — NOT NULL
- owner_uuid — CHAR(36) — NOT NULL
- group_uuid — CHAR(36)
- is_private — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_profiles
- uuid — CHAR(36) — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- gender — ENUM('male', 'female') — NOT NULL
- birthdate — DATE — NOT NULL
- paradox_flag — BOOLEAN — NOT NULL
- profile_picture — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- uuid — CHAR(36) — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL