/*******************************************************************************
* Copyright (c) 1998, 2015 Oracle and/or its affiliates, IBM Corporation. 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
* 12/02/2010-2.2 Guy Pelletier
* - 324471: Do not default to VariableOneToOneMapping for interfaces unless a managed class implementing it is found
* 01/25/2011-2.3 Guy Pelletier
* - 333488: Serializable attribute being defaulted to a variable one to one mapping and causing exception
* 06/25/2014-2.5.2 Rick Curtis
* - 438177: Test M2M map
******************************************************************************/
package org.eclipse.persistence.testing.models.jpa.relationships;
import org.eclipse.persistence.testing.framework.TogglingFastTableCreator;
import org.eclipse.persistence.tools.schemaframework.FieldDefinition;
import org.eclipse.persistence.tools.schemaframework.ForeignKeyConstraint;
import org.eclipse.persistence.tools.schemaframework.TableCreator;
import org.eclipse.persistence.tools.schemaframework.TableDefinition;
public class RelationshipsTableManager extends TogglingFastTableCreator {
public static TableCreator tableCreator;
public RelationshipsTableManager() {
setName("Relationships");
addTableDefinition(buildCMP3_CUSTOMERTable());
addTableDefinition(buildCMP3_ITEMTable());
addTableDefinition(buildCMP3_ISOLATEDITEMTable());
addTableDefinition(buildCMP3_ORDERTable());
addTableDefinition(buildORDERCARDTable());
addTableDefinition(buildORDERLABELTable());
addTableDefinition(buildAUDITORTable());
addTableDefinition(buildORDER_AUDITORTable());
addTableDefinition(buildORDER_ORDERCARDTable());
addTableDefinition(buildORDER_ORDERLABELTable());
addTableDefinition(buildCMP3_SALESPERSONTable());
addTableDefinition(buildCUSTOMER_CUSTOMERTable());
addTableDefinition(buildCUSTOMER_CUSTOMER2Table());
addTableDefinition(buildCMP3_ENTITYATable());
addTableDefinition(buildCMP3_ENTITYBTable());
addTableDefinition(buildCMP3_ENTITYA_ENTITYBTable());
addTableDefinition(buildCMP3_ENTITYCTable());
addTableDefinition(buildCMP3_ENTITYDTable());
addTableDefinition(buildCMP3_UNIDIR_ENTITYC_ENTITYDTable());
addTableDefinition(buildMATTELTable());
addTableDefinition(buildLEGOTable());
addTableDefinition(buildMEGABRANDSTable());
addTableDefinition(buildNAMCOTable());
addTableDefinition(buildServiceCallTable());
addTableDefinition(buildCustomerServiceRepTable());
addTableDefinition(buildCustRepTable());
addTableDefinition(buildMtoMEntityATable());
addTableDefinition(buildMtoMEntityBTable());
addTableDefinition(buildMtoMEntityJoinTable());
addTableDefinition(buildMtoMEntityDefaultJoinTable());
}
public static TableCreator getCreator(){
if (RelationshipsTableManager.tableCreator == null){
RelationshipsTableManager.tableCreator = new RelationshipsTableManager();
}
return RelationshipsTableManager.tableCreator;
}
public static TableDefinition buildORDER_AUDITORTable() {
TableDefinition table = new TableDefinition();
table.setName("JPA_ORDER_AUDITOR");
FieldDefinition fieldORDERID = new FieldDefinition();
fieldORDERID.setName("ORDER_ID");
fieldORDERID.setTypeName("NUMERIC");
fieldORDERID.setSize(15);
fieldORDERID.setShouldAllowNull(false);
fieldORDERID.setIsPrimaryKey(false);
fieldORDERID.setUnique(false);
fieldORDERID.setIsIdentity(false);
fieldORDERID.setForeignKeyFieldName("CMP3_ORDER.ORDER_ID");
table.addField(fieldORDERID);
FieldDefinition fieldAUDITORID = new FieldDefinition();
fieldAUDITORID.setName("AUDITOR_ID");
fieldAUDITORID.setTypeName("NUMERIC");
fieldAUDITORID.setSize(15);
fieldAUDITORID.setShouldAllowNull(false);
fieldAUDITORID.setIsPrimaryKey(false);
fieldAUDITORID.setUnique(false);
fieldAUDITORID.setIsIdentity(false);
fieldAUDITORID.setForeignKeyFieldName("JPA_AUDITOR.ID");
table.addField(fieldAUDITORID);
return table;
}
public static TableDefinition buildORDER_ORDERCARDTable() {
TableDefinition table = new TableDefinition();
table.setName("JPA_ORDER_CARD_CMP3_ORDER");
FieldDefinition fieldORDERID = new FieldDefinition();
fieldORDERID.setName("order_ORDER_ID");
fieldORDERID.setTypeName("NUMERIC");
fieldORDERID.setSize(15);
fieldORDERID.setShouldAllowNull(false);
fieldORDERID.setIsPrimaryKey(false);
fieldORDERID.setUnique(false);
fieldORDERID.setIsIdentity(false);
fieldORDERID.setForeignKeyFieldName("CMP3_ORDER.ORDER_ID");
table.addField(fieldORDERID);
FieldDefinition fieldAUDITORID = new FieldDefinition();
fieldAUDITORID.setName("OrderCard_ID");
fieldAUDITORID.setTypeName("NUMERIC");
fieldAUDITORID.setSize(15);
fieldAUDITORID.setShouldAllowNull(false);
fieldAUDITORID.setIsPrimaryKey(false);
fieldAUDITORID.setUnique(false);
fieldAUDITORID.setIsIdentity(false);
fieldAUDITORID.setForeignKeyFieldName("JPA_ORDER_CARD.ID");
table.addField(fieldAUDITORID);
return table;
}
public static TableDefinition buildORDER_ORDERLABELTable() {
TableDefinition table = new TableDefinition();
table.setName("JPA_ORDER_ORDER_LABEL");
FieldDefinition fieldORDERID = new FieldDefinition();
fieldORDERID.setName("ORDER_ID");
fieldORDERID.setTypeName("NUMERIC");
fieldORDERID.setSize(15);
fieldORDERID.setShouldAllowNull(false);
fieldORDERID.setIsPrimaryKey(false);
fieldORDERID.setUnique(false);
fieldORDERID.setIsIdentity(false);
fieldORDERID.setForeignKeyFieldName("CMP3_ORDER.ORDER_ID");
table.addField(fieldORDERID);
FieldDefinition fieldAUDITORID = new FieldDefinition();
fieldAUDITORID.setName("ORDER_LABEL_ID");
fieldAUDITORID.setTypeName("NUMERIC");
fieldAUDITORID.setSize(15);
fieldAUDITORID.setShouldAllowNull(false);
fieldAUDITORID.setIsPrimaryKey(false);
fieldAUDITORID.setUnique(false);
fieldAUDITORID.setIsIdentity(false);
fieldAUDITORID.setForeignKeyFieldName("JPA_ORDER_LABEL.ID");
table.addField(fieldAUDITORID);
return table;
}
public static TableDefinition buildORDERCARDTable() {
TableDefinition table = new TableDefinition();
table.setName("JPA_ORDER_CARD");
FieldDefinition fieldORDERLABEL_ID = new FieldDefinition();
fieldORDERLABEL_ID.setName("ID");
fieldORDERLABEL_ID.setTypeName("NUMBER");
fieldORDERLABEL_ID.setSize(15);
fieldORDERLABEL_ID.setSubSize(0);
fieldORDERLABEL_ID.setIsPrimaryKey(true);
fieldORDERLABEL_ID.setIsIdentity(false);
fieldORDERLABEL_ID.setUnique(false);
fieldORDERLABEL_ID.setShouldAllowNull(false);
table.addField(fieldORDERLABEL_ID);
return table;
}
public static TableDefinition buildORDERLABELTable() {
TableDefinition table = new TableDefinition();
table.setName("JPA_ORDER_LABEL");
FieldDefinition fieldORDERLABEL_ID = new FieldDefinition();
fieldORDERLABEL_ID.setName("ID");
fieldORDERLABEL_ID.setTypeName("NUMBER");
fieldORDERLABEL_ID.setSize(15);
fieldORDERLABEL_ID.setSubSize(0);
fieldORDERLABEL_ID.setIsPrimaryKey(true);
fieldORDERLABEL_ID.setIsIdentity(false);
fieldORDERLABEL_ID.setUnique(false);
fieldORDERLABEL_ID.setShouldAllowNull(false);
table.addField(fieldORDERLABEL_ID);
FieldDefinition fieldDESCRIPTION = new FieldDefinition();
fieldDESCRIPTION.setName("DESCRIP");
fieldDESCRIPTION.setTypeName("VARCHAR2");
fieldDESCRIPTION.setSize(80);
fieldDESCRIPTION.setSubSize(0);
fieldDESCRIPTION.setIsPrimaryKey(false);
fieldDESCRIPTION.setIsIdentity(false);
fieldDESCRIPTION.setUnique(false);
fieldDESCRIPTION.setShouldAllowNull(true);
table.addField(fieldDESCRIPTION);
return table;
}
public static TableDefinition buildAUDITORTable() {
TableDefinition table = new TableDefinition();
table.setName("JPA_AUDITOR");
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 buildCMP3_CUSTOMERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_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("NUMBER");
field10.setSize(15);
field10.setShouldAllowNull(true );
field10.setIsPrimaryKey(false );
field10.setUnique(false );
field10.setIsIdentity(false );
table.addField(field10);
return table;
}
public static TableDefinition buildCMP3_ISOLATEDITEMTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_ISOLATED_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);
return table;
}
public static TableDefinition buildCMP3_ITEMTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_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 fieldDTYPE = new FieldDefinition();
fieldDTYPE.setName("DTYPE");
fieldDTYPE.setTypeName("VARCHAR2");
fieldDTYPE.setSize(80);
fieldDTYPE.setSubSize(0);
fieldDTYPE.setIsPrimaryKey(false);
fieldDTYPE.setIsIdentity(false);
fieldDTYPE.setUnique(false);
fieldDTYPE.setShouldAllowNull(true);
table.addField(fieldDTYPE);
FieldDefinition fieldMANUFACTURER_ID = new FieldDefinition();
fieldMANUFACTURER_ID.setName("MANUFACTURER_ID");
fieldMANUFACTURER_ID.setTypeName("NUMBER");
fieldMANUFACTURER_ID.setSize(15);
fieldMANUFACTURER_ID.setSubSize(0);
fieldMANUFACTURER_ID.setIsPrimaryKey(false);
fieldMANUFACTURER_ID.setIsIdentity(false);
fieldMANUFACTURER_ID.setUnique(false);
fieldMANUFACTURER_ID.setShouldAllowNull(true);
table.addField(fieldMANUFACTURER_ID);
FieldDefinition fieldDISTRIBUTOR_TYPE = new FieldDefinition();
fieldDISTRIBUTOR_TYPE.setName("DISTRIBUTOR_TYPE");
fieldDISTRIBUTOR_TYPE.setTypeName("VARCHAR2");
fieldDISTRIBUTOR_TYPE.setSize(2);
fieldDISTRIBUTOR_TYPE.setSubSize(0);
fieldDISTRIBUTOR_TYPE.setIsPrimaryKey(false);
fieldDISTRIBUTOR_TYPE.setIsIdentity(false);
fieldDISTRIBUTOR_TYPE.setUnique(false);
fieldDISTRIBUTOR_TYPE.setShouldAllowNull(true);
table.addField(fieldDISTRIBUTOR_TYPE);
FieldDefinition fieldDISTRIBUTOR_ID = new FieldDefinition();
fieldDISTRIBUTOR_ID.setName("DISTRIBUTOR_ID");
fieldDISTRIBUTOR_ID.setTypeName("NUMBER");
fieldDISTRIBUTOR_ID.setSize(15);
fieldDISTRIBUTOR_ID.setSubSize(0);
fieldDISTRIBUTOR_ID.setIsPrimaryKey(false);
fieldDISTRIBUTOR_ID.setIsIdentity(false);
fieldDISTRIBUTOR_ID.setUnique(false);
fieldDISTRIBUTOR_ID.setShouldAllowNull(true);
table.addField(fieldDISTRIBUTOR_ID);
FieldDefinition fieldFACADE = new FieldDefinition();
fieldFACADE.setName("FACADE");
fieldFACADE.setTypeName("BLOB");
table.addField(fieldFACADE);
FieldDefinition fieldTAG = new FieldDefinition();
fieldTAG.setName("TAG");
fieldTAG.setTypeName("BLOB");
table.addField(fieldTAG);
return table;
}
public static TableDefinition buildCMP3_ORDERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_ORDER");
FieldDefinition fieldCUST_ID = new FieldDefinition();
fieldCUST_ID.setName("CUSTOMER_CUST_ID");
fieldCUST_ID.setTypeName("NUMBER");
fieldCUST_ID.setSize(15);
fieldCUST_ID.setSubSize(0);
fieldCUST_ID.setIsPrimaryKey(false);
fieldCUST_ID.setIsIdentity(false);
fieldCUST_ID.setUnique(false);
fieldCUST_ID.setShouldAllowNull(true);
fieldCUST_ID.setForeignKeyFieldName("CMP3_CUSTOMER.CUST_ID");
table.addField(fieldCUST_ID);
FieldDefinition fieldBILLED_CUST_ID = new FieldDefinition();
fieldBILLED_CUST_ID.setName("BILLEDCUSTOMER_CUST_ID");
//fieldBILLED_CUST_ID.setName("BILLCUST_CUST_ID");
fieldBILLED_CUST_ID.setTypeName("NUMBER");
fieldBILLED_CUST_ID.setSize(15);
fieldBILLED_CUST_ID.setSubSize(0);
fieldBILLED_CUST_ID.setIsPrimaryKey(false);
fieldBILLED_CUST_ID.setIsIdentity(false);
fieldBILLED_CUST_ID.setUnique(false);
fieldBILLED_CUST_ID.setShouldAllowNull(true);
fieldBILLED_CUST_ID.setForeignKeyFieldName("CMP3_CUSTOMER.CUST_ID");
table.addField(fieldBILLED_CUST_ID);
FieldDefinition fieldSALESPERSON_ID = new FieldDefinition();
fieldSALESPERSON_ID.setName("SALESPERSON_ID");
fieldSALESPERSON_ID.setTypeName("NUMBER");
fieldSALESPERSON_ID.setSize(15);
fieldSALESPERSON_ID.setSubSize(0);
fieldSALESPERSON_ID.setIsPrimaryKey(false);
fieldSALESPERSON_ID.setIsIdentity(false);
fieldSALESPERSON_ID.setUnique(false);
fieldSALESPERSON_ID.setShouldAllowNull(true);
table.addField(fieldSALESPERSON_ID);
FieldDefinition fieldITEM_ID = new FieldDefinition();
fieldITEM_ID.setName("ITEM_ID");
fieldITEM_ID.setTypeName("NUMBER");
fieldITEM_ID.setSize(15);
fieldITEM_ID.setSubSize(0);
fieldITEM_ID.setIsPrimaryKey(false);
fieldITEM_ID.setIsIdentity(false);
fieldITEM_ID.setUnique(false);
fieldITEM_ID.setShouldAllowNull(true);
fieldITEM_ID.setForeignKeyFieldName("CMP3_ITEM.ID");
table.addField(fieldITEM_ID);
FieldDefinition fieldORDER_ID = new FieldDefinition();
fieldORDER_ID.setName("ORDER_ID");
fieldORDER_ID.setTypeName("NUMBER");
fieldORDER_ID.setSize(15);
fieldORDER_ID.setSubSize(0);
fieldORDER_ID.setIsPrimaryKey(true);
fieldORDER_ID.setIsIdentity(false);
fieldORDER_ID.setUnique(false);
fieldORDER_ID.setShouldAllowNull(false);
table.addField(fieldORDER_ID);
FieldDefinition fieldQUANTITY = new FieldDefinition();
fieldQUANTITY.setName("QUANTITY");
fieldQUANTITY.setTypeName("NUMBER");
fieldQUANTITY.setSize(15);
fieldQUANTITY.setSubSize(0);
fieldQUANTITY.setIsPrimaryKey(false);
fieldQUANTITY.setIsIdentity(false);
fieldQUANTITY.setUnique(false);
fieldQUANTITY.setShouldAllowNull(false);
table.addField(fieldQUANTITY);
FieldDefinition fieldSHIP_ADDR = new FieldDefinition();
fieldSHIP_ADDR.setName("SHIP_ADDR");
fieldSHIP_ADDR.setTypeName("VARCHAR2");
fieldSHIP_ADDR.setSize(80);
fieldSHIP_ADDR.setSubSize(0);
fieldSHIP_ADDR.setIsPrimaryKey(false);
fieldSHIP_ADDR.setIsIdentity(false);
fieldSHIP_ADDR.setUnique(false);
fieldSHIP_ADDR.setShouldAllowNull(true);
table.addField(fieldSHIP_ADDR);
FieldDefinition field10 = new FieldDefinition();
field10.setName("ORDER_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_SALESPERSONTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_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 buildCUSTOMER_CUSTOMERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_CUSTOMER_CUSTOMER");
// SECTION: FIELD
FieldDefinition field = new FieldDefinition();
field.setName("Customer_CUST_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
field.setForeignKeyFieldName("CMP3_CUSTOMER.CUST_ID");
table.addField(field);
// SECTION: FIELD
FieldDefinition field1 = new FieldDefinition();
field1.setName("CCustomers_CUST_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(true);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_CUSTOMER.CUST_ID");
table.addField(field1);
return table;
}
public static TableDefinition buildCUSTOMER_CUSTOMER2Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_CUSTOMER_CUSTOMER2");
// SECTION: FIELD
FieldDefinition field = new FieldDefinition();
field.setName("Customer_CUST_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
// SECTION: FIELD
FieldDefinition field1 = new FieldDefinition();
field1.setName("CCustomers2_CUST_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(true);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
table.addForeignKeyConstraint(new ForeignKeyConstraint("CMP3CUST2_CID", "Customer_CUST_ID", "CUST_ID", "CMP3_CUSTOMER"));
table.addForeignKeyConstraint(new ForeignKeyConstraint("CMP3CCUST2_CID", "CCustomers2_CUST_ID", "CUST_ID", "CMP3_CUSTOMER"));
return table;
}
public static TableDefinition buildCMP3_ENTITYATable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_ENTITYA");
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 buildCMP3_ENTITYBTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_ENTITYB");
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 buildCMP3_ENTITYA_ENTITYBTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_ENTITYA_ENTITYB");
// SECTION: FIELD
FieldDefinition field = new FieldDefinition();
field.setName("ENTITYA_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
field.setForeignKeyFieldName("CMP3_ENTITYA.ID");
table.addField(field);
// SECTION: FIELD
FieldDefinition field1 = new FieldDefinition();
field1.setName("ENTITYB_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(true);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_ENTITYB.ID");
table.addField(field1);
return table;
}
public static TableDefinition buildCMP3_ENTITYCTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_ENTITYC");
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 buildCMP3_ENTITYDTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_ENTITYD");
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 buildCMP3_UNIDIR_ENTITYC_ENTITYDTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_UNIDIR_ENTITYC_ENTITYD");
// SECTION: FIELD
FieldDefinition field = new FieldDefinition();
field.setName("ENTITYC_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
field.setForeignKeyFieldName("CMP3_ENTITYC.ID");
table.addField(field);
// SECTION: FIELD
FieldDefinition field1 = new FieldDefinition();
field1.setName("ENTITYD_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(true);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_ENTITYD.ID");
table.addField(field1);
return table;
}
public static TableDefinition buildLEGOTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_LEGO");
FieldDefinition fieldCUST_ID = new FieldDefinition();
fieldCUST_ID.setName("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);
return table;
}
public static TableDefinition buildMATTELTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MATTEL");
FieldDefinition fieldCUST_ID = new FieldDefinition();
fieldCUST_ID.setName("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);
return table;
}
public static TableDefinition buildMEGABRANDSTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MEGABRANDS");
FieldDefinition fieldCUST_ID = new FieldDefinition();
fieldCUST_ID.setName("DISTRIBUTORID");
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);
return table;
}
public static TableDefinition buildNAMCOTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_NAMCO");
FieldDefinition fieldCUST_ID = new FieldDefinition();
fieldCUST_ID.setName("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);
return table;
}
public static TableDefinition buildServiceCallTable(){
TableDefinition table = new TableDefinition();
table.setName("CMP3_SERVICE_CALL");
FieldDefinition fieldCUST_ID = new FieldDefinition();
fieldCUST_ID.setName("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("DESCRIPTION");
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 buildCustomerServiceRepTable(){
TableDefinition table = new TableDefinition();
table.setName("CMP3_CUSTOMER_SERVICE_REP");
FieldDefinition fieldCUST_ID = new FieldDefinition();
fieldCUST_ID.setName("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);
return table;
}
public static TableDefinition buildCustRepTable(){
TableDefinition table = new TableDefinition();
table.setName("CMP3_CUST_REP");
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 fieldREP_ID = new FieldDefinition();
fieldREP_ID.setName("REP_ID");
fieldREP_ID.setTypeName("NUMBER");
fieldREP_ID.setSize(15);
fieldREP_ID.setSubSize(0);
fieldREP_ID.setIsPrimaryKey(true);
fieldREP_ID.setIsIdentity(false);
fieldREP_ID.setUnique(false);
fieldREP_ID.setShouldAllowNull(false);
table.addField(fieldREP_ID);
FieldDefinition fieldCALL_ID = new FieldDefinition();
fieldCALL_ID.setName("CSInteractions_KEY");
fieldCALL_ID.setTypeName("NUMBER");
fieldCALL_ID.setSize(15);
fieldCALL_ID.setSubSize(0);
fieldCALL_ID.setIsPrimaryKey(true);
fieldCALL_ID.setIsIdentity(false);
fieldCALL_ID.setUnique(false);
fieldCALL_ID.setShouldAllowNull(false);
table.addField(fieldCALL_ID);
return table;
}
public static TableDefinition buildMtoMEntityATable(){
TableDefinition table = new TableDefinition();
table.setName("MTOMENTITYA");
FieldDefinition field_ID = new FieldDefinition();
field_ID.setName("ID");
field_ID.setTypeName("NUMBER");
field_ID.setSize(15);
field_ID.setSubSize(0);
field_ID.setIsPrimaryKey(true);
field_ID.setIsIdentity(false);
field_ID.setUnique(false);
field_ID.setShouldAllowNull(false);
table.addField(field_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);
return table;
}
public static TableDefinition buildMtoMEntityBTable(){
TableDefinition table = new TableDefinition();
table.setName("MTOMENTITYB");
FieldDefinition field_ID = new FieldDefinition();
field_ID.setName("ID");
field_ID.setTypeName("NUMBER");
field_ID.setSize(15);
field_ID.setSubSize(0);
field_ID.setIsPrimaryKey(true);
field_ID.setIsIdentity(false);
field_ID.setUnique(false);
field_ID.setShouldAllowNull(false);
table.addField(field_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);
return table;
}
public static TableDefinition buildMtoMEntityJoinTable(){
TableDefinition table = new TableDefinition();
table.setName("MM_MNMK_JT");
FieldDefinition fieldMtoMEntityA_ID = new FieldDefinition();
fieldMtoMEntityA_ID.setName("MtoMEntityA_ID");
fieldMtoMEntityA_ID.setTypeName("NUMBER");
fieldMtoMEntityA_ID.setSize(15);
fieldMtoMEntityA_ID.setSubSize(0);
fieldMtoMEntityA_ID.setIsPrimaryKey(true);
fieldMtoMEntityA_ID.setIsIdentity(false);
fieldMtoMEntityA_ID.setUnique(false);
fieldMtoMEntityA_ID.setShouldAllowNull(false);
table.addField(fieldMtoMEntityA_ID);
FieldDefinition fieldMtoMEntityB_ID = new FieldDefinition();
fieldMtoMEntityB_ID.setName("entityB_ID");
fieldMtoMEntityB_ID.setTypeName("NUMBER");
fieldMtoMEntityB_ID.setSize(15);
fieldMtoMEntityB_ID.setSubSize(0);
fieldMtoMEntityB_ID.setIsPrimaryKey(true);
fieldMtoMEntityB_ID.setIsIdentity(false);
fieldMtoMEntityB_ID.setUnique(false);
fieldMtoMEntityB_ID.setShouldAllowNull(false);
table.addField(fieldMtoMEntityB_ID);
FieldDefinition fieldMtoMEntityB_Key_ID = new FieldDefinition();
fieldMtoMEntityB_Key_ID.setName("EntityB_Key");
fieldMtoMEntityB_Key_ID.setTypeName("NUMBER");
fieldMtoMEntityB_Key_ID.setSize(15);
fieldMtoMEntityB_Key_ID.setSubSize(0);
fieldMtoMEntityB_Key_ID.setIsPrimaryKey(false);
fieldMtoMEntityB_Key_ID.setIsIdentity(false);
fieldMtoMEntityB_Key_ID.setUnique(false);
fieldMtoMEntityB_Key_ID.setShouldAllowNull(true);
table.addField(fieldMtoMEntityB_Key_ID);
return table;
}
public static TableDefinition buildMtoMEntityDefaultJoinTable(){
TableDefinition table = new TableDefinition();
table.setName("MTOMENTITYA_MTOMENTITYB");
FieldDefinition fieldMtoMEntityA_ID = new FieldDefinition();
fieldMtoMEntityA_ID.setName("MtoMEntityA_ID");
fieldMtoMEntityA_ID.setTypeName("NUMBER");
fieldMtoMEntityA_ID.setSize(15);
fieldMtoMEntityA_ID.setSubSize(0);
fieldMtoMEntityA_ID.setIsPrimaryKey(true);
fieldMtoMEntityA_ID.setIsIdentity(false);
fieldMtoMEntityA_ID.setUnique(false);
fieldMtoMEntityA_ID.setShouldAllowNull(false);
table.addField(fieldMtoMEntityA_ID);
FieldDefinition fieldMtoMEntityB_ID = new FieldDefinition();
fieldMtoMEntityB_ID.setName("entityBDefault_ID");
fieldMtoMEntityB_ID.setTypeName("NUMBER");
fieldMtoMEntityB_ID.setSize(15);
fieldMtoMEntityB_ID.setSubSize(0);
fieldMtoMEntityB_ID.setIsPrimaryKey(true);
fieldMtoMEntityB_ID.setIsIdentity(false);
fieldMtoMEntityB_ID.setUnique(false);
fieldMtoMEntityB_ID.setShouldAllowNull(false);
table.addField(fieldMtoMEntityB_ID);
FieldDefinition fieldMtoMEntityB_Key_ID = new FieldDefinition();
fieldMtoMEntityB_Key_ID.setName("entityBDefault_Key");
fieldMtoMEntityB_Key_ID.setTypeName("NUMBER");
fieldMtoMEntityB_Key_ID.setSize(15);
fieldMtoMEntityB_Key_ID.setSubSize(0);
fieldMtoMEntityB_Key_ID.setIsPrimaryKey(false);
fieldMtoMEntityB_Key_ID.setIsIdentity(false);
fieldMtoMEntityB_Key_ID.setUnique(false);
fieldMtoMEntityB_Key_ID.setShouldAllowNull(true);
table.addField(fieldMtoMEntityB_Key_ID);
return table;
}
}