connectivity type table structure

This table holds information about whether a vehicle is a connected vehicle. Only two options are currently allowed: Yes and No. Other levels of connectivity can be included as needed.

Static table. POLARIS does not change the value of this table.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
type_id*	INTEGER	NO			Identifier for connectivity type
type	TEXT	NO	‘’		Text description of connectivity type: currently Yes or No

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Connectivity_Type" (
  "type_id" INTEGER NOT NULL PRIMARY KEY,
  "type" TEXT NOT NULL DEFAULT '')