DROP TABLE DUMMY_ENTITY CASCADE CONSTRAINTS PURGE;
DROP TABLE ELEMENT CASCADE CONSTRAINTS PURGE;

CREATE TABLE DUMMY_ENTITY (
    ID NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY PRIMARY KEY,
    NAME VARCHAR2(100)
);

CREATE TABLE ELEMENT (
    ID   NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY PRIMARY KEY,
    CONTENT NUMBER,
    DUMMY_ENTITY_KEY NUMBER ,
    DUMMY_ENTITY NUMBER
);
