/*******************************************************************************
* 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:
* dminsky - initial API and implementation
******************************************************************************/
package org.eclipse.persistence.testing.models.aggregate;
import org.eclipse.persistence.tools.schemaframework.*;
/**
* This class was generated by the TopLink table creator generator.
* It stores the meta-data (tables) that define the database schema.
* @see org.eclipse.persistence.sessions.factories.TableCreatorClassGenerator
*/
public class AggregateRelationshipsTableCreator extends TableCreator {
public AggregateRelationshipsTableCreator() {
setName("AggregateProblem");
addTableDefinition(buildAGG_CHILDTable());
addTableDefinition(buildAGG_PARENTTable());
addTableDefinition(buildAGG_STEPCHILDTable());
addTableDefinition(buildAGG_COUSINTable());
addTableDefinition(buildAGG_NICKNAMETable());
addTableDefinition(buildAGG_PARENT_RELATIVETable());
addTableDefinition(buildAGG_RELATIVETable());
}
public TableDefinition buildAGG_CHILDTable() {
TableDefinition table = new TableDefinition();
table.setName("AGG_CHILD");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("ID");
fieldID.setTypeName("NUMBER");
fieldID.setSize(0);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(false);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldPARENT_ID = new FieldDefinition();
fieldPARENT_ID.setName("PARENT_ID");
fieldPARENT_ID.setTypeName("NUMBER");
fieldPARENT_ID.setSize(0);
fieldPARENT_ID.setSubSize(0);
fieldPARENT_ID.setIsPrimaryKey(false);
fieldPARENT_ID.setIsIdentity(false);
fieldPARENT_ID.setUnique(false);
fieldPARENT_ID.setShouldAllowNull(true);
table.addField(fieldPARENT_ID);
ForeignKeyConstraint foreignKeyCHILD_PARENT = new ForeignKeyConstraint();
foreignKeyCHILD_PARENT.setName("CHILD_PARENT");
foreignKeyCHILD_PARENT.setTargetTable("AGG_PARENT");
foreignKeyCHILD_PARENT.addSourceField("PARENT_ID");
foreignKeyCHILD_PARENT.addTargetField("P_ID");
table.addForeignKeyConstraint(foreignKeyCHILD_PARENT);
return table;
}
public TableDefinition buildAGG_COUSINTable() {
TableDefinition table = new TableDefinition();
table.setName("AGG_COUSIN");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("ID");
fieldID.setTypeName("NUMBER");
fieldID.setSize(0);
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(20);
fieldNAME.setSubSize(0);
fieldNAME.setIsPrimaryKey(false);
fieldNAME.setIsIdentity(false);
fieldNAME.setUnique(false);
fieldNAME.setShouldAllowNull(true);
table.addField(fieldNAME);
return table;
}
public TableDefinition buildAGG_NICKNAMETable() {
TableDefinition table = new TableDefinition();
table.setName("AGG_NICKNAME");
FieldDefinition fieldNICKNAME = new FieldDefinition();
fieldNICKNAME.setName("NICKNAME");
fieldNICKNAME.setTypeName("VARCHAR2");
fieldNICKNAME.setSize(20);
fieldNICKNAME.setSubSize(0);
fieldNICKNAME.setIsPrimaryKey(false);
fieldNICKNAME.setIsIdentity(false);
fieldNICKNAME.setUnique(false);
fieldNICKNAME.setShouldAllowNull(false);
table.addField(fieldNICKNAME);
FieldDefinition fieldPARENT_ID = new FieldDefinition();
fieldPARENT_ID.setName("PARENT_ID");
fieldPARENT_ID.setTypeName("NUMBER");
fieldPARENT_ID.setSize(0);
fieldPARENT_ID.setSubSize(0);
fieldPARENT_ID.setIsPrimaryKey(false);
fieldPARENT_ID.setIsIdentity(false);
fieldPARENT_ID.setUnique(false);
fieldPARENT_ID.setShouldAllowNull(false);
table.addField(fieldPARENT_ID);
ForeignKeyConstraint foreignKeyNICKNAME_PARENT = new ForeignKeyConstraint();
foreignKeyNICKNAME_PARENT.setName("NICKNAME_PARENT");
foreignKeyNICKNAME_PARENT.setTargetTable("AGG_PARENT");
foreignKeyNICKNAME_PARENT.addSourceField("PARENT_ID");
foreignKeyNICKNAME_PARENT.addTargetField("P_ID");
table.addForeignKeyConstraint(foreignKeyNICKNAME_PARENT);
return table;
}
public TableDefinition buildAGG_PARENTTable() {
TableDefinition table = new TableDefinition();
table.setName("AGG_PARENT");
FieldDefinition fieldCOUSIN_ID = new FieldDefinition();
fieldCOUSIN_ID.setName("COUSIN_ID");
fieldCOUSIN_ID.setTypeName("NUMBER");
fieldCOUSIN_ID.setSize(0);
fieldCOUSIN_ID.setSubSize(0);
fieldCOUSIN_ID.setIsPrimaryKey(false);
fieldCOUSIN_ID.setIsIdentity(false);
fieldCOUSIN_ID.setUnique(false);
fieldCOUSIN_ID.setShouldAllowNull(true);
table.addField(fieldCOUSIN_ID);
FieldDefinition fieldP_ID = new FieldDefinition();
fieldP_ID.setName("P_ID");
fieldP_ID.setTypeName("NUMBER");
fieldP_ID.setSize(0);
fieldP_ID.setSubSize(0);
fieldP_ID.setIsPrimaryKey(true);
fieldP_ID.setIsIdentity(false);
fieldP_ID.setUnique(false);
fieldP_ID.setShouldAllowNull(false);
table.addField(fieldP_ID);
ForeignKeyConstraint foreignKeyPARENT_COUSIN = new ForeignKeyConstraint();
foreignKeyPARENT_COUSIN.setName("PARENT_COUSIN");
foreignKeyPARENT_COUSIN.setTargetTable("AGG_COUSIN");
foreignKeyPARENT_COUSIN.addSourceField("COUSIN_ID");
foreignKeyPARENT_COUSIN.addTargetField("ID");
table.addForeignKeyConstraint(foreignKeyPARENT_COUSIN);
return table;
}
public TableDefinition buildAGG_PARENT_RELATIVETable() {
TableDefinition table = new TableDefinition();
table.setName("AGG_PARENT_RELATIVE");
FieldDefinition fieldPARENT_ID = new FieldDefinition();
fieldPARENT_ID.setName("PARENT_ID");
fieldPARENT_ID.setTypeName("NUMBER");
fieldPARENT_ID.setSize(0);
fieldPARENT_ID.setSubSize(0);
fieldPARENT_ID.setIsPrimaryKey(true);
fieldPARENT_ID.setIsIdentity(false);
fieldPARENT_ID.setUnique(false);
fieldPARENT_ID.setShouldAllowNull(false);
table.addField(fieldPARENT_ID);
FieldDefinition fieldRELATIVE_ID = new FieldDefinition();
fieldRELATIVE_ID.setName("RELATIVE_ID");
fieldRELATIVE_ID.setTypeName("NUMBER");
fieldRELATIVE_ID.setSize(0);
fieldRELATIVE_ID.setSubSize(0);
fieldRELATIVE_ID.setIsPrimaryKey(true);
fieldRELATIVE_ID.setIsIdentity(false);
fieldRELATIVE_ID.setUnique(false);
fieldRELATIVE_ID.setShouldAllowNull(false);
table.addField(fieldRELATIVE_ID);
ForeignKeyConstraint foreignKeyPARENT_TO_RELATIVE = new ForeignKeyConstraint();
foreignKeyPARENT_TO_RELATIVE.setName("PARENT_TO_RELATIVE");
foreignKeyPARENT_TO_RELATIVE.setTargetTable("AGG_RELATIVE");
foreignKeyPARENT_TO_RELATIVE.addSourceField("RELATIVE_ID");
foreignKeyPARENT_TO_RELATIVE.addTargetField("REL_ID");
table.addForeignKeyConstraint(foreignKeyPARENT_TO_RELATIVE);
ForeignKeyConstraint foreignKeyRELATIVE_TO_PARENT = new ForeignKeyConstraint();
foreignKeyRELATIVE_TO_PARENT.setName("RELATIVE_TO_PARENT");
foreignKeyRELATIVE_TO_PARENT.setTargetTable("AGG_PARENT");
foreignKeyRELATIVE_TO_PARENT.addSourceField("PARENT_ID");
foreignKeyRELATIVE_TO_PARENT.addTargetField("P_ID");
table.addForeignKeyConstraint(foreignKeyRELATIVE_TO_PARENT);
return table;
}
public TableDefinition buildAGG_RELATIVETable() {
TableDefinition table = new TableDefinition();
table.setName("AGG_RELATIVE");
FieldDefinition fieldREL_ID = new FieldDefinition();
fieldREL_ID.setName("REL_ID");
fieldREL_ID.setTypeName("NUMBER");
fieldREL_ID.setSize(0);
fieldREL_ID.setSubSize(0);
fieldREL_ID.setIsPrimaryKey(true);
fieldREL_ID.setIsIdentity(false);
fieldREL_ID.setUnique(false);
fieldREL_ID.setShouldAllowNull(false);
table.addField(fieldREL_ID);
FieldDefinition fieldNAME = new FieldDefinition();
fieldNAME.setName("NAME");
fieldNAME.setTypeName("VARCHAR2");
fieldNAME.setSize(20);
fieldNAME.setSubSize(0);
fieldNAME.setIsPrimaryKey(false);
fieldNAME.setIsIdentity(false);
fieldNAME.setUnique(false);
fieldNAME.setShouldAllowNull(true);
table.addField(fieldNAME);
return table;
}
public TableDefinition buildAGG_STEPCHILDTable() {
TableDefinition table = new TableDefinition();
table.setName("AGG_STEPCHILD");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("ID");
fieldID.setTypeName("NUMBER");
fieldID.setSize(0);
fieldID.setSubSize(0);
fieldID.setIsPrimaryKey(true);
fieldID.setIsIdentity(false);
fieldID.setUnique(false);
fieldID.setShouldAllowNull(false);
table.addField(fieldID);
FieldDefinition fieldPARENT_ID = new FieldDefinition();
fieldPARENT_ID.setName("PARENT_ID");
fieldPARENT_ID.setTypeName("NUMBER");
fieldPARENT_ID.setSize(0);
fieldPARENT_ID.setSubSize(0);
fieldPARENT_ID.setIsPrimaryKey(false);
fieldPARENT_ID.setIsIdentity(false);
fieldPARENT_ID.setUnique(false);
fieldPARENT_ID.setShouldAllowNull(true);
table.addField(fieldPARENT_ID);
ForeignKeyConstraint foreignKeySTEPCHILD_PARENT = new ForeignKeyConstraint();
foreignKeySTEPCHILD_PARENT.setName("STEPCHILD_PARENT");
foreignKeySTEPCHILD_PARENT.setTargetTable("AGG_PARENT");
foreignKeySTEPCHILD_PARENT.addSourceField("PARENT_ID");
foreignKeySTEPCHILD_PARENT.addTargetField("P_ID");
table.addForeignKeyConstraint(foreignKeySTEPCHILD_PARENT);
return table;
}
}