IntermediateDB
The intermediate DB is more or less a SQL incarnation of an OSM file.
It comprise five tables. Their structure are straightforward.
Nodes, ways and relations table contain data of nodes etc. These three tables have several columns in common:
| id | primary key |
| osm_id | the osm id |
| tstamp | timestamp (last change date) |
| classcode | foreign key referencing a row in OHDM classification table |
| otherclasscodes | primary key |
| id | primary key |
| id | primary key |