automation type table structure

This table holds information about the various levels of automation that can exist within a given vehicular fleet. Vehicles have a vehicle_type and each vehicle_type has an associated automation_type (this table) which defines the abilities of that vehicle type in a connected and autonomous network.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
type_id*	INTEGER	NO			The unique identifier for this type of automation
type	TEXT	NO	‘’		Human readable identifier
acc	INTEGER	NO			boolean flag - does vehicle support adaptive cruise control (ACC)?
cacc	INTEGER	NO			boolean flag - does vehicle support connected ACC?
connected_signal	INTEGER	NO			boolean flag - does vehicle support communication with connected signals?
fully_autonomous	INTEGER	NO			boolean flag - does vehicle support fully autonomous driving mode?

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Automation_Type" (
  "type_id" INTEGER NOT NULL PRIMARY KEY,
  "type" TEXT NOT NULL DEFAULT '',
  "acc" INTEGER NOT NULL,
  "cacc" INTEGER NOT NULL,
  "connected_signal" INTEGER NOT NULL,
  "fully_autonomous" INTEGER NOT NULL
)