airbnb

Tables (3)

Book (예약)

  • book_id (예약 id) — Integer — Primary key — NOT NULL
  • book_guest (예약 인원) — Integer
  • book_cost (예약 요금) — Integer
  • check_in (체크인 날짜) — datetime
  • check_out (체크아웃 날짜) — datetime
  • user_id (계정 id) — varchar(15) — Foreign key → User.user_id — NOT NULL
  • room_id (숙소 id) — Integer — Foreign key → Room.room_id — NOT NULL

Room (숙소)

  • room_id (숙소 id) — Integer — Primary key — NOT NULL
  • room_lat (숙소 위도) — Decimal(16,14)
  • room_lon (숙소 경도) — Decimal(17,14)
  • max_guest (숙소 최대 인원) — Integer
  • room_feat (숙소 특징) — varchar(2000)
  • Field

User (회원)

  • user_id (계정 id) — varchar(15) — Primary key — NOT NULL
  • user_pw (계정 pw) — varchar(100)
  • Field