bangbang
Tables (5)
Untitled (User)
- Key (id) — int — Primary key — NOT NULL
- Field (loginId) — varchar(20)
- Field (password) — varchar(20)
- Field (nickname) — varchar(20)
- Field (type) — varchar(20)
Untitled (Review)
- Key (id) — int — Primary key — NOT NULL
- Key (writer_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (hotel_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (star_rating) — int
- Field (body) — text
Untitled (Hotel)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (coord) — point
- Field (address) — varchar(100)
Untitled (Reserve)
- Key (id) — int — Primary key — NOT NULL
- Key (reserver_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (room_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (check_in_date) — date
- Field (check_out_date) — date
Untitled (Room)
- Key (id) — int — Primary key — NOT NULL
- Key (hotel_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(20)
- Field (occupancy) — int
- Field (price_per_night) — int
- Field (description) — text