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