Design

Serial.

CREATE SEQUENCE user_id_seq;.

CREATE TABLE user (

User_id smallint NOT NULL DEFAULT nextval('user_id_seq').

);.

ALTER SEQUENCE user_id_seq OWNED BY user.user_id;.

Foreign

Foreign REFERENCES <Table>((<column>))

is still referenced from table

ON DELETE [CASCADE|Restrict].

Constraint

Unique.