| /* |
| * Copyright (c) 1998, 2020 Oracle and/or its affiliates. All rights reserved. |
| * Copyright (c) 1998, 2018 IBM Corporation. All rights reserved. |
| * |
| * This program and the accompanying materials are made available under the |
| * terms of the Eclipse Public License v. 2.0 which is available at |
| * http://www.eclipse.org/legal/epl-2.0, |
| * or the Eclipse Distribution License v. 1.0 which is available at |
| * http://www.eclipse.org/org/documents/edl-v10.php. |
| * |
| * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause |
| */ |
| |
| // 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; |
| } |
| } |
| |
