airbnb
Tables (6)
option_main
- stay_id — int — NOT NULL
- room — int — NOT NULL
- bedroom — int
- bathroom — int
- kitchen — int
reservation
- id — int — Primary key — NOT NULL
- id (id2) — int — Foreign key → user.id — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- stay_id — int — NOT NULL
- host_id — int — NOT NULL
- confirmation — boolean — NOT NULL
- created_at — datetime — NOT NULL
- number_of_guest — int — NOT NULL
- total_charge — int — NOT NULL
stay
- id — int — NOT NULL
- name — VARCHAR(100) — NOT NULL
- longitude — DECIMAL(10,7) — NOT NULL
- latitude — DECIMAL(10,7) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- thumbnail — text
- review_rating — DECIMAL(3,2)
- day_cost — int — NOT NULL
- discount_rate — float
- cleaning_fee — int
- service_fee — int
- accommondation_tax — int
- created_at — TIMESTAMP — NOT NULL
- host_id — int — NOT NULL
- activate — boolean — NOT NULL
- maximum_guest — int — NOT NULL
- Field
user
- id — int — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- birth — date
- 회원등급 (status) — varchar(45) — NOT NULL
- gender — char(1) — NOT NULL
- created_at — Timestamp
wishlist
- id — int — NOT NULL
- user_id — int — NOT NULL
- stay_id — int — NOT NULL