니집내집

테이블 (17)

amenities

  • id — int — 기본 키 — NOT NULL
  • amenity_type_id (id2) — int — 외래 키 → amenity_types.id — NOT NULL
  • name — varchar(50)

amenity_types

  • id — int — 기본 키 — NOT NULL
  • name — varchar(50)

houserules (houseRules)

  • id — int — 기본 키 — NOT NULL
  • name — varchar(50)

reservation_item

  • id — int — 기본 키 — NOT NULL
  • guests — varchar(50)
  • room_schedule_id — date
  • reservation_id — int — 외래 키 → reservations.id — NOT NULL

reservation_status

  • id — int — 기본 키 — NOT NULL
  • name — varchar(50)
  • reservation_id — int — 외래 키 → reservations.id — NOT NULL

reservations

  • id — int — 기본 키 — 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 — 외래 키 → users.id — NOT NULL
  • room_id — int — 외래 키 → rooms.id — NOT NULL

review_images (review_image)

  • id — int — 기본 키 — NOT NULL
  • image_url — varchar(2000)
  • review_id — int — 외래 키 → reviews.id — NOT NULL

reviews

  • id — int — 기본 키 — 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 — 외래 키 → users.id — NOT NULL
  • room_id — int — 외래 키 → rooms.id — NOT NULL

room_amenities

  • id — int — 기본 키 — NOT NULL
  • room_id — int — 외래 키 → rooms.id — NOT NULL
  • amenity_id — int — 외래 키 → amenities.id — NOT NULL

room_houserules

  • id — int — 기본 키 — NOT NULL
  • room_id — int — 외래 키 → rooms.id — NOT NULL
  • house_rule_id — int — 외래 키 → houserules.id — NOT NULL

room_images

  • id — int — 기본 키 — NOT NULL
  • image_url — varchar(1000)
  • room_id — int — 외래 키 → rooms.id — NOT NULL

room_schedule

  • id — int — 기본 키 — NOT NULL
  • check_in — date
  • check_out
  • reservation_id — int — 외래 키 → reservations.id — NOT NULL
  • reservation_item_id — int — 외래 키 → reservation_item.id — NOT NULL

rooms

  • id — int — 기본 키 — 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 — 외래 키 → users.id — NOT NULL
  • room_type_id — int — 외래 키 → roomtypes.id — NOT NULL

roomtypes

  • id — int — 기본 키 — NOT NULL
  • type — varchar(50)

users

  • id — int — 기본 키 — 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 (wishList_rooms)

  • id — int — 기본 키 — NOT NULL
  • wishlist_id — int — 외래 키 → wishlists.id — NOT NULL
  • room_id — int — 외래 키 → rooms.id — NOT NULL

wishlists

  • id — int — 기본 키 — NOT NULL
  • name — varchar(50)
  • user_id — int — 외래 키 → users.id — NOT NULL