create table ADDRESS (ID number(10,0) not null, CITY varchar2(255), constraint ADDRESS_PK primary key(ID));
create table BIG_DECIMAL_ENTITY (BIG_DECIMAL_PROPERTY number(19,2));
create table BIG_INTEGER_ENTITY (BIG_INTEGER_PROPERTY number(19,0));
create table BOOLEAN_ENTITY (BOOLEAN_PROPERTY number(1,0));
create table BYTE_ARRAY_ENTITY (BYTE_ARRAY_PROPERTY raw(255), BLOB_PROPERTY blob);
create table BYTE_ENTITY (BYTE_PROPERTY number(5,0));
create table CALENDAR_ENTITY (DATE_PROPERTY date, TIME_PROPERTY date, TIMESTAMP_PROPERTY timestamp);
create table CHARACTER_ENTITY (CHARACTER_PROPERTY char(1));
create table DATE_ENTITY (DATE_PROPERTY date, TIME_PROPERTY date, TIMESTAMP_PROPERTY timestamp);
create table DEPARTMENT (ID number(10,0) not null, NAME varchar2(255), constraint DEPARTMENT_PK primary key(ID));
create table DOUBLE_ENTITY (DOUBLE1_PROPERTY double precision);
create table EMPLOYEE (ID number(10,0) not null, FIRST_NAME varchar2(255) not null, LAST_NAME varchar2(255) not null, DEPARTMENT_ID number(10,0), ADDRESS_ID number(10,0), constraint EMPLOYEE_PK primary key(ID));
create table ENUM_ENTITY (ENUM_PROPERTY number(10,0));
create table FLOAT_ENTITY (FLOAT_PROPERTY float);
create table INTEGER_ENTITY (INTEGER_PROPERTY number(10,0));
create table LONG_ENTITY (LONG_PROPERTY number(19,0));
create table SERIALIZABLE_ENTITY (SERIALIZABLE_PROPERTY raw(255), BLOB_PROPERTY blob);
create table SHORT_ENTITY (SHORT_PROPERTY number(5,0));
create table SQL_DATE_ENTITY (SQL_DATE_PROPERTY date);
create table STRING_ENTITY (STRING_PROPERTY varchar2(255), CLOB_PROPERTY clob);
create table TIME_ENTITY (TIME_PROPERTY date);
create table TIMESTAMP_ENTITY (TIMESTAMP_PROPERTY timestamp);