특화 프로젝트 erd
테이블 (6)
car_info (Untitled4)
- id (PK) — int — 기본 키 — NOT NULL
- name (Field) — char
- fee_per_hour (Field2) — int
reservation (Untitled5)
- id (PK) — int — 기본 키 — NOT NULL
- vehicle_id (PK3) — int — 외래 키 → vehicle.id — NOT NULL
- user_id (PK2) — int — 외래 키 → user.id — NOT NULL
- reservation_time (Field3) — datetime
- get_location (Field4) — char
- total_fee (Field5) — int
- return_time (Field2) — datetime
travel (Untitled3)
- id (PK) — int — 기본 키 — NOT NULL
- type_id (PK2) — int — 외래 키 → travel_type.id — NOT NULL
- name (Field) — char
- latitude (Field2) — float
- longitude (Field3) — float
- star_point (Field4) — float
- review (Field5)
travel_type (Untitled6)
- id (PK) — int — 기본 키 — NOT NULL
- Field — char
user (Untitled)
- id (PK) — int — 기본 키 — NOT NULL
- email (Field3) — char
- password (Field) — char
- name (Field2) — char
- phonenumber (Field4) — char
vehicle (Untitled2)
- id (PK) — int — 기본 키 — NOT NULL
- car_info_id (PK2) — int — 외래 키 → car_info.id — NOT NULL
- arround_location (Field4) — char
- now_location (Field3) — char
- next_location (Field8) — char
- fuel_left (Field5) — float
- car_number (Field7)