/*******************************************************************************
* Copyright (c) 1998, 2015 Oracle and/or its affiliates. All rights reserved.
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* Contributors:
* 04/30/2009-2.0 Michael O'Brien
* - 266912: JPA 2.0 Metamodel API (part of Criteria API)
******************************************************************************/
package org.eclipse.persistence.testing.tests.jpa.metamodel;
import org.eclipse.persistence.tools.schemaframework.FieldDefinition;
import org.eclipse.persistence.tools.schemaframework.TableCreator;
import org.eclipse.persistence.tools.schemaframework.TableDefinition;
public class MetamodelTableCreator extends TableCreator {
/**
*
* DDL schema cleanup order
DROP TABLE CMP3_MM_HIST_EMPLOY
DROP TABLE CMP3_MM_MANUF_MM_HWDES_MAP
DROP TABLE CMP3_MM_MANUF_MM_HWDES_MAPUC8
DROP TABLE CMP3_MM_MANUF_MM_HWDES_MAPUC7
DROP TABLE CMP3_MM_MANUF_MM_HWDES_MAPUC4
DROP TABLE CMP3_MM_MANUF_MM_HWDES_MAPUC2
DROP TABLE CMP3_MM_MANUF_MM_HWDES_MAPUC1A
DROP TABLE CMP3_MM_MANUF_MM_CORPCOMPUTER
DROP TABLE CMP3_MM_MANUF_MM_COMPUTER
DROP TABLE CMP3_MM_MANUF_MM_HWDESIGNER
DROP TABLE CMP3_MM_BOARD_MM_MEMORY
DROP TABLE CMP3_MM_BOARD_MM_PROC
DROP TABLE CMP3_MM_COMPUTER_MM_USER
DROP TABLE CMP3_MM_COMPUTER_MM_BOARD
DROP TABLE CMP3_MM_BOARD_SEQ
DROP TABLE CMP3_MM_PERSON_SEQ
DROP TABLE CMP3_MM_PROC_SEQ
DROP TABLE CMP3_MM_USER
DROP TABLE CMP3_MM_HWDESIGNER
DROP TABLE CMP3_MM_MEMORY
DROP TABLE CMP3_MM_PROC
DROP TABLE CMP3_MM_ARRAYPROC
DROP TABLE CMP3_MM_LOCATION
DROP TABLE CMP3_MM_GALACTIC
DROP TABLE CMP3_MM_BOARD
DROP TABLE CMP3_MM_SWDESIGNER
DROP TABLE CMP3_MM_MANUF
DROP TABLE CMP3_MM_ENCLOSURE
DROP TABLE CMP3_MM_COMPUTER
*/
public MetamodelTableCreator() {
setName("MetamodelProject");
addTableDefinition(buildENCLOSURETable());
addTableDefinition(buildMANUFACTURERTable());
addTableDefinition(buildHARDWAREDESIGNERTable());
addTableDefinition(buildSOFTWAREDESIGNERTable());
addTableDefinition(buildUSERTable());
addTableDefinition(buildCOMPUTERTable());
addTableDefinition(buildBOARDTable());
addTableDefinition(buildMEMORYTable());
addTableDefinition(buildPROCESSORTable());
//addTableDefinition(buildVECTORPROCESSORTable());
//addTableDefinition(buildARRAYPROCESSORTable());
//addTableDefinition(buildLOCATIONTable());
addTableDefinition(buildGALACTICPOSITIONTable());
// Test ms-ms-entity chain with idclass above id
addTableDefinition(buildMS_MS_Entity_Leaf_Table());
// 1:n
addTableDefinition(buildMANUFACTURER_COMPUTER_JOINTable());
addTableDefinition(buildMANUFACTURER_CORPCOMPUTER_JOINTable());
addTableDefinition(buildMANUFACTURER_HARDWAREDESIGNER_JOINTable());
addTableDefinition(buildMANUFACTURER_HARDWAREDESIGNER_MAPUC1A_JOINTable());
addTableDefinition(buildMANUFACTURER_HARDWAREDESIGNER_MAPUC2_JOINTable());
addTableDefinition(buildMANUFACTURER_HARDWAREDESIGNER_MAPUC4_JOINTable());
addTableDefinition(buildMANUFACTURER_HARDWAREDESIGNER_MAPUC7_JOINTable());
addTableDefinition(buildMANUFACTURER_HARDWAREDESIGNER_MAPUC8_JOINTable());
//addTableDefinition(buildMANUFACTURER_ENCLOSURE_MAPUC9_JOINTable());
addTableDefinition(buildMANUFACTURER_HARDWAREDESIGNER_HISTORICAL_JOINTable());
addTableDefinition(buildBOARD_MEMORY_JOINTable());
addTableDefinition(buildBOARD_PROCESSOR_JOINTable());
addTableDefinition(buildCOMPUTER_BOARD_JOINTable());
// n:n
//addTableDefinition(buildCOMPUTER_USER_JOINTable());
addTableDefinition(buildCMP3_MM_BOARD_SEQTable());
addTableDefinition(buildCMP3_MM_PERSON_SEQTable());
addTableDefinition(buildCMP3_MM_MANUF_CMP3_MM_MANUFTable());
}
public static TableDefinition buildMANUFACTURERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF");
FieldDefinition field = new FieldDefinition();
field.setName("PERSON_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("MANUF_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
/* // 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("EMPLOYER_PERSON_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field6);
*/
// Primitive and Basic type testing
//ADOUBLEOBJECT, ABIGINTEGEROBJECT, AFLOATOBJECT, MANUF_VERSION, ALONGOBJECT, ASHORT, ABYTEOBJECT, NAME, ABOOLEANOBJECT, ACHAR, ACHARACTEROBJECT, ANINT, AFLOAT, ALONG, ADOUBLE, ASHORTOBJECT, ANINTEGEROBJECT
//private Boolean aBooleanObject;
FieldDefinition field71 = new FieldDefinition();
field71.setName("ABOOLEANOBJECT");
field71.setTypeName("NUMERIC");
field71.setSize(2);
field71.setShouldAllowNull(true);
field71.setIsPrimaryKey(false);
field71.setUnique(false);
field71.setIsIdentity(false);
table.addField(field71);
//private Byte aByteObject;
FieldDefinition field72 = new FieldDefinition();
field72.setName("ABYTEOBJECT");
field72.setTypeName("NUMERIC");
field72.setSize(2);
field72.setShouldAllowNull(true);
field72.setIsPrimaryKey(false);
field72.setUnique(false);
field72.setIsIdentity(false);
table.addField(field72);
//private Short aShortObject;
FieldDefinition field73 = new FieldDefinition();
field73.setName("ASHORTOBJECT");
field73.setTypeName("NUMERIC");
field73.setSize(15);
field73.setShouldAllowNull(true);
field73.setIsPrimaryKey(false);
field73.setUnique(false);
field73.setIsIdentity(false);
table.addField(field73);
//private Integer anIntegerObject;
FieldDefinition field74 = new FieldDefinition();
field74.setName("ANINTEGEROBJECT");
field74.setTypeName("NUMERIC");
field74.setSize(15);
field74.setShouldAllowNull(true);
field74.setIsPrimaryKey(false);
field74.setUnique(false);
field74.setIsIdentity(false);
table.addField(field74);
//private Long aLongObject;
FieldDefinition field75 = new FieldDefinition();
field75.setName("ALONGOBJECT");
field75.setTypeName("NUMERIC");
field75.setSize(18);
field75.setShouldAllowNull(true);
field75.setIsPrimaryKey(false);
field75.setUnique(false);
field75.setIsIdentity(false);
table.addField(field75);
//private BigInteger aBigIntegerObject;
FieldDefinition field76 = new FieldDefinition();
field76.setName("ABIGINTEGEROBJECT");
field76.setTypeName("NUMERIC");
field76.setSize(18);
field76.setShouldAllowNull(true);
field76.setIsPrimaryKey(false);
field76.setUnique(false);
field76.setIsIdentity(false);
table.addField(field76);
//private Float aFloatObject;
FieldDefinition field77 = new FieldDefinition();
field77.setName("AFLOATOBJECT");
field77.setTypeName("NUMERIC");
field77.setSize(18);
field77.setShouldAllowNull(true);
field77.setIsPrimaryKey(false);
field77.setUnique(false);
field77.setIsIdentity(false);
table.addField(field77);
//private Double aDoubleObject;
FieldDefinition field78 = new FieldDefinition();
field78.setName("ADOUBLEOBJECT");
field78.setTypeName("NUMERIC");
field78.setSize(18);
field78.setShouldAllowNull(true);
field78.setIsPrimaryKey(false);
field78.setUnique(false);
field78.setIsIdentity(false);
table.addField(field78);
//private Character aCharacterObject;
FieldDefinition field79 = new FieldDefinition();
field79.setName("ACHARACTEROBJECT");
field79.setTypeName("VARCHAR");
field79.setSize(80);
field79.setShouldAllowNull(true);
field79.setIsPrimaryKey(false);
field79.setUnique(false);
field79.setIsIdentity(false);
table.addField(field79);
//private boolean aBoolean;
FieldDefinition field80 = new FieldDefinition();
field80.setName("ABOOLEAN");
field80.setTypeName("NUMERIC");
field80.setSize(2);
field80.setShouldAllowNull(true);
field80.setIsPrimaryKey(false);
field80.setUnique(false);
field80.setIsIdentity(false);
table.addField(field80);
//private byte aByte;
FieldDefinition field81 = new FieldDefinition();
field81.setName("ABYTE");
field81.setTypeName("NUMERIC");
field81.setSize(15);
field81.setShouldAllowNull(true);
field81.setIsPrimaryKey(false);
field81.setUnique(false);
field81.setIsIdentity(false);
table.addField(field81);
//private short aShort;
FieldDefinition field82 = new FieldDefinition();
field82.setName("ASHORT");
field82.setTypeName("NUMERIC");
field82.setSize(15);
field82.setShouldAllowNull(true);
field82.setIsPrimaryKey(false);
field82.setUnique(false);
field82.setIsIdentity(false);
table.addField(field82);
//private int anInt;
FieldDefinition field83 = new FieldDefinition();
field83.setName("ANINT");
field83.setTypeName("NUMERIC");
field83.setSize(15);
field83.setShouldAllowNull(true);
field83.setIsPrimaryKey(false);
field83.setUnique(false);
field83.setIsIdentity(false);
table.addField(field83);
//private long aLong;
FieldDefinition field84 = new FieldDefinition();
field84.setName("ALONG");
field84.setTypeName("NUMERIC");
field84.setSize(18);
field84.setShouldAllowNull(true);
field84.setIsPrimaryKey(false);
field84.setUnique(false);
field84.setIsIdentity(false);
table.addField(field84);
//private float aFloat;
FieldDefinition field85 = new FieldDefinition();
field85.setName("AFLOAT");
field85.setTypeName("NUMERIC");
field85.setSize(18);
field85.setShouldAllowNull(true);
field85.setIsPrimaryKey(false);
field85.setUnique(false);
field85.setIsIdentity(false);
table.addField(field85);
//private double aDouble;
FieldDefinition field86 = new FieldDefinition();
field86.setName("ADOUBLE");
field86.setTypeName("NUMERIC");
field86.setSize(18);
field86.setShouldAllowNull(true);
field86.setIsPrimaryKey(false);
field86.setUnique(false);
field86.setIsIdentity(false);
table.addField(field86);
//private char aChar;
FieldDefinition field87 = new FieldDefinition();
field87.setName("ACHAR");
field87.setTypeName("VARCHAR");
field87.setSize(2);
field87.setShouldAllowNull(true);
field87.setIsPrimaryKey(false);
field87.setUnique(false);
field87.setIsIdentity(false);
table.addField(field87);
//public enum anEnum { one, two, three};
/* FieldDefinition field88 = new FieldDefinition();
field88.setName("ANENUM");
field88.setTypeName("NUMERIC");
field88.setSize(15);
field88.setShouldAllowNull(true);
field88.setIsPrimaryKey(false);
field88.setUnique(false);
field88.setIsIdentity(false);
table.addField(field88);
*/
//private BigInteger aBigIntegerObject;
FieldDefinition field90 = new FieldDefinition();
field90.setName("ABIGDECIMALOBJECT");
field90.setTypeName("NUMERIC");
field90.setSize(31);
field90.setShouldAllowNull(true);
field90.setIsPrimaryKey(false);
field90.setUnique(false);
field90.setIsIdentity(false);
table.addField(field90);
return table;
}
public static TableDefinition buildHARDWAREDESIGNERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_HWDESIGNER");
/*FieldDefinition field_id2 = new FieldDefinition();
field_id2.setName("DESIGNER_ID");
field_id2.setTypeName("NUMERIC");
field_id2.setSize(15);
field_id2.setShouldAllowNull(false);
field_id2.setIsPrimaryKey(true);
field_id2.setUnique(false);
field_id2.setIsIdentity(true);
table.addField(field_id2);*/
FieldDefinition field = new FieldDefinition();
field.setName("PERSON_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("HWDESIGNER_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
// from MappedSuperclass
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("EMPLOYER_PERSON_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field6);
// from MappedSuperclass
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field9 = new FieldDefinition();
field9.setName("MAPPEDEMPLOYER_PERSON_ID");
field9.setTypeName("NUMERIC");
field9.setSize(15);
field9.setShouldAllowNull(false);
field9.setIsPrimaryKey(false);
field9.setUnique(false);
field9.setIsIdentity(false);
field9.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field9);
// from MappedSuperclass
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field19 = new FieldDefinition();
field19.setName("MAPPEDEMPLOYERUC1A_PERSON_ID");
field19.setTypeName("NUMERIC");
field19.setSize(15);
field19.setShouldAllowNull(false);
field19.setIsPrimaryKey(false);
field19.setUnique(false);
field19.setIsIdentity(false);
field19.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field19);
// from MappedSuperclass
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field29 = new FieldDefinition();
field29.setName("MAPPEDEMPLOYERUC2_PERSON_ID");
field29.setTypeName("NUMERIC");
field29.setSize(15);
field29.setShouldAllowNull(false);
field29.setIsPrimaryKey(false);
field29.setUnique(false);
field29.setIsIdentity(false);
field29.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field29);
// from MappedSuperclass
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field39 = new FieldDefinition();
field39.setName("MAPPEDEMPLOYERUC4_PERSON_ID");
field39.setTypeName("NUMERIC");
field39.setSize(15);
field39.setShouldAllowNull(false);
field39.setIsPrimaryKey(false);
field39.setUnique(false);
field39.setIsIdentity(false);
field39.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field39);
// from MappedSuperclass
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field49 = new FieldDefinition();
field49.setName("MAPPEDEMPLOYERUC7_PERSON_ID");
field49.setTypeName("NUMERIC");
field49.setSize(15);
field49.setShouldAllowNull(false);
field49.setIsPrimaryKey(false);
field49.setUnique(false);
field49.setIsIdentity(false);
field49.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field49);
// from MappedSuperclass
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field59 = new FieldDefinition();
field59.setName("MAPPEDEMPLOYERUC8_PERSON_ID");
field59.setTypeName("NUMERIC");
field59.setSize(15);
field59.setShouldAllowNull(false);
field59.setIsPrimaryKey(false);
field59.setUnique(false);
field59.setIsIdentity(false);
field59.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field59);
// from MappedSuperclass
// 1:1 unidirectional
FieldDefinition field7 = new FieldDefinition();
field7.setName("PRIME_EMPLOYER_PERSON_ID");
field7.setTypeName("NUMERIC");
field7.setSize(15);
field7.setShouldAllowNull(false);
field7.setIsPrimaryKey(false);
field7.setUnique(false);
field7.setIsIdentity(false);
field7.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field7);
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field8 = new FieldDefinition();
field8.setName("SEC_EMPLOYER_PERSON_ID");
field8.setTypeName("NUMERIC");
field8.setSize(15);
field8.setShouldAllowNull(false);
field8.setIsPrimaryKey(false);
field8.setUnique(false);
field8.setIsIdentity(false);
field8.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field8);
return table;
}
public static TableDefinition buildSOFTWAREDESIGNERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_SWDESIGNER");
/*FieldDefinition field_id2 = new FieldDefinition();
field_id2.setName("DESIGNER_ID");
field_id2.setTypeName("NUMERIC");
field_id2.setSize(15);
field_id2.setShouldAllowNull(false);
field_id2.setIsPrimaryKey(true);
field_id2.setUnique(false);
field_id2.setIsIdentity(true);
table.addField(field_id2);*/
FieldDefinition field = new FieldDefinition();
field.setName("PERSON_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("SWDESIGNER_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
// from MappedSuperclass
/* // 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("EMPLOYER_PERSON_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field6);
*/
// from MappedSuperclass
// 1:1 unidirectional
FieldDefinition field7 = new FieldDefinition();
field7.setName("PRIME_EMPLOYER_PERSON_ID");
field7.setTypeName("NUMERIC");
field7.setSize(15);
field7.setShouldAllowNull(false);
field7.setIsPrimaryKey(false);
field7.setUnique(false);
field7.setIsIdentity(false);
field7.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field7);
// m:1 does not require a JoinTable - only a JoinColumn
FieldDefinition field8 = new FieldDefinition();
field8.setName("SEC_EMPLOYER_PERSON_ID");
field8.setTypeName("NUMERIC");
field8.setSize(15);
field8.setShouldAllowNull(false);
field8.setIsPrimaryKey(false);
field8.setUnique(false);
field8.setIsIdentity(false);
field8.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field8);
// 1:m with JoinTable - by default
/* FieldDefinition field9 = new FieldDefinition();
field9.setName("HIST_EMPLOYER_PERSON_ID");
field9.setTypeName("NUMERIC");
field9.setSize(15);
field9.setShouldAllowNull(false);
field9.setIsPrimaryKey(false);
field9.setUnique(false);
field9.setIsIdentity(false);
field9.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field9);*/
return table;
}
public static TableDefinition buildUSERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_USER");
FieldDefinition field = new FieldDefinition();
field.setName("PERSON_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("USER_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
return table;
}
public static TableDefinition buildCOMPUTERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_COMPUTER");
FieldDefinition field = new FieldDefinition();
field.setName("COMPUTER_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("COMPUTER_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
// Bidirectional OneToOne with Location.computer
FieldDefinition field5 = new FieldDefinition();
field5.setName("GALACTIC_GALACTIC_ID");
field5.setTypeName("NUMERIC");
field5.setSize(15);
field5.setShouldAllowNull(true);
field5.setIsPrimaryKey(false);
field5.setUnique(false);
field5.setIsIdentity(false);
field5.setForeignKeyFieldName("CMP3_MM_GALACTIC.GALACTIC_ID");
//field5.setForeignKeyFieldName("CMP3_MM_LOCATION.PK_PART1");
table.addField(field5);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("MANUFACTURER_PERSON_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(true);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field6);
return table;
}
public static TableDefinition buildBOARDTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_BOARD");
FieldDefinition field = new FieldDefinition();
field.setName("BOARD_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("BOARD_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
/* // m:1 requires a JoinTable
FieldDefinition field6 = new FieldDefinition();
field6.setName("COMPUTER_COMPUTER_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field6);
*/
return table;
}
public static TableDefinition buildENCLOSURETable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_ENCLOSURE");
FieldDefinition field13 = new FieldDefinition();
field13.setName("TYPE");
field13.setTypeName("VARCHAR");
field13.setSize(80);
field13.setShouldAllowNull(false);
field13.setIsPrimaryKey(true);
field13.setUnique(false);
field13.setIsIdentity(true);
table.addField(field13);
FieldDefinition field14 = new FieldDefinition();
field14.setName("LENGTH");
field14.setTypeName("VARCHAR");
field14.setSize(80);
field14.setShouldAllowNull(false);
field14.setIsPrimaryKey(true);
field14.setUnique(false);
field14.setIsIdentity(true);
table.addField(field14);
FieldDefinition field15 = new FieldDefinition();
field15.setName("WIDTH");
field15.setTypeName("VARCHAR");
field15.setSize(80);
field15.setShouldAllowNull(false);
field15.setIsPrimaryKey(true);
field15.setUnique(false);
field15.setIsIdentity(true);
table.addField(field15);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("COMPUTERUC10_COMPUTER_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(true);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field6);
FieldDefinition field = new FieldDefinition();
field.setName("PERSON_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
return table;
}
/**
* This table defines a MappedSuperclass chain that defines a composite PK
* that is distributed along the MappedSuperclass hierarchy of the form.
* Root (MappedSuperclass)
* --> Center (MappedSuperclass)
* --> Leaf (Entity)
*/
public static TableDefinition buildMS_MS_Entity_Leaf_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MSMSENTITY_LEAF");
// From (MS)-MS-Entity root
FieldDefinition field13 = new FieldDefinition();
field13.setName("TYPE");
field13.setTypeName("VARCHAR");
field13.setSize(80);
field13.setShouldAllowNull(false);
field13.setIsPrimaryKey(true);
field13.setUnique(false);
field13.setIsIdentity(true);
table.addField(field13);
FieldDefinition field14 = new FieldDefinition();
field14.setName("LENGTH");
field14.setTypeName("VARCHAR");
field14.setSize(80);
field14.setShouldAllowNull(false);
field14.setIsPrimaryKey(true);
field14.setUnique(false);
field14.setIsIdentity(true);
table.addField(field14);
FieldDefinition field15 = new FieldDefinition();
field15.setName("WIDTH");
field15.setTypeName("VARCHAR");
field15.setSize(80);
field15.setShouldAllowNull(false);
field15.setIsPrimaryKey(true);
field15.setUnique(false);
field15.setIsIdentity(true);
table.addField(field15);
// From MS-(MS)-Entity center
FieldDefinition field = new FieldDefinition();
//field.setName("MSMSENTITY_ID");
field.setName("IDENTITY");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
//field.setIsPrimaryKey(false);//true);
field.setIsPrimaryKey(true);
field.setUnique(false);
//field.setIsIdentity(false);//true);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DECLAREDCENTERSTRINGFIELD");
field2.setTypeName("VARCHAR");
field2.setSize(80);
field2.setShouldAllowNull(true);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
table.addField(field2);
FieldDefinition field3 = new FieldDefinition();
field3.setName("DECLAREDLEAFSTRINGFIELD");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
FieldDefinition field4 = new FieldDefinition();
field4.setName("MSMSENTITY_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
return table;
}
public static TableDefinition buildMEMORYTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MEMORY");
FieldDefinition field = new FieldDefinition();
field.setName("MEMORY_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("MEMORY_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("BOARD_BOARD_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_BOARD.BOARD_ID");
table.addField(field6);
return table;
}
// Entity --> Entity inheritance
public static TableDefinition buildPROCESSORTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_PROC");
FieldDefinition field = new FieldDefinition();
field.setName("PROC_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field4 = new FieldDefinition();
field4.setName("PROC_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition field5 = new FieldDefinition();
field5.setName("SPEED");
field5.setTypeName("VARCHAR");
field5.setSize(80);
field5.setShouldAllowNull(true);
field5.setIsPrimaryKey(false);
field5.setUnique(false);
field5.setIsIdentity(false);
table.addField(field5);
// OVERRIDE @Inheritance from SINGLE_TABLE to JOINED
// http://wiki.eclipse.org/Introduction_to_EclipseLink_JPA_%28ELUG%29#.40Inheritance
// discriminator column (for inheritance)
FieldDefinition field3 = new FieldDefinition();
field3.setName("DTYPE");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("BOARD_BOARD_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_BOARD.BOARD_ID");
table.addField(field6);
return table;
}
public static TableDefinition buildVECTORPROCESSORTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_PROC");
// JOINED @Inheritance still requires a PK field on the sub entity table
FieldDefinition field = new FieldDefinition();
field.setName("PROC_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
/* FieldDefinition field3 = new FieldDefinition();
field3.setName("SPEED");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
*/
/* FieldDefinition field4 = new FieldDefinition();
field4.setName("VECTPROC_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
*/
// 1:m does not require a JoinTable - only a JoinColumn
/* FieldDefinition field6 = new FieldDefinition();
field6.setName("BOARD_BOARD_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_BOARD.BOARD_ID");
table.addField(field6);
*/
return table;
}
public static TableDefinition buildARRAYPROCESSORTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_PROC");
// JOINED @Inheritance still requires a PK field on the sub entity table
FieldDefinition field = new FieldDefinition();
field.setName("PROC_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
/* FieldDefinition field4 = new FieldDefinition();
field4.setName("ARRAYPROC_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
*/
// 1:m does not require a JoinTable - only a JoinColumn
/* FieldDefinition field6 = new FieldDefinition();
field6.setName("BOARD_BOARD_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_BOARD.BOARD_ID");
table.addField(field6);
*/
return table;
}
public static TableDefinition buildGALACTICPOSITIONTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_GALACTIC");
// Using EmbeddedId
FieldDefinition field = new FieldDefinition();
field.setName("GALACTIC_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
// Using single Id
/* FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("GALACTIC_ID");
fieldID.setTypeName("NUMBER");
fieldID.setSize(18);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);//true);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
*/
/*FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("PK_PART1");
fieldID.setTypeName("NUMBER");
fieldID.setSize(19);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);//true);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);*/
/*FieldDefinition fieldID2 = new FieldDefinition();
fieldID2.setName("PK_PART2");
fieldID2.setTypeName("NUMBER");
fieldID2.setSize(18);
fieldID2.setSubSize(0);
fieldID2.setIsPrimaryKey(true);
fieldID2.setIsIdentity(true);
fieldID2.setUnique(false);//true);
fieldID2.setShouldAllowNull(false);
table.addField(fieldID2);*/
FieldDefinition field4 = new FieldDefinition();
field4.setName("GALACTIC_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
/* FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
*/
// for MappedSuperclass
/* // 1:1 unidirectional
FieldDefinition field7 = new FieldDefinition();
field7.setName("FUTURE_POS_GALACTIC_ID");
field7.setTypeName("NUMERIC");
field7.setSize(15);
field7.setShouldAllowNull(false);
field7.setIsPrimaryKey(false);
field7.setUnique(false);
field7.setIsIdentity(false);
field7.setForeignKeyFieldName("CMP3_MM_GALACTIC.GALACTIC_ID");
table.addField(field7);
*/
// OVERRIDE @Inheritance from SINGLE_TABLE to JOINED
// http://wiki.eclipse.org/Introduction_to_EclipseLink_JPA_%28ELUG%29#.40Inheritance
// discriminator column (for inheritance)
FieldDefinition field13 = new FieldDefinition();
field13.setName("DTYPE");
field13.setTypeName("VARCHAR");
field13.setSize(80);
field13.setShouldAllowNull(true);
field13.setIsPrimaryKey(false);
field13.setUnique(false);
field13.setIsIdentity(false);
table.addField(field13);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field6 = new FieldDefinition();
field6.setName("COMPUTERUC12_COMPUTER_ID");
field6.setTypeName("NUMERIC");
field6.setSize(15);
field6.setShouldAllowNull(false);
field6.setIsPrimaryKey(false);
field6.setUnique(false);
field6.setIsIdentity(false);
field6.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field6);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition field7 = new FieldDefinition();
field7.setName("COMPUTERUNIUC13_COMPUTER_ID");
field7.setTypeName("NUMERIC");
field7.setSize(15);
field7.setShouldAllowNull(false);
field7.setIsPrimaryKey(false);
field7.setUnique(false);
field7.setIsIdentity(false);
field7.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field7);
FieldDefinition field8 = new FieldDefinition();
field8.setName("ELEVATION");
field8.setTypeName("NUMERIC");
field8.setSize(15);
field8.setShouldAllowNull(true);
field8.setIsPrimaryKey(false);
field8.setUnique(false);
field8.setIsIdentity(false);
table.addField(field8);
FieldDefinition field9 = new FieldDefinition();
field9.setName("LATTITUDE");
field9.setTypeName("NUMERIC");
field9.setSize(15);
field9.setShouldAllowNull(true);
field9.setIsPrimaryKey(false);
field9.setUnique(false);
field9.setIsIdentity(false);
table.addField(field9);
FieldDefinition field10 = new FieldDefinition();
field10.setName("LONGITUDE");
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 buildLOCATIONTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_LOCATION");
/*
* Commented 20090720 in favor of a the composite key EmbeddedPK
*/
/* FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("LOCATION_ID");
fieldID.setTypeName("NUMBER");
fieldID.setSize(18);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);//true);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
*/
/*FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("PK_PART1");
fieldID.setTypeName("NUMBER");
fieldID.setSize(18);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);//true);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);*/
/*FieldDefinition fieldID2 = new FieldDefinition();
fieldID2.setName("PK_PART2");
fieldID2.setTypeName("NUMBER");
fieldID2.setSize(18);
fieldID2.setSubSize(0);
fieldID2.setIsPrimaryKey(true);
fieldID2.setIsIdentity(true);
fieldID2.setUnique(false);//true);
fieldID2.setShouldAllowNull(false);
table.addField(fieldID2);*/
/* FieldDefinition field4 = new FieldDefinition();
field4.setName("LOCATION_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
*/
/* FieldDefinition field3 = new FieldDefinition();
field3.setName("NAME");
field3.setTypeName("VARCHAR");
field3.setSize(80);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
*/
// Bidirectional OneToOne with Computer.location - unidirectional for now
/* FieldDefinition field5 = new FieldDefinition();
field5.setName("COMPUTER_COMPUTER_ID");
field5.setTypeName("NUMERIC");
field5.setSize(15);
field5.setShouldAllowNull(false);
field5.setIsPrimaryKey(false);
field5.setUnique(false);
field5.setIsIdentity(false);
field5.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field5);
*/
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("GALACTIC_ID");
fieldID.setTypeName("NUMBER");
fieldID.setSize(18);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);//true);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
/* // from MappedSuperclass
// 1:1 unidirectional
FieldDefinition field7 = new FieldDefinition();
field7.setName("FUTURE_POS_GALACTIC_ID");
field7.setTypeName("NUMERIC");
field7.setSize(15);
field7.setShouldAllowNull(false);
field7.setIsPrimaryKey(false);
field7.setUnique(false);
field7.setIsIdentity(false);
field7.setForeignKeyFieldName("CMP3_MM_GALACTIC.GALACTIC_ID");
table.addField(field7);
*/
return table;
}
public static TableDefinition buildMANUFACTURER_COMPUTER_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_COMPUTER");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("COMPUTER_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_CORPCOMPUTER_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_CORPCOMPUTER");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("COMPCOMPUTER_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_HWDESIGNER");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_HISTORICAL_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_HIST_EMPLOY");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_MAPUC1A_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_HWDES_MAPUC1A");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_MAP_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_MAPUC2_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_HWDES_MAPUC2");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_MAP_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_MAPUC4_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_HWDES_MAPUC4");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_MAP_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_MAPUC7_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_HWDES_MAPUC7");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_MAP_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_MAPUC8_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_HWDES_MAPUC8");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_MAP_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
/* public static TableDefinition buildMANUFACTURER_ENCLOSURE_MAPUC9_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_ENCL_MAPUC9");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("ENCLOSURE_MAP_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
//field2.setForeignKeyFieldName("CMP3_MM_ENCLOSURE.PERSON_ID"); // need composite PK reference
//table.addField(field2);
return table;
}*/
public static TableDefinition buildMANUFACTURER_HARDWAREDESIGNER_MAP_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_MM_HWDES_MAP");
FieldDefinition field1 = new FieldDefinition();
field1.setName("MANUF_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_MANUF.PERSON_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("DESIGNER_MAP_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_HWDESIGNER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildBOARD_MEMORY_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_BOARD_MM_MEMORY");
FieldDefinition field1 = new FieldDefinition();
field1.setName("BOARD_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_BOARD.BOARD_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("MEMORY_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_MEMORY.MEMORY_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildBOARD_PROCESSOR_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_BOARD_MM_PROC");
FieldDefinition field1 = new FieldDefinition();
field1.setName("BOARD_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_BOARD.BOARD_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("PROC_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_PROC.PROC_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildCOMPUTER_BOARD_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_COMPUTER_MM_BOARD");
FieldDefinition field2 = new FieldDefinition();
field2.setName("BOARD_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_BOARD.BOARD_ID");
table.addField(field2);
FieldDefinition field1 = new FieldDefinition();
field1.setName("COMPUTER_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field1);
return table;
}
public static TableDefinition buildCOMPUTER_USER_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_COMPUTER_MM_USER");
FieldDefinition field1 = new FieldDefinition();
field1.setName("COMPUTER_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
field1.setForeignKeyFieldName("CMP3_MM_COMPUTER.COMPUTER_ID");
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("USER_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
field2.setForeignKeyFieldName("CMP3_MM_USER.PERSON_ID");
table.addField(field2);
return table;
}
public static TableDefinition buildMETAMODEL_CUSTOMERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_CUSTOMER");
FieldDefinition field = new FieldDefinition();
field.setName("LIFEFORM_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
/* FieldDefinition field0 = new FieldDefinition();
field0.setName("FK_DEALER_ID");
field0.setTypeName("NUMERIC");
field0.setSize(15);
field0.setShouldAllowNull(true);
field0.setIsPrimaryKey(false);
field0.setUnique(false);
field0.setIsIdentity(false);
field0.setForeignKeyFieldName("CMP3_DEALER.DEALER_ID");
table.addField(field0);
*/
FieldDefinition field1 = new FieldDefinition();
field1.setName("NAME");
field1.setTypeName("VARCHAR");
field1.setSize(80);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
FieldDefinition fieldCITY = new FieldDefinition();
fieldCITY.setName("CITY");
fieldCITY.setTypeName("VARCHAR");
fieldCITY.setSize(80);
fieldCITY.setShouldAllowNull(true);
fieldCITY.setIsPrimaryKey(false);
fieldCITY.setUnique(false);
fieldCITY.setIsIdentity(false);
table.addField(fieldCITY);
/* FieldDefinition field2 = new FieldDefinition();
field2.setName("L_NAME");
field2.setTypeName("VARCHAR");
field2.setSize(40);
field2.setShouldAllowNull(true);
field2.setIsPrimaryKey(false);
field2.setUnique(false);
field2.setIsIdentity(false);
table.addField(field2);
FieldDefinition field3 = new FieldDefinition();
field3.setName("BUDGET");
field3.setTypeName("NUMERIC");
field3.setSize(15);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
*/
FieldDefinition field4 = new FieldDefinition();
field4.setName("CUSTOMER_VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
FieldDefinition fieldADDRESS = new FieldDefinition();
fieldADDRESS.setName("HOMEADDRESS_ADDRESS_ID");
fieldADDRESS.setTypeName("NUMERIC");
fieldADDRESS.setSize(15);
fieldADDRESS.setShouldAllowNull(false);
fieldADDRESS.setIsPrimaryKey(false);
fieldADDRESS.setUnique(false);
fieldADDRESS.setIsIdentity(false);
fieldADDRESS.setForeignKeyFieldName("CMP3_MM_ADDRESS.ADDRESS_ID");
table.addField(fieldADDRESS);
// we are using a JoinTable - so no need for a column here
/*
FieldDefinition fieldORDERS = new FieldDefinition();
fieldORDERS.setName("ORDER_ID");
fieldORDERS.setTypeName("NUMERIC");
fieldORDERS.setSize(15);
fieldORDERS.setShouldAllowNull(false);
fieldORDERS.setIsPrimaryKey(false);
fieldORDERS.setUnique(false);
fieldORDERS.setIsIdentity(false);
fieldORDERS.setForeignKeyFieldName("CMP3_MM_ORDER.ORDER_ID");
table.addField(fieldORDERS);
*/
return table;
}
public static TableDefinition buildMETAMODEL_ORDERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_ORDER");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("ORDER_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldQUANTITY = new FieldDefinition();
fieldQUANTITY.setName("QUANTITY");
fieldQUANTITY.setTypeName("NUMERIC");
fieldQUANTITY.setSize(16);
fieldQUANTITY.setSubSize(0);
fieldQUANTITY.setIsPrimaryKey(false);
fieldQUANTITY.setIsIdentity(false);
fieldQUANTITY.setUnique(false);
fieldQUANTITY.setShouldAllowNull(true);
table.addField(fieldQUANTITY);
FieldDefinition fieldDESCRIPTION = new FieldDefinition();
fieldDESCRIPTION.setName("DESCRIPTION");
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 fieldVERSION = new FieldDefinition();
fieldVERSION.setName("ORDER_VERSION");
fieldVERSION.setTypeName("NUMERIC");
fieldVERSION.setSize(15);
fieldVERSION.setShouldAllowNull(true);
fieldVERSION.setIsPrimaryKey(false);
fieldVERSION.setUnique(false);
fieldVERSION.setIsIdentity(false);
table.addField(fieldVERSION);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition fieldITEM = new FieldDefinition();
fieldITEM.setName("ITEM_ITEM_ID");
fieldITEM.setTypeName("NUMERIC");
fieldITEM.setSize(16);
fieldITEM.setShouldAllowNull(false);
fieldITEM.setIsPrimaryKey(false);
fieldITEM.setUnique(false);
fieldITEM.setIsIdentity(false);
fieldITEM.setForeignKeyFieldName("CMP3_MM_ITEM.ITEM_ID");
table.addField(fieldITEM);
// 1:m does not require a JoinTable - only a JoinColumn
FieldDefinition fieldCUSTOMER = new FieldDefinition();
fieldCUSTOMER.setName("CUSTOMER_LIFEFORM_ID");
fieldCUSTOMER.setTypeName("NUMERIC");
fieldCUSTOMER.setSize(15);
fieldCUSTOMER.setShouldAllowNull(false);
fieldCUSTOMER.setIsPrimaryKey(false);
fieldCUSTOMER.setUnique(false);
fieldCUSTOMER.setIsIdentity(false);
fieldCUSTOMER.setForeignKeyFieldName("CMP3_MM_CUSTOMER.LIFEFORM_ID");
table.addField(fieldCUSTOMER);
FieldDefinition fieldADDRESS = new FieldDefinition();
fieldADDRESS.setName("BILLINGADDRESS_ADDRESS_ID");
fieldADDRESS.setTypeName("NUMERIC");
fieldADDRESS.setSize(15);
fieldADDRESS.setShouldAllowNull(false);
fieldADDRESS.setIsPrimaryKey(false);
fieldADDRESS.setUnique(false);
fieldADDRESS.setIsIdentity(false);
fieldADDRESS.setForeignKeyFieldName("CMP3_MM_ADDRESS.ADDRESS_ID");
table.addField(fieldADDRESS);
FieldDefinition fieldADDRESS2 = new FieldDefinition();
fieldADDRESS2.setName("SHIPPINGADDRESS_ADDRESS_ID");
fieldADDRESS2.setTypeName("NUMERIC");
fieldADDRESS2.setSize(15);
fieldADDRESS2.setShouldAllowNull(false);
fieldADDRESS2.setIsPrimaryKey(false);
fieldADDRESS2.setUnique(false);
fieldADDRESS2.setIsIdentity(false);
fieldADDRESS2.setForeignKeyFieldName("CMP3_MM_ADDRESS.ADDRESS_ID");
table.addField(fieldADDRESS2);
return table;
}
public static TableDefinition buildMETAMODEL_CUSTOMER_ORDER_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_CUSTOMER_MM_ORDER");
FieldDefinition fieldORDER = new FieldDefinition();
fieldORDER.setName("ORDER_ID");
fieldORDER.setTypeName("NUMERIC");
fieldORDER.setSize(15);
fieldORDER.setShouldAllowNull(false);
fieldORDER.setIsPrimaryKey(false);
fieldORDER.setUnique(false);
fieldORDER.setIsIdentity(false);
fieldORDER.setForeignKeyFieldName("CMP3_MM_ORDER.ORDER_ID");
table.addField(fieldORDER);
FieldDefinition fieldCUSTOMER = new FieldDefinition();
fieldCUSTOMER.setName("CUSTOMER_ID");
fieldCUSTOMER.setTypeName("NUMERIC");
fieldCUSTOMER.setSize(15);
fieldCUSTOMER.setShouldAllowNull(false);
fieldCUSTOMER.setIsPrimaryKey(false);
fieldCUSTOMER.setUnique(false);
fieldCUSTOMER.setIsIdentity(false);
fieldCUSTOMER.setForeignKeyFieldName("CMP3_MM_CUSTOMER.LIFEFORM_ID");
table.addField(fieldCUSTOMER);
return table;
}
/* public static TableDefinition buildMETAMODEL_ORDER_ITEM_JOINTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_ORDER_MM_ITEM");
FieldDefinition fieldORDER = new FieldDefinition();
fieldORDER.setName("ORDER_ID");
fieldORDER.setTypeName("NUMERIC");
fieldORDER.setSize(15);
fieldORDER.setShouldAllowNull(false);
fieldORDER.setIsPrimaryKey(false);
fieldORDER.setUnique(false);
fieldORDER.setIsIdentity(false);
fieldORDER.setForeignKeyFieldName("CMP3_MM_ORDER.ORDER_ID");
table.addField(fieldORDER);
FieldDefinition fieldCUSTOMER = new FieldDefinition();
fieldCUSTOMER.setName("ITEM_ID");
fieldCUSTOMER.setTypeName("NUMERIC");
fieldCUSTOMER.setSize(15);
fieldCUSTOMER.setShouldAllowNull(false);
fieldCUSTOMER.setIsPrimaryKey(false);
fieldCUSTOMER.setUnique(false);
fieldCUSTOMER.setIsIdentity(false);
fieldCUSTOMER.setForeignKeyFieldName("CMP3_MM_ITEM.ITEM_ID");
table.addField(fieldCUSTOMER);
return table;
}*/
public static TableDefinition buildMETAMODEL_ADDRESSTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_ADDRESS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("ADDRESS_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldSTREET = new FieldDefinition();
fieldSTREET.setName("STREET");
fieldSTREET.setTypeName("VARCHAR2");
fieldSTREET.setSize(60);
fieldSTREET.setSubSize(0);
fieldSTREET.setIsPrimaryKey(false);
fieldSTREET.setIsIdentity(false);
fieldSTREET.setUnique(false);
fieldSTREET.setShouldAllowNull(true);
table.addField(fieldSTREET);
FieldDefinition fieldCITY = new FieldDefinition();
fieldCITY.setName("CITY");
fieldCITY.setTypeName("VARCHAR2");
fieldCITY.setSize(60);
fieldCITY.setSubSize(0);
fieldCITY.setIsPrimaryKey(false);
fieldCITY.setIsIdentity(false);
fieldCITY.setUnique(false);
fieldCITY.setShouldAllowNull(true);
table.addField(fieldCITY);
FieldDefinition fieldPROVINCE = new FieldDefinition();
fieldPROVINCE.setName("PROVINCE");
fieldPROVINCE.setTypeName("VARCHAR2");
fieldPROVINCE.setSize(60);
fieldPROVINCE.setSubSize(0);
fieldPROVINCE.setIsPrimaryKey(false);
fieldPROVINCE.setIsIdentity(false);
fieldPROVINCE.setUnique(false);
fieldPROVINCE.setShouldAllowNull(true);
table.addField(fieldPROVINCE);
FieldDefinition fieldPOSTALCODE = new FieldDefinition();
fieldPOSTALCODE.setName("P_CODE");
fieldPOSTALCODE.setTypeName("VARCHAR2");
fieldPOSTALCODE.setSize(67);
fieldPOSTALCODE.setSubSize(0);
fieldPOSTALCODE.setIsPrimaryKey(false);
fieldPOSTALCODE.setIsIdentity(false);
fieldPOSTALCODE.setUnique(false);
fieldPOSTALCODE.setShouldAllowNull(true);
table.addField(fieldPOSTALCODE);
FieldDefinition fieldCOUNTRY = new FieldDefinition();
fieldCOUNTRY.setName("COUNTRY");
fieldCOUNTRY.setTypeName("VARCHAR2");
fieldCOUNTRY.setSize(60);
fieldCOUNTRY.setSubSize(0);
fieldCOUNTRY.setIsPrimaryKey(false);
fieldCOUNTRY.setIsIdentity(false);
fieldCOUNTRY.setUnique(false);
fieldCOUNTRY.setShouldAllowNull(true);
table.addField(fieldCOUNTRY);
FieldDefinition fieldVERSION = new FieldDefinition();
fieldVERSION.setName("ADDRESS_VERSION");
fieldVERSION.setTypeName("NUMERIC");
fieldVERSION.setSize(15);
fieldVERSION.setShouldAllowNull(true);
fieldVERSION.setIsPrimaryKey(false);
fieldVERSION.setUnique(false);
fieldVERSION.setIsIdentity(false);
table.addField(fieldVERSION);
// default DTYPE field when we subclass a non-entity
FieldDefinition fieldType = new FieldDefinition();
fieldType.setName("DTYPE");
fieldType.setTypeName("VARCHAR2");
fieldType.setSize(150);
fieldType.setSubSize(0);
fieldType.setIsPrimaryKey(false);
fieldType.setIsIdentity(false);
fieldType.setUnique(false);
fieldType.setShouldAllowNull(true);
table.addField(fieldType);
return table;
}
public static TableDefinition buildMETAMODEL_HOMEADDRESSTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_ADDRESS");
//HOMEADDRESS_ADDRESS_ID
return table;
}
public static TableDefinition buildMETAMODEL_ITEMTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_ITEM");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("ITEM_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldDESCRIPTION = new FieldDefinition();
fieldDESCRIPTION.setName("DESCRIPTION");
fieldDESCRIPTION.setTypeName("VARCHAR2");
fieldDESCRIPTION.setSize(128);
fieldDESCRIPTION.setSubSize(0);
fieldDESCRIPTION.setIsPrimaryKey(false);
fieldDESCRIPTION.setIsIdentity(false);
fieldDESCRIPTION.setUnique(false);
fieldDESCRIPTION.setShouldAllowNull(true);
table.addField(fieldDESCRIPTION);
FieldDefinition fieldNAME = new FieldDefinition();
fieldNAME.setName("NAME");
fieldNAME.setTypeName("VARCHAR2");
fieldNAME.setSize(60);
fieldNAME.setSubSize(0);
fieldNAME.setIsPrimaryKey(false);
fieldNAME.setIsIdentity(false);
fieldNAME.setUnique(false);
fieldNAME.setShouldAllowNull(true);
table.addField(fieldNAME);
FieldDefinition fieldVERSION = new FieldDefinition();
fieldVERSION.setName("ITEM_VERSION");
fieldVERSION.setTypeName("NUMERIC");
fieldVERSION.setSize(15);
fieldVERSION.setShouldAllowNull(true);
fieldVERSION.setIsPrimaryKey(false);
fieldVERSION.setUnique(false);
fieldVERSION.setIsIdentity(false);
table.addField(fieldVERSION);
return table;
}
public static TableDefinition buildCMP3_MM_BOARD_SEQTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_BOARD_SEQ");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("SEQ_MM_COUNT");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldDESCRIPTION = new FieldDefinition();
fieldDESCRIPTION.setName("SEQ_MM_NAME");
fieldDESCRIPTION.setTypeName("VARCHAR2");
fieldDESCRIPTION.setSize(40);
fieldDESCRIPTION.setSubSize(0);
fieldDESCRIPTION.setIsPrimaryKey(false);
fieldDESCRIPTION.setIsIdentity(false);
fieldDESCRIPTION.setUnique(false);
fieldDESCRIPTION.setShouldAllowNull(true);
table.addField(fieldDESCRIPTION);
return table;
}
public static TableDefinition buildCMP3_MM_PERSON_SEQTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_PERSON_SEQ");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("SEQ_MM_COUNT");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(true);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldDESCRIPTION = new FieldDefinition();
fieldDESCRIPTION.setName("SEQ_MM_NAME");
fieldDESCRIPTION.setTypeName("VARCHAR2");
fieldDESCRIPTION.setSize(40);
fieldDESCRIPTION.setSubSize(0);
fieldDESCRIPTION.setIsPrimaryKey(false);
fieldDESCRIPTION.setIsIdentity(false);
fieldDESCRIPTION.setUnique(false);
fieldDESCRIPTION.setShouldAllowNull(true);
table.addField(fieldDESCRIPTION);
return table;
}
public static TableDefinition buildCMP3_MM_MANUF_CMP3_MM_MANUFTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_MM_MANUF_CMP3_MM_MANUF");
FieldDefinition field = new FieldDefinition();
field.setName("ManuMetamodel_PERSON_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field2 = new FieldDefinition();
field2.setName("historicalEmps_PERSON_ID");
field2.setTypeName("NUMERIC");
field2.setSize(15);
field2.setShouldAllowNull(false);
field2.setIsPrimaryKey(true);
field2.setUnique(false);
field2.setIsIdentity(true);
table.addField(field2);
return table;
}
}