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 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 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 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 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 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 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 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;
}
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 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 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 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 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 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 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 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 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 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 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 buildRewardTable() {
TableDefinition table = new TableDefinition();
table.setName("JPA_REWARD");
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);
table.addField(fieldID);
FieldDefinition fieldDescription = new FieldDefinition();
fieldDescription.setName("DESCRIP");
fieldDescription.setTypeName("VARCHAR2");
fieldDescription.setSize(60);
fieldDescription.setSubSize(0);
fieldDescription.setIsPrimaryKey(false);
fieldDescription.setIsIdentity(false);
fieldDescription.setUnique(false);
fieldDescription.setShouldAllowNull(true);
table.addField(fieldDescription);
FieldDefinition fieldTenantId = new FieldDefinition();
fieldTenantId.setName("T_ID");
fieldTenantId.setTypeName("VARCHAR2");
fieldTenantId.setSize(10);
fieldTenantId.setSubSize(0);
fieldTenantId.setIsPrimaryKey(false);
fieldTenantId.setIsIdentity(false);
fieldTenantId.setUnique(false);
fieldTenantId.setShouldAllowNull(false);
table.addField(fieldTenantId);
FieldDefinition fieldMafiosoId = new FieldDefinition();
fieldMafiosoId.setName("MAFIOSO_ID");
fieldMafiosoId.setTypeName("NUMERIC");
fieldMafiosoId.setSize(15);
fieldMafiosoId.setShouldAllowNull(false);
fieldMafiosoId.setIsPrimaryKey(true);
fieldMafiosoId.setUnique(false);
fieldMafiosoId.setIsIdentity(false);
fieldMafiosoId.setForeignKeyFieldName("JPA_MAFIOSO.ID");
table.addField(fieldMafiosoId);
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;
}