테크돔

테이블 (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