area type table structure

Area types are used throughout the demand model to differentiate different regions within the modeled area (e.g. CBD, inner suburb, outer suburb, industrial).

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
area_type*	INTEGER	NO			Unique identifier for the area type
name	TEXT	NO	‘’		Simple description of the area type
notes	TEXT	YES			User notes

(* - Primary key)

The SQL statement for table and index creation is below.

create TABLE IF NOT EXISTS "Area_Type" (
    "area_type" INTEGER NOT NULL PRIMARY KEY,
    "name"      TEXT    NOT NULL DEFAULT '',
    "notes"     TEXT
);

INSERT INTO "Area_Type" VALUES (100,'default area type', 'default with no practical meaning');