testcar

Tables (7)

company

  • company_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • contact_info — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

device

  • device_id — INT — Primary key — NOT NULL
  • vehicle_id — INT — Foreign key → vehicle.vehicle_id — NOT NULL
  • send_interval_seconds — INT — NOT NULL — 60,120,180
  • protocol — ENUM('TCP', 'UDP') — NOT NULL
  • ui_enabled — BOOLEAN — NOT NULL

event_log

  • event_id — BIGINT — Primary key — NOT NULL
  • vehicle_id — INT — NOT NULL
  • ts — DATETIME — NOT NULL
  • event_type — ENUM('ENGINE_ON','ENGINE_OFF') — NOT NULL
  • vehicle_id (vehicle_id2) — INT — Foreign key → vehicle.vehicle_id — NOT NULL

rental_request

  • request_id — INT — Primary key — NOT NULL
  • vehicle_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • approved_at — DATETIME

telemetry

  • telemetry_id — BIGINT — Primary key — NOT NULL
  • vehicle_id — INT — Foreign key → vehicle.vehicle_id — NOT NULL
  • 위도 (latitude) — DECIMAL(9,6) — NOT NULL
  • 경도 (longitude) — DECIMAL(9,6) — NOT NULL
  • 속도 (speed) — DECIMAL(5,2)
  • Field (event_ts)

users

  • user_id — INT — Primary key — NOT NULL
  • company_id (company_id2) — INT — Foreign key → company.company_id — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('ADMIN','CORPORATE_USER') — NOT NULL
  • created_at — DATETIME — NOT NULL

vehicle

  • vehicle_id — INT — Primary key — NOT NULL
  • company_id — INT — Foreign key → company.company_id — NOT NULL
  • terminal_id — VARCHAR(50) — NOT NULL
  • color — VARCHAR(30)
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL