/******************************************************************************* | |
* 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; | |
} | |
} |