travelmarket
Tables (3)
Chat
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- room_id — int — Foreign key → Room.id — NOT NULL
- content — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
Room
- id — int — Primary key — NOT NULL
- type — varchar(255)
- name — varchar(255)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
User
- id — int — Primary key — NOT NULL
- email — varchar(255)
- nickname — varchar(255)
- created_at — timestamp
- updated_at — timestamp
- role — enum('admin', 'expert', 'general')