onna

Tables (17)

Real_estate Agency (users)

  • id — int — Primary key — NOT NULL
  • name — varchar(50) — Primary key
  • 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)

amenities

  • id — int — Primary key — NOT NULL
  • amenity_type_id (id2) — int — Foreign key → amenity_types.id — NOT NULL
  • name — varchar(50)

amenity_types

  • id — int — Primary key — NOT NULL
  • name — varchar(50)

houserules (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 — Foreign key → reservations.id — NOT NULL
  • name — varchar(50) — Foreign key → reservations.name

reservation_status

  • id — int — Primary key — NOT NULL
  • name — varchar(50)
  • reservation_id — int — Foreign key → reservations.id — NOT NULL
  • name (name2) — varchar(50) — Foreign key → reservations.name

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 — Foreign key → Real_estate Agency.id — NOT NULL
  • room_id — int — Foreign key → rooms.id — NOT NULL
  • name — varchar(50) — Foreign key → Real_estate Agency.name

review_images (review_image)

  • id — int — Primary key — NOT NULL
  • image_url — varchar(2000)
  • review_id — int — Foreign key → reviews.id — NOT NULL
  • name — varchar(50) — Foreign key → reviews.name

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 — Foreign key → Real_estate Agency.id — NOT NULL
  • room_id — int — Foreign key → rooms.id — NOT NULL
  • name — varchar(50) — Foreign key → Real_estate Agency.name

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
  • name (name2) — varchar(50) — Foreign key → rooms.name

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
  • name (name2) — varchar(50) — Foreign key → rooms.name

room_images

  • id — int — Primary key — NOT NULL
  • image_url — varchar(1000)
  • room_id — int — Foreign key → rooms.id — NOT NULL
  • name (name2) — varchar(50) — Foreign key → rooms.name

room_schedule

  • id — int — Primary key — NOT NULL
  • check_in — date
  • check_out
  • reservation_id — int — Foreign key → reservations.id — NOT NULL
  • reservation_item_id — int — Foreign key → reservation_item.id — NOT NULL
  • name — varchar(50) — Foreign key → reservations.name

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 — Foreign key → Real_estate Agency.id — NOT NULL
  • room_type_id — int — Foreign key → roomtypes.id — NOT NULL
  • name (name2) — varchar(50) — Foreign key → Real_estate Agency.name

roomtypes

  • id — int — Primary key — NOT NULL
  • type — varchar(50)

wishlist_rooms (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
  • name (name2) — varchar(50) — Foreign key → wishlists.name

wishlists

  • id — int — Primary key — NOT NULL
  • name — varchar(50)
  • user_id — int — Foreign key → Real_estate Agency.id — NOT NULL
  • name (name2) — varchar(50) — Foreign key → Real_estate Agency.name