rail operator counties table structure#

List of rail operators by county in the model

Table Structure#

Field	Type	NULL allowed	Default Value	Foreign key	Description
rail_operator	INTEGER	NO	0		The unique identifier of the rail operator as in the Rail_Operator table
county	INTEGER	NO	0		County FIPS code

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Rail_Operator_Counties (
    "rail_operator" INTEGER NOT NULL DEFAULT 0,
    "county"        INTEGER NOT NULL DEFAULT 0
);