public static TableDefinition buildENGINETable() {
    // CREATE TABLE JPA_OR_ENGINE (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL, PRIMARY KEY
    // (ID))
    TableDefinition table = new TableDefinition();
    table.setName("JPA_OR_ENGINE");

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

    FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
    fieldSERIALNUMBER.setName("SERIALNUMBER");
    fieldSERIALNUMBER.setTypeName("NUMERIC");
    fieldSERIALNUMBER.setSize(18);
    fieldSERIALNUMBER.setSubSize(0);
    fieldSERIALNUMBER.setIsPrimaryKey(false);
    fieldSERIALNUMBER.setIsIdentity(false);
    fieldSERIALNUMBER.setShouldAllowNull(true);
    fieldSERIALNUMBER.setUnique(false);
    table.addField(fieldSERIALNUMBER);

    return table;
  }
  public static TableDefinition buildCMP3_SALESPERSONTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_FIELDACCESS_SALESPERSON");

    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(80);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);

    return table;
  }
  public static TableDefinition buildSALARYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_SALARY");

    FieldDefinition fieldEMP_ID = new FieldDefinition();
    fieldEMP_ID.setName("E_ID");
    fieldEMP_ID.setTypeName("NUMERIC");
    fieldEMP_ID.setSize(15);
    fieldEMP_ID.setSubSize(0);
    fieldEMP_ID.setIsPrimaryKey(true);
    fieldEMP_ID.setIsIdentity(false);
    fieldEMP_ID.setUnique(false);
    fieldEMP_ID.setShouldAllowNull(false);
    fieldEMP_ID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(fieldEMP_ID);

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

    return table;
  }
  public static TableDefinition buildCACHEABLE_FALSE_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_CACHEABLE_FALSE");

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

    FieldDefinition protectedFK = new FieldDefinition();
    protectedFK.setName("PROTECTED_FK");
    protectedFK.setTypeName("NUMERIC");
    protectedFK.setSize(15);
    protectedFK.setShouldAllowNull(true);
    protectedFK.setIsPrimaryKey(false);
    protectedFK.setUnique(false);
    protectedFK.setIsIdentity(false);
    table.addField(protectedFK);

    return table;
  }
  public static TableDefinition buildCACHEABLE_PROTECTED_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_CACHEABLE_PROTECTED");

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

    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR");
    fieldNAME.setSize(75);
    fieldNAME.setShouldAllowNull(true);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setUnique(false);
    fieldNAME.setIsIdentity(false);
    table.addField(fieldNAME);

    return table;
  }
  public TableDefinition buildSoldierTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_SOLDIER");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    // fieldID.setForeignKeyFieldName("JPA_MAFIOSO.ID");
    table.addField(fieldID);

    FieldDefinition fieldCapo = new FieldDefinition();
    fieldCapo.setName("CAPO_ID");
    fieldCapo.setTypeName("NUMERIC");
    fieldCapo.setSize(15);
    fieldCapo.setShouldAllowNull(false);
    fieldCapo.setIsPrimaryKey(false);
    fieldCapo.setUnique(false);
    fieldCapo.setIsIdentity(false);
    // fieldCapo.setForeignKeyFieldName("JPA_CAPO.ID");
    table.addField(fieldCapo);

    return table;
  }
  public TableDefinition buildContract_SoldierTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_CONTRACT_SOLDIER");

    FieldDefinition fieldContractId = new FieldDefinition();
    fieldContractId.setName("CONTRACT_ID");
    fieldContractId.setTypeName("NUMERIC");
    fieldContractId.setSize(15);
    fieldContractId.setShouldAllowNull(false);
    fieldContractId.setIsPrimaryKey(true);
    fieldContractId.setUnique(false);
    fieldContractId.setIsIdentity(false);
    fieldContractId.setForeignKeyFieldName("JPA_CONTRACT.ID");
    table.addField(fieldContractId);

    FieldDefinition fieldSoldierId = new FieldDefinition();
    fieldSoldierId.setName("SOLDIER_ID");
    fieldSoldierId.setTypeName("NUMERIC");
    fieldSoldierId.setSize(15);
    fieldSoldierId.setShouldAllowNull(false);
    fieldSoldierId.setIsPrimaryKey(true);
    fieldSoldierId.setUnique(false);
    fieldSoldierId.setIsIdentity(false);
    fieldSoldierId.setForeignKeyFieldName("JPA_SOLDIER.ID");
    table.addField(fieldSoldierId);

    return table;
  }
  public TableDefinition buildMafiaFamily_RevenueTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_FAMILY_REVENUE");

    FieldDefinition fieldFamilyId = new FieldDefinition();
    fieldFamilyId.setName("ID");
    fieldFamilyId.setTypeName("NUMERIC");
    fieldFamilyId.setSize(15);
    fieldFamilyId.setIsPrimaryKey(false);
    fieldFamilyId.setIsIdentity(false);
    fieldFamilyId.setUnique(false);
    fieldFamilyId.setShouldAllowNull(false);
    // fieldFamilyId.setForeignKeyFieldName("JPA_MAFIA_FAMILY.ID");
    table.addField(fieldFamilyId);

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

    return table;
  }
  public TableDefinition buildCapoTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_CAPO");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    // fieldID.setForeignKeyFieldName("JPA_MAFIOSO.ID");
    table.addField(fieldID);

    FieldDefinition fieldUnderboss = new FieldDefinition();
    fieldUnderboss.setName("UNDERBOSS_ID");
    fieldUnderboss.setTypeName("NUMERIC");
    fieldUnderboss.setSize(15);
    fieldUnderboss.setShouldAllowNull(false);
    fieldUnderboss.setIsPrimaryKey(false);
    fieldUnderboss.setUnique(false);
    fieldUnderboss.setIsIdentity(false);
    // fieldUnderboss.setForeignKeyFieldName("JPA_UNDERBOSS.ID");
    table.addField(fieldUnderboss);

    return table;
  }
  public TableDefinition buildMafiaFamily_TagsTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_FAMILY_TAGS");

    FieldDefinition fieldFamilyId = new FieldDefinition();
    fieldFamilyId.setName("FAMILY_ID");
    fieldFamilyId.setTypeName("NUMERIC");
    fieldFamilyId.setSize(15);
    fieldFamilyId.setIsPrimaryKey(false);
    fieldFamilyId.setIsIdentity(false);
    fieldFamilyId.setUnique(false);
    fieldFamilyId.setShouldAllowNull(false);
    // fieldFamilyId.setForeignKeyFieldName("JPA_MAFIA_FAMILY.ID");
    table.addField(fieldFamilyId);

    FieldDefinition fieldTag = new FieldDefinition();
    fieldTag.setName("TAG");
    fieldTag.setTypeName("VARCHAR2");
    fieldTag.setSize(60);
    fieldTag.setSubSize(0);
    fieldTag.setIsPrimaryKey(false);
    fieldTag.setIsIdentity(false);
    fieldTag.setUnique(false);
    fieldTag.setShouldAllowNull(true);
    table.addField(fieldTag);

    return table;
  }
  public TableDefinition buildAboutToInsertSingleTable() {
    TableDefinition table = new TableDefinition();
    table.setName("AboutToInsertSingle");

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

    FieldDefinition fieldNUMBER = new FieldDefinition();
    fieldNUMBER.setName("EXTRA_NUMBER");
    fieldNUMBER.setTypeName("NUMERIC");
    fieldNUMBER.setSize(28);
    fieldNUMBER.setSubSize(0);
    fieldNUMBER.setIsPrimaryKey(false);
    fieldNUMBER.setIsIdentity(false);
    fieldNUMBER.setUnique(false);
    fieldNUMBER.setShouldAllowNull(true);
    table.addField(fieldNUMBER);

    return table;
  }
  public static TableDefinition buildTIREDETAILTable() {
    // 474752 :CREATE TABLE TIREDETAIL (ID NUMBER(10) NOT NULL, DETAIL VARCHAR2(255), PRIMARY KEY
    // (ID))
    TableDefinition table = new TableDefinition();
    table.setName("OR_TIREDETAIL");

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

    FieldDefinition fieldDetail = new FieldDefinition();
    fieldDetail.setName("DETAIL");
    fieldDetail.setTypeName("VARCHAR");
    fieldDetail.setSize(255);
    fieldDetail.setSubSize(0);
    fieldDetail.setIsPrimaryKey(false);
    fieldDetail.setIsIdentity(false);
    fieldDetail.setShouldAllowNull(true);
    fieldDetail.setUnique(false);
    table.addField(fieldDetail);

    return table;
  }
  public static TableDefinition buildCMP3_ORDER_SEQTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_FIELDACCESS_CUSTOMER_SEQ");

    FieldDefinition fieldSEQ_NAME = new FieldDefinition();
    fieldSEQ_NAME.setName("SEQ_NAME");
    fieldSEQ_NAME.setTypeName("VARCHAR");
    fieldSEQ_NAME.setSize(80);
    fieldSEQ_NAME.setSubSize(0);
    fieldSEQ_NAME.setIsPrimaryKey(true);
    fieldSEQ_NAME.setIsIdentity(false);
    fieldSEQ_NAME.setUnique(false);
    fieldSEQ_NAME.setShouldAllowNull(false);
    table.addField(fieldSEQ_NAME);

    FieldDefinition fieldSEQ_VALUE = new FieldDefinition();
    fieldSEQ_VALUE.setName("SEQ_COUNT");
    fieldSEQ_VALUE.setTypeName("NUMERIC");
    fieldSEQ_VALUE.setSize(15);
    fieldSEQ_VALUE.setSubSize(0);
    fieldSEQ_VALUE.setIsPrimaryKey(false);
    fieldSEQ_VALUE.setIsIdentity(false);
    fieldSEQ_VALUE.setUnique(false);
    fieldSEQ_VALUE.setShouldAllowNull(false);
    table.addField(fieldSEQ_VALUE);

    return table;
  }
  public static TableDefinition buildCUSTOMER_CUSTOMERTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_FIELDACCESS_CUST_CUST");

    // SECTION: FIELD
    FieldDefinition field = new FieldDefinition();
    field.setName("FieldAccessCustomer_CUST_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_FIELDACCESS_CUSTOMER.CUST_ID");
    table.addField(field);

    // SECTION: FIELD
    FieldDefinition field1 = new FieldDefinition();
    field1.setName("controlledCustomers_CUST_ID");
    field1.setTypeName("NUMERIC");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    field1.setForeignKeyFieldName("CMP3_FIELDACCESS_CUSTOMER.CUST_ID");
    table.addField(field1);

    return table;
  }
  protected void buildSimpleSpatialTable() {
    org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition =
        new org.eclipse.persistence.tools.schemaframework.TableDefinition();

    // SECTION: TABLE
    tabledefinition.setName("SIMPLE_SPATIAL");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("GID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(true);
    tabledefinition.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("GEOMETRY");
    field1.setTypeName("MDSYS.SDO_GEOMETRY");
    field1.setShouldAllowNull(true);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    tabledefinition.addField(field1);

    addTableDefinition(tabledefinition);
  }
  public static TableDefinition buildRESPONSTable() {
    TableDefinition table = new TableDefinition();
    // SECTION: TABLE
    table.setName("CMP3_XML_RESPONS");

    // SECTION: FIELD
    FieldDefinition field = new FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(false);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    FieldDefinition field1 = new FieldDefinition();
    field1.setName("DESCRIPTION");
    field1.setTypeName("VARCHAR");
    field1.setSize(200);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    return table;
  }
  public static TableDefinition buildEMPLOYEE_SEQTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_EMPLOYEE_SEQ");

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

    FieldDefinition fieldSEQ_NAME = new FieldDefinition();
    fieldSEQ_NAME.setName("SEQ_NAME");
    fieldSEQ_NAME.setTypeName("VARCHAR2");
    fieldSEQ_NAME.setSize(80);
    fieldSEQ_NAME.setSubSize(0);
    fieldSEQ_NAME.setIsPrimaryKey(true);
    fieldSEQ_NAME.setIsIdentity(false);
    fieldSEQ_NAME.setUnique(false);
    fieldSEQ_NAME.setShouldAllowNull(false);
    table.addField(fieldSEQ_NAME);

    return table;
  }
  public static TableDefinition buildPROJECT_EMPTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_XML_PROJ_EMP");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("PROJ_ID");
    field1.setTypeName("NUMERIC");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    field1.setForeignKeyFieldName("CMP3_XML_PROJECT.PROJ_ID");
    table.addField(field1);

    return table;
  }
  public static TableDefinition buildPARTNERLINKTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_MW");

    FieldDefinition fieldMID = new FieldDefinition();
    fieldMID.setName("M");
    fieldMID.setTypeName("NUMERIC");
    fieldMID.setSize(15);
    fieldMID.setSubSize(0);
    fieldMID.setIsPrimaryKey(false);
    fieldMID.setIsIdentity(false);
    fieldMID.setUnique(false);
    fieldMID.setShouldAllowNull(true);
    fieldMID.setForeignKeyFieldName("XML_MAN.ID");
    table.addField(fieldMID);

    FieldDefinition fieldWID = new FieldDefinition();
    fieldWID.setName("W");
    fieldWID.setTypeName("NUMERIC");
    fieldWID.setSize(15);
    fieldWID.setSubSize(0);
    fieldWID.setIsPrimaryKey(false);
    fieldWID.setIsIdentity(false);
    fieldWID.setUnique(false);
    fieldWID.setShouldAllowNull(true);
    fieldWID.setForeignKeyFieldName("XML_WOMAN.ID");
    table.addField(fieldWID);

    return table;
  }
  public static TableDefinition buildCMP3_PARTSLISTTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_MERGE_PARTSLIST");

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

    FieldDefinition field10 = new FieldDefinition();
    field10.setName("VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    return table;
  }
  public static TableDefinition buildCMP3_PARTSLIST_ITEMTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_XML_MERGE_PARTSLIST_ITEM");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("PARTSLIST_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_MERGE_ITEM.ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("ITEM_ID");
    field1.setTypeName("NUMERIC");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    field1.setForeignKeyFieldName("CMP3_XML_MERGE_PARTSLIST.ID");
    table.addField(field1);

    return table;
  }
  public TableDefinition buildVHCL_POLTable() {
    TableDefinition table = new TableDefinition();
    table.setName("VHCL_POL");

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

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

    ForeignKeyConstraint foreignKeyFK_VHCL_POL_POL_ID = new ForeignKeyConstraint();
    foreignKeyFK_VHCL_POL_POL_ID.setName("VHCL_POL_POLICY");
    foreignKeyFK_VHCL_POL_POL_ID.setTargetTable("POLICY");
    foreignKeyFK_VHCL_POL_POL_ID.addSourceField("POL_ID");
    foreignKeyFK_VHCL_POL_POL_ID.addTargetField("POL_ID");
    table.addForeignKeyConstraint(foreignKeyFK_VHCL_POL_POL_ID);

    return table;
  }
  public TableDefinition buildCHILDNAMTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CHILDNAM");

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

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

    ForeignKeyConstraint foreignKeyFK_CHILDNAM_HOLDER_ID = new ForeignKeyConstraint();
    foreignKeyFK_CHILDNAM_HOLDER_ID.setName("CHILD_HOLDER");
    foreignKeyFK_CHILDNAM_HOLDER_ID.setTargetTable("HOLDER");
    foreignKeyFK_CHILDNAM_HOLDER_ID.addSourceField("HOLDER_ID");
    foreignKeyFK_CHILDNAM_HOLDER_ID.addTargetField("SSN");
    table.addForeignKeyConstraint(foreignKeyFK_CHILDNAM_HOLDER_ID);

    return table;
  }
  public static TableDefinition buildCHASSISTable() {
    // CREATE TABLE JPA_OR_CHASSIS (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL, PRIMARY
    // KEY (ID))
    TableDefinition table = new TableDefinition();
    table.setName("JPA_OR_CHASSIS");

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

    FieldDefinition serialNumber = new FieldDefinition();
    serialNumber.setName("SERIALNUMBER");
    serialNumber.setTypeName("NUMERIC");
    serialNumber.setSize(18);
    serialNumber.setSubSize(0);
    serialNumber.setIsPrimaryKey(false);
    serialNumber.setIsIdentity(false);
    serialNumber.setShouldAllowNull(true);
    serialNumber.setUnique(false);
    table.addField(serialNumber);

    return table;
  }
  public TableDefinition buildINS_PHONETable() {
    TableDefinition table = new TableDefinition();
    table.setName("INS_PHONE");

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

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

    FieldDefinition fieldAREACODE = new FieldDefinition();
    fieldAREACODE.setName("AREACODE");
    fieldAREACODE.setTypeName("NUMBER");
    fieldAREACODE.setSize(3);
    fieldAREACODE.setSubSize(0);
    fieldAREACODE.setIsPrimaryKey(false);
    fieldAREACODE.setIsIdentity(false);
    fieldAREACODE.setUnique(false);
    fieldAREACODE.setShouldAllowNull(true);
    table.addField(fieldAREACODE);

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

    ForeignKeyConstraint foreignKeyFK_INS_PHONE_HOLDER_SSN = new ForeignKeyConstraint();
    foreignKeyFK_INS_PHONE_HOLDER_SSN.setName("INS_PHONE_HOLDER");
    foreignKeyFK_INS_PHONE_HOLDER_SSN.setTargetTable("HOLDER");
    foreignKeyFK_INS_PHONE_HOLDER_SSN.addSourceField("HOLDER_SSN");
    foreignKeyFK_INS_PHONE_HOLDER_SSN.addTargetField("SSN");
    table.addForeignKeyConstraint(foreignKeyFK_INS_PHONE_HOLDER_SSN);

    return table;
  }
  public static TableDefinition buildPHONENUMBERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_PHONENUMBER");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("OWNER_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("TYPE");
    field1.setTypeName("VARCHAR");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field2.setName("AREA_CODE");
    field2.setTypeName("VARCHAR");
    field2.setSize(3);
    field2.setShouldAllowNull(true);
    field2.setIsPrimaryKey(false);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    table.addField(field2);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field3.setName("NUMB");
    field3.setTypeName("VARCHAR");
    field3.setSize(8);
    field3.setShouldAllowNull(true);
    field3.setIsPrimaryKey(false);
    field3.setUnique(false);
    field3.setIsIdentity(false);
    table.addField(field3);

    return table;
  }
  public static TableDefinition buildCMP3_ITEMTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_MERGE_ITEM");

    FieldDefinition fieldDESCRIPTION = new FieldDefinition();
    fieldDESCRIPTION.setName("DESCRIPTION");
    fieldDESCRIPTION.setTypeName("VARCHAR2");
    fieldDESCRIPTION.setSize(80);
    fieldDESCRIPTION.setSubSize(0);
    fieldDESCRIPTION.setIsPrimaryKey(false);
    fieldDESCRIPTION.setIsIdentity(false);
    fieldDESCRIPTION.setUnique(false);
    fieldDESCRIPTION.setShouldAllowNull(true);
    table.addField(fieldDESCRIPTION);

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

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

    FieldDefinition field10 = new FieldDefinition();
    field10.setName("ITEM_VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    FieldDefinition fieldIMAGE = new FieldDefinition();
    fieldIMAGE.setName("IMAGE");
    fieldIMAGE.setTypeName("BLOB");
    fieldIMAGE.setShouldAllowNull(true);
    table.addField(fieldIMAGE);

    return table;
  }
  public static TableDefinition buildSPARKPLUGTable() {
    // CREATE TABLE JPA_OR_SPARK_PLUG (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL,
    // ENGINE_ID NUMBER(10) NULL, PRIMARY KEY (ID))
    TableDefinition table = new TableDefinition();
    table.setName("JPA_OR_SPARK_PLUG");

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

    FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
    fieldSERIALNUMBER.setName("SERIALNUMBER");
    fieldSERIALNUMBER.setTypeName("NUMERIC");
    fieldSERIALNUMBER.setSize(18);
    fieldSERIALNUMBER.setSubSize(0);
    fieldSERIALNUMBER.setIsPrimaryKey(false);
    fieldSERIALNUMBER.setIsIdentity(false);
    fieldSERIALNUMBER.setShouldAllowNull(true);
    fieldSERIALNUMBER.setUnique(false);
    table.addField(fieldSERIALNUMBER);

    FieldDefinition fieldENGINE = new FieldDefinition();
    fieldENGINE.setName("ENGINE_ID");
    fieldENGINE.setTypeName("NUMERIC");
    fieldENGINE.setSize(10);
    fieldENGINE.setSubSize(0);
    fieldENGINE.setIsPrimaryKey(false);
    fieldENGINE.setIsIdentity(false);
    fieldENGINE.setShouldAllowNull(true);
    fieldENGINE.setUnique(false);
    table.addField(fieldENGINE);

    // ALTER TABLE JPA_OR_SPARK_PLUG ADD CONSTRAINT JPA_OR_SPARK_PLUG_ENGINE_ID FOREIGN KEY
    // (ENGINE_ID) REFERENCES JPA_OR_ENGINE (ID)
    ForeignKeyConstraint foreignKeySPARKPLUG_ENGINE = new ForeignKeyConstraint();
    foreignKeySPARKPLUG_ENGINE.setName("FK_SPK_PG_ENG_ID");
    foreignKeySPARKPLUG_ENGINE.setTargetTable("JPA_OR_ENGINE");
    foreignKeySPARKPLUG_ENGINE.addSourceField("ENGINE_ID");
    foreignKeySPARKPLUG_ENGINE.addTargetField("ID");
    table.addForeignKeyConstraint(foreignKeySPARKPLUG_ENGINE);

    return table;
  }
  public TableDefinition buildPHONEVLIOTable() {
    TableDefinition table = new TableDefinition();
    table.setName("PHONEVLIO");

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

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

    FieldDefinition fieldAREA_CODE = new FieldDefinition();
    fieldAREA_CODE.setName("AREA_CODE");
    fieldAREA_CODE.setTypeName("VARCHAR2");
    fieldAREA_CODE.setSize(3);
    fieldAREA_CODE.setSubSize(0);
    fieldAREA_CODE.setIsPrimaryKey(false);
    fieldAREA_CODE.setIsIdentity(false);
    fieldAREA_CODE.setUnique(false);
    fieldAREA_CODE.setShouldAllowNull(true);
    table.addField(fieldAREA_CODE);

    FieldDefinition fieldP_NUMBER = new FieldDefinition();
    fieldP_NUMBER.setName("P_NUMBER");
    fieldP_NUMBER.setTypeName("VARCHAR2");
    fieldP_NUMBER.setSize(7);
    fieldP_NUMBER.setSubSize(0);
    fieldP_NUMBER.setIsPrimaryKey(false);
    fieldP_NUMBER.setIsIdentity(false);
    fieldP_NUMBER.setUnique(false);
    fieldP_NUMBER.setShouldAllowNull(true);
    table.addField(fieldP_NUMBER);

    return table;
  }
  public static TableDefinition buildCMP3_CUSTOMERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_MERGE_CUSTOMER");

    FieldDefinition fieldCITY = new FieldDefinition();
    fieldCITY.setName("CITY");
    fieldCITY.setTypeName("VARCHAR2");
    fieldCITY.setSize(80);
    fieldCITY.setSubSize(0);
    fieldCITY.setIsPrimaryKey(false);
    fieldCITY.setIsIdentity(false);
    fieldCITY.setUnique(false);
    fieldCITY.setShouldAllowNull(true);
    table.addField(fieldCITY);

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

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

    FieldDefinition field10 = new FieldDefinition();
    field10.setName("CUST_VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    return table;
  }