Database Commands...

CREATE TYPE Texture AS OBJECT(
    entropy NUMBER(10,10),
    energy NUMBER(10,10),
    inertia NUMBER(10,10),
    inverseDiffMoment NUMBER(10,10),
    correlation NUMBER(10,10),
    infoCorrelation1 NUMBER(10,10),
    infoCorrelation2 NUMBER(10,10),
    sumAvg NUMBER(10,10),
    sumVar NUMBER(10,10),
    sumEntropy NUMBER(10,10),
    diffAvg NUMBER(10,10),
    difVar NUMBER(10,10),
    diffEntropy NUMBER(10,10)
)

CREATE TYPE Color AS OBJECT(
    row1 VARCHAR(2500),
    row2 VARCHAR(2500),
    row3 VARCHAR(2500),
    row4 VARCHAR(2500),
    row5 VARCHAR(2500),
    row6 VARCHAR(2500),
    row7 VARCHAR(2500),
    row8 VARCHAR(2500),
    row9 VARCHAR(2500),
    row10 VARCHAR(2500),
    row11 VARCHAR(2500)
)

CREATE TYPE Shape AS OBJECT(
    xCentroid NUMBER(10,10),
    yCentroid NUMBER(10,10),
    area NUMBER(10,10),
    eccentricity NUMBER(10,10),
    perimeter NUMBER(10,10),
    shapeHistogram VARCHAR(2500)
)

CREATE TABLE Object_Table(
    key NUMBER(10, 10),
    color Color,
    shape Shape,
    texture Texture,
    tag VARCHAR(20),
    PRIMARY KEY(key)
)

CREATE TABLE Image_Feature (
    no_objects NUMBER CHECK (no_objects > 0),
    hash VARCHAR(50) NOT NULL,
    path VARCHAR(200),
    histogram color,
    PRIMARY KEY(hash)
)

CREATE TABLE Image_Object (
    hash VARCHAR(50),
    key NUMBER(10, 10),
    FOREIGN KEY (hash) REFERENCES Image_Feature (hash),
    FOREIGN KEY (key) REFERENCES Object_Table(key),
    PRIMARY KEY (hash, key)
)