AAIA schema relationships (PostgreSQL FK metadata)

Every foreign key recorded in PostgreSQL information_schema for the AAIA schemas used in this app. Outgoing: child table in the schema → parent table (any schema). Incoming: some table (any schema) → parent table in the schema. If a link is missing here, the database may not declare that constraint as an FK (common on legacy dumps).

How to use this

aaia_vcdb

Open FK listing →

aaia_pcdb

Open FK listing →

aaia_qdb

Open FK listing →