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')