airbnb

Tables (5)

Room (tb_room)

  • room_id (id) — integer — Primary key — NOT NULL
  • price (Field) — interger — NOT NULL
  • rating (Field2) — float — NOT NULL
  • title (Field3) — varchar(300) — NOT NULL
  • content (Field4) — text
  • img_path (Field5) — varchar(200)

person (Untitled2)

  • person_id (Key) — Integer — Primary key — NOT NULL
  • name (Field) — varchar(100) — NOT NULL

reservation (Untitled)

  • reservation_id (Key) — Integer — Primary key — NOT NULL
  • user_id (id) — Integer — Foreign key → tb_user.user_id — NOT NULL
  • room_id (id2) — integer — Foreign key → Room.room_id — NOT NULL
  • check_in (Field) — Date — NOT NULL
  • check_out (Field2) — Date — NOT NULL

reservation_person (Untitled3)

  • reservation_id (Key2) — Integer — Foreign key → reservation.reservation_id — NOT NULL
  • person_id (Key) — Integer — Foreign key → person.person_id — NOT NULL
  • count (Field)

tb_user

  • user_id (id) — Integer — Primary key — NOT NULL
  • email — varchar(80) — NOT NULL
  • password — varchar(200) — NOT NULL
  • name — varchar(50) — NOT NULL