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