DROP TABLE IF EXISTS OTHER.DUMMY_ENTITY;
DROP TABLE IF EXISTS OTHER.REFERENCED;
DROP SCHEMA IF EXISTS OTHER;

CREATE SCHEMA OTHER;

CREATE TABLE OTHER.DUMMY_ENTITY
(
  ID BIGINT IDENTITY PRIMARY KEY,
  NAME VARCHAR(30)
);

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

