DROP TABLE OTHER.DUMMY_ENTITY;
DROP TABLE OTHER.REFERENCED;
DROP SCHEMA OTHER RESTRICT;

CREATE SCHEMA OTHER;

CREATE TABLE OTHER.DUMMY_ENTITY
(
  ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
  NAME VARCHAR(30)
);

CREATE TABLE OTHER.REFERENCED
(
  DUMMY_ENTITY INTEGER,
  NAME VARCHAR(30)
);
