| /* |
| * 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: |
| // 05/05/2009 Andrei Ilitchev |
| // - JPA 2.0 - OrderedList support. |
| package org.eclipse.persistence.testing.models.orderedlist; |
| |
| /** |
| * TopLink generated Project class. |
| * <b>WARNING</b>: This code was generated by an automated tool. |
| * Any changes will be lost when the code is re-generated |
| */ |
| public class EmployeeTableCreator extends org.eclipse.persistence.tools.schemaframework.TableCreator { |
| |
| public EmployeeTableCreator() { |
| applyPROJECT(); |
| buildALLOWANCE(); |
| buildCHILDTable(); |
| buildEMPLOYEETable(); |
| buildLPROJECTTable(); |
| buildPHONETable(); |
| buildPROJ_EMPTable(); |
| buildPROJECTTable(); |
| buildRESPONSTable(); |
| buildSALARYTable(); |
| } |
| |
| protected void applyPROJECT() { |
| setName("OL_Employee"); |
| } |
| |
| protected void buildALLOWANCE() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_ALLOWANCE"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("OWNER_CHILD_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(true); |
| field.setUnique(false); |
| field.setIsIdentity(false); |
| field.setForeignKeyFieldName("OL_CHILD.CHILD_ID"); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("ALLOWANCE"); |
| field1.setTypeName("INT"); |
| field1.setSize(10); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field5 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field5.setName("PARENT_ID"); |
| field5.setTypeName("NUMERIC"); |
| field5.setSize(15); |
| field5.setShouldAllowNull(true); |
| field5.setIsPrimaryKey(false); |
| field5.setUnique(false); |
| field5.setIsIdentity(false); |
| field5.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field5); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field6 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field6.setName("CHILDREN_ORDER"); |
| field6.setTypeName("NUMERIC"); |
| field6.setSize(15); |
| field6.setShouldAllowNull(true); |
| field6.setIsPrimaryKey(false); |
| field6.setUnique(false); |
| field6.setIsIdentity(false); |
| tabledefinition.addField(field6); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field7 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field7.setName("CHILDREN_ORDER_VARCHAR"); |
| field7.setTypeName("VARCHAR"); |
| field7.setSize(40); |
| field7.setShouldAllowNull(true); |
| field7.setIsPrimaryKey(false); |
| field7.setUnique(false); |
| field7.setIsIdentity(false); |
| tabledefinition.addField(field7); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildCHILDTable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_CHILD"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("CHILD_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(true); |
| field.setUnique(false); |
| field.setIsIdentity(true); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("F_NAME"); |
| field1.setTypeName("VARCHAR"); |
| field1.setSize(40); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field2.setName("L_NAME"); |
| field2.setTypeName("VARCHAR"); |
| field2.setSize(40); |
| field2.setShouldAllowNull(true); |
| field2.setIsPrimaryKey(false); |
| field2.setUnique(false); |
| field2.setIsIdentity(false); |
| tabledefinition.addField(field2); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field5 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field5.setName("PARENT_ID"); |
| field5.setTypeName("NUMERIC"); |
| field5.setSize(15); |
| field5.setShouldAllowNull(true); |
| field5.setIsPrimaryKey(false); |
| field5.setUnique(false); |
| field5.setIsIdentity(false); |
| field5.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field5); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field6 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field6.setName("CHILDREN_ORDER"); |
| field6.setTypeName("NUMERIC"); |
| field6.setSize(15); |
| field6.setShouldAllowNull(true); |
| field6.setIsPrimaryKey(false); |
| field6.setUnique(false); |
| field6.setIsIdentity(false); |
| tabledefinition.addField(field6); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field7 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field7.setName("CHILDREN_ORDER_VARCHAR"); |
| field7.setTypeName("VARCHAR"); |
| field7.setSize(40); |
| field7.setShouldAllowNull(true); |
| field7.setIsPrimaryKey(false); |
| field7.setUnique(false); |
| field7.setIsIdentity(false); |
| tabledefinition.addField(field7); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildEMPLOYEETable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_EMPLOYEE"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("EMP_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(true); |
| field.setUnique(false); |
| field.setIsIdentity(true); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("F_NAME"); |
| field1.setTypeName("VARCHAR"); |
| field1.setSize(40); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field2.setName("L_NAME"); |
| field2.setTypeName("VARCHAR"); |
| field2.setSize(40); |
| field2.setShouldAllowNull(true); |
| field2.setIsPrimaryKey(false); |
| field2.setUnique(false); |
| field2.setIsIdentity(false); |
| tabledefinition.addField(field2); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field7 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field7.setName("GENDER"); |
| field7.setTypeName("VARCHAR"); |
| field7.setSize(1); |
| field7.setShouldAllowNull(true); |
| field7.setIsPrimaryKey(false); |
| field7.setUnique(false); |
| field7.setIsIdentity(false); |
| tabledefinition.addField(field7); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field9 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field9.setName("MANAGER_ID"); |
| field9.setTypeName("NUMERIC"); |
| field9.setSize(15); |
| field9.setShouldAllowNull(true); |
| field9.setIsPrimaryKey(false); |
| field9.setUnique(false); |
| field9.setIsIdentity(false); |
| field9.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field9); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field10 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field10.setName("VERSION"); |
| field10.setTypeName("NUMERIC"); |
| field10.setSize(15); |
| field10.setShouldAllowNull(true); |
| field10.setIsPrimaryKey(false); |
| field10.setUnique(false); |
| field10.setIsIdentity(false); |
| tabledefinition.addField(field10); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field11 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field11.setName("MANAGED_ORDER"); |
| field11.setTypeName("NUMERIC"); |
| field11.setSize(15); |
| field11.setShouldAllowNull(true); |
| field11.setIsPrimaryKey(false); |
| field11.setUnique(false); |
| field11.setIsIdentity(false); |
| tabledefinition.addField(field11); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field12 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field12.setName("MANAGED_ORDER_VARCHAR"); |
| field12.setTypeName("VARCHAR"); |
| field12.setSize(40); |
| field12.setShouldAllowNull(true); |
| field12.setIsPrimaryKey(false); |
| field12.setUnique(false); |
| field12.setIsIdentity(false); |
| tabledefinition.addField(field12); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildLPROJECTTable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_LPROJECT"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("PROJ_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(true); |
| field.setUnique(false); |
| field.setIsIdentity(false); |
| field.setForeignKeyFieldName("OL_PROJECT.PROJ_ID"); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("BUDGET"); |
| field1.setTypeName("DOUBLE PRECIS"); |
| field1.setSize(18); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field2.setName("MILESTONE"); |
| field2.setTypeName("DATETIME"); |
| field2.setSize(6); |
| field2.setShouldAllowNull(true); |
| field2.setIsPrimaryKey(false); |
| field2.setUnique(false); |
| field2.setIsIdentity(false); |
| tabledefinition.addField(field2); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildPHONETable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_PHONE"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("OWNER_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(false); |
| field.setUnique(false); |
| field.setIsIdentity(false); |
| field.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("TYPE"); |
| field1.setTypeName("VARCHAR"); |
| field1.setSize(15); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field2.setName("AREA_CODE"); |
| field2.setTypeName("VARCHAR"); |
| field2.setSize(3); |
| field2.setShouldAllowNull(true); |
| field2.setIsPrimaryKey(false); |
| field2.setUnique(false); |
| field2.setIsIdentity(false); |
| tabledefinition.addField(field2); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field3.setName("P_NUMBER"); |
| field3.setTypeName("VARCHAR"); |
| field3.setSize(7); |
| field3.setShouldAllowNull(true); |
| field3.setIsPrimaryKey(false); |
| field3.setUnique(false); |
| field3.setIsIdentity(false); |
| tabledefinition.addField(field3); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field6 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field6.setName("PHONE_ORDER"); |
| field6.setTypeName("NUMERIC"); |
| field6.setSize(15); |
| field6.setShouldAllowNull(true); |
| field6.setIsPrimaryKey(false); |
| field6.setUnique(false); |
| field6.setIsIdentity(false); |
| tabledefinition.addField(field6); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field7 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field7.setName("PHONE_ORDER_VARCHAR"); |
| field7.setTypeName("VARCHAR"); |
| field7.setSize(40); |
| field7.setShouldAllowNull(true); |
| field7.setIsPrimaryKey(false); |
| field7.setUnique(false); |
| field7.setIsIdentity(false); |
| tabledefinition.addField(field7); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildPROJ_EMPTable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_PROJ_EMP"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("EMP_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(true); |
| field.setUnique(false); |
| field.setIsIdentity(false); |
| field.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("PROJ_ID"); |
| field1.setTypeName("NUMERIC"); |
| field1.setSize(15); |
| field1.setShouldAllowNull(false); |
| field1.setIsPrimaryKey(true); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| field1.setForeignKeyFieldName("OL_PROJECT.PROJ_ID"); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field3.setName("PROJ_ORDER"); |
| field3.setTypeName("NUMERIC"); |
| field3.setSize(15); |
| field3.setShouldAllowNull(true); |
| field3.setIsPrimaryKey(false); |
| field3.setUnique(false); |
| field3.setIsIdentity(false); |
| tabledefinition.addField(field3); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field5 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field5.setName("PROJ_ORDER_VARCHAR"); |
| field5.setTypeName("VARCHAR"); |
| field5.setSize(40); |
| field5.setShouldAllowNull(true); |
| field5.setIsPrimaryKey(false); |
| field5.setUnique(false); |
| field5.setIsIdentity(false); |
| tabledefinition.addField(field5); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildPROJECTTable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_PROJECT"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("PROJ_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(true); |
| field.setUnique(false); |
| field.setIsIdentity(true); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("PROJ_TYPE"); |
| field1.setTypeName("VARCHAR"); |
| field1.setSize(1); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field2.setName("PROJ_NAME"); |
| field2.setTypeName("VARCHAR"); |
| field2.setSize(30); |
| field2.setShouldAllowNull(true); |
| field2.setIsPrimaryKey(false); |
| field2.setUnique(false); |
| field2.setIsIdentity(false); |
| tabledefinition.addField(field2); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field3.setName("DESCRIP"); |
| field3.setTypeName("VARCHAR"); |
| field3.setSize(200); |
| field3.setShouldAllowNull(true); |
| field3.setIsPrimaryKey(false); |
| field3.setUnique(false); |
| field3.setIsIdentity(false); |
| tabledefinition.addField(field3); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field4 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field4.setName("LEADER_ID"); |
| field4.setTypeName("NUMERIC"); |
| field4.setSize(15); |
| field4.setShouldAllowNull(true); |
| field4.setIsPrimaryKey(false); |
| field4.setUnique(false); |
| field4.setIsIdentity(false); |
| field4.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field4); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field5 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field5.setName("VERSION"); |
| field5.setTypeName("NUMERIC"); |
| field5.setSize(15); |
| field5.setShouldAllowNull(true); |
| field5.setIsPrimaryKey(false); |
| field5.setUnique(false); |
| field5.setIsIdentity(false); |
| tabledefinition.addField(field5); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field6 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field6.setName("PROJECTS_LED_ORDER"); |
| field6.setTypeName("NUMERIC"); |
| field6.setSize(15); |
| field6.setShouldAllowNull(true); |
| field6.setIsPrimaryKey(false); |
| field6.setUnique(false); |
| field6.setIsIdentity(false); |
| tabledefinition.addField(field6); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildRESPONSTable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_RESPONS"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("EMP_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(false); |
| field.setUnique(false); |
| field.setIsIdentity(false); |
| field.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("DESCRIP"); |
| field1.setTypeName("VARCHAR"); |
| field1.setSize(200); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field6 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field6.setName("RESPONS_ORDER"); |
| field6.setTypeName("NUMERIC"); |
| field6.setSize(15); |
| field6.setShouldAllowNull(true); |
| field6.setIsPrimaryKey(false); |
| field6.setUnique(false); |
| field6.setIsIdentity(false); |
| tabledefinition.addField(field6); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field7 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field7.setName("RESPONS_ORDER_VARCHAR"); |
| field7.setTypeName("VARCHAR"); |
| field7.setSize(40); |
| field7.setShouldAllowNull(true); |
| field7.setIsPrimaryKey(false); |
| field7.setUnique(false); |
| field7.setIsIdentity(false); |
| tabledefinition.addField(field7); |
| |
| addTableDefinition(tabledefinition); |
| } |
| |
| protected void buildSALARYTable() { |
| org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition = new org.eclipse.persistence.tools.schemaframework.TableDefinition(); |
| |
| // SECTION: TABLE |
| tabledefinition.setName("OL_SALARY"); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field.setName("OWNER_EMP_ID"); |
| field.setTypeName("NUMERIC"); |
| field.setSize(15); |
| field.setShouldAllowNull(false); |
| field.setIsPrimaryKey(true); |
| field.setUnique(false); |
| field.setIsIdentity(false); |
| field.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field1.setName("SALARY"); |
| field1.setTypeName("INT"); |
| field1.setSize(10); |
| field1.setShouldAllowNull(true); |
| field1.setIsPrimaryKey(false); |
| field1.setUnique(false); |
| field1.setIsIdentity(false); |
| tabledefinition.addField(field1); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field9 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field9.setName("MANAGER_ID"); |
| field9.setTypeName("NUMERIC"); |
| field9.setSize(15); |
| field9.setShouldAllowNull(true); |
| field9.setIsPrimaryKey(false); |
| field9.setUnique(false); |
| field9.setIsIdentity(false); |
| field9.setForeignKeyFieldName("OL_EMPLOYEE.EMP_ID"); |
| tabledefinition.addField(field9); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field11 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field11.setName("MANAGED_ORDER"); |
| field11.setTypeName("NUMERIC"); |
| field11.setSize(15); |
| field11.setShouldAllowNull(true); |
| field11.setIsPrimaryKey(false); |
| field11.setUnique(false); |
| field11.setIsIdentity(false); |
| tabledefinition.addField(field11); |
| |
| // SECTION: FIELD |
| org.eclipse.persistence.tools.schemaframework.FieldDefinition field12 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition(); |
| field12.setName("MANAGED_ORDER_VARCHAR"); |
| field12.setTypeName("VARCHAR"); |
| field12.setSize(40); |
| field12.setShouldAllowNull(true); |
| field12.setIsPrimaryKey(false); |
| field12.setUnique(false); |
| field12.setIsIdentity(false); |
| tabledefinition.addField(field12); |
| |
| addTableDefinition(tabledefinition); |
| } |
| } |