/*******************************************************************************
* 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:
* Oracle - initial API and implementation from Oracle TopLink
******************************************************************************/
package org.eclipse.persistence.testing.models.multipletable;
import org.eclipse.persistence.tools.schemaframework.*;
/**
* Creates the necessary tables for the MultipleTableProject.
*
* @author Guy Pelletier
* @version 1.0
* @date June 17, 2005
*/
public class MultipleTableTableCreator extends TableCreator {
public MultipleTableTableCreator() {
setName("MultipleTableTableCreator");
addTableDefinition(buildCOWTable());
addTableDefinition(buildCALFSTable());
addTableDefinition(buildCOW_AGETable());
addTableDefinition(buildCOW_WEIGHTTable());
addTableDefinition(buildSUPER_COWTable());
addTableDefinition(buildHORSETable());
addTableDefinition(buildFOALSTable());
addTableDefinition(buildHORSE_AGETable());
addTableDefinition(buildHORSE_WEIGHTTable());
addTableDefinition(buildSUPER_HORSETable());
addTableDefinition(buildHUMANTable());
addTableDefinition(buildKIDSTable());
addTableDefinition(buildSWANTable());
addTableDefinition(buildCYGNETSTable());
addTableDefinition(buildSWAN_AGETable());
addTableDefinition(buildSWAN_WEIGHTTable());
addTableDefinition(buildSUPER_SWANTable());
addTableDefinition(buildSWAN_WINGSPANTable());
}
protected TableDefinition buildCOWTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_COW");
FieldDefinition field = new FieldDefinition();
field.setName("ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition typeField = new FieldDefinition();
typeField.setName("TYPE");
typeField.setTypeName("VARCHAR");
typeField.setSize(3);
typeField.setShouldAllowNull(true);
typeField.setIsPrimaryKey(false);
typeField.setUnique(false);
typeField.setIsIdentity(false);
table.addField(typeField);
FieldDefinition field1 = new FieldDefinition();
field1.setName("CALFS_ID");
field1.setTypeName("NUMERIC");
field1.setSize(15);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
FieldDefinition field2 = new FieldDefinition();
field2.setName("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("AGE_ID");
field3.setTypeName("NUMERIC");
field3.setSize(15);
field3.setShouldAllowNull(false);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
FieldDefinition field4 = new FieldDefinition();
field4.setName("WEIGHT_ID");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(false);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
ForeignKeyConstraint foreignKeyCOW_CALFS = new ForeignKeyConstraint();
foreignKeyCOW_CALFS.setName("COW_CALFS");
foreignKeyCOW_CALFS.setTargetTable("MULTI_CALFS");
foreignKeyCOW_CALFS.addSourceField("CALFS_ID");
foreignKeyCOW_CALFS.addTargetField("C_ID");
table.addForeignKeyConstraint(foreignKeyCOW_CALFS);
ForeignKeyConstraint foreignKeyCOW_AGE = new ForeignKeyConstraint();
foreignKeyCOW_AGE.setName("COW_AGE");
foreignKeyCOW_AGE.setTargetTable("MULTI_COW_AGE");
foreignKeyCOW_AGE.addSourceField("AGE_ID");
foreignKeyCOW_AGE.addTargetField("A_ID");
table.addForeignKeyConstraint(foreignKeyCOW_AGE);
ForeignKeyConstraint foreignKeyCOW_WEIGHT = new ForeignKeyConstraint();
foreignKeyCOW_WEIGHT.setName("COW_WEIGHT");
foreignKeyCOW_WEIGHT.setTargetTable("MULTI_COW_WEIGHT");
foreignKeyCOW_WEIGHT.addSourceField("WEIGHT_ID");
foreignKeyCOW_WEIGHT.addTargetField("W_ID");
table.addForeignKeyConstraint(foreignKeyCOW_WEIGHT);
return table;
}
protected TableDefinition buildCALFSTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_CALFS");
FieldDefinition field = new FieldDefinition();
field.setName("C_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("CALFS");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
protected TableDefinition buildCOW_AGETable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_COW_AGE");
FieldDefinition field = new FieldDefinition();
field.setName("A_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("AGE");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
protected TableDefinition buildCOW_WEIGHTTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_COW_WEIGHT");
FieldDefinition field = new FieldDefinition();
field.setName("W_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("WEIGHT");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
protected TableDefinition buildSUPER_COWTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_SUPER_COW");
FieldDefinition field = new FieldDefinition();
field.setName("SC_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
field.setForeignKeyFieldName("MULTI_COW.ID");
table.addField(field);
FieldDefinition sppedField = new FieldDefinition();
sppedField.setName("SPEED");
sppedField.setTypeName("NUMERIC");
sppedField.setSize(15);
sppedField.setShouldAllowNull(false);
sppedField.setIsPrimaryKey(false);
sppedField.setUnique(false);
sppedField.setIsIdentity(false);
table.addField(sppedField);
return table;
}
protected TableDefinition buildHORSETable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_HORSE");
FieldDefinition field = new FieldDefinition();
field.setName("ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition typeField = new FieldDefinition();
typeField.setName("TYPE");
typeField.setTypeName("VARCHAR");
typeField.setSize(3);
typeField.setShouldAllowNull(true);
typeField.setIsPrimaryKey(false);
typeField.setUnique(false);
typeField.setIsIdentity(false);
table.addField(typeField);
FieldDefinition field1 = new FieldDefinition();
field1.setName("NAME");
field1.setTypeName("VARCHAR");
field1.setSize(40);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
protected TableDefinition buildFOALSTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_FOALS");
FieldDefinition field = new FieldDefinition();
field.setName("F_HORSE_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("FOALS");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeyFOALS_HORSE = new ForeignKeyConstraint();
foreignKeyFOALS_HORSE.setName("FOALS_HORSE");
foreignKeyFOALS_HORSE.setTargetTable("MULTI_HORSE");
foreignKeyFOALS_HORSE.addSourceField("F_HORSE_ID");
foreignKeyFOALS_HORSE.addTargetField("ID");
table.addForeignKeyConstraint(foreignKeyFOALS_HORSE);
return table;
}
protected TableDefinition buildHORSE_AGETable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_HORSE_AGE");
FieldDefinition field = new FieldDefinition();
field.setName("A_HORSE_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("AGE");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeyHORSE_AGE = new ForeignKeyConstraint();
foreignKeyHORSE_AGE.setName("AGE_HORSE");
foreignKeyHORSE_AGE.setTargetTable("MULTI_HORSE");
foreignKeyHORSE_AGE.addSourceField("A_HORSE_ID");
foreignKeyHORSE_AGE.addTargetField("ID");
table.addForeignKeyConstraint(foreignKeyHORSE_AGE);
return table;
}
protected TableDefinition buildHORSE_WEIGHTTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_HORSE_WEIGHT");
FieldDefinition field = new FieldDefinition();
field.setName("W_HORSE_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("WEIGHT");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeyHORSE_WEIGHT = new ForeignKeyConstraint();
foreignKeyHORSE_WEIGHT.setName("WEIGHT_HORSE");
foreignKeyHORSE_WEIGHT.setTargetTable("MULTI_HORSE");
foreignKeyHORSE_WEIGHT.addSourceField("W_HORSE_ID");
foreignKeyHORSE_WEIGHT.addTargetField("ID");
table.addForeignKeyConstraint(foreignKeyHORSE_WEIGHT);
return table;
}
protected TableDefinition buildSUPER_HORSETable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_SUPER_HORSE");
FieldDefinition field = new FieldDefinition();
field.setName("SH_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
field.setForeignKeyFieldName("MULTI_HORSE.ID");
table.addField(field);
FieldDefinition sppedField = new FieldDefinition();
sppedField.setName("SPEED");
sppedField.setTypeName("NUMERIC");
sppedField.setSize(15);
sppedField.setShouldAllowNull(false);
sppedField.setIsPrimaryKey(false);
sppedField.setUnique(false);
sppedField.setIsIdentity(false);
table.addField(sppedField);
return table;
}
protected TableDefinition buildHUMANTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_HUMAN");
FieldDefinition field = new FieldDefinition();
field.setName("ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("NAME");
field1.setTypeName("VARCHAR");
field1.setSize(40);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
protected TableDefinition buildKIDSTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_KIDS");
FieldDefinition field = new FieldDefinition();
field.setName("ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("KIDS");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeyKIDS_HUMAN = new ForeignKeyConstraint();
foreignKeyKIDS_HUMAN.setName("KIDS_HUMAN");
foreignKeyKIDS_HUMAN.setTargetTable("MULTI_HUMAN");
foreignKeyKIDS_HUMAN.addSourceField("ID");
foreignKeyKIDS_HUMAN.addTargetField("ID");
table.addForeignKeyConstraint(foreignKeyKIDS_HUMAN);
return table;
}
protected TableDefinition buildSWANTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_SWAN");
FieldDefinition field = new FieldDefinition();
field.setName("ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition typeField = new FieldDefinition();
typeField.setName("TYPE");
typeField.setTypeName("VARCHAR");
typeField.setSize(3);
typeField.setShouldAllowNull(true);
typeField.setIsPrimaryKey(false);
typeField.setUnique(false);
typeField.setIsIdentity(false);
table.addField(typeField);
FieldDefinition field1 = new FieldDefinition();
field1.setName("NAME");
field1.setTypeName("VARCHAR");
field1.setSize(40);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeySWAN_CYGNET = new ForeignKeyConstraint();
foreignKeySWAN_CYGNET.setName("SWAN_CYGNET");
foreignKeySWAN_CYGNET.setTargetTable("MULTI_CYGNETS");
foreignKeySWAN_CYGNET.addSourceField("ID");
foreignKeySWAN_CYGNET.addTargetField("C_SWAN_ID");
table.addForeignKeyConstraint(foreignKeySWAN_CYGNET);
return table;
}
protected TableDefinition buildCYGNETSTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_CYGNETS");
FieldDefinition field = new FieldDefinition();
field.setName("C_SWAN_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("CYGNETS");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
protected TableDefinition buildSWAN_AGETable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_SWAN_AGE");
FieldDefinition field = new FieldDefinition();
field.setName("A_SWAN_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("AGE");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeySWAN_AGE = new ForeignKeyConstraint();
foreignKeySWAN_AGE.setName("AGE_SWAN");
foreignKeySWAN_AGE.setTargetTable("MULTI_SWAN");
foreignKeySWAN_AGE.addSourceField("A_SWAN_ID");
foreignKeySWAN_AGE.addTargetField("ID");
table.addForeignKeyConstraint(foreignKeySWAN_AGE);
return table;
}
protected TableDefinition buildSWAN_WINGSPANTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_SWAN_WINGSPAN");
FieldDefinition field = new FieldDefinition();
field.setName("A_SWAN_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("WING_SPAN");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeySWAN_WING_SPAN = new ForeignKeyConstraint();
foreignKeySWAN_WING_SPAN.setName("WING_SPAN");
foreignKeySWAN_WING_SPAN.setTargetTable("MULTI_SUPER_SWAN");
foreignKeySWAN_WING_SPAN.addSourceField("A_SWAN_ID");
foreignKeySWAN_WING_SPAN.addTargetField("SS_ID");
table.addForeignKeyConstraint(foreignKeySWAN_WING_SPAN);
return table;
}
protected TableDefinition buildSWAN_WEIGHTTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_SWAN_WEIGHT");
FieldDefinition field = new FieldDefinition();
field.setName("W_SWAN_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
table.addField(field);
FieldDefinition field1 = new FieldDefinition();
field1.setName("WEIGHT");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(true);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
ForeignKeyConstraint foreignKeySWAN_WEIGHT = new ForeignKeyConstraint();
foreignKeySWAN_WEIGHT.setName("WIGHT_SWAN");
foreignKeySWAN_WEIGHT.setTargetTable("MULTI_SWAN");
foreignKeySWAN_WEIGHT.addSourceField("W_SWAN_ID");
foreignKeySWAN_WEIGHT.addTargetField("ID");
table.addForeignKeyConstraint(foreignKeySWAN_WEIGHT);
return table;
}
protected TableDefinition buildSUPER_SWANTable() {
TableDefinition table = new TableDefinition();
table.setName("MULTI_SUPER_SWAN");
FieldDefinition field = new FieldDefinition();
field.setName("SS_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(false);
field.setForeignKeyFieldName("MULTI_SWAN.ID");
table.addField(field);
FieldDefinition sppedField = new FieldDefinition();
sppedField.setName("SPEED");
sppedField.setTypeName("NUMERIC");
sppedField.setSize(15);
sppedField.setShouldAllowNull(false);
sppedField.setIsPrimaryKey(false);
sppedField.setUnique(false);
sppedField.setIsIdentity(false);
table.addField(sppedField);
return table;
}
}