뽀득뽀득 ERD 초안
테이블 (11)
User (사용자)
- 유저 ID (id) — 기본 키 — NOT NULL
- 비밀번호 (pwd)
- 차종 (VehicleInfo)
- 세차 실력 (WashingExprience)
- 위치 (Location)
bay
- id — bigint — 기본 키 — NOT NULL
- carwash_id — bigint — NOT NULL
- bay_num — bigint — NOT NULL
- bay_type — varchar(50) — NOT NULL
- price — int(11)
- duration — int(11)
carwash
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — NOT NULL
- name — varchar(255) — NOT NULL
- rate — int(11)
- address — varchar(255) — NOT NULL
- pic — varchar(255)
- pic_type — int(11)
- tel — varchar(255)
- d_time — timestamp
- w_time — timestamp
- time_des — varchar(50)
- des — varchar(255)
- dzone — int(11)
reservation
- id — bigint — 기본 키 — NOT NULL
- bay_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- start_time — timestamp
- end_time — timestamp
- price — int(11)