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