fine.SQL

CREATE TABLE Entity(
    label CHAR(512),
    entityname CHAR(512),
    entitytype CHAR(512),
    required CHAR(1),
    is_index CHAR(1),
    is_unique CHAR(1),
    options TEXT,
    default TEXT,
    min DOUBLE,
    max DOUBLE,
    readonly CHAR(1),
    compute CHAR(512),
    dependsof CHAR(512),
    description TEXT,
    name CHAR(512) NOT NULL UNIQUE,
    parent CHAR(512), 
    parent_name CHAR(512) NOT NULL,
    parent_entity CHAR(512) NOT NULL,
    idx INTEGER NOT NULL DEFAULT 1,
    CONSTRAINT  "FK_Entity_parent__constraint" FOREIGN KEY (parent) REFERENCES Schema (name) ON DELETE CASCADE,
    PRIMARY KEY(name));

wrong.SQL

CREATE TABLE Entity(
    label CHAR(512),
    entityname CHAR(512),
    entitytype CHAR(512),
    required CHAR(1),
    is_index CHAR(1),
    is_unique CHAR(1),
    options TEXT,
    default TEXT,
    min DOUBLE,
    max DOUBLE,
    readonly CHAR(1),
    compute CHAR(512),
    dependsof CHAR(512),
    description TEXT,
    name CHAR(512) NOT NULL UNIQUE,
    parent CHAR(512), CONSTRAINT  "FK_Entity_parent__constraint" FOREIGN KEY (parent) REFERENCES Schema (name) ON DELETE CASCADE,
    parent_name CHAR(512) NOT NULL,
    parent_entity CHAR(512) NOT NULL,
    idx INTEGER NOT NULL DEFAULT 1,
    PRIMARY KEY(name)) ;