From OpenStreetMap Wiki
The complete and updated documentation is spread in the following sources:
- The git of Osm2pgsql project: have an updated database schema at docs/pgsql.md, with the columns defined in default.style.
- The information about tags at https://taginfo.openstreetmap.org
There are no explicit reference (no SQL-expressed foreign key) between tables.