CREATE TABLE usstate
(
    id               INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,
    state_name       VARCHAR(255),
    state_short_name VARCHAR(255),
    CONSTRAINT pk_usstate PRIMARY KEY (id)
);

ALTER TABLE usstate
    ADD CONSTRAINT uc_usstate_state_name UNIQUE (state_name);

ALTER TABLE usstate
    ADD CONSTRAINT uc_usstate_state_short_name UNIQUE (state_short_name);