create table PARSABLE ( INTAKE_ID NUMBER(10) not null constraint FK_PARSABLE_INTAKE_INTAKE_ID references INTAKE on delete cascade, NAME NVARCHAR2(450) not null, SCHEMA NVARCHAR2(450) not null, PARENT_INTAKE_ID NUMBER(10) not null, PARENT_NAME NVARCHAR2(450), PARENT_SCHEMA NVARCHAR2(450), AS_AT TIMESTAMP(7) not null, CODE NCLOB, CODE_HASH NVARCHAR2(2000), CODE_ITEM_TYPE NVARCHAR2(2000) not null, DATABASE NVARCHAR2(2000), CONTAINER NVARCHAR2(2000), SIZE_MB NUMBER(10), constraint PK_PARSABLE primary key (INTAKE_ID, NAME, SCHEMA), constraint FK_PARSABLE_PARSABLE_PARENT_INTAKE_ID_PARENT_NAME_PARENT_SCHEMA foreign key (PARENT_INTAKE_ID, PARENT_NAME, PARENT_SCHEMA) references PARSABLE ) / create index IX_PARSABLE_PARENT_INTAKE_ID_PARENT_NAME_PARENT_SCHEMA on PARSABLE (PARENT_INTAKE_ID, PARENT_NAME, PARENT_SCHEMA) /