| /* |
| * Copyright (c) 1998, 2020 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 v. 2.0 which is available at |
| * http://www.eclipse.org/legal/epl-2.0, |
| * or the Eclipse Distribution License v. 1.0 which is available at |
| * http://www.eclipse.org/org/documents/edl-v10.php. |
| * |
| * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause |
| */ |
| |
| // Contributors: |
| // 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; |
| } |
| |
| } |