APIHUB Backend ERD

APIHUB Backend database structure (ERD)

• Relationships tables
• Orphans tables
• Appendix: how to generate dynamic document
  • Run SchemaSpy from jar distribution (on Windows)

This article depicts tables and relationships in APIHUB Backend database.

This article contains static pictures for reference.

Interactive document can be found here: ERD on GitHub pages

Relationships tables

Orphans tables

Appendix: how to generate dynamic document

The following tool is used: SchemaSpy, GitHub

Run SchemaSpy from jar distribution (on Windows)

Software prerequisites:

• JRE

Steps:

1. Download jar file from Release v6.2.4
2. Download PG JDBC driver from Release 42.7.7
3. Put both jars to same folder

You need PG with APIHUB Backend database up and running. For example you could set up APIHUB via docker-compose or in local k8s cluster and make port-forward.

Let's imagine PG is available on localhost:5432

Just execute the following command:

java -jar schemaspy-6.2.4.jar ^
  -t pgsql ^
  -dp postgresql-42.7.7.jar ^
  -host localhost ^
  -port 5432 ^
  -db apihub_backend ^
  -u postgres ^
  -p postgres ^
  -s public ^
  -o erd ^
  -vizjs ^
  -norows ^
  -noimplied

Results will be placed in ./erd