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