/*******************************************************************************
 * Copyright (c) 1998, 2013 Oracle and/or its affiliates. All rights reserved.
 * This program and the accompanying materials are made available under the 
 * terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0 
 * which accompanies this distribution. 
 * The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
 * and the Eclipse Distribution License is available at 
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * Contributors:
 *     Oracle - initial API and implementation from Oracle TopLink
 ******************************************************************************/  
package org.eclipse.persistence.testing.models.inheritance;

import org.eclipse.persistence.tools.schemaframework.*;

/**
 * This class was generated by the TopLink table creator generator.
 * It stores the meta-data (tables) that define the database schema.
 * @see org.eclipse.persistence.sessions.factories.TableCreatorClassGenerator
 */
public class InheritanceTableCreator extends org.eclipse.persistence.tools.schemaframework.TableCreator {
    public InheritanceTableCreator() {
        setName("InheritanceProject");

        addTableDefinition(buildMAMMALTable());
        addTableDefinition(buildJAVAPROGRAMMERTable());
        addTableDefinition(buildANIMALTable());
        addTableDefinition(buildPROGRAMMERTable());
        addTableDefinition(buildALLIGATORTable());
        addTableDefinition(buildANIMAL_MATTTable());
        addTableDefinition(buildPRIMATETable());
        addTableDefinition(buildHUMAN_MTable());
        addTableDefinition(buildBUSTable());
        addTableDefinition(buildPROJECT_WORKER_BATCHTable());
        addTableDefinition(buildCOMPANYTable());
        addTableDefinition(buildINH_MFTable());
        addTableDefinition(buildINH_COMPTable());
        addTableDefinition(buildPROJECT_BATCHTable());
        addTableDefinition(buildBUDGETTED_PROJECT_BATCHTable());
        addTableDefinition(buildKING_DEVELOPERTable());
        addTableDefinition(buildA_KING2Table());
        addTableDefinition(buildCARTable());
        addTableDefinition(buildVEHICLETable());
        addTableDefinition(buildPERSON2Table());
        addTableDefinition(buildPARTNUMSTable());
        addTableDefinition(buildFUEL_VEHTable());
        addTableDefinition(buildKING_PERSONTable());
        addTableDefinition(buildINSECTTable());
        addTableDefinition(buildGRASSHOPPERTable());
		addTableDefinition(buildENTOMOLOGISTTable());
        addTableDefinition(buildLADYBUGTable());
        addTableDefinition(buildWORKERTable());
        addTableDefinition(buildTEACHERTable());
        addTableDefinition(buildFRUITTable());
    }

    public TableDefinition buildALLIGATORTable() {
        TableDefinition table = new TableDefinition();
        table.setName("ALLIGATOR");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(18);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldFAVORITESWAMP = new FieldDefinition();
        fieldFAVORITESWAMP.setName("FAVORITESWAMP");
        fieldFAVORITESWAMP.setTypeName("VARCHAR2");
        fieldFAVORITESWAMP.setSize(255);
        fieldFAVORITESWAMP.setSubSize(0);
        fieldFAVORITESWAMP.setIsPrimaryKey(false);
        fieldFAVORITESWAMP.setIsIdentity(false);
        fieldFAVORITESWAMP.setUnique(false);
        fieldFAVORITESWAMP.setShouldAllowNull(true);
        table.addField(fieldFAVORITESWAMP);

        FieldDefinition fieldVICTIM_ID = new FieldDefinition();
        fieldVICTIM_ID.setName("VICTIM_ID");
        fieldVICTIM_ID.setTypeName("NUMBER");
        fieldVICTIM_ID.setSize(18);
        fieldVICTIM_ID.setSubSize(0);
        fieldVICTIM_ID.setIsPrimaryKey(false);
        fieldVICTIM_ID.setIsIdentity(false);
        fieldVICTIM_ID.setUnique(false);
        fieldVICTIM_ID.setShouldAllowNull(true);
        table.addField(fieldVICTIM_ID);

        ForeignKeyConstraint foreignKeyFK_ALLIGATOR_VICTIM_ID = new ForeignKeyConstraint();
        foreignKeyFK_ALLIGATOR_VICTIM_ID.setName("FK_ALL_VICTIM_ID");
        foreignKeyFK_ALLIGATOR_VICTIM_ID.setTargetTable("ANIMAL_MATT");
        foreignKeyFK_ALLIGATOR_VICTIM_ID.addSourceField("VICTIM_ID");
        foreignKeyFK_ALLIGATOR_VICTIM_ID.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyFK_ALLIGATOR_VICTIM_ID);

        return table;
    }

    public TableDefinition buildANIMALTable() {
        TableDefinition table = new TableDefinition();
        table.setName("ANIMAL");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(18);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldNAME = new FieldDefinition();
        fieldNAME.setName("NAME");
        fieldNAME.setTypeName("VARCHAR2");
        fieldNAME.setSize(255);
        fieldNAME.setSubSize(0);
        fieldNAME.setIsPrimaryKey(false);
        fieldNAME.setIsIdentity(false);
        fieldNAME.setUnique(false);
        fieldNAME.setShouldAllowNull(true);
        table.addField(fieldNAME);

        FieldDefinition fieldTYPE = new FieldDefinition();
        fieldTYPE.setName("TYPE");
        fieldTYPE.setTypeName("VARCHAR2");
        fieldTYPE.setSize(240);
        fieldTYPE.setSubSize(0);
        fieldTYPE.setIsPrimaryKey(true);
        fieldTYPE.setIsIdentity(false);
        fieldTYPE.setUnique(false);
        fieldTYPE.setShouldAllowNull(false);
        table.addField(fieldTYPE);

        return table;
    }

    public TableDefinition buildANIMAL_MATTTable() {
        TableDefinition table = new TableDefinition();
        table.setName("ANIMAL_MATT");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(18);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldANIMALSIZE = new FieldDefinition();
        fieldANIMALSIZE.setName("ANIMALSIZE");
        fieldANIMALSIZE.setTypeName("VARCHAR2");
        fieldANIMALSIZE.setSize(255);
        fieldANIMALSIZE.setSubSize(0);
        fieldANIMALSIZE.setIsPrimaryKey(false);
        fieldANIMALSIZE.setIsIdentity(false);
        fieldANIMALSIZE.setUnique(false);
        fieldANIMALSIZE.setShouldAllowNull(true);
        table.addField(fieldANIMALSIZE);

        FieldDefinition fieldSUBCLASS = new FieldDefinition();
        fieldSUBCLASS.setName("SUBCLASS");
        fieldSUBCLASS.setTypeName("VARCHAR2");
        fieldSUBCLASS.setSize(100);
        fieldSUBCLASS.setSubSize(0);
        fieldSUBCLASS.setIsPrimaryKey(false);
        fieldSUBCLASS.setIsIdentity(false);
        fieldSUBCLASS.setUnique(false);
        fieldSUBCLASS.setShouldAllowNull(true);
        table.addField(fieldSUBCLASS);

        return table;
    }

    public TableDefinition buildA_KING2Table() {
        TableDefinition table = new TableDefinition();
        table.setName("A_KING2");

        FieldDefinition fieldINDEX_KING2 = new FieldDefinition();
        fieldINDEX_KING2.setName("INDEX_KING2");
        fieldINDEX_KING2.setTypeName("NUMBER");
        fieldINDEX_KING2.setSize(15);
        fieldINDEX_KING2.setSubSize(0);
        fieldINDEX_KING2.setIsPrimaryKey(true);
        fieldINDEX_KING2.setIsIdentity(false);
        fieldINDEX_KING2.setUnique(false);
        fieldINDEX_KING2.setShouldAllowNull(false);
        table.addField(fieldINDEX_KING2);

        FieldDefinition fieldBAR = new FieldDefinition();
        fieldBAR.setName("BAR");
        fieldBAR.setTypeName("VARCHAR2");
        fieldBAR.setSize(20);
        fieldBAR.setSubSize(0);
        fieldBAR.setIsPrimaryKey(false);
        fieldBAR.setIsIdentity(false);
        fieldBAR.setUnique(false);
        fieldBAR.setShouldAllowNull(true);
        table.addField(fieldBAR);

        FieldDefinition fieldFOO = new FieldDefinition();
        fieldFOO.setName("FOO");
        fieldFOO.setTypeName("VARCHAR2");
        fieldFOO.setSize(20);
        fieldFOO.setSubSize(0);
        fieldFOO.setIsPrimaryKey(false);
        fieldFOO.setIsIdentity(false);
        fieldFOO.setUnique(false);
        fieldFOO.setShouldAllowNull(true);
        table.addField(fieldFOO);

        FieldDefinition fieldTYPE = new FieldDefinition();
        fieldTYPE.setName("TYPE");
        fieldTYPE.setTypeName("CHAR");
        fieldTYPE.setSize(1);
        fieldTYPE.setSubSize(0);
        fieldTYPE.setIsPrimaryKey(false);
        fieldTYPE.setIsIdentity(false);
        fieldTYPE.setUnique(false);
        fieldTYPE.setShouldAllowNull(true);
        table.addField(fieldTYPE);

        FieldDefinition fieldHA = new FieldDefinition();
        fieldHA.setName("HA");
        fieldHA.setTypeName("VARCHAR2");
        fieldHA.setSize(20);
        fieldHA.setSubSize(0);
        fieldHA.setIsPrimaryKey(false);
        fieldHA.setIsIdentity(false);
        fieldHA.setUnique(false);
        fieldHA.setShouldAllowNull(true);
        table.addField(fieldHA);

        return table;
    }

    public TableDefinition buildBUDGETTED_PROJECT_BATCHTable() {
        TableDefinition table = new TableDefinition();
        table.setName("BUDGETTED_PROJECT_BATCH");

        FieldDefinition fieldBUDGET = new FieldDefinition();
        fieldBUDGET.setName("BUDGET");
        fieldBUDGET.setTypeName("NUMBER");
        fieldBUDGET.setSize(15);
        fieldBUDGET.setSubSize(0);
        fieldBUDGET.setIsPrimaryKey(false);
        fieldBUDGET.setIsIdentity(false);
        fieldBUDGET.setUnique(false);
        fieldBUDGET.setShouldAllowNull(true);
        table.addField(fieldBUDGET);

        FieldDefinition fieldPROJECT_ID = new FieldDefinition();
        fieldPROJECT_ID.setName("PROJECT_ID");
        fieldPROJECT_ID.setTypeName("NUMBER");
        fieldPROJECT_ID.setSize(15);
        fieldPROJECT_ID.setSubSize(0);
        fieldPROJECT_ID.setIsPrimaryKey(true);
        fieldPROJECT_ID.setIsIdentity(false);
        fieldPROJECT_ID.setUnique(false);
        fieldPROJECT_ID.setShouldAllowNull(false);
        table.addField(fieldPROJECT_ID);

        FieldDefinition fieldTITLE = new FieldDefinition();
        fieldTITLE.setName("TITLE");
        fieldTITLE.setTypeName("VARCHAR2");
        fieldTITLE.setSize(10);
        fieldTITLE.setSubSize(0);
        fieldTITLE.setIsPrimaryKey(false);
        fieldTITLE.setIsIdentity(false);
        fieldTITLE.setUnique(false);
        fieldTITLE.setShouldAllowNull(true);
        table.addField(fieldTITLE);
        
        ForeignKeyConstraint foreignKeyBUDGET_PROJECT_ID = new ForeignKeyConstraint();
        foreignKeyBUDGET_PROJECT_ID.setName("BUDGET_PROJECT_ID");
        foreignKeyBUDGET_PROJECT_ID.setTargetTable("PROJECT_BATCH");
        foreignKeyBUDGET_PROJECT_ID.addSourceField("PROJECT_ID");
        foreignKeyBUDGET_PROJECT_ID.addTargetField("PROJECT_ID");
        table.addForeignKeyConstraint(foreignKeyBUDGET_PROJECT_ID);

        return table;
    }

    public TableDefinition buildBUSTable() {
        TableDefinition table = new TableDefinition();
        table.setName("BUS");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldDESCRIP = new FieldDefinition();
        fieldDESCRIP.setName("DESCRIP");
        fieldDESCRIP.setTypeName("VARCHAR2");
        fieldDESCRIP.setSize(30);
        fieldDESCRIP.setSubSize(0);
        fieldDESCRIP.setIsPrimaryKey(false);
        fieldDESCRIP.setIsIdentity(false);
        fieldDESCRIP.setUnique(false);
        fieldDESCRIP.setShouldAllowNull(true);
        table.addField(fieldDESCRIP);

        FieldDefinition fieldDRIVER_ID = new FieldDefinition();
        fieldDRIVER_ID.setName("DRIVER_ID");
        fieldDRIVER_ID.setTypeName("NUMBER");
        fieldDRIVER_ID.setSize(15);
        fieldDRIVER_ID.setSubSize(0);
        fieldDRIVER_ID.setIsPrimaryKey(false);
        fieldDRIVER_ID.setIsIdentity(false);
        fieldDRIVER_ID.setUnique(false);
        fieldDRIVER_ID.setShouldAllowNull(true);
        table.addField(fieldDRIVER_ID);

        ForeignKeyConstraint foreignKeyBUS_PERSON2 = new ForeignKeyConstraint();
        foreignKeyBUS_PERSON2.setName("BUS_PERSON2");
        foreignKeyBUS_PERSON2.setTargetTable("PERSON2");
        foreignKeyBUS_PERSON2.addSourceField("DRIVER_ID");
        foreignKeyBUS_PERSON2.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyBUS_PERSON2);
        
        ForeignKeyConstraint foreignKeyFK_BUS_FUEL_VEH_ID = new ForeignKeyConstraint();
        foreignKeyFK_BUS_FUEL_VEH_ID.setName("FK_BUS_FUEL_VEH_ID");
        foreignKeyFK_BUS_FUEL_VEH_ID.setTargetTable("FUEL_VEH");
        foreignKeyFK_BUS_FUEL_VEH_ID.addSourceField("ID");
        foreignKeyFK_BUS_FUEL_VEH_ID.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyFK_BUS_FUEL_VEH_ID);

        return table;
    }

    public TableDefinition buildCARTable() {
        TableDefinition table = new TableDefinition();
        table.setName("CAR");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldCDESCRIP = new FieldDefinition();
        fieldCDESCRIP.setName("CDESCRIP");
        fieldCDESCRIP.setTypeName("VARCHAR2");
        fieldCDESCRIP.setSize(30);
        fieldCDESCRIP.setSubSize(0);
        fieldCDESCRIP.setIsPrimaryKey(false);
        fieldCDESCRIP.setIsIdentity(false);
        fieldCDESCRIP.setUnique(false);
        fieldCDESCRIP.setShouldAllowNull(true);
        table.addField(fieldCDESCRIP);

        FieldDefinition fieldFUEL_CAP = new FieldDefinition();
        fieldFUEL_CAP.setName("FUEL_CAP");
        fieldFUEL_CAP.setTypeName("NUMBER");
        fieldFUEL_CAP.setSize(10);
        fieldFUEL_CAP.setSubSize(0);
        fieldFUEL_CAP.setIsPrimaryKey(false);
        fieldFUEL_CAP.setIsIdentity(false);
        fieldFUEL_CAP.setUnique(false);
        fieldFUEL_CAP.setShouldAllowNull(true);
        table.addField(fieldFUEL_CAP);
        
        ForeignKeyConstraint foreignKeyFK_CAR_FUEL_VEH_ID = new ForeignKeyConstraint();
        foreignKeyFK_CAR_FUEL_VEH_ID.setName("FK_CAR_FUEL_VEH_ID");
        foreignKeyFK_CAR_FUEL_VEH_ID.setTargetTable("FUEL_VEH");
        foreignKeyFK_CAR_FUEL_VEH_ID.addSourceField("ID");
        foreignKeyFK_CAR_FUEL_VEH_ID.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyFK_CAR_FUEL_VEH_ID);

        return table;
    }

    public TableDefinition buildCOMPANYTable() {
        TableDefinition table = new TableDefinition();
        table.setName("COMPANY");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldNAME = new FieldDefinition();
        fieldNAME.setName("NAME");
        fieldNAME.setTypeName("VARCHAR2");
        fieldNAME.setSize(100);
        fieldNAME.setSubSize(0);
        fieldNAME.setIsPrimaryKey(false);
        fieldNAME.setIsIdentity(false);
        fieldNAME.setUnique(false);
        fieldNAME.setShouldAllowNull(false);
        table.addField(fieldNAME);

        return table;
    }

	public TableDefinition buildENTOMOLOGISTTable() {
		TableDefinition table = new TableDefinition();
		table.setName("ENTOMOLOGIST");
		
		FieldDefinition fieldID = new FieldDefinition();
		fieldID.setName("ID");
		fieldID.setTypeName("NUMBER");
		fieldID.setSize(0);
		fieldID.setSubSize(0);
		fieldID.setIsPrimaryKey(true);
		fieldID.setIsIdentity(false);
		fieldID.setUnique(false);
		fieldID.setShouldAllowNull(false);
		table.addField(fieldID);
		
		FieldDefinition fieldNAME = new FieldDefinition();
		fieldNAME.setName("NAME");
		fieldNAME.setTypeName("VARCHAR2");
		fieldNAME.setSize(20);
		fieldNAME.setSubSize(0);
		fieldNAME.setIsPrimaryKey(false);
		fieldNAME.setIsIdentity(false);
		fieldNAME.setUnique(false);
		fieldNAME.setShouldAllowNull(true);
		table.addField(fieldNAME);
		
		return table;
	}

	public TableDefinition buildFUEL_VEHTable() {
        TableDefinition table = new TableDefinition();
        table.setName("FUEL_VEH");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldFUEL_CAP = new FieldDefinition();
        fieldFUEL_CAP.setName("FUEL_CAP");
        fieldFUEL_CAP.setTypeName("NUMBER");
        fieldFUEL_CAP.setSize(10);
        fieldFUEL_CAP.setSubSize(0);
        fieldFUEL_CAP.setIsPrimaryKey(false);
        fieldFUEL_CAP.setIsIdentity(false);
        fieldFUEL_CAP.setUnique(false);
        fieldFUEL_CAP.setShouldAllowNull(true);
        table.addField(fieldFUEL_CAP);

        FieldDefinition fieldFUEL_TYP = new FieldDefinition();
        fieldFUEL_TYP.setName("FUEL_TYP");
        fieldFUEL_TYP.setTypeName("VARCHAR2");
        fieldFUEL_TYP.setSize(30);
        fieldFUEL_TYP.setSubSize(0);
        fieldFUEL_TYP.setIsPrimaryKey(false);
        fieldFUEL_TYP.setIsIdentity(false);
        fieldFUEL_TYP.setUnique(false);
        fieldFUEL_TYP.setShouldAllowNull(true);
        table.addField(fieldFUEL_TYP);
        
        ForeignKeyConstraint foreignKeyFUEL_VEH_VEHICLE = new ForeignKeyConstraint();
        foreignKeyFUEL_VEH_VEHICLE.setName("FUEL_VEH_VEHICLE");
        foreignKeyFUEL_VEH_VEHICLE.setTargetTable("VEHICLE");
        foreignKeyFUEL_VEH_VEHICLE.addSourceField("ID");
        foreignKeyFUEL_VEH_VEHICLE.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyFUEL_VEH_VEHICLE);

        return table;
    }

    public TableDefinition buildGRASSHOPPERTable() {
        TableDefinition table = new TableDefinition();
        table.setName("GRASSHOPPER");

        FieldDefinition fieldGH_ID = new FieldDefinition();
        fieldGH_ID.setName("GH_ID");
        fieldGH_ID.setTypeName("NUMBER");
        fieldGH_ID.setSize(18);
        fieldGH_ID.setSubSize(0);
        fieldGH_ID.setIsPrimaryKey(true);
        fieldGH_ID.setIsIdentity(false);
        fieldGH_ID.setUnique(false);
        fieldGH_ID.setShouldAllowNull(false);
        table.addField(fieldGH_ID);

        FieldDefinition fieldGH_MAXIMUMJUMP = new FieldDefinition();
        fieldGH_MAXIMUMJUMP.setName("GH_MAXIMUMJUMP");
        fieldGH_MAXIMUMJUMP.setTypeName("NUMBER");
        fieldGH_MAXIMUMJUMP.setSize(18);
        fieldGH_MAXIMUMJUMP.setSubSize(0);
        fieldGH_MAXIMUMJUMP.setIsPrimaryKey(false);
        fieldGH_MAXIMUMJUMP.setIsIdentity(false);
        fieldGH_MAXIMUMJUMP.setUnique(false);
        fieldGH_MAXIMUMJUMP.setShouldAllowNull(true);
        table.addField(fieldGH_MAXIMUMJUMP);

        ForeignKeyConstraint foreignKeyGRASSHOPPER_INSECT = new ForeignKeyConstraint();
        foreignKeyGRASSHOPPER_INSECT.setName("GRASSHOPPER_INSECT");
        foreignKeyGRASSHOPPER_INSECT.setTargetTable("INSECT");
        foreignKeyGRASSHOPPER_INSECT.addSourceField("GH_ID");
        foreignKeyGRASSHOPPER_INSECT.addTargetField("IN_ID");
        table.addForeignKeyConstraint(foreignKeyGRASSHOPPER_INSECT);

        return table;
    }

    public TableDefinition buildHUMAN_MTable() {
        TableDefinition table = new TableDefinition();
        table.setName("HUMAN_M");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(10);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldTHE_NAME = new FieldDefinition();
        fieldTHE_NAME.setName("THE_NAME");
        fieldTHE_NAME.setTypeName("VARCHAR2");
        fieldTHE_NAME.setSize(255);
        fieldTHE_NAME.setSubSize(0);
        fieldTHE_NAME.setIsPrimaryKey(false);
        fieldTHE_NAME.setIsIdentity(false);
        fieldTHE_NAME.setUnique(false);
        fieldTHE_NAME.setShouldAllowNull(true);
        table.addField(fieldTHE_NAME);
        
        ForeignKeyConstraint foreignKeyHUMAN_M_PRIMATE = new ForeignKeyConstraint();
        foreignKeyHUMAN_M_PRIMATE.setName("HUMAN_M_PRIMATE");
        foreignKeyHUMAN_M_PRIMATE.setTargetTable("PRIMATE");
        foreignKeyHUMAN_M_PRIMATE.addSourceField("ID");
        foreignKeyHUMAN_M_PRIMATE.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyHUMAN_M_PRIMATE);

        return table;
    }

    public TableDefinition buildINH_COMPTable() {
        TableDefinition table = new TableDefinition();
        table.setName("INH_COMP");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(10);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldMEMORY = new FieldDefinition();
        fieldMEMORY.setName("MEMORY");
        fieldMEMORY.setTypeName("NUMBER");
        fieldMEMORY.setSize(10);
        fieldMEMORY.setSubSize(0);
        fieldMEMORY.setIsPrimaryKey(false);
        fieldMEMORY.setIsIdentity(false);
        fieldMEMORY.setUnique(false);
        fieldMEMORY.setShouldAllowNull(true);
        table.addField(fieldMEMORY);

        FieldDefinition fieldSPEED = new FieldDefinition();
        fieldSPEED.setName("SPEED");
        fieldSPEED.setTypeName("NUMBER");
        fieldSPEED.setSize(10);
        fieldSPEED.setSubSize(0);
        fieldSPEED.setIsPrimaryKey(false);
        fieldSPEED.setIsIdentity(false);
        fieldSPEED.setUnique(false);
        fieldSPEED.setShouldAllowNull(true);
        table.addField(fieldSPEED);

        FieldDefinition fieldMAKE = new FieldDefinition();
        fieldMAKE.setName("MAKE");
        fieldMAKE.setTypeName("VARCHAR2");
        fieldMAKE.setSize(100);
        fieldMAKE.setSubSize(0);
        fieldMAKE.setIsPrimaryKey(false);
        fieldMAKE.setIsIdentity(false);
        fieldMAKE.setUnique(false);
        fieldMAKE.setShouldAllowNull(true);
        table.addField(fieldMAKE);

        FieldDefinition fieldMANUFAC = new FieldDefinition();
        fieldMANUFAC.setName("MANUFAC");
        fieldMANUFAC.setTypeName("VARCHAR2");
        fieldMANUFAC.setSize(100);
        fieldMANUFAC.setSubSize(0);
        fieldMANUFAC.setIsPrimaryKey(false);
        fieldMANUFAC.setIsIdentity(false);
        fieldMANUFAC.setUnique(false);
        fieldMANUFAC.setShouldAllowNull(true);
        table.addField(fieldMANUFAC);

        FieldDefinition fieldCTYPE = new FieldDefinition();
        fieldCTYPE.setName("CTYPE");
        fieldCTYPE.setTypeName("VARCHAR2");
        fieldCTYPE.setSize(20);
        fieldCTYPE.setSubSize(0);
        fieldCTYPE.setIsPrimaryKey(false);
        fieldCTYPE.setIsIdentity(false);
        fieldCTYPE.setUnique(false);
        fieldCTYPE.setShouldAllowNull(true);
        table.addField(fieldCTYPE);

        FieldDefinition fieldPCTYPE = new FieldDefinition();
        fieldPCTYPE.setName("PCTYPE");
        fieldPCTYPE.setTypeName("VARCHAR2");
        fieldPCTYPE.setSize(20);
        fieldPCTYPE.setSubSize(0);
        fieldPCTYPE.setIsPrimaryKey(false);
        fieldPCTYPE.setIsIdentity(false);
        fieldPCTYPE.setUnique(false);
        fieldPCTYPE.setShouldAllowNull(true);
        table.addField(fieldPCTYPE);

        FieldDefinition fieldCLONE = new FieldDefinition();
        fieldCLONE.setName("CLONE");
        fieldCLONE.setTypeName("VARCHAR2");
        fieldCLONE.setSize(255);
        fieldCLONE.setSubSize(0);
        fieldCLONE.setIsPrimaryKey(false);
        fieldCLONE.setIsIdentity(false);
        fieldCLONE.setUnique(false);
        fieldCLONE.setShouldAllowNull(true);
        table.addField(fieldCLONE);

        return table;
    }

    public TableDefinition buildINH_MFTable() {
        TableDefinition table = new TableDefinition();
        table.setName("INH_MF");

        FieldDefinition fieldMF_ID = new FieldDefinition();
        fieldMF_ID.setName("MF_ID");
        fieldMF_ID.setTypeName("NUMBER");
        fieldMF_ID.setSize(10);
        fieldMF_ID.setSubSize(0);
        fieldMF_ID.setIsPrimaryKey(true);
        fieldMF_ID.setIsIdentity(false);
        fieldMF_ID.setUnique(false);
        fieldMF_ID.setShouldAllowNull(false);
        table.addField(fieldMF_ID);

        FieldDefinition fieldPROCS = new FieldDefinition();
        fieldPROCS.setName("PROCS");
        fieldPROCS.setTypeName("NUMBER");
        fieldPROCS.setSize(10);
        fieldPROCS.setSubSize(0);
        fieldPROCS.setIsPrimaryKey(false);
        fieldPROCS.setIsIdentity(false);
        fieldPROCS.setUnique(false);
        fieldPROCS.setShouldAllowNull(true);
        table.addField(fieldPROCS);

        ForeignKeyConstraint foreignKeyINH_MF_INH_COMP = new ForeignKeyConstraint();
        foreignKeyINH_MF_INH_COMP.setName("INH_MF_INH_COMP");
        foreignKeyINH_MF_INH_COMP.setTargetTable("INH_COMP");
        foreignKeyINH_MF_INH_COMP.addSourceField("MF_ID");
        foreignKeyINH_MF_INH_COMP.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyINH_MF_INH_COMP);

        return table;
    }

    public TableDefinition buildINSECTTable() {
        TableDefinition table = new TableDefinition();
        table.setName("INSECT");

        FieldDefinition fieldIN_ID = new FieldDefinition();
        fieldIN_ID.setName("IN_ID");
        fieldIN_ID.setTypeName("NUMBER");
        fieldIN_ID.setSize(18);
        fieldIN_ID.setSubSize(0);
        fieldIN_ID.setIsPrimaryKey(true);
        fieldIN_ID.setIsIdentity(false);
        fieldIN_ID.setUnique(false);
        fieldIN_ID.setShouldAllowNull(false);
        table.addField(fieldIN_ID);

        FieldDefinition fieldIN_TYPE = new FieldDefinition();
        fieldIN_TYPE.setName("IN_TYPE");
        fieldIN_TYPE.setTypeName("VARCHAR2");
        fieldIN_TYPE.setSize(255);
        fieldIN_TYPE.setSubSize(0);
        fieldIN_TYPE.setIsPrimaryKey(false);
        fieldIN_TYPE.setIsIdentity(false);
        fieldIN_TYPE.setUnique(false);
        fieldIN_TYPE.setShouldAllowNull(true);
        table.addField(fieldIN_TYPE);

        FieldDefinition fieldIN_NUMBEROFLEGS = new FieldDefinition();
        fieldIN_NUMBEROFLEGS.setName("IN_NUMBEROFLEGS");
        fieldIN_NUMBEROFLEGS.setTypeName("NUMBER");
        fieldIN_NUMBEROFLEGS.setSize(18);
        fieldIN_NUMBEROFLEGS.setSubSize(0);
        fieldIN_NUMBEROFLEGS.setIsPrimaryKey(false);
        fieldIN_NUMBEROFLEGS.setIsIdentity(false);
        fieldIN_NUMBEROFLEGS.setUnique(false);
        fieldIN_NUMBEROFLEGS.setShouldAllowNull(true);
        table.addField(fieldIN_NUMBEROFLEGS);

        FieldDefinition fieldENTOMOLOGIST = new FieldDefinition();
        fieldENTOMOLOGIST.setName("ENTOMOLOGIST");
        fieldENTOMOLOGIST.setTypeName("NUMBER");
        fieldENTOMOLOGIST.setSize(18);
        fieldENTOMOLOGIST.setSubSize(0);
        fieldENTOMOLOGIST.setIsPrimaryKey(false);
        fieldENTOMOLOGIST.setIsIdentity(false);
        fieldENTOMOLOGIST.setUnique(false);
        fieldENTOMOLOGIST.setShouldAllowNull(true);
        table.addField(fieldENTOMOLOGIST);
        return table;
    }

    public TableDefinition buildJAVAPROGRAMMERTable() {
        TableDefinition table = new TableDefinition();
        table.setName("JAVAPROGRAMMER");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(10);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldNUMBER_OF_SUPPORT = new FieldDefinition();
        fieldNUMBER_OF_SUPPORT.setName("NUMBER_OF_SUPPORT");
        fieldNUMBER_OF_SUPPORT.setTypeName("NUMBER");
        fieldNUMBER_OF_SUPPORT.setSize(10);
        fieldNUMBER_OF_SUPPORT.setSubSize(0);
        fieldNUMBER_OF_SUPPORT.setIsPrimaryKey(false);
        fieldNUMBER_OF_SUPPORT.setIsIdentity(false);
        fieldNUMBER_OF_SUPPORT.setUnique(false);
        fieldNUMBER_OF_SUPPORT.setShouldAllowNull(false);
        table.addField(fieldNUMBER_OF_SUPPORT);
        
        ForeignKeyConstraint foreignKeyJAVAPROGRAMMER_PROGRAMMER = new ForeignKeyConstraint();
        foreignKeyJAVAPROGRAMMER_PROGRAMMER.setName("JAVAP_P");
        foreignKeyJAVAPROGRAMMER_PROGRAMMER.setTargetTable("PROGRAMMER");
        foreignKeyJAVAPROGRAMMER_PROGRAMMER.addSourceField("ID");
        foreignKeyJAVAPROGRAMMER_PROGRAMMER.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyJAVAPROGRAMMER_PROGRAMMER);

        return table;
    }

    public TableDefinition buildKING_DEVELOPERTable() {
        TableDefinition table = new TableDefinition();
        table.setName("KING_DEVELOPER");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldCODEINDEX = new FieldDefinition();
        fieldCODEINDEX.setName("CODEINDEX");
        fieldCODEINDEX.setTypeName("NUMBER");
        fieldCODEINDEX.setSize(6);
        fieldCODEINDEX.setSubSize(0);
        fieldCODEINDEX.setIsPrimaryKey(false);
        fieldCODEINDEX.setIsIdentity(false);
        fieldCODEINDEX.setUnique(false);
        fieldCODEINDEX.setShouldAllowNull(true);
        table.addField(fieldCODEINDEX);

        FieldDefinition fieldOFF_NUM = new FieldDefinition();
        fieldOFF_NUM.setName("OFF_NUM");
        fieldOFF_NUM.setTypeName("NUMBER");
        fieldOFF_NUM.setSize(6);
        fieldOFF_NUM.setSubSize(0);
        fieldOFF_NUM.setIsPrimaryKey(false);
        fieldOFF_NUM.setIsIdentity(false);
        fieldOFF_NUM.setUnique(false);
        fieldOFF_NUM.setShouldAllowNull(true);
        table.addField(fieldOFF_NUM);

        FieldDefinition fieldRESPONS = new FieldDefinition();
        fieldRESPONS.setName("RESPONS");
        fieldRESPONS.setTypeName("VARCHAR2");
        fieldRESPONS.setSize(100);
        fieldRESPONS.setSubSize(0);
        fieldRESPONS.setIsPrimaryKey(false);
        fieldRESPONS.setIsIdentity(false);
        fieldRESPONS.setUnique(false);
        fieldRESPONS.setShouldAllowNull(true);
        table.addField(fieldRESPONS);

        ForeignKeyConstraint foreignKeyDEVELOPER_KING_PERSON_KING = new ForeignKeyConstraint();
        foreignKeyDEVELOPER_KING_PERSON_KING.setName("DEVLOPER_PERSON");
        foreignKeyDEVELOPER_KING_PERSON_KING.setTargetTable("KING_PERSON");
        foreignKeyDEVELOPER_KING_PERSON_KING.addSourceField("ID");
        foreignKeyDEVELOPER_KING_PERSON_KING.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyDEVELOPER_KING_PERSON_KING);
        
        return table;
    }

    public TableDefinition buildKING_PERSONTable() {
        TableDefinition table = new TableDefinition();
        table.setName("KING_PERSON");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldNAME = new FieldDefinition();
        fieldNAME.setName("NAME");
        fieldNAME.setTypeName("VARCHAR2");
        fieldNAME.setSize(20);
        fieldNAME.setSubSize(0);
        fieldNAME.setIsPrimaryKey(false);
        fieldNAME.setIsIdentity(false);
        fieldNAME.setUnique(false);
        fieldNAME.setShouldAllowNull(true);
        table.addField(fieldNAME);

        FieldDefinition fieldPERSON_TYPE = new FieldDefinition();
        fieldPERSON_TYPE.setName("PERSON_TYPE");
        fieldPERSON_TYPE.setTypeName("VARCHAR2");
        fieldPERSON_TYPE.setSize(10);
        fieldPERSON_TYPE.setSubSize(0);
        fieldPERSON_TYPE.setIsPrimaryKey(false);
        fieldPERSON_TYPE.setIsIdentity(false);
        fieldPERSON_TYPE.setUnique(false);
        fieldPERSON_TYPE.setShouldAllowNull(true);
        table.addField(fieldPERSON_TYPE);

        return table;
    }

    public TableDefinition buildLADYBUGTable() {
        TableDefinition table = new TableDefinition();
        table.setName("LADYBUG");

        FieldDefinition fieldLB_ID = new FieldDefinition();
        fieldLB_ID.setName("LB_ID");
        fieldLB_ID.setTypeName("NUMBER");
        fieldLB_ID.setSize(18);
        fieldLB_ID.setSubSize(0);
        fieldLB_ID.setIsPrimaryKey(true);
        fieldLB_ID.setIsIdentity(false);
        fieldLB_ID.setUnique(false);
        fieldLB_ID.setShouldAllowNull(false);
        table.addField(fieldLB_ID);

        FieldDefinition fieldLB_NUMBEROFSPOTS = new FieldDefinition();
        fieldLB_NUMBEROFSPOTS.setName("LB_NUMBEROFSPOTS");
        fieldLB_NUMBEROFSPOTS.setTypeName("NUMBER");
        fieldLB_NUMBEROFSPOTS.setSize(18);
        fieldLB_NUMBEROFSPOTS.setSubSize(0);
        fieldLB_NUMBEROFSPOTS.setIsPrimaryKey(false);
        fieldLB_NUMBEROFSPOTS.setIsIdentity(false);
        fieldLB_NUMBEROFSPOTS.setUnique(false);
        fieldLB_NUMBEROFSPOTS.setShouldAllowNull(true);
        table.addField(fieldLB_NUMBEROFSPOTS);

        ForeignKeyConstraint foreignKeyLADYBUG_INSECT = new ForeignKeyConstraint();
        foreignKeyLADYBUG_INSECT.setName("LADYBUG_INSECT");
        foreignKeyLADYBUG_INSECT.setTargetTable("INSECT");
        foreignKeyLADYBUG_INSECT.addSourceField("LB_ID");
        foreignKeyLADYBUG_INSECT.addTargetField("IN_ID");
        table.addForeignKeyConstraint(foreignKeyLADYBUG_INSECT);

        return table;
    }

    public TableDefinition buildMAMMALTable() {
        TableDefinition table = new TableDefinition();
        table.setName("MAMMAL");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(10);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldWEIGHT = new FieldDefinition();
        fieldWEIGHT.setName("WEIGHT");
        fieldWEIGHT.setTypeName("NUMBER");
        fieldWEIGHT.setSize(10);
        fieldWEIGHT.setSubSize(0);
        fieldWEIGHT.setIsPrimaryKey(false);
        fieldWEIGHT.setIsIdentity(false);
        fieldWEIGHT.setUnique(false);
        fieldWEIGHT.setShouldAllowNull(false);
        table.addField(fieldWEIGHT);

        return table;
    }

    public TableDefinition buildPARTNUMSTable() {
        TableDefinition table = new TableDefinition();
        table.setName("PARTNUMS");

        FieldDefinition fieldVEHIC_ID = new FieldDefinition();
        fieldVEHIC_ID.setName("VEHIC_ID");
        fieldVEHIC_ID.setTypeName("NUMBER");
        fieldVEHIC_ID.setSize(15);
        fieldVEHIC_ID.setSubSize(0);
        fieldVEHIC_ID.setIsPrimaryKey(false);
        fieldVEHIC_ID.setIsIdentity(false);
        fieldVEHIC_ID.setUnique(false);
        fieldVEHIC_ID.setShouldAllowNull(true);
        table.addField(fieldVEHIC_ID);

        FieldDefinition fieldPART_NUM = new FieldDefinition();
        fieldPART_NUM.setName("PART_NUM");
        fieldPART_NUM.setTypeName("VARCHAR2");
        fieldPART_NUM.setSize(30);
        fieldPART_NUM.setSubSize(0);
        fieldPART_NUM.setIsPrimaryKey(false);
        fieldPART_NUM.setIsIdentity(false);
        fieldPART_NUM.setUnique(false);
        fieldPART_NUM.setShouldAllowNull(true);
        table.addField(fieldPART_NUM);

        ForeignKeyConstraint foreignKeyPARTNUMS_VEHICLE = new ForeignKeyConstraint();
        foreignKeyPARTNUMS_VEHICLE.setName("PARTNUMS_VEHICLE");
        foreignKeyPARTNUMS_VEHICLE.setTargetTable("VEHICLE");
        foreignKeyPARTNUMS_VEHICLE.addSourceField("VEHIC_ID");
        foreignKeyPARTNUMS_VEHICLE.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyPARTNUMS_VEHICLE);

        return table;
    }

    public TableDefinition buildPERSON2Table() {
        TableDefinition table = new TableDefinition();
        table.setName("PERSON2");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldNAME = new FieldDefinition();
        fieldNAME.setName("NAME");
        fieldNAME.setTypeName("VARCHAR2");
        fieldNAME.setSize(20);
        fieldNAME.setSubSize(0);
        fieldNAME.setIsPrimaryKey(false);
        fieldNAME.setIsIdentity(false);
        fieldNAME.setUnique(false);
        fieldNAME.setShouldAllowNull(true);
        table.addField(fieldNAME);

        FieldDefinition fieldC_TYPE = new FieldDefinition();
        fieldC_TYPE.setName("C_TYPE");
        fieldC_TYPE.setTypeName("VARCHAR2");
        fieldC_TYPE.setSize(100);
        fieldC_TYPE.setSubSize(0);
        fieldC_TYPE.setIsPrimaryKey(false);
        fieldC_TYPE.setIsIdentity(false);
        fieldC_TYPE.setUnique(false);
        fieldC_TYPE.setShouldAllowNull(true);
        table.addField(fieldC_TYPE);

        FieldDefinition fieldKNOWS_JAVA = new FieldDefinition();
        fieldKNOWS_JAVA.setName("KNOWS_JAVA");
        fieldKNOWS_JAVA.setTypeName("VARCHAR2");
        fieldKNOWS_JAVA.setSize(1);
        fieldKNOWS_JAVA.setSubSize(0);
        fieldKNOWS_JAVA.setIsPrimaryKey(false);
        fieldKNOWS_JAVA.setIsIdentity(false);
        fieldKNOWS_JAVA.setUnique(false);
        fieldKNOWS_JAVA.setShouldAllowNull(true);
        table.addField(fieldKNOWS_JAVA);

        FieldDefinition fieldBOSS_ID = new FieldDefinition();
        fieldBOSS_ID.setName("BOSS_ID");
        fieldBOSS_ID.setTypeName("NUMBER");
        fieldBOSS_ID.setSize(15);
        fieldBOSS_ID.setSubSize(0);
        fieldBOSS_ID.setIsPrimaryKey(false);
        fieldBOSS_ID.setIsIdentity(false);
        fieldBOSS_ID.setUnique(false);
        fieldBOSS_ID.setShouldAllowNull(true);
        table.addField(fieldBOSS_ID);

        FieldDefinition fieldREP_ID = new FieldDefinition();
        fieldREP_ID.setName("REP_ID");
        fieldREP_ID.setTypeName("NUMBER");
        fieldREP_ID.setSize(15);
        fieldREP_ID.setSubSize(0);
        fieldREP_ID.setIsPrimaryKey(false);
        fieldREP_ID.setIsIdentity(false);
        fieldREP_ID.setUnique(false);
        fieldREP_ID.setShouldAllowNull(true);
        table.addField(fieldREP_ID);

        FieldDefinition fieldFRIEND_ID = new FieldDefinition();
        fieldFRIEND_ID.setName("FRIEND_ID");
        fieldFRIEND_ID.setTypeName("NUMBER");
        fieldFRIEND_ID.setSize(15);
        fieldFRIEND_ID.setSubSize(0);
        fieldFRIEND_ID.setIsPrimaryKey(false);
        fieldFRIEND_ID.setIsIdentity(false);
        fieldFRIEND_ID.setUnique(false);
        fieldFRIEND_ID.setShouldAllowNull(true);
        table.addField(fieldFRIEND_ID);

        FieldDefinition fieldCAR_ID = new FieldDefinition();
        fieldCAR_ID.setName("CAR_ID");
        fieldCAR_ID.setTypeName("NUMBER");
        fieldCAR_ID.setSize(15);
        fieldCAR_ID.setSubSize(0);
        fieldCAR_ID.setIsPrimaryKey(false);
        fieldCAR_ID.setIsIdentity(false);
        fieldCAR_ID.setUnique(false);
        fieldCAR_ID.setShouldAllowNull(true);
        table.addField(fieldCAR_ID);

        ForeignKeyConstraint foreignKeyPERSON2_PERSON2_FRND = new ForeignKeyConstraint();
        foreignKeyPERSON2_PERSON2_FRND.setName("PER2_PER2_FRND");
        foreignKeyPERSON2_PERSON2_FRND.setTargetTable("PERSON2");
        foreignKeyPERSON2_PERSON2_FRND.addSourceField("FRIEND_ID");
        foreignKeyPERSON2_PERSON2_FRND.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyPERSON2_PERSON2_FRND);

        ForeignKeyConstraint foreignKeyPERSON2_CAR = new ForeignKeyConstraint();
        foreignKeyPERSON2_CAR.setName("PERSON2_CAR");
        foreignKeyPERSON2_CAR.setTargetTable("CAR");
        foreignKeyPERSON2_CAR.addSourceField("CAR_ID");
        foreignKeyPERSON2_CAR.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyPERSON2_CAR);

        ForeignKeyConstraint foreignKeyPERSON2_PERSON2_REP = new ForeignKeyConstraint();
        foreignKeyPERSON2_PERSON2_REP.setName("PER2_PER2_REP");
        foreignKeyPERSON2_PERSON2_REP.setTargetTable("PERSON2");
        foreignKeyPERSON2_PERSON2_REP.addSourceField("REP_ID");
        foreignKeyPERSON2_PERSON2_REP.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyPERSON2_PERSON2_REP);

        ForeignKeyConstraint foreignKeyPERSON2_PERSON2_BS = new ForeignKeyConstraint();
        foreignKeyPERSON2_PERSON2_BS.setName("PER2_PER2_BS");
        foreignKeyPERSON2_PERSON2_BS.setTargetTable("PERSON2");
        foreignKeyPERSON2_PERSON2_BS.addSourceField("BOSS_ID");
        foreignKeyPERSON2_PERSON2_BS.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyPERSON2_PERSON2_BS);

        return table;
    }

    public TableDefinition buildPRIMATETable() {
        TableDefinition table = new TableDefinition();
        table.setName("PRIMATE");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(10);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldGENDER = new FieldDefinition();
        fieldGENDER.setName("GENDER");
        fieldGENDER.setTypeName("VARCHAR2");
        fieldGENDER.setSize(255);
        fieldGENDER.setSubSize(0);
        fieldGENDER.setIsPrimaryKey(false);
        fieldGENDER.setIsIdentity(false);
        fieldGENDER.setUnique(false);
        fieldGENDER.setShouldAllowNull(true);
        table.addField(fieldGENDER);

        return table;
    }

    public TableDefinition buildPROGRAMMERTable() {
        TableDefinition table = new TableDefinition();
        table.setName("PROGRAMMER");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(10);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldSALARY = new FieldDefinition();
        fieldSALARY.setName("SALARY");
        fieldSALARY.setTypeName("NUMBER");
        fieldSALARY.setSize(10);
        fieldSALARY.setSubSize(0);
        fieldSALARY.setIsPrimaryKey(false);
        fieldSALARY.setIsIdentity(false);
        fieldSALARY.setUnique(false);
        fieldSALARY.setShouldAllowNull(false);
        table.addField(fieldSALARY);

        return table;
    }

    public TableDefinition buildPROJECT_BATCHTable() {
        TableDefinition table = new TableDefinition();
        table.setName("PROJECT_BATCH");

        FieldDefinition fieldPERSON_ID = new FieldDefinition();
        fieldPERSON_ID.setName("PERSON_ID");
        fieldPERSON_ID.setTypeName("NUMBER");
        fieldPERSON_ID.setSize(15);
        fieldPERSON_ID.setSubSize(0);
        fieldPERSON_ID.setIsPrimaryKey(false);
        fieldPERSON_ID.setIsIdentity(false);
        fieldPERSON_ID.setUnique(false);
        fieldPERSON_ID.setShouldAllowNull(true);
        table.addField(fieldPERSON_ID);

        FieldDefinition fieldPROJECT_ID = new FieldDefinition();
        fieldPROJECT_ID.setName("PROJECT_ID");
        fieldPROJECT_ID.setTypeName("NUMBER");
        fieldPROJECT_ID.setSize(15);
        fieldPROJECT_ID.setSubSize(0);
        fieldPROJECT_ID.setIsPrimaryKey(true);
        fieldPROJECT_ID.setIsIdentity(false);
        fieldPROJECT_ID.setUnique(false);
        fieldPROJECT_ID.setShouldAllowNull(false);
        table.addField(fieldPROJECT_ID);

        FieldDefinition fieldPROJECT_NAME = new FieldDefinition();
        fieldPROJECT_NAME.setName("PROJECT_NAME");
        fieldPROJECT_NAME.setTypeName("VARCHAR2");
        fieldPROJECT_NAME.setSize(30);
        fieldPROJECT_NAME.setSubSize(0);
        fieldPROJECT_NAME.setIsPrimaryKey(false);
        fieldPROJECT_NAME.setIsIdentity(false);
        fieldPROJECT_NAME.setUnique(false);
        fieldPROJECT_NAME.setShouldAllowNull(true);
        table.addField(fieldPROJECT_NAME);

        FieldDefinition fieldPROJECT_TYPE = new FieldDefinition();
        fieldPROJECT_TYPE.setName("PROJECT_TYPE");
        fieldPROJECT_TYPE.setTypeName("VARCHAR2");
        fieldPROJECT_TYPE.setSize(20);
        fieldPROJECT_TYPE.setSubSize(0);
        fieldPROJECT_TYPE.setIsPrimaryKey(false);
        fieldPROJECT_TYPE.setIsIdentity(false);
        fieldPROJECT_TYPE.setUnique(false);
        fieldPROJECT_TYPE.setShouldAllowNull(true);
        table.addField(fieldPROJECT_TYPE);

        ForeignKeyConstraint foreignKeyPROJECT_BATCH_PROJECT_WORKER_BATCH = new ForeignKeyConstraint();
        foreignKeyPROJECT_BATCH_PROJECT_WORKER_BATCH.setName("PRJ_WK_BATCH_FK");
        foreignKeyPROJECT_BATCH_PROJECT_WORKER_BATCH.setTargetTable("PROJECT_WORKER_BATCH");
        foreignKeyPROJECT_BATCH_PROJECT_WORKER_BATCH.addSourceField("PERSON_ID");
        foreignKeyPROJECT_BATCH_PROJECT_WORKER_BATCH.addTargetField("PERSON_ID");
        table.addForeignKeyConstraint(foreignKeyPROJECT_BATCH_PROJECT_WORKER_BATCH);

        return table;
    }

    public TableDefinition buildPROJECT_WORKER_BATCHTable() {
        TableDefinition table = new TableDefinition();
        table.setName("PROJECT_WORKER_BATCH");

        FieldDefinition fieldPERSON_ID = new FieldDefinition();
        fieldPERSON_ID.setName("PERSON_ID");
        fieldPERSON_ID.setTypeName("NUMBER");
        fieldPERSON_ID.setSize(15);
        fieldPERSON_ID.setSubSize(0);
        fieldPERSON_ID.setIsPrimaryKey(true);
        fieldPERSON_ID.setIsIdentity(false);
        fieldPERSON_ID.setUnique(false);
        fieldPERSON_ID.setShouldAllowNull(false);
        table.addField(fieldPERSON_ID);

        FieldDefinition fieldPERSON_LAST_NAME = new FieldDefinition();
        fieldPERSON_LAST_NAME.setName("PERSON_LAST_NAME");
        fieldPERSON_LAST_NAME.setTypeName("VARCHAR2");
        fieldPERSON_LAST_NAME.setSize(40);
        fieldPERSON_LAST_NAME.setSubSize(0);
        fieldPERSON_LAST_NAME.setIsPrimaryKey(false);
        fieldPERSON_LAST_NAME.setIsIdentity(false);
        fieldPERSON_LAST_NAME.setUnique(false);
        fieldPERSON_LAST_NAME.setShouldAllowNull(true);
        table.addField(fieldPERSON_LAST_NAME);

        FieldDefinition fieldPERSON_NAME = new FieldDefinition();
        fieldPERSON_NAME.setName("PERSON_NAME");
        fieldPERSON_NAME.setTypeName("VARCHAR2");
        fieldPERSON_NAME.setSize(40);
        fieldPERSON_NAME.setSubSize(0);
        fieldPERSON_NAME.setIsPrimaryKey(false);
        fieldPERSON_NAME.setIsIdentity(false);
        fieldPERSON_NAME.setUnique(false);
        fieldPERSON_NAME.setShouldAllowNull(true);
        table.addField(fieldPERSON_NAME);

        FieldDefinition fieldPROJECT_ID = new FieldDefinition();
        fieldPROJECT_ID.setName("PROJECT_ID");
        fieldPROJECT_ID.setTypeName("NUMBER");
        fieldPROJECT_ID.setSize(15);
        fieldPROJECT_ID.setSubSize(0);
        fieldPROJECT_ID.setIsPrimaryKey(false);
        fieldPROJECT_ID.setIsIdentity(false);
        fieldPROJECT_ID.setUnique(false);
        fieldPROJECT_ID.setShouldAllowNull(true);
        table.addField(fieldPROJECT_ID);

        ForeignKeyConstraint foreignKeyPROJECT_WORKER_BATCH_PROJECT_BATCH_HD = new ForeignKeyConstraint();
        foreignKeyPROJECT_WORKER_BATCH_PROJECT_BATCH_HD.setName("PRJ_WK_BATCH_HD");
        foreignKeyPROJECT_WORKER_BATCH_PROJECT_BATCH_HD.setTargetTable("PROJECT_BATCH");
        foreignKeyPROJECT_WORKER_BATCH_PROJECT_BATCH_HD.addSourceField("PROJECT_ID");
        foreignKeyPROJECT_WORKER_BATCH_PROJECT_BATCH_HD.addTargetField("PROJECT_ID");
        table.addForeignKeyConstraint(foreignKeyPROJECT_WORKER_BATCH_PROJECT_BATCH_HD);

        return table;
    }

    public TableDefinition buildVEHICLETable() {
        TableDefinition table = new TableDefinition();
        table.setName("VEHICLE");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldTYPE = new FieldDefinition();
        fieldTYPE.setName("TYPE");
        fieldTYPE.setTypeName("NUMBER");
        fieldTYPE.setSize(15);
        fieldTYPE.setSubSize(0);
        fieldTYPE.setIsPrimaryKey(false);
        fieldTYPE.setIsIdentity(false);
        fieldTYPE.setUnique(false);
        fieldTYPE.setShouldAllowNull(true);
        table.addField(fieldTYPE);

        FieldDefinition fieldCAPACITY = new FieldDefinition();
        fieldCAPACITY.setName("CAPACITY");
        fieldCAPACITY.setTypeName("NUMBER");
        fieldCAPACITY.setSize(10);
        fieldCAPACITY.setSubSize(0);
        fieldCAPACITY.setIsPrimaryKey(false);
        fieldCAPACITY.setIsIdentity(false);
        fieldCAPACITY.setUnique(false);
        fieldCAPACITY.setShouldAllowNull(true);
        table.addField(fieldCAPACITY);

        FieldDefinition fieldOWNER_ID = new FieldDefinition();
        fieldOWNER_ID.setName("OWNER_ID");
        fieldOWNER_ID.setTypeName("NUMBER");
        fieldOWNER_ID.setSize(15);
        fieldOWNER_ID.setSubSize(0);
        fieldOWNER_ID.setIsPrimaryKey(false);
        fieldOWNER_ID.setIsIdentity(false);
        fieldOWNER_ID.setUnique(false);
        fieldOWNER_ID.setShouldAllowNull(true);
        table.addField(fieldOWNER_ID);

        FieldDefinition fieldBICY_DES = new FieldDefinition();
        fieldBICY_DES.setName("BICY_DES");
        fieldBICY_DES.setTypeName("VARCHAR2");
        fieldBICY_DES.setSize(30);
        fieldBICY_DES.setSubSize(0);
        fieldBICY_DES.setIsPrimaryKey(false);
        fieldBICY_DES.setIsIdentity(false);
        fieldBICY_DES.setUnique(false);
        fieldBICY_DES.setShouldAllowNull(true);
        table.addField(fieldBICY_DES);

        ForeignKeyConstraint foreignKeyVEHICLE_COMPANY = new ForeignKeyConstraint();
        foreignKeyVEHICLE_COMPANY.setName("VEHICLE_COMPANY");
        foreignKeyVEHICLE_COMPANY.setTargetTable("COMPANY");
        foreignKeyVEHICLE_COMPANY.addSourceField("OWNER_ID");
        foreignKeyVEHICLE_COMPANY.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyVEHICLE_COMPANY);

        return table;
    }
    
    public TableDefinition buildWORKERTable() {
        TableDefinition table = new TableDefinition();
        table.setName("WORKER2");

        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(15);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);

        FieldDefinition fieldNAME = new FieldDefinition();
        fieldNAME.setName("NAME");
        fieldNAME.setTypeName("VARCHAR2");
        fieldNAME.setSize(20);
        fieldNAME.setSubSize(0);
        fieldNAME.setIsPrimaryKey(false);
        fieldNAME.setIsIdentity(false);
        fieldNAME.setUnique(false);
        fieldNAME.setShouldAllowNull(true);
        table.addField(fieldNAME);
        
        FieldDefinition fieldW_TYPE = new FieldDefinition();
        fieldW_TYPE.setName("W_TYPE");
        fieldW_TYPE.setTypeName("VARCHAR2");
        fieldW_TYPE.setSize(100);
        fieldW_TYPE.setSubSize(0);
        fieldW_TYPE.setIsPrimaryKey(false);
        fieldW_TYPE.setIsIdentity(false);
        fieldW_TYPE.setUnique(false);
        fieldW_TYPE.setShouldAllowNull(true);
        table.addField(fieldW_TYPE);
        
        FieldDefinition fieldCOMPANY_ID = new FieldDefinition();
        fieldCOMPANY_ID.setName("COMPANY_ID");
        fieldCOMPANY_ID.setTypeName("NUMBER");
        fieldCOMPANY_ID.setSize(15);
        fieldCOMPANY_ID.setSubSize(0);
        fieldCOMPANY_ID.setIsPrimaryKey(false);
        fieldCOMPANY_ID.setIsIdentity(false);
        fieldCOMPANY_ID.setUnique(false);
        fieldCOMPANY_ID.setShouldAllowNull(true);
        table.addField(fieldCOMPANY_ID);
        
        ForeignKeyConstraint foreignKeyWORKER_COMPANY = new ForeignKeyConstraint();
        foreignKeyWORKER_COMPANY.setName("WORKER_COMPANY");
        foreignKeyWORKER_COMPANY.setTargetTable("COMPANY");
        foreignKeyWORKER_COMPANY.addSourceField("COMPANY_ID");
        foreignKeyWORKER_COMPANY.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyWORKER_COMPANY);

        return table;
    }
    
    public TableDefinition buildFRUITTable() {
        TableDefinition table = new TableDefinition();
        table.setName("FRUIT");
        
        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(0);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);
        
        FieldDefinition fieldTYPE = new FieldDefinition();
        fieldTYPE.setName("TYPE");
        fieldTYPE.setTypeName("VARCHAR2");
        fieldTYPE.setSize(20);
        fieldTYPE.setSubSize(0);
        fieldTYPE.setIsPrimaryKey(false);
        fieldTYPE.setIsIdentity(false);
        fieldTYPE.setUnique(false);
        fieldTYPE.setShouldAllowNull(false);
        table.addField(fieldTYPE);
        
        FieldDefinition fieldQUALITY = new FieldDefinition();
        fieldQUALITY.setName("QUALITY");
        fieldQUALITY.setTypeName("VARCHAR2");
        fieldQUALITY.setSize(20);
        fieldQUALITY.setSubSize(0);
        fieldQUALITY.setIsPrimaryKey(false);
        fieldQUALITY.setIsIdentity(false);
        fieldQUALITY.setUnique(false);
        fieldQUALITY.setShouldAllowNull(true);
        table.addField(fieldQUALITY);
        
        FieldDefinition fieldTEACHER_ID = new FieldDefinition();
        fieldTEACHER_ID.setName("TEACHER_ID");
        fieldTEACHER_ID.setTypeName("NUMBER");
        fieldTEACHER_ID.setSize(0);
        fieldTEACHER_ID.setSubSize(0);
        fieldTEACHER_ID.setIsPrimaryKey(false);
        fieldTEACHER_ID.setIsIdentity(false);
        fieldTEACHER_ID.setUnique(false);
        fieldTEACHER_ID.setShouldAllowNull(true);
        table.addField(fieldTEACHER_ID);
        
        ForeignKeyConstraint foreignKeyFRUIT_TEACHER = new ForeignKeyConstraint();
        foreignKeyFRUIT_TEACHER.setName("FRUIT_TEACHER");
        foreignKeyFRUIT_TEACHER.setTargetTable("TEACHER");
        foreignKeyFRUIT_TEACHER.addSourceField("TEACHER_ID");
        foreignKeyFRUIT_TEACHER.addTargetField("ID");
        table.addForeignKeyConstraint(foreignKeyFRUIT_TEACHER);
        
        return table;
    }
    
    public TableDefinition buildTEACHERTable() {
        TableDefinition table = new TableDefinition();
        table.setName("TEACHER");
        
        FieldDefinition fieldID = new FieldDefinition();
        fieldID.setName("ID");
        fieldID.setTypeName("NUMBER");
        fieldID.setSize(0);
        fieldID.setSubSize(0);
        fieldID.setIsPrimaryKey(true);
        fieldID.setIsIdentity(false);
        fieldID.setUnique(false);
        fieldID.setShouldAllowNull(false);
        table.addField(fieldID);
        
        FieldDefinition fieldNAME = new FieldDefinition();
        fieldNAME.setName("NAME");
        fieldNAME.setTypeName("VARCHAR2");
        fieldNAME.setSize(20);
        fieldNAME.setSubSize(0);
        fieldNAME.setIsPrimaryKey(false);
        fieldNAME.setIsIdentity(false);
        fieldNAME.setUnique(false);
        fieldNAME.setShouldAllowNull(false);
        table.addField(fieldNAME);
        
        return table;
    }
    
}
