vintage type table structure

Table representing the different levels of vintage (age) for a vehicle that is currently allowed by POLARIS Primarily used when passing along vehicle characteristic to Autonomie.

Static table. POLARIS does not modify the outputs.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
type_id*	INTEGER	NO			Unique identifier of this vintage type
type	TEXT	NO	‘’		Text description of vintage type and currently includes: 0-5 years, 6-10 years, and 10+ years

(* - Primary key)

The SQL statement for table and index creation is below.

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