TrueOil

테이블 (7)

Untitled (fuel_logs)

  • Key (log_id) — INT — 기본 키 — NOT NULL
  • Key (user_id) — INT — 외래 키 → 사용자.Key — NOT NULL — Auto Increment
  • Key (station_id) — VATCHAR(20) — 외래 키 → 주유소 정보.Key — NOT NULL — 오피넷ID
  • Field (total_price) — INT — NOT NULL
  • Field (unit_price) — INT — NOT NULL
  • Field (current_mileage) — INT — NOT NULL
  • Field (fuel_date) — DATETIME — NOT NULL

사용자 (users)

  • Key (user_id) — INT — 기본 키 — NOT NULL — Auto Increment
  • Field (email) — VARCHAR(50) — NOT NULL
  • Field (password) — VARCHAR(50) — NOT NULL
  • Field (fuel_type) — VARCHAR(10) — NOT NULL
  • Field (efficiency) — DOUBLE — NOT NULL
  • Field (current_mileage) — INT — NOT NULL
  • Field (profile_img) — VARCHAR(255) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

소모품 개별 상태 (maintenance_status)

  • Key (m_id) — INT — 기본 키 — NOT NULL — Auto Increment
  • Key (user_id) — INT — 외래 키 → 사용자.Key — NOT NULL — Auto Increment
  • Key (item_id) — INT — 외래 키 → 소모품 관리.Key — NOT NULL — Auto Increment
  • Field (item_name) — VARCHAR(50) — NOT NULL
  • Field (last_replace_mileage) — INT

소모품 관리 (maintenance_items)

  • Key (item_id) — INT — 기본 키 — NOT NULL — Auto Increment
  • Field (item_name) — VARCHAR(50) — NOT NULL
  • Field (cycle_mileage) — INT — NOT NULL
  • Field (description) — VARCHAR(255)

유류 가격 (station_prices)

  • Field (fuel_type) — VARCHAR(20) — 기본 키 — NOT NULL
  • Key (station_id) — VATCHAR(20) — 외래 키 → 주유소 정보.Key — NOT NULL — 오피넷ID
  • Field (price) — INT — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL

정비 예약 (repair_reservations)

  • Key (res_id) — INT — 기본 키 — NOT NULL — Auto Increment
  • Key (user_id) — INT — 외래 키 → 사용자.Key — NOT NULL — Auto Increment
  • Field (shop_name) — VARCHAR(100) — NOT NULL
  • Field (res_date) — DATE — NOT NULL
  • Field (res_time) — TIME — NOT NULL
  • Field (status) — VARCHAR(20)

주유소 정보 (gas_stations)

  • Key (station_id) — VATCHAR(20) — 기본 키 — NOT NULL — 오피넷ID
  • Field (name) — VARCHAR(100) — NOT NULL
  • Field (brand) — VARCHAR(20) — NOT NULL
  • Field (address) — VARCHAR(255) — NOT NULL
  • Field (lat) — DOUBLE — NOT NULL
  • Field (lon) — DOUBLE — NOT NULL
  • Field (has_car_wash) — BOOLEAN — NOT NULL
  • Field (has_repair) — BOOLEAN — NOT NULL