CREATE TABLE address
(
    id       BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL,
    address1 VARCHAR(255),
    address2 VARCHAR(255),
    city     VARCHAR(255),
    state    VARCHAR(255),
    zip      VARCHAR(255),
    CONSTRAINT pk_address PRIMARY KEY (id)
);

ALTER TABLE employee
    ADD address_id BIGINT;

ALTER TABLE employee
    ADD CONSTRAINT FK_EMPLOYEE_ON_ADDRESS FOREIGN KEY (address_id) REFERENCES address (id);