특화 프로젝트 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)