In PostgreSQL, I created a constraint (a composite alternate key):
CREATE UNIQUE INDEX i_1ON sp_region (code ASC, name ASC);
For table:
CREATE TABLE sp_region
(
id serial NOT NULL,
code int4 NOT NULL,
name varchar NOT NULL,
dt_create timestamp NOT NULL,
PRIMARY KEY (id)
);
It would be convenient to display the composite key on the diagram for each attribute that is part of the key.
code - AK 1.1
name - AK 1.2
For example:
Or
Or

In PostgreSQL, I created a constraint (a composite alternate key):
CREATE UNIQUE INDEX i_1ON sp_region (code ASC, name ASC);For table:
It would be convenient to display the composite key on the diagram for each attribute that is part of the key.
code - AK 1.1
name - AK 1.2
For example:
Or
Or