Visitor Counter:
Countries and Vehicle Types.
Within ERD there are two tables which contain details of countries and vehicle types and the fields forming the tables are as follows.
The user can change or delete any of the data records but is advised against doing that since deletion of a record will delete all stock of that country or type, Changing the data is also not advised since this will potentially cause conflicts with future data updates.
Fields in the Countries Table.
| Field | Description | Example Record Data |
| country | The name of the country to which vehicles are allocated | GERMANY |
| abbreviation | The abbreviation used for the country | DB |
Different versions of ERD have different countries defined in this table but the following view gives an example of what there might be.
| Country | Abbreviation |
|---|---|
| AUSTRIA | OBB |
| BELGIUM | SNCB |
| CZECH | CD |
| DENMARK | DSB |
| FINLAND | VR |
| FRANCE | SNCF |
| GERMANY | DB |
| GREECE | OSE |
| HUNGARY | MAV |
| IRELAND | IE/NIR |
| ITALY | FS |
| LUXEMBOURG | CFL |
| NETHERLANDS | NS |
| NORWAY | NSB |
| POLAND | PKP |
| PORTUGAL | CP |
| ROMANIA | CFR |
| SLOVAK | ZSR |
| SLOVENIA | SZ |
| SPAIN | RENFE |
| SWEDEN | SJ |
| SWITZERLAND | SBB |
| UK-STEAM(1948) | BR-S |
| UNITED KINGDOM | BR |
Fields in the Vehicle Types Table.
| Field | Description | Example Record Data |
| type | code used in the locos table which designates the vehicle type | DE |
| description | The abbreviation used for the country | Diesel Locos |
The standard version of ERD currently contains 11 vehicle types as shown here. You can change the descriptions at will but it is not reccommended that you change or delete the type.
| Type | Description |
|---|---|
| C | Coaches |
| D | Diesel Locos |
| DEP | Departmental |
| DMU | Diesel Units |
| E | Electric Locos |
| EMU | Electric Units |
| H | High Speed Trains |
| P | Plant |
| S | Steam Locos |
| T | Trams & Light Rail |
| U | Underground |