여기모여

테이블 (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