테크돔
테이블 (10)
company
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- code — VARCHAR(50) — NOT NULL
- biz_number — VARCHAR(20) — NOT NULL
department
- id — BIGINT
- company_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
geofence
- id — BIGINT
- company_id — BIGINT — NOT NULL
- geo_control_id — VARCHAR(50) — NOT NULL
- upload_value — VARCHAR(10) — NOT NULL
- geo_group_id — VARCHAR(50) — NOT NULL
- geo_event_type — VARCHAR(50) — NOT NULL
- geo_range — DOUBLE — NOT NULL
- center_latitude — DOUBLE — NOT NULL
- center_longitude — DOUBLE — NOT NULL
- start_time — TIME
- end_time — TIME
- store_type — VARCHAR(10)
- name — VARCHAR(255)
manager
- id — BIGINT
- company_id — BIGINT — NOT NULL
- manager_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- point_count — INT
member
- id — BIGINT
- company_id — BIGINT — NOT NULL
- department_id — BIGINT
- position_id — BIGINT
- member_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
position
- id — BIGINT
- company_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
terminal_token
- id — BIGINT
- mdn — VARCHAR(20) — NOT NULL
- token_value — VARCHAR(255) — NOT NULL
- issued_at — TIMESTAMP — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- last_accessed_at — TIMESTAMP
vehicle
- id — BIGINT
- company_id — BIGINT — NOT NULL
- mdn — VARCHAR(20) — NOT NULL
- brand — VARCHAR(100)
- model_name — VARCHAR(100)
- vehicle_type — VARCHAR(50)
- fuel_type — VARCHAR(50)
- total_distance_km — BIGINT
- tid — VARCHAR(50) — NOT NULL
- mid — VARCHAR(50) — NOT NULL
- pv — VARCHAR(50) — NOT NULL
- did — VARCHAR(50) — NOT NULL
- dfw_ver — VARCHAR(50) — NOT NULL
vehicle_event_log
- timestamp_utc — TIMESTAMP — 기본 키 — NOT NULL
- id — BIGINT
- vehicle_id — BIGINT — NOT NULL
- mdn — VARCHAR(20) — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- gcd — VARCHAR(1) — NOT NULL
- angle — SMALLINT
- speed — SMALLINT
- geofence_id — BIGINT
- event_value — VARCHAR(10)
- battery_voltage — SMALLINT
- second_in_cycle — SMALLINT
vehicle_usage_log
- id — BIGINT
- vehicle_id — BIGINT — NOT NULL
- member_id — BIGINT
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP
- start_latitude — DOUBLE
- start_longitude — DOUBLE
- end_latitude — DOUBLE
- end_longitude — DOUBLE
- driving_distance_km — DOUBLE