Booket

Tables (7)

chat_members

  • id — BIGINT
  • room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME

chat_messages

  • id — BIGINT
  • room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • message — TEXT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME

chat_rooms

  • id — BIGINT
  • meeting_id — BIGINT — Foreign key → meetings.id — NOT NULL

meetings

  • id — BIGINT
  • host_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • price — INT — NOT NULL
  • max_capacity — INT — NOT NULL
  • current_count — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • version — BIGINT
  • created_at — DATETIME

posts

  • id — BIGINT
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.id
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

reservations

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • reserved_at — DATETIME

users

  • id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME