boostbnb
Tables (5)
Copy Of Untitled (Price)
- Key (price_id) — varchar(20) — Primary key — NOT NULL
- Field (date) — date
- Field (price) — int
- Key (accommodation_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (User)
- Key (id) — varchar(20) — Primary key — NOT NULL
- Field (nickname) — varchar(36)
- Field (profile_img_url) — text
- Field (password) — varchar(255)
Untitled (Accommodation)
- Key (id) — varchar(20) — Primary key — NOT NULL
- Key (host_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — text
- Field (img) — text
- Field (option) — text
- Field (personnel) — int
- Field (position) — point
Untitled (Reservation)
- Key (reservation_id) — varchar(20) — Primary key — NOT NULL
- Key (user_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Key (accommodation_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (fee) — int
- Field (checkin_day) — date
- Field (checkout_day) — date
- Field (personnel) — int
Untitled (Review)
- Key (revirew_id) — int — Primary key — NOT NULL
- Key (writer_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (rate) — int
- Field (content) — text
- Field (write_at) — date
- Key (accommodation_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL