/*******************************************************************************
* 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
* 01/28/2009-2.0 Guy Pelletier
* - 248293: JPA 2.0 Element Collections (part 1)
* 03/27/2009-2.0 Guy Pelletier
* - 241413: JPA 2.0 Add EclipseLink support for Map type attributes
* 04/03/2009-2.0 Guy Pelletier
* - 241413: JPA 2.0 Add EclipseLink support for Map type attributes
* 06/02/2009-2.0 Guy Pelletier
* - 278768: JPA 2.0 Association Override Join Table
* 06/09/2009-2.0 Guy Pelletier
* - 249037: JPA 2.0 persisting list item index
* 02/18/2010-2.0.2 Guy Pelletier
* - 294803: @Column(updatable=false) has no effect on @Basic mappings
* 06/03/2011-2.3.1 Guy Pelletier
* - 347563: transient field/property in embeddable entity
******************************************************************************/
package org.eclipse.persistence.testing.models.jpa.xml.inherited;
import org.eclipse.persistence.sessions.Session;
import org.eclipse.persistence.sessions.DatabaseSession;
import org.eclipse.persistence.tools.schemaframework.TableCreator;
import org.eclipse.persistence.tools.schemaframework.TableDefinition;
import org.eclipse.persistence.tools.schemaframework.FieldDefinition;
public class InheritedTableManager extends TableCreator {
public static TableCreator tableCreator;
public InheritedTableManager() {
setName("EJB3BeerProject");
addTableDefinition(build_BEER_CONSUMER_Table());
addTableDefinition(build_BEER_CONSUMER_REDSTRIPES_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_AWARDS_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_ACCLAIMS_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_AUDIO_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_CELEBRATIONS_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_COMMITTEE_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_DESIGNATIONS_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_QUOTES_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_RECORDS_Table());
addTableDefinition(build_EXPERT_BEER_CONSUMER_ACCREDIDATION_WITNESS_Table());
addTableDefinition(build_NOVICE_BEER_CONSUMER_Table());
addTableDefinition(build_NOVICE_BEER_CONSUMER_AWARDS_Table());
addTableDefinition(build_NOVICE_BEER_CONSUMER_ACCLAIMS_Table());
addTableDefinition(build_NOVICE_BEER_CONSUMER_COMMITTEE_Table());
addTableDefinition(build_NOVICE_BEER_CONSUMER_DESIGNATIONS_Table());
addTableDefinition(build_NOVICE_BEER_CONSUMER_RECORDS_Table());
addTableDefinition(build_NOVICE_BEER_CONSUMER_ACCREDIDATION_WITNESS_Table());
addTableDefinition(build_ALPINE_Table());
addTableDefinition(build_BECKS_Table());
addTableDefinition(build_BECKS_TAG_Table());
addTableDefinition(build_CANADIAN_Table());
addTableDefinition(build_CORONA_Table());
addTableDefinition(build_HEINEKEN_Table());
addTableDefinition(build_OFFICIAL_Table());
addTableDefinition(build_OFFICIAL_COMPENSATIONTable());
addTableDefinition(build_WITNESS_Table());
addTableDefinition(build_CERTIFICATION_Table());
addTableDefinition(build_COMMITTEE_Table());
addTableDefinition(build_TELEPHONE_NUMBER_Table());
addTableDefinition(build_LOCATION_Table());
}
public static TableDefinition build_ALPINE_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_ALPINE");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ALPINE_ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition ALCOHOL_CONTENT_field = new FieldDefinition();
ALCOHOL_CONTENT_field.setName("ALCOHOL_CONTENT");
ALCOHOL_CONTENT_field.setTypeName("DOUBLE PRECIS");
ALCOHOL_CONTENT_field.setSize(15);
ALCOHOL_CONTENT_field.setIsPrimaryKey(false);
ALCOHOL_CONTENT_field.setUnique(false);
ALCOHOL_CONTENT_field.setIsIdentity(false);
ALCOHOL_CONTENT_field.setShouldAllowNull(true);
table.addField(ALCOHOL_CONTENT_field);
FieldDefinition BEST_BEFORE_DATE_field = new FieldDefinition();
BEST_BEFORE_DATE_field.setName("BB_DATE");
BEST_BEFORE_DATE_field.setTypeName("DATETIME");
BEST_BEFORE_DATE_field.setSize(6);
BEST_BEFORE_DATE_field.setIsPrimaryKey(false);
BEST_BEFORE_DATE_field.setUnique(false);
BEST_BEFORE_DATE_field.setIsIdentity(false);
BEST_BEFORE_DATE_field.setShouldAllowNull(true);
table.addField(BEST_BEFORE_DATE_field);
FieldDefinition CLASSIFICATION_field = new FieldDefinition();
CLASSIFICATION_field.setName("CLASSIFICATION");
CLASSIFICATION_field.setTypeName("NUMERIC");
CLASSIFICATION_field.setSize(15);
CLASSIFICATION_field.setIsPrimaryKey(false);
CLASSIFICATION_field.setUnique(false);
CLASSIFICATION_field.setIsIdentity(false);
CLASSIFICATION_field.setShouldAllowNull(true);
table.addField(CLASSIFICATION_field);
FieldDefinition BEER_CONSUMER_ID_field = new FieldDefinition();
BEER_CONSUMER_ID_field.setName("C_ID");
BEER_CONSUMER_ID_field.setTypeName("NUMERIC");
BEER_CONSUMER_ID_field.setSize(15);
BEER_CONSUMER_ID_field.setIsPrimaryKey(false);
BEER_CONSUMER_ID_field.setUnique(false);
BEER_CONSUMER_ID_field.setIsIdentity(false);
BEER_CONSUMER_ID_field.setShouldAllowNull(true);
BEER_CONSUMER_ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(BEER_CONSUMER_ID_field);
return table;
}
public static TableDefinition build_BECKS_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_BECKS");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition ALCOHOL_CONTENT_field = new FieldDefinition();
ALCOHOL_CONTENT_field.setName("ALCOHOL_CONTENT");
ALCOHOL_CONTENT_field.setTypeName("DOUBLE PRECIS");
ALCOHOL_CONTENT_field.setSize(15);
ALCOHOL_CONTENT_field.setIsPrimaryKey(false);
ALCOHOL_CONTENT_field.setUnique(false);
ALCOHOL_CONTENT_field.setIsIdentity(false);
ALCOHOL_CONTENT_field.setShouldAllowNull(true);
table.addField(ALCOHOL_CONTENT_field);
FieldDefinition BECKS_TAG_field = new FieldDefinition();
BECKS_TAG_field.setName("TAG_ID");
BECKS_TAG_field.setTypeName("NUMERIC");
BECKS_TAG_field.setSize(15);
BECKS_TAG_field.setIsPrimaryKey(false);
BECKS_TAG_field.setUnique(false);
BECKS_TAG_field.setIsIdentity(false);
BECKS_TAG_field.setShouldAllowNull(true);
BECKS_TAG_field.setForeignKeyFieldName("CMP3_XML_BECKS_TAG.ID");
table.addField(BECKS_TAG_field);
FieldDefinition BEER_CONSUMER_ID_field = new FieldDefinition();
BEER_CONSUMER_ID_field.setName("C_ID");
BEER_CONSUMER_ID_field.setTypeName("NUMERIC");
BEER_CONSUMER_ID_field.setSize(15);
BEER_CONSUMER_ID_field.setIsPrimaryKey(false);
BEER_CONSUMER_ID_field.setUnique(false);
BEER_CONSUMER_ID_field.setIsIdentity(false);
BEER_CONSUMER_ID_field.setShouldAllowNull(true);
BEER_CONSUMER_ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(BEER_CONSUMER_ID_field);
FieldDefinition VERSION_field = new FieldDefinition();
VERSION_field.setName("VERSION");
VERSION_field.setTypeName("DATETIME");
VERSION_field.setSize(6);
VERSION_field.setIsPrimaryKey(false);
VERSION_field.setUnique(false);
VERSION_field.setIsIdentity(false);
VERSION_field.setShouldAllowNull(true);
table.addField(VERSION_field);
return table;
}
public static TableDefinition build_BECKS_TAG_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_BECKS_TAG");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition CALL_NUMBER_field = new FieldDefinition();
CALL_NUMBER_field.setName("CALL_NUMBER");
CALL_NUMBER_field.setTypeName("VARCHAR");
CALL_NUMBER_field.setSize(40);
CALL_NUMBER_field.setShouldAllowNull(true);
CALL_NUMBER_field.setIsPrimaryKey(false);
CALL_NUMBER_field.setUnique(false);
CALL_NUMBER_field.setIsIdentity(false);
table.addField(CALL_NUMBER_field);
return table;
}
public static TableDefinition build_BEER_CONSUMER_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_CONSUMER");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition NAME_field = new FieldDefinition();
NAME_field.setName("NAME");
NAME_field.setTypeName("VARCHAR");
NAME_field.setSize(40);
NAME_field.setShouldAllowNull(true);
NAME_field.setIsPrimaryKey(false);
NAME_field.setUnique(false);
NAME_field.setIsIdentity(false);
table.addField(NAME_field);
FieldDefinition DTYPE_field = new FieldDefinition();
DTYPE_field.setName("DTYPE");
DTYPE_field.setTypeName("VARCHAR2");
DTYPE_field.setSize(3);
DTYPE_field.setSubSize(0);
DTYPE_field.setIsPrimaryKey(false);
DTYPE_field.setIsIdentity(false);
DTYPE_field.setUnique(false);
DTYPE_field.setShouldAllowNull(true);
table.addField(DTYPE_field);
return table;
}
public static TableDefinition build_BEER_CONSUMER_REDSTRIPES_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_CONSUMER_REDSTRIPES");
FieldDefinition ALCOHOL_CONTENT_field = new FieldDefinition();
ALCOHOL_CONTENT_field.setName("ALCOHOLCONTENT");
ALCOHOL_CONTENT_field.setTypeName("DOUBLE PRECIS");
ALCOHOL_CONTENT_field.setSize(15);
ALCOHOL_CONTENT_field.setIsPrimaryKey(false);
ALCOHOL_CONTENT_field.setUnique(false);
ALCOHOL_CONTENT_field.setIsIdentity(false);
ALCOHOL_CONTENT_field.setShouldAllowNull(true);
table.addField(ALCOHOL_CONTENT_field);
FieldDefinition RS_KEY_field = new FieldDefinition();
RS_KEY_field.setName("RS_KEY");
RS_KEY_field.setTypeName("VARCHAR");
RS_KEY_field.setSize(10);
RS_KEY_field.setShouldAllowNull(false);
RS_KEY_field.setIsPrimaryKey(false);
RS_KEY_field.setUnique(true);
RS_KEY_field.setIsIdentity(false);
table.addField(RS_KEY_field);
FieldDefinition BEER_CONSUMER_ID_field = new FieldDefinition();
BEER_CONSUMER_ID_field.setName("C_ID");
BEER_CONSUMER_ID_field.setTypeName("NUMERIC");
BEER_CONSUMER_ID_field.setSize(15);
BEER_CONSUMER_ID_field.setIsPrimaryKey(false);
BEER_CONSUMER_ID_field.setUnique(false);
BEER_CONSUMER_ID_field.setIsIdentity(false);
BEER_CONSUMER_ID_field.setShouldAllowNull(true);
BEER_CONSUMER_ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(BEER_CONSUMER_ID_field);
return table;
}
public static TableDefinition build_CANADIAN_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_CANADIAN");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("CANADIAN_ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition ALCOHOL_CONTENT_field = new FieldDefinition();
ALCOHOL_CONTENT_field.setName("ALCOHOL_CONTENT");
ALCOHOL_CONTENT_field.setTypeName("DOUBLE PRECIS");
ALCOHOL_CONTENT_field.setSize(15);
ALCOHOL_CONTENT_field.setIsPrimaryKey(false);
ALCOHOL_CONTENT_field.setUnique(false);
ALCOHOL_CONTENT_field.setIsIdentity(false);
ALCOHOL_CONTENT_field.setShouldAllowNull(true);
table.addField(ALCOHOL_CONTENT_field);
FieldDefinition BORN_ON_DATE_field = new FieldDefinition();
BORN_ON_DATE_field.setName("BORN");
BORN_ON_DATE_field.setTypeName("DATETIME");
BORN_ON_DATE_field.setSize(6);
BORN_ON_DATE_field.setIsPrimaryKey(false);
BORN_ON_DATE_field.setUnique(false);
BORN_ON_DATE_field.setIsIdentity(false);
BORN_ON_DATE_field.setShouldAllowNull(true);
table.addField(BORN_ON_DATE_field);
FieldDefinition FLAVOR_field = new FieldDefinition();
FLAVOR_field.setName("FLAVOR");
FLAVOR_field.setTypeName("VARCHAR");
FLAVOR_field.setSize(23);
FLAVOR_field.setIsPrimaryKey(false);
FLAVOR_field.setUnique(false);
FLAVOR_field.setIsIdentity(false);
FLAVOR_field.setShouldAllowNull(true);
table.addField(FLAVOR_field);
FieldDefinition BEER_CONSUMER_ID_field = new FieldDefinition();
BEER_CONSUMER_ID_field.setName("CONSUMER_ID");
BEER_CONSUMER_ID_field.setTypeName("NUMERIC");
BEER_CONSUMER_ID_field.setSize(15);
BEER_CONSUMER_ID_field.setIsPrimaryKey(false);
BEER_CONSUMER_ID_field.setUnique(false);
BEER_CONSUMER_ID_field.setIsIdentity(false);
BEER_CONSUMER_ID_field.setShouldAllowNull(true);
BEER_CONSUMER_ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(BEER_CONSUMER_ID_field);
return table;
}
public static TableDefinition build_CORONA_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_CORONA");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition ALCOHOL_CONTENT_field = new FieldDefinition();
ALCOHOL_CONTENT_field.setName("ALCOHOL_CONTENT");
ALCOHOL_CONTENT_field.setTypeName("DOUBLE PRECIS");
ALCOHOL_CONTENT_field.setSize(15);
ALCOHOL_CONTENT_field.setIsPrimaryKey(false);
ALCOHOL_CONTENT_field.setUnique(false);
ALCOHOL_CONTENT_field.setIsIdentity(false);
ALCOHOL_CONTENT_field.setShouldAllowNull(true);
table.addField(ALCOHOL_CONTENT_field);
FieldDefinition TAG_NUMBER_field = new FieldDefinition();
TAG_NUMBER_field.setName("TAG_NUMBER");
TAG_NUMBER_field.setTypeName("NUMERIC");
TAG_NUMBER_field.setSize(15);
TAG_NUMBER_field.setIsPrimaryKey(false);
TAG_NUMBER_field.setUnique(false);
TAG_NUMBER_field.setIsIdentity(false);
TAG_NUMBER_field.setShouldAllowNull(true);
table.addField(TAG_NUMBER_field);
FieldDefinition TAG_CODE_field = new FieldDefinition();
TAG_CODE_field.setName("TAG_CODE");
TAG_CODE_field.setTypeName("VARCHAR");
TAG_CODE_field.setSize(10);
TAG_CODE_field.setShouldAllowNull(true);
TAG_CODE_field.setIsPrimaryKey(false);
TAG_CODE_field.setUnique(false);
TAG_CODE_field.setIsIdentity(false);
table.addField(TAG_CODE_field);
FieldDefinition BEER_CONSUMER_ID_field = new FieldDefinition();
BEER_CONSUMER_ID_field.setName("C_ID");
BEER_CONSUMER_ID_field.setTypeName("NUMERIC");
BEER_CONSUMER_ID_field.setSize(15);
BEER_CONSUMER_ID_field.setIsPrimaryKey(false);
BEER_CONSUMER_ID_field.setUnique(false);
BEER_CONSUMER_ID_field.setIsIdentity(false);
BEER_CONSUMER_ID_field.setShouldAllowNull(true);
BEER_CONSUMER_ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(BEER_CONSUMER_ID_field);
FieldDefinition VERSION_field = new FieldDefinition();
VERSION_field.setName("VERSION");
VERSION_field.setTypeName("DATETIME");
VERSION_field.setSize(6);
VERSION_field.setIsPrimaryKey(false);
VERSION_field.setUnique(false);
VERSION_field.setIsIdentity(false);
VERSION_field.setShouldAllowNull(true);
table.addField(VERSION_field);
return table;
}
public static TableDefinition build_CERTIFICATION_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_CERTIFICATION");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(true);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition MAP_KEY_field = new FieldDefinition();
MAP_KEY_field.setName("MAPKEY");
MAP_KEY_field.setTypeName("NUMERIC");
MAP_KEY_field.setSize(15);
MAP_KEY_field.setIsPrimaryKey(false);
MAP_KEY_field.setUnique(true);
MAP_KEY_field.setIsIdentity(false);
MAP_KEY_field.setShouldAllowNull(false);
table.addField(MAP_KEY_field);
FieldDefinition DESCRIPTION_field = new FieldDefinition();
DESCRIPTION_field.setName("DESCRIPTION");
DESCRIPTION_field.setTypeName("VARCHAR");
DESCRIPTION_field.setSize(40);
DESCRIPTION_field.setShouldAllowNull(true);
DESCRIPTION_field.setIsPrimaryKey(false);
DESCRIPTION_field.setUnique(false);
DESCRIPTION_field.setIsIdentity(false);
table.addField(DESCRIPTION_field);
FieldDefinition BEER_CONSUMER_ID_field = new FieldDefinition();
BEER_CONSUMER_ID_field.setName("CONSUMER_ID");
BEER_CONSUMER_ID_field.setTypeName("NUMERIC");
BEER_CONSUMER_ID_field.setSize(15);
BEER_CONSUMER_ID_field.setIsPrimaryKey(false);
BEER_CONSUMER_ID_field.setUnique(false);
BEER_CONSUMER_ID_field.setIsIdentity(false);
BEER_CONSUMER_ID_field.setShouldAllowNull(true);
BEER_CONSUMER_ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(BEER_CONSUMER_ID_field);
return table;
}
public static TableDefinition build_COMMITTEE_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_COMMITTEE");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition DESCRIPTION_field = new FieldDefinition();
DESCRIPTION_field.setName("DESCRIP");
DESCRIPTION_field.setTypeName("VARCHAR");
DESCRIPTION_field.setSize(40);
DESCRIPTION_field.setShouldAllowNull(true);
DESCRIPTION_field.setIsPrimaryKey(false);
DESCRIPTION_field.setUnique(false);
DESCRIPTION_field.setIsIdentity(false);
table.addField(DESCRIPTION_field);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EXPERT_CONSUMER");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(ID_field);
FieldDefinition IQ_field = new FieldDefinition();
IQ_field.setName("CONSUMER_IQ");
IQ_field.setTypeName("NUMERIC");
IQ_field.setSize(15);
IQ_field.setShouldAllowNull(true);
IQ_field.setIsPrimaryKey(false);
IQ_field.setUnique(false);
IQ_field.setIsIdentity(false);
table.addField(IQ_field);
FieldDefinition ACCREDIDATION_field = new FieldDefinition();
ACCREDIDATION_field.setName("ACCREDIDATION");
ACCREDIDATION_field.setTypeName("VARCHAR");
ACCREDIDATION_field.setSize(40);
ACCREDIDATION_field.setShouldAllowNull(true);
ACCREDIDATION_field.setIsPrimaryKey(false);
ACCREDIDATION_field.setUnique(false);
ACCREDIDATION_field.setIsIdentity(false);
table.addField(ACCREDIDATION_field);
return table;
}
public static TableDefinition build_HEINEKEN_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_HEINEKEN");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition ALCOHOL_CONTENT_field = new FieldDefinition();
ALCOHOL_CONTENT_field.setName("ALCOHOL_CONTENT");
ALCOHOL_CONTENT_field.setTypeName("DOUBLE PRECIS");
ALCOHOL_CONTENT_field.setSize(15);
ALCOHOL_CONTENT_field.setIsPrimaryKey(false);
ALCOHOL_CONTENT_field.setUnique(false);
ALCOHOL_CONTENT_field.setIsIdentity(false);
ALCOHOL_CONTENT_field.setShouldAllowNull(true);
table.addField(ALCOHOL_CONTENT_field);
FieldDefinition BOTTLED_DATE_field = new FieldDefinition();
BOTTLED_DATE_field.setName("BOTTLED_DATE");
BOTTLED_DATE_field.setTypeName("DATETIME");
BOTTLED_DATE_field.setSize(6);
BOTTLED_DATE_field.setIsPrimaryKey(false);
BOTTLED_DATE_field.setUnique(false);
BOTTLED_DATE_field.setIsIdentity(false);
BOTTLED_DATE_field.setShouldAllowNull(true);
table.addField(BOTTLED_DATE_field);
FieldDefinition BEER_CONSUMER_ID_field = new FieldDefinition();
BEER_CONSUMER_ID_field.setName("C_ID");
BEER_CONSUMER_ID_field.setTypeName("NUMERIC");
BEER_CONSUMER_ID_field.setSize(15);
BEER_CONSUMER_ID_field.setIsPrimaryKey(false);
BEER_CONSUMER_ID_field.setUnique(false);
BEER_CONSUMER_ID_field.setIsIdentity(false);
BEER_CONSUMER_ID_field.setShouldAllowNull(true);
BEER_CONSUMER_ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(BEER_CONSUMER_ID_field);
FieldDefinition VERSION_field = new FieldDefinition();
VERSION_field.setName("VERSION");
VERSION_field.setTypeName("DATETIME");
VERSION_field.setSize(6);
VERSION_field.setIsPrimaryKey(false);
VERSION_field.setUnique(false);
VERSION_field.setIsIdentity(false);
VERSION_field.setShouldAllowNull(true);
table.addField(VERSION_field);
return table;
}
public static TableDefinition build_LOCATION_Table() {
TableDefinition table = new TableDefinition();
table.setName("JPA2_XML_LOCATION");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("VARCHAR");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition CITY_field = new FieldDefinition();
CITY_field.setName("CITY");
CITY_field.setTypeName("VARCHAR");
CITY_field.setSize(40);
CITY_field.setShouldAllowNull(false);
CITY_field.setIsPrimaryKey(false);
CITY_field.setUnique(false);
CITY_field.setIsIdentity(false);
table.addField(CITY_field);
FieldDefinition COUNTRY_field = new FieldDefinition();
COUNTRY_field.setName("COUNTRY");
COUNTRY_field.setTypeName("VARCHAR");
COUNTRY_field.setSize(40);
COUNTRY_field.setShouldAllowNull(false);
COUNTRY_field.setIsPrimaryKey(false);
COUNTRY_field.setUnique(false);
COUNTRY_field.setIsIdentity(false);
table.addField(COUNTRY_field);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_ACCLAIMS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_ACCLAIMS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_EBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition field1 = new FieldDefinition();
field1.setName("ACCLAIM");
field1.setTypeName("VARCHAR");
field1.setSize(20);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_ACCREDIDATION_WITNESS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_ACCREDIDATION_WITNESS");
FieldDefinition fieldCONSUMERID = new FieldDefinition();
fieldCONSUMERID.setName("XML_EBC_ID");
fieldCONSUMERID.setTypeName("NUMERIC");
fieldCONSUMERID.setSize(15);
fieldCONSUMERID.setShouldAllowNull(false);
fieldCONSUMERID.setIsPrimaryKey(true);
fieldCONSUMERID.setUnique(false);
fieldCONSUMERID.setIsIdentity(false);
fieldCONSUMERID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldCONSUMERID);
FieldDefinition fieldWITNESSID = new FieldDefinition();
fieldWITNESSID.setName("XML_WITNESS_ID");
fieldWITNESSID.setTypeName("NUMERIC");
fieldWITNESSID.setSize(15);
fieldWITNESSID.setShouldAllowNull(false);
fieldWITNESSID.setIsPrimaryKey(true);
fieldWITNESSID.setUnique(false);
fieldWITNESSID.setIsIdentity(false);
fieldWITNESSID.setForeignKeyFieldName("XML_WITNESS.ID");
table.addField(fieldWITNESSID);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_AUDIO_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_AUDIO");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_EBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldAUDIO = new FieldDefinition();
fieldAUDIO.setName("AUDIO");
fieldAUDIO.setTypeName("BLOB");
fieldAUDIO.setSize(0);
fieldAUDIO.setSubSize(0);
fieldAUDIO.setIsPrimaryKey(false);
fieldAUDIO.setIsIdentity(false);
fieldAUDIO.setUnique(false);
fieldAUDIO.setShouldAllowNull(true);
table.addField(fieldAUDIO);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_AWARDS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_AWARDS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_EBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldAWARDS_KEY = new FieldDefinition();
fieldAWARDS_KEY.setName("AWARDS_KEY");
fieldAWARDS_KEY.setTypeName("VARCHAR");
fieldAWARDS_KEY.setSize(20);
fieldAWARDS_KEY.setShouldAllowNull(false);
fieldAWARDS_KEY.setIsPrimaryKey(false);
fieldAWARDS_KEY.setUnique(true);
fieldAWARDS_KEY.setIsIdentity(false);
table.addField(fieldAWARDS_KEY);
FieldDefinition fieldAWARD_CODE = new FieldDefinition();
fieldAWARD_CODE.setName("AWARD_CODE");
fieldAWARD_CODE.setTypeName("VARCHAR");
fieldAWARD_CODE.setSize(20);
fieldAWARD_CODE.setShouldAllowNull(false);
fieldAWARD_CODE.setIsPrimaryKey(false);
fieldAWARD_CODE.setUnique(false);
fieldAWARD_CODE.setIsIdentity(false);
table.addField(fieldAWARD_CODE);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_CELEBRATIONS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_CELEBRATIONS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_EBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition DETAILS_field = new FieldDefinition();
DETAILS_field.setName("DETAILS");
DETAILS_field.setTypeName("VARCHAR");
DETAILS_field.setSize(40);
DETAILS_field.setShouldAllowNull(true);
DETAILS_field.setIsPrimaryKey(false);
DETAILS_field.setUnique(false);
DETAILS_field.setIsIdentity(false);
table.addField(DETAILS_field);
FieldDefinition BIRTH_DAY_field = new FieldDefinition();
BIRTH_DAY_field.setName("BIRTH_DAY");
BIRTH_DAY_field.setTypeName("NUMERIC");
BIRTH_DAY_field.setSize(2);
BIRTH_DAY_field.setShouldAllowNull(true);
BIRTH_DAY_field.setIsPrimaryKey(false);
BIRTH_DAY_field.setUnique(false);
BIRTH_DAY_field.setIsIdentity(false);
table.addField(BIRTH_DAY_field);
FieldDefinition BIRTH_MONTH_field = new FieldDefinition();
BIRTH_MONTH_field.setName("BIRTH_MONTH");
BIRTH_MONTH_field.setTypeName("NUMERIC");
BIRTH_MONTH_field.setSize(2);
BIRTH_MONTH_field.setShouldAllowNull(true);
BIRTH_MONTH_field.setIsPrimaryKey(false);
BIRTH_MONTH_field.setUnique(false);
BIRTH_MONTH_field.setIsIdentity(false);
table.addField(BIRTH_MONTH_field);
FieldDefinition BIRTH_YEAR_field = new FieldDefinition();
BIRTH_YEAR_field.setName("BIRTH_YEAR");
BIRTH_YEAR_field.setTypeName("NUMERIC");
BIRTH_YEAR_field.setSize(4);
BIRTH_YEAR_field.setShouldAllowNull(true);
BIRTH_YEAR_field.setIsPrimaryKey(false);
BIRTH_YEAR_field.setUnique(false);
BIRTH_YEAR_field.setIsIdentity(false);
table.addField(BIRTH_YEAR_field);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_COMMITTEE_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_COMMITTEE");
FieldDefinition fieldCONSUMERID = new FieldDefinition();
fieldCONSUMERID.setName("XML_EBC_ID");
fieldCONSUMERID.setTypeName("NUMERIC");
fieldCONSUMERID.setSize(15);
fieldCONSUMERID.setShouldAllowNull(false);
fieldCONSUMERID.setIsPrimaryKey(true);
fieldCONSUMERID.setUnique(false);
fieldCONSUMERID.setIsIdentity(false);
fieldCONSUMERID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldCONSUMERID);
FieldDefinition fieldCOMMITTEEID = new FieldDefinition();
fieldCOMMITTEEID.setName("XML_COMMITTEE_ID");
fieldCOMMITTEEID.setTypeName("NUMERIC");
fieldCOMMITTEEID.setSize(15);
fieldCOMMITTEEID.setShouldAllowNull(false);
fieldCOMMITTEEID.setIsPrimaryKey(true);
fieldCOMMITTEEID.setUnique(false);
fieldCOMMITTEEID.setIsIdentity(false);
fieldCOMMITTEEID.setForeignKeyFieldName("XML_COMMITTEE.ID");
table.addField(fieldCOMMITTEEID);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_DESIGNATIONS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_DESIGNATIONS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_EBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldDESIGNATION = new FieldDefinition();
fieldDESIGNATION.setName("DESIGNATION");
fieldDESIGNATION.setTypeName("VARCHAR");
fieldDESIGNATION.setSize(20);
fieldDESIGNATION.setShouldAllowNull(false);
fieldDESIGNATION.setIsPrimaryKey(false);
fieldDESIGNATION.setUnique(false);
fieldDESIGNATION.setIsIdentity(false);
table.addField(fieldDESIGNATION);
FieldDefinition fieldDESIGNATIONS_ORDER = new FieldDefinition();
fieldDESIGNATIONS_ORDER.setName("designations_ORDER");
fieldDESIGNATIONS_ORDER.setTypeName("NUMERIC");
fieldDESIGNATIONS_ORDER.setSize(15);
fieldDESIGNATIONS_ORDER.setShouldAllowNull(true);
fieldDESIGNATIONS_ORDER.setIsPrimaryKey(false);
fieldDESIGNATIONS_ORDER.setUnique(false);
fieldDESIGNATIONS_ORDER.setIsIdentity(false);
table.addField(fieldDESIGNATIONS_ORDER);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_QUOTES_Table() {
TableDefinition table = new TableDefinition();
table.setName("EBC_QUOTES");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("EBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldQ_DATE = new FieldDefinition();
fieldQ_DATE.setName("Q_DATE");
fieldQ_DATE.setTypeName("DATE");
fieldQ_DATE.setSize(23);
fieldQ_DATE.setShouldAllowNull(true);
fieldQ_DATE.setIsPrimaryKey(false);
fieldQ_DATE.setUnique(false);
fieldQ_DATE.setIsIdentity(false);
table.addField(fieldQ_DATE);
FieldDefinition fieldQUOTE = new FieldDefinition();
fieldQUOTE.setName("QUOTE");
fieldQUOTE.setTypeName("VARCHAR");
fieldQUOTE.setSize(50);
fieldQUOTE.setShouldAllowNull(false);
fieldQUOTE.setIsPrimaryKey(false);
fieldQUOTE.setUnique(false);
fieldQUOTE.setIsIdentity(false);
table.addField(fieldQUOTE);
return table;
}
public static TableDefinition build_EXPERT_BEER_CONSUMER_RECORDS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_EBC_RECORDS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_EBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldQ_DATE = new FieldDefinition();
fieldQ_DATE.setName("RECORD_DATE");
fieldQ_DATE.setTypeName("DATE");
fieldQ_DATE.setSize(23);
fieldQ_DATE.setShouldAllowNull(true);
fieldQ_DATE.setIsPrimaryKey(false);
fieldQ_DATE.setUnique(false);
fieldQ_DATE.setIsIdentity(false);
table.addField(fieldQ_DATE);
FieldDefinition DESCRIP_field = new FieldDefinition();
DESCRIP_field.setName("DESCRIPTION");
DESCRIP_field.setTypeName("VARCHAR");
DESCRIP_field.setSize(40);
DESCRIP_field.setShouldAllowNull(true);
DESCRIP_field.setIsPrimaryKey(false);
DESCRIP_field.setUnique(false);
DESCRIP_field.setIsIdentity(false);
table.addField(DESCRIP_field);
FieldDefinition LOCATION_ID_field = new FieldDefinition();
LOCATION_ID_field.setName("LOCATION_ID");
LOCATION_ID_field.setTypeName("VARCHAR");
LOCATION_ID_field.setSize(15);
LOCATION_ID_field.setIsPrimaryKey(true);
LOCATION_ID_field.setUnique(false);
LOCATION_ID_field.setIsIdentity(false);
LOCATION_ID_field.setShouldAllowNull(false);
LOCATION_ID_field.setForeignKeyFieldName("JPA2_XML_LOCATION.ID");
table.addField(LOCATION_ID_field);
return table;
}
public static TableDefinition build_NOVICE_BEER_CONSUMER_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_NOVICE_CONSUMER");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(ID_field);
FieldDefinition IQ_field = new FieldDefinition();
IQ_field.setName("CONSUMER_IQ");
IQ_field.setTypeName("NUMERIC");
IQ_field.setSize(15);
IQ_field.setShouldAllowNull(true);
IQ_field.setIsPrimaryKey(false);
IQ_field.setUnique(false);
IQ_field.setIsIdentity(false);
table.addField(IQ_field);
FieldDefinition ACCREDIDATION_field = new FieldDefinition();
ACCREDIDATION_field.setName("ACCR_DETAILS");
ACCREDIDATION_field.setTypeName("VARCHAR");
ACCREDIDATION_field.setSize(40);
ACCREDIDATION_field.setShouldAllowNull(true);
ACCREDIDATION_field.setIsPrimaryKey(false);
ACCREDIDATION_field.setUnique(false);
ACCREDIDATION_field.setIsIdentity(false);
table.addField(ACCREDIDATION_field);
return table;
}
public static TableDefinition build_NOVICE_BEER_CONSUMER_ACCLAIMS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_NBC_ACCLAIMS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_NBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_NOVICE_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition field1 = new FieldDefinition();
field1.setName("ACCLAIM");
field1.setTypeName("NUMERIC");
field1.setSize(10);
field1.setShouldAllowNull(false);
field1.setIsPrimaryKey(false);
field1.setUnique(false);
field1.setIsIdentity(false);
table.addField(field1);
return table;
}
public static TableDefinition build_NOVICE_BEER_CONSUMER_ACCREDIDATION_WITNESS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_NBC_ACCREDITATION_WITNESS");
FieldDefinition fieldCONSUMERID = new FieldDefinition();
fieldCONSUMERID.setName("XML_NBC_ID");
fieldCONSUMERID.setTypeName("NUMERIC");
fieldCONSUMERID.setSize(15);
fieldCONSUMERID.setShouldAllowNull(false);
fieldCONSUMERID.setIsPrimaryKey(true);
fieldCONSUMERID.setUnique(false);
fieldCONSUMERID.setIsIdentity(false);
fieldCONSUMERID.setForeignKeyFieldName("XML_NOVICE_CONSUMER.ID");
table.addField(fieldCONSUMERID);
FieldDefinition fieldWITNESSID = new FieldDefinition();
fieldWITNESSID.setName("XML_WITNESSID");
fieldWITNESSID.setTypeName("NUMERIC");
fieldWITNESSID.setSize(15);
fieldWITNESSID.setShouldAllowNull(false);
fieldWITNESSID.setIsPrimaryKey(true);
fieldWITNESSID.setUnique(false);
fieldWITNESSID.setIsIdentity(false);
fieldWITNESSID.setForeignKeyFieldName("XML_WITNESS.ID");
table.addField(fieldWITNESSID);
return table;
}
public static TableDefinition build_NOVICE_BEER_CONSUMER_AWARDS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_NBC_AWARDS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_NBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_NOVICE_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldAWARDS_KEY = new FieldDefinition();
fieldAWARDS_KEY.setName("AWARDS_KEY");
fieldAWARDS_KEY.setTypeName("NUMERIC");
fieldAWARDS_KEY.setSize(10);
fieldAWARDS_KEY.setShouldAllowNull(false);
fieldAWARDS_KEY.setIsPrimaryKey(false);
fieldAWARDS_KEY.setUnique(true);
fieldAWARDS_KEY.setIsIdentity(false);
table.addField(fieldAWARDS_KEY);
FieldDefinition fieldAWARD_CODE = new FieldDefinition();
fieldAWARD_CODE.setName("AWARD_CODE");
fieldAWARD_CODE.setTypeName("NUMERIC");
fieldAWARD_CODE.setSize(10);
fieldAWARD_CODE.setShouldAllowNull(false);
fieldAWARD_CODE.setIsPrimaryKey(false);
fieldAWARD_CODE.setUnique(false);
fieldAWARD_CODE.setIsIdentity(false);
table.addField(fieldAWARD_CODE);
return table;
}
public static TableDefinition build_NOVICE_BEER_CONSUMER_COMMITTEE_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_NBC_COMMITTEE");
FieldDefinition fieldCONSUMERID = new FieldDefinition();
fieldCONSUMERID.setName("XML_NBC_ID");
fieldCONSUMERID.setTypeName("NUMERIC");
fieldCONSUMERID.setSize(15);
fieldCONSUMERID.setShouldAllowNull(false);
fieldCONSUMERID.setIsPrimaryKey(true);
fieldCONSUMERID.setUnique(false);
fieldCONSUMERID.setIsIdentity(false);
fieldCONSUMERID.setForeignKeyFieldName("XML_NOVICE_CONSUMER.ID");
table.addField(fieldCONSUMERID);
FieldDefinition fieldCOMMITTEEID = new FieldDefinition();
fieldCOMMITTEEID.setName("XML_COM_ID");
fieldCOMMITTEEID.setTypeName("NUMERIC");
fieldCOMMITTEEID.setSize(15);
fieldCOMMITTEEID.setShouldAllowNull(false);
fieldCOMMITTEEID.setIsPrimaryKey(true);
fieldCOMMITTEEID.setUnique(false);
fieldCOMMITTEEID.setIsIdentity(false);
fieldCOMMITTEEID.setForeignKeyFieldName("XML_COMMITTEE.ID");
table.addField(fieldCOMMITTEEID);
return table;
}
public static TableDefinition build_NOVICE_BEER_CONSUMER_DESIGNATIONS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_NBC_DESIGNATIONS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_NBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_NOVICE_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldDESIGNATION = new FieldDefinition();
fieldDESIGNATION.setName("DESIGNATION");
fieldDESIGNATION.setTypeName("VARCHAR");
fieldDESIGNATION.setSize(20);
fieldDESIGNATION.setShouldAllowNull(false);
fieldDESIGNATION.setIsPrimaryKey(false);
fieldDESIGNATION.setUnique(false);
fieldDESIGNATION.setIsIdentity(false);
table.addField(fieldDESIGNATION);
FieldDefinition fieldDESIGNATIONS_ORDER = new FieldDefinition();
fieldDESIGNATIONS_ORDER.setName("designations_ORDER");
fieldDESIGNATIONS_ORDER.setTypeName("NUMERIC");
fieldDESIGNATIONS_ORDER.setSize(15);
fieldDESIGNATIONS_ORDER.setShouldAllowNull(true);
fieldDESIGNATIONS_ORDER.setIsPrimaryKey(false);
fieldDESIGNATIONS_ORDER.setUnique(false);
fieldDESIGNATIONS_ORDER.setIsIdentity(false);
table.addField(fieldDESIGNATIONS_ORDER);
return table;
}
public static TableDefinition build_NOVICE_BEER_CONSUMER_RECORDS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_NBC_RECORDS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("XML_NBC_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("XML_NOVICE_CONSUMER.ID");
table.addField(fieldID);
FieldDefinition fieldQ_DATE = new FieldDefinition();
fieldQ_DATE.setName("REC_DATE");
fieldQ_DATE.setTypeName("DATE");
fieldQ_DATE.setSize(23);
fieldQ_DATE.setShouldAllowNull(true);
fieldQ_DATE.setIsPrimaryKey(false);
fieldQ_DATE.setUnique(false);
fieldQ_DATE.setIsIdentity(false);
table.addField(fieldQ_DATE);
FieldDefinition DESCRIP_field = new FieldDefinition();
DESCRIP_field.setName("DESCRIP");
DESCRIP_field.setTypeName("VARCHAR");
DESCRIP_field.setSize(40);
DESCRIP_field.setShouldAllowNull(true);
DESCRIP_field.setIsPrimaryKey(false);
DESCRIP_field.setUnique(false);
DESCRIP_field.setIsIdentity(false);
table.addField(DESCRIP_field);
FieldDefinition LOCATION_ID_field = new FieldDefinition();
LOCATION_ID_field.setName("LOC_ID");
LOCATION_ID_field.setTypeName("VARCHAR");
LOCATION_ID_field.setSize(15);
LOCATION_ID_field.setIsPrimaryKey(true);
LOCATION_ID_field.setUnique(false);
LOCATION_ID_field.setIsIdentity(false);
LOCATION_ID_field.setShouldAllowNull(false);
LOCATION_ID_field.setForeignKeyFieldName("JPA2_XML_LOCATION.ID");
table.addField(LOCATION_ID_field);
return table;
}
public static TableDefinition build_OFFICIAL_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_OFFICIAL");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition DESCRIPTION_field = new FieldDefinition();
DESCRIPTION_field.setName("NAME");
DESCRIPTION_field.setTypeName("VARCHAR");
DESCRIPTION_field.setSize(40);
DESCRIPTION_field.setShouldAllowNull(true);
DESCRIPTION_field.setIsPrimaryKey(false);
DESCRIPTION_field.setUnique(false);
DESCRIPTION_field.setIsIdentity(false);
table.addField(DESCRIPTION_field);
FieldDefinition AGE_field = new FieldDefinition();
AGE_field.setName("AGE");
AGE_field.setTypeName("NUMERIC");
AGE_field.setSize(15);
AGE_field.setIsPrimaryKey(false);
AGE_field.setUnique(false);
AGE_field.setIsIdentity(false);
AGE_field.setShouldAllowNull(true);
table.addField(AGE_field);
FieldDefinition fieldSTARTDATE = new FieldDefinition();
fieldSTARTDATE.setName("START_DATE");
fieldSTARTDATE.setTypeName("VARCHAR");
fieldSTARTDATE.setSize(40);
fieldSTARTDATE.setShouldAllowNull(true);
fieldSTARTDATE.setIsPrimaryKey(false);
fieldSTARTDATE.setUnique(false);
fieldSTARTDATE.setIsIdentity(false);
table.addField(fieldSTARTDATE);
FieldDefinition fieldENDDATE = new FieldDefinition();
fieldENDDATE.setName("END_DATE");
fieldENDDATE.setTypeName("VARCHAR");
fieldENDDATE.setSize(40);
fieldENDDATE.setShouldAllowNull(true);
fieldENDDATE.setIsPrimaryKey(false);
fieldENDDATE.setUnique(false);
fieldENDDATE.setIsIdentity(false);
table.addField(fieldENDDATE);
FieldDefinition EBC_ID_field = new FieldDefinition();
EBC_ID_field.setName("FK_EBC_ID");
EBC_ID_field.setTypeName("NUMERIC");
EBC_ID_field.setSize(15);
EBC_ID_field.setShouldAllowNull(true);
EBC_ID_field.setIsPrimaryKey(false);
EBC_ID_field.setUnique(false);
EBC_ID_field.setIsIdentity(false);
EBC_ID_field.setForeignKeyFieldName("XML_EXPERT_CONSUMER.ID");
table.addField(EBC_ID_field);
FieldDefinition NBC_ID_field = new FieldDefinition();
NBC_ID_field.setName("FK_NBC_ID");
NBC_ID_field.setTypeName("NUMERIC");
NBC_ID_field.setSize(15);
NBC_ID_field.setShouldAllowNull(true);
NBC_ID_field.setIsPrimaryKey(false);
NBC_ID_field.setUnique(false);
NBC_ID_field.setIsIdentity(false);
NBC_ID_field.setForeignKeyFieldName("XML_NOVICE_CONSUMER.ID");
table.addField(NBC_ID_field);
return table;
}
public static TableDefinition build_OFFICIAL_COMPENSATIONTable() {
TableDefinition table = new TableDefinition();
table.setName("XML_OFFICIAL_COMPENSATION");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
ID_field.setForeignKeyFieldName("XML_OFFICIAL.ID");
table.addField(ID_field);
FieldDefinition SALARY_field = new FieldDefinition();
SALARY_field.setName("SALARY");
SALARY_field.setTypeName("NUMERIC");
SALARY_field.setSize(15);
SALARY_field.setIsPrimaryKey(false);
SALARY_field.setUnique(false);
SALARY_field.setIsIdentity(false);
SALARY_field.setShouldAllowNull(true);
table.addField(SALARY_field);
FieldDefinition BONUS_field = new FieldDefinition();
BONUS_field.setName("BONUS");
BONUS_field.setTypeName("NUMERIC");
BONUS_field.setSize(15);
BONUS_field.setIsPrimaryKey(false);
BONUS_field.setUnique(false);
BONUS_field.setIsIdentity(false);
BONUS_field.setShouldAllowNull(true);
table.addField(BONUS_field);
return table;
}
public static TableDefinition build_TELEPHONE_NUMBER_Table() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_TELEPHONE");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("CONSUMER_ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(false);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(true);
ID_field.setForeignKeyFieldName("CMP3_XML_CONSUMER.ID");
table.addField(ID_field);
FieldDefinition TYPE_field = new FieldDefinition();
TYPE_field.setName("TYPE");
TYPE_field.setTypeName("VARCHAR");
TYPE_field.setSize(15);
TYPE_field.setIsPrimaryKey(true);
TYPE_field.setUnique(false);
TYPE_field.setIsIdentity(false);
TYPE_field.setShouldAllowNull(false);
table.addField(TYPE_field);
FieldDefinition AREA_CODE_field = new FieldDefinition();
AREA_CODE_field.setName("AREA_CODE");
AREA_CODE_field.setTypeName("VARCHAR");
AREA_CODE_field.setSize(3);
AREA_CODE_field.setIsPrimaryKey(true);
AREA_CODE_field.setUnique(false);
AREA_CODE_field.setIsIdentity(false);
AREA_CODE_field.setShouldAllowNull(false);
table.addField(AREA_CODE_field);
FieldDefinition NUMBER_field = new FieldDefinition();
NUMBER_field.setName("TNUMBER");
NUMBER_field.setTypeName("VARCHAR");
NUMBER_field.setSize(8);
NUMBER_field.setIsPrimaryKey(true);
NUMBER_field.setUnique(false);
NUMBER_field.setIsIdentity(false);
NUMBER_field.setShouldAllowNull(false);
table.addField(NUMBER_field);
return table;
}
public static TableDefinition build_WITNESS_Table() {
TableDefinition table = new TableDefinition();
table.setName("XML_WITNESS");
FieldDefinition ID_field = new FieldDefinition();
ID_field.setName("ID");
ID_field.setTypeName("NUMERIC");
ID_field.setSize(15);
ID_field.setIsPrimaryKey(true);
ID_field.setUnique(false);
ID_field.setIsIdentity(false);
ID_field.setShouldAllowNull(false);
table.addField(ID_field);
FieldDefinition DESCRIPTION_field = new FieldDefinition();
DESCRIPTION_field.setName("NAME");
DESCRIPTION_field.setTypeName("VARCHAR");
DESCRIPTION_field.setSize(40);
DESCRIPTION_field.setShouldAllowNull(true);
DESCRIPTION_field.setIsPrimaryKey(false);
DESCRIPTION_field.setUnique(false);
DESCRIPTION_field.setIsIdentity(false);
table.addField(DESCRIPTION_field);
return table;
}
public static void createTables(Session session) {
InheritedTableManager.getCreator().createTables((DatabaseSession) session);
}
public static void dropTables(Session session) {
InheritedTableManager.getCreator().dropTables((DatabaseSession) session);
}
public static TableCreator getCreator(){
if (InheritedTableManager.tableCreator == null) {
InheritedTableManager.tableCreator = new InheritedTableManager();
}
return InheritedTableManager.tableCreator;
}
}