ai-diagrams · Diagram examples · Sample fintechERD · overview · V1
■ Logical model · 4 schemas
Dependencies between schemas
Each cell counts columns in the row schema that point to a table in the column schema. These are FKs without reads: the database guarantees the row exists, and the service does not read the other table.
| comum | cadastro | conta | cobranca | points to N schemas |
|---|
| comumshared reference data | 3 | | | | 0 |
|---|
| cadastroCustomer registration | 1 | 3 | | | 1 |
|---|
| contaAccounts and transactions | 1 | 1 | 4 | | 2 |
|---|
| cobrancaInvoices and receipts | 1 | 1 | 2 | 8 | 3 |
|---|
| used byhow many schemas point to it | 3 | 2 | 1 | 0 | |
|---|
Dark diagonal: how many tables the schema has. The total is 18.
Cell color: stronger means more referencing columns. The densest pair has 2 columns.
comum is referenced most: 3 schemas depend on it. cobranca has the most dependencies: it points to 3.
Each column, by schema pair
cadastro → comum 1
enderecos.pais_id → paises
conta → comum 1
contas.moeda_id → moedas
conta → cadastro 1
contas.cliente_id → clientes
cobranca → comum 1
faturas_cobranca.moeda_id → moedas
cobranca → cadastro 1
faturas_cobranca.cliente_id → clientes
cobranca → conta 2
faturas_cobranca.conta_id → contas
pagamentos_recebidos.conta_id → contas