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