Skip to content
Once there was a railway

Once there was a railway

  • Lines
    • Caernarfon to Beddgelert
  • Organisations
    • Ffestiniog and Welsh Highland Railways Trust
    • Ffestiniog Railway Society
    • Henschel & Sohn
    • Welsh Highland Railway Society
  • Railways
    • Ffestiniog and Welsh Highland Railway
  • Rolling Stock
    • NG15 No.134
  • Stations
    • Caernarfon
  • Trains
    • Gelert Explorer / Fforiwr Gelert
  • Data Model

Data Model

Here is a rough idea of how the data model is set up. It does not indicate relationships.

  • Content (names, text, images, maps, links, documents)
  • Activity (yes/no)

Relationships are outlined here:

  1. Organisations
  2. Railways
  3. Rolling Stock
  4. Trains
  5. Stations
  6. Lines

Taxonomic Data

Gauges

  • Broad
    • 1445mm – Italian Broad Gauge
  • Narrow
    • 1000mm – Metre
    • 1067mm – Three Foot Six Inch
    • 1219mm – Four Foot
    • 1372mm – Four Foot Six Inch
    • 1432mm
    • 600mm
    • 610mm – Two Foot
    • 686mm – Two Foot Three Inch
    • 750mm
    • 760mm – Bosnian Gauge
    • 762mm – Two Foot Six Inch
    • 891mm – Swedish Three-Foot
    • 900mm
    • 914mm – Three-Foot
    • 950mm – Italian Metre
  • Standard
    • 1435mm

Line Types

  • Branch
  • Loop
  • Main
  • Section

Organisation Types

  • Manufacturer
  • Operator
  • Owner

Railway Regions

  • International
  • Local
  • National
  • Regional

Rolling Stock Types

  • Locomotive
    • Diesel and Diesel Electric
    • Electric
    • Other
    • Steam
      • Articulated
        • Fairlie
        • Garratt
        • Mallet
        • Meyer
      • Expansion
        • Compound
        • Simple
      • Fixed
        • Duplex
        • Standard
  • Unpowered
    • Freight Wagons
      • Box
      • Combination
      • Flat
      • Hopper
      • Tank
    • Non-Revenue
      • Ballast
      • Caboose
      • Clearance
      • Crew
      • Guard
    • Passenger Coaches
      • Dining
      • Observation
      • Sleeping
      • Standard

Station Facilities

  • Fuel
  • Servicing
  • Workshop

Station Types

  • Hault
  • Siding
  • Station

Usage

  • Freight
  • Mixed
  • Passenger
  • Specialised
    • Funicular
    • Military
    • Mining
    • Monorails
    • Rack
    • Service and Repair
    • Trams
    • Wrecking
© Once there was a railway - 2026