A customer can have at most one wallet in accounts. Find the rules behind that: from
pg_constraint, show conname, contype and pg_get_constraintdef(oid) as definition for every
primary key, unique and foreign key constraint of accounts.
End your query with ORDER BY contype, conname.
| accounts |
|---|
| account_id (PK) |
| customer_id (FK) |
| account_no |
| balance |
| opened_at |
A customer can have at most one wallet in accounts. Find the rules behind that: from
pg_constraint, show conname, contype and pg_get_constraintdef(oid) as definition for every
primary key, unique and foreign key constraint of accounts.
End your query with ORDER BY contype, conname.
| accounts |
|---|
| account_id (PK) |
| customer_id (FK) |
| account_no |
| balance |
| opened_at |
| conname | contype | definition |
|---|---|---|
| accounts_customer_id_fkey | f | FOREIGN KEY (customer_id) REFERENCES customers(customer_id) ON UPDATE CASCADE ON DELETE CASCADE |
| accounts_pkey | p | PRIMARY KEY (account_id) |
| accounts_account_no_key | u | UNIQUE (account_no) |
| accounts_customer_id_key | u | UNIQUE (customer_id) |
Run query to see output