/******************************************************************************* | |
* Copyright (c) 1998, 2013 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.relationshipmaintenance; | |
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 RelationshipsTableCreator extends TableCreator { | |
public RelationshipsTableCreator() { | |
setName("Relationships"); | |
addTableDefinition(buildFIELDLOCATIONTable()); | |
addTableDefinition(buildFIELDOFFICETable()); | |
addTableDefinition(buildCUSTOMERTable()); | |
addTableDefinition(buildFIELDMANAGERTable()); | |
addTableDefinition(buildSALESPERSONTable()); | |
addTableDefinition(buildSALES_CUSTTable()); | |
addTableDefinition(buildREL_EMPTable()); | |
addTableDefinition(buildREL_DEPTTable()); | |
addTableDefinition(buildRESOURCETable()); | |
} | |
public TableDefinition buildCUSTOMERTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("REL_CUSTOMER"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("INTEGER"); | |
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("VARCHAR"); | |
fieldNAME.setSize(20); | |
fieldNAME.setSubSize(0); | |
fieldNAME.setIsPrimaryKey(false); | |
fieldNAME.setIsIdentity(false); | |
fieldNAME.setUnique(false); | |
fieldNAME.setShouldAllowNull(false); | |
table.addField(fieldNAME); | |
return table; | |
} | |
public TableDefinition buildFIELDLOCATIONTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("FIELDLOCATION"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("INTEGER"); | |
fieldID.setSize(0); | |
fieldID.setSubSize(0); | |
fieldID.setIsPrimaryKey(true); | |
fieldID.setIsIdentity(false); | |
fieldID.setUnique(false); | |
fieldID.setShouldAllowNull(false); | |
table.addField(fieldID); | |
FieldDefinition fieldCITY = new FieldDefinition(); | |
fieldCITY.setName("CITY"); | |
fieldCITY.setTypeName("VARCHAR"); | |
fieldCITY.setSize(20); | |
fieldCITY.setSubSize(0); | |
fieldCITY.setIsPrimaryKey(false); | |
fieldCITY.setIsIdentity(false); | |
fieldCITY.setUnique(false); | |
fieldCITY.setShouldAllowNull(false); | |
table.addField(fieldCITY); | |
return table; | |
} | |
public TableDefinition buildFIELDMANAGERTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("FIELDMANAGER"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("INTEGER"); | |
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("VARCHAR"); | |
fieldNAME.setSize(20); | |
fieldNAME.setSubSize(0); | |
fieldNAME.setIsPrimaryKey(false); | |
fieldNAME.setIsIdentity(false); | |
fieldNAME.setUnique(false); | |
fieldNAME.setShouldAllowNull(false); | |
table.addField(fieldNAME); | |
return table; | |
} | |
public TableDefinition buildFIELDOFFICETable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("FIELDOFFICE"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("INTEGER"); | |
fieldID.setSize(0); | |
fieldID.setSubSize(0); | |
fieldID.setIsPrimaryKey(true); | |
fieldID.setIsIdentity(false); | |
fieldID.setUnique(false); | |
fieldID.setShouldAllowNull(false); | |
table.addField(fieldID); | |
FieldDefinition fieldMANAGER_ID = new FieldDefinition(); | |
fieldMANAGER_ID.setName("MANAGER_ID"); | |
fieldMANAGER_ID.setTypeName("INTEGER"); | |
fieldMANAGER_ID.setSize(0); | |
fieldMANAGER_ID.setSubSize(0); | |
fieldMANAGER_ID.setIsPrimaryKey(false); | |
fieldMANAGER_ID.setIsIdentity(false); | |
fieldMANAGER_ID.setUnique(false); | |
fieldMANAGER_ID.setShouldAllowNull(true); | |
table.addField(fieldMANAGER_ID); | |
FieldDefinition fieldLOCATION_ID = new FieldDefinition(); | |
fieldLOCATION_ID.setName("LOCATION_ID"); | |
fieldLOCATION_ID.setTypeName("INTEGER"); | |
fieldLOCATION_ID.setSize(0); | |
fieldLOCATION_ID.setSubSize(0); | |
fieldLOCATION_ID.setIsPrimaryKey(false); | |
fieldLOCATION_ID.setIsIdentity(false); | |
fieldLOCATION_ID.setUnique(false); | |
fieldLOCATION_ID.setShouldAllowNull(true); | |
table.addField(fieldLOCATION_ID); | |
return table; | |
} | |
public TableDefinition buildSALES_CUSTTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("SALES_CUST"); | |
FieldDefinition fieldSALES_ID = new FieldDefinition(); | |
fieldSALES_ID.setName("SALES_ID"); | |
fieldSALES_ID.setTypeName("INTEGER"); | |
fieldSALES_ID.setSize(0); | |
fieldSALES_ID.setSubSize(0); | |
fieldSALES_ID.setIsPrimaryKey(true); | |
fieldSALES_ID.setIsIdentity(false); | |
fieldSALES_ID.setUnique(false); | |
fieldSALES_ID.setShouldAllowNull(false); | |
table.addField(fieldSALES_ID); | |
FieldDefinition fieldCUST_ID = new FieldDefinition(); | |
fieldCUST_ID.setName("CUST_ID"); | |
fieldCUST_ID.setTypeName("INTEGER"); | |
fieldCUST_ID.setSize(0); | |
fieldCUST_ID.setSubSize(0); | |
fieldCUST_ID.setIsPrimaryKey(true); | |
fieldCUST_ID.setIsIdentity(false); | |
fieldCUST_ID.setUnique(false); | |
fieldCUST_ID.setShouldAllowNull(false); | |
table.addField(fieldCUST_ID); | |
return table; | |
} | |
public TableDefinition buildSALESPERSONTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("SALESPERSON"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("INTEGER"); | |
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("VARCHAR"); | |
fieldNAME.setSize(20); | |
fieldNAME.setSubSize(0); | |
fieldNAME.setIsPrimaryKey(false); | |
fieldNAME.setIsIdentity(false); | |
fieldNAME.setUnique(false); | |
fieldNAME.setShouldAllowNull(false); | |
table.addField(fieldNAME); | |
FieldDefinition fieldOFFICE_ID = new FieldDefinition(); | |
fieldOFFICE_ID.setName("OFFICE_ID"); | |
fieldOFFICE_ID.setTypeName("INTEGER"); | |
fieldOFFICE_ID.setSize(0); | |
fieldOFFICE_ID.setSubSize(0); | |
fieldOFFICE_ID.setIsPrimaryKey(false); | |
fieldOFFICE_ID.setIsIdentity(false); | |
fieldOFFICE_ID.setUnique(false); | |
fieldOFFICE_ID.setShouldAllowNull(true); | |
table.addField(fieldOFFICE_ID); | |
return table; | |
} | |
public TableDefinition buildREL_EMPTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("REL_EMP"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("INTEGER"); | |
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("VARCHAR"); | |
fieldNAME.setSize(255); | |
fieldNAME.setSubSize(0); | |
fieldNAME.setIsPrimaryKey(false); | |
fieldNAME.setIsIdentity(false); | |
fieldNAME.setUnique(false); | |
fieldNAME.setShouldAllowNull(false); | |
table.addField(fieldNAME); | |
FieldDefinition fieldDEPTNO = new FieldDefinition(); | |
fieldDEPTNO.setName("DEPTNO"); | |
fieldDEPTNO.setTypeName("INTEGER"); | |
fieldDEPTNO.setSize(0); | |
fieldDEPTNO.setSubSize(0); | |
fieldDEPTNO.setIsPrimaryKey(false); | |
fieldDEPTNO.setIsIdentity(false); | |
fieldDEPTNO.setUnique(false); | |
fieldDEPTNO.setShouldAllowNull(true); | |
table.addField(fieldDEPTNO); | |
return table; | |
} | |
public TableDefinition buildREL_DEPTTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("REL_DEPT"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("DEPTNO"); | |
fieldID.setTypeName("INTEGER"); | |
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("VARCHAR"); | |
fieldNAME.setSize(255); | |
fieldNAME.setSubSize(0); | |
fieldNAME.setIsPrimaryKey(false); | |
fieldNAME.setIsIdentity(false); | |
fieldNAME.setUnique(false); | |
fieldNAME.setShouldAllowNull(false); | |
table.addField(fieldNAME); | |
return table; | |
} | |
public TableDefinition buildRESOURCETable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("REL_RESOURCE"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("INTEGER"); | |
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("VARCHAR"); | |
fieldNAME.setSize(100); | |
fieldNAME.setSubSize(0); | |
fieldNAME.setIsPrimaryKey(false); | |
fieldNAME.setIsIdentity(false); | |
fieldNAME.setUnique(false); | |
fieldNAME.setShouldAllowNull(false); | |
table.addField(fieldNAME); | |
FieldDefinition fieldOFFICE = new FieldDefinition(); | |
fieldOFFICE.setName("OFFICE_ID"); | |
fieldOFFICE.setTypeName("INTEGER"); | |
fieldOFFICE.setSize(0); | |
fieldOFFICE.setSubSize(0); | |
fieldOFFICE.setIsPrimaryKey(false); | |
fieldOFFICE.setIsIdentity(false); | |
fieldOFFICE.setUnique(false); | |
fieldOFFICE.setShouldAllowNull(true); | |
table.addField(fieldOFFICE); | |
return table; | |
} | |
} |