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