rail operator table structure

rail operator table structure#

List of rail operators in the model

Table Structure#
Field	Type	NULL allowed	Description
rail_operator	INTEGER	NO	The unique identifier of the rail operator
name	TEXT	NO	Name of the rail operator
short_name*	TEXT	NO	Rail operator acronym

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Rail_Operator (
    "rail_operator" INTEGER NOT NULL,
    "name"          TEXT    NOT NULL,
    "short_name"    TEXT    NOT NULL   PRIMARY KEY
);
CREATE INDEX IF NOT EXISTS "rail_operator_i" ON "Rail_Operator" ("rail_operator");