/******************************************************************************* | |
* Copyright (c) 2011, 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: | |
* Vikram Bhatia - initial API and implementation | |
******************************************************************************/ | |
package org.eclipse.persistence.testing.models.vehicle; | |
import org.eclipse.persistence.tools.schemaframework.FieldDefinition; | |
import org.eclipse.persistence.tools.schemaframework.TableDefinition; | |
/** | |
* 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 VehicleTableCreator extends org.eclipse.persistence.tools.schemaframework.TableCreator { | |
public VehicleTableCreator() { | |
setName("Vehicle"); | |
addTableDefinition(buildCAROWNERTable()); | |
addTableDefinition(buildSPORTSCARTable()); | |
addTableDefinition(buildFUELTYPETable()); | |
addTableDefinition(buildENGINETYPETable()); | |
} | |
public TableDefinition buildCAROWNERTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("CAROWNER"); | |
FieldDefinition fieldCARID = new FieldDefinition(); | |
fieldCARID.setName("CARID"); | |
fieldCARID.setTypeName("NUMBER"); | |
fieldCARID.setSize(4); | |
fieldCARID.setSubSize(0); | |
fieldCARID.setIsPrimaryKey(false); | |
fieldCARID.setIsIdentity(false); | |
fieldCARID.setUnique(false); | |
fieldCARID.setShouldAllowNull(false); | |
table.addField(fieldCARID); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("NUMBER"); | |
fieldID.setSize(8); | |
fieldID.setSubSize(0); | |
fieldID.setIsPrimaryKey(true); | |
fieldID.setIsIdentity(false); | |
fieldID.setUnique(false); | |
fieldID.setShouldAllowNull(false); | |
table.addField(fieldID); | |
FieldDefinition fieldLASTCARID = new FieldDefinition(); | |
fieldLASTCARID.setName("LASTCARID"); | |
fieldLASTCARID.setTypeName("NUMBER"); | |
fieldLASTCARID.setSize(4); | |
fieldLASTCARID.setSubSize(0); | |
fieldLASTCARID.setIsPrimaryKey(false); | |
fieldLASTCARID.setIsIdentity(false); | |
fieldLASTCARID.setUnique(false); | |
fieldLASTCARID.setShouldAllowNull(false); | |
table.addField(fieldLASTCARID); | |
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(false); | |
table.addField(fieldNAME); | |
return table; | |
} | |
public TableDefinition buildENGINETYPETable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("ENGINETYPE"); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("NUMBER"); | |
fieldID.setSize(4); | |
fieldID.setSubSize(0); | |
fieldID.setIsPrimaryKey(true); | |
fieldID.setIsIdentity(false); | |
fieldID.setUnique(false); | |
fieldID.setShouldAllowNull(false); | |
table.addField(fieldID); | |
FieldDefinition fieldTYPE = new FieldDefinition(); | |
fieldTYPE.setName("TYPE"); | |
fieldTYPE.setTypeName("VARCHAR2"); | |
fieldTYPE.setSize(40); | |
fieldTYPE.setSubSize(0); | |
fieldTYPE.setIsPrimaryKey(false); | |
fieldTYPE.setIsIdentity(false); | |
fieldTYPE.setUnique(false); | |
fieldTYPE.setShouldAllowNull(false); | |
table.addField(fieldTYPE); | |
return table; | |
} | |
public TableDefinition buildFUELTYPETable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("FUELTYPE"); | |
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(false); | |
table.addField(fieldDESCRIPTION); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("NUMBER"); | |
fieldID.setSize(4); | |
fieldID.setSubSize(0); | |
fieldID.setIsPrimaryKey(true); | |
fieldID.setIsIdentity(false); | |
fieldID.setUnique(false); | |
fieldID.setShouldAllowNull(false); | |
table.addField(fieldID); | |
return table; | |
} | |
public TableDefinition buildSPORTSCARTable() { | |
TableDefinition table = new TableDefinition(); | |
table.setName("SPORTSCAR"); | |
FieldDefinition fieldDESCRIPTION = new FieldDefinition(); | |
fieldDESCRIPTION.setName("DESCRIPTION"); | |
fieldDESCRIPTION.setTypeName("VARCHAR2"); | |
fieldDESCRIPTION.setSize(20); | |
fieldDESCRIPTION.setSubSize(0); | |
fieldDESCRIPTION.setIsPrimaryKey(false); | |
fieldDESCRIPTION.setIsIdentity(false); | |
fieldDESCRIPTION.setUnique(false); | |
fieldDESCRIPTION.setShouldAllowNull(false); | |
table.addField(fieldDESCRIPTION); | |
FieldDefinition fieldENGINEID = new FieldDefinition(); | |
fieldENGINEID.setName("ENGINEID"); | |
fieldENGINEID.setTypeName("NUMBER"); | |
fieldENGINEID.setSize(4); | |
fieldENGINEID.setSubSize(0); | |
fieldENGINEID.setIsPrimaryKey(false); | |
fieldENGINEID.setIsIdentity(false); | |
fieldENGINEID.setUnique(false); | |
fieldENGINEID.setShouldAllowNull(false); | |
table.addField(fieldENGINEID); | |
FieldDefinition fieldFUELCAPACITY = new FieldDefinition(); | |
fieldFUELCAPACITY.setName("FUELCAPACITY"); | |
fieldFUELCAPACITY.setTypeName("NUMBER"); | |
fieldFUELCAPACITY.setSize(4); | |
fieldFUELCAPACITY.setSubSize(0); | |
fieldFUELCAPACITY.setIsPrimaryKey(false); | |
fieldFUELCAPACITY.setIsIdentity(false); | |
fieldFUELCAPACITY.setUnique(false); | |
fieldFUELCAPACITY.setShouldAllowNull(false); | |
table.addField(fieldFUELCAPACITY); | |
FieldDefinition fieldFUELID = new FieldDefinition(); | |
fieldFUELID.setName("FUELID"); | |
fieldFUELID.setTypeName("NUMBER"); | |
fieldFUELID.setSize(4); | |
fieldFUELID.setSubSize(0); | |
fieldFUELID.setIsPrimaryKey(false); | |
fieldFUELID.setIsIdentity(false); | |
fieldFUELID.setUnique(false); | |
fieldFUELID.setShouldAllowNull(false); | |
table.addField(fieldFUELID); | |
FieldDefinition fieldID = new FieldDefinition(); | |
fieldID.setName("ID"); | |
fieldID.setTypeName("NUMBER"); | |
fieldID.setSize(4); | |
fieldID.setSubSize(0); | |
fieldID.setIsPrimaryKey(true); | |
fieldID.setIsIdentity(false); | |
fieldID.setUnique(false); | |
fieldID.setShouldAllowNull(false); | |
table.addField(fieldID); | |
return table; | |
} | |
} |