test
Tables (17)
amenities
- id — int — Primary key — NOT NULL
- id2 — int — Foreign key → amenity_types.id — NOT NULL
- name — varchar(50)
amenity_types
- id — int — Primary key — NOT NULL
- name — varchar(50)
houseRules
- id — int — Primary key — NOT NULL
- name — varchar(50)
reservation_item
- id — int — Primary key — NOT NULL
- guests — varchar(50)
- room_schedule_id — date
- reservation_id — int — NOT NULL
reservation_status
- id — int — Primary key — NOT NULL
- name — varchar(50)
- reservation_id — int — NOT NULL
reservations
- id — int — Primary key — NOT NULL
- reservation_code — int
- reservation_status_id — int
- guests — int
- created_at — time
- updated_at — time
- check_in — time
- check_out — time
- user_id — int — NOT NULL
- room_id — int — NOT NULL
review_image
- id — int — Primary key — NOT NULL
- image_url — varchar(2000)
- review_id — int — NOT NULL
reviews
- id — int — Primary key — NOT NULL
- content — text
- accuracy — int(1,5)
- communication — int(1,5)
- cleanliness — int(1,5)
- location — int(1,5)
- check_in — int(1,5)
- cost_perfomance — int(1,5)
- user_id — int — NOT NULL
- room_id — int — NOT NULL
room_amenities
- id — int — Primary key — NOT NULL
- room_id — int — Foreign key → rooms.id — NOT NULL
- amenity_id — int — Foreign key → amenities.id — NOT NULL
room_houserules
- id — int — Primary key — NOT NULL
- room_id — int — Foreign key → rooms.id — NOT NULL
- house_rule_id — int — Foreign key → houseRules.id — NOT NULL
room_images
- id — int — Primary key — NOT NULL
- image_url — varchar(1000)
- room_id — int — NOT NULL
room_schedule
- id — int — Primary key — NOT NULL
- check_in — date
- check_out — VARCHAR(255)
- reservation_id — int — NOT NULL
- reservation_item_id — int — NOT NULL
rooms
- id — int — Primary key — NOT NULL
- name — varchar(50)
- description — text
- district — varchar(50)
- neighborhood — varchar(50)
- price — decimal
- address — varchar(50)
- guests — int
- beds — int
- bedrooms — int
- baths — int
- check_in_time — time
- check_out_time — time
- is_instant_book — boolean
- latitude — decimal
- longitude — decimal
- user_id — int — NOT NULL
- room_type_id — int — NOT NULL
roomtypes
- id — int — Primary key — NOT NULL
- type — varchar(50)
users
- id — int — Primary key — NOT NULL
- nickname — varchar(50)
- email — email
- password — varchar(200)
- profile_image — varchar(1000)
- gender — varchar(50)
- bio — text
- birthdate — date
- is_superhost — boolean
- kakao_id — varchar(50)
- github_id — varchar(50)
wishList_rooms
- id — int — Primary key — NOT NULL
- wishlist_id — int — Foreign key → wishlists.id — NOT NULL
- room_id — int — Foreign key → rooms.id — NOT NULL
wishlists
- id — int — Primary key — NOT NULL
- name — varchar(50)
- user_id — int — NOT NULL