<filename>src/main/resources/db/migration/postgresql/V8__create_office.sql
CREATE TABLE OFFICE
(
  ID BIGINT NOT NULL,
  NAME CHARACTER VARYING(255) NOT NULL,
  ADDRESS_ID BIGINT,
  DEPARTMENT_ID BIGINT,
  CONSTRAINT OFFICE_PKEY PRIMARY KEY (ID),
  CONSTRAINT FK4FFKMQMLNYV67LD0DCTCVJSFJ FOREIGN KEY (DEPARTMENT_ID)
      REFERENCES DEPARTMENT (ID) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT FKAK81M3GKJ8XQ5T48XUFLBJ0KN FOREIGN KEY (ADDRESS_ID)
      REFERENCES ADDRESS (ID) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);