| /* |
| * 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: |
| // Oracle - initial API and implementation from Oracle TopLink |
| package org.eclipse.persistence.testing.models.forceupdate; |
| |
| 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 FUVLTableCreator extends TableCreator { |
| |
| public FUVLTableCreator() { |
| setName("FUVL_TL4.0"); |
| |
| addTableDefinition(buildEMPLOYEETLICTable()); |
| addTableDefinition(buildEMPLOYEETLIOTable()); |
| addTableDefinition(buildEMPLOYEEVLICTable()); |
| addTableDefinition(buildEMPLOYEEVLIOTable()); |
| addTableDefinition(buildPHONETLICTable()); |
| addTableDefinition(buildPHONETLIOTable()); |
| addTableDefinition(buildPHONEVLICTable()); |
| addTableDefinition(buildPHONEVLIOTable()); |
| addTableDefinition(buildADDRESSTLICTable()); |
| addTableDefinition(buildADDRESSTLIOTable()); |
| addTableDefinition(buildADDRESSVLICTable()); |
| addTableDefinition(buildADDRESSVLIOTable()); |
| } |
| |
| public TableDefinition buildADDRESSTLICTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("ADDRESSTLIC"); |
| |
| FieldDefinition fieldADDRESS_ID = new FieldDefinition(); |
| fieldADDRESS_ID.setName("ADDRESS_ID"); |
| fieldADDRESS_ID.setTypeName("NUMBER"); |
| fieldADDRESS_ID.setSize(0); |
| fieldADDRESS_ID.setSubSize(0); |
| fieldADDRESS_ID.setIsPrimaryKey(true); |
| fieldADDRESS_ID.setIsIdentity(true); |
| fieldADDRESS_ID.setUnique(false); |
| fieldADDRESS_ID.setShouldAllowNull(false); |
| table.addField(fieldADDRESS_ID); |
| |
| FieldDefinition fieldP_CODE = new FieldDefinition(); |
| fieldP_CODE.setName("P_CODE"); |
| fieldP_CODE.setTypeName("VARCHAR2"); |
| fieldP_CODE.setSize(20); |
| fieldP_CODE.setSubSize(0); |
| fieldP_CODE.setIsPrimaryKey(false); |
| fieldP_CODE.setIsIdentity(false); |
| fieldP_CODE.setUnique(false); |
| fieldP_CODE.setShouldAllowNull(true); |
| table.addField(fieldP_CODE); |
| |
| FieldDefinition fieldCITY = new FieldDefinition(); |
| fieldCITY.setName("CITY"); |
| fieldCITY.setTypeName("VARCHAR2"); |
| fieldCITY.setSize(80); |
| fieldCITY.setSubSize(0); |
| fieldCITY.setIsPrimaryKey(false); |
| fieldCITY.setIsIdentity(false); |
| fieldCITY.setUnique(false); |
| fieldCITY.setShouldAllowNull(true); |
| table.addField(fieldCITY); |
| |
| FieldDefinition fieldPROVINCE = new FieldDefinition(); |
| fieldPROVINCE.setName("PROVINCE"); |
| fieldPROVINCE.setTypeName("VARCHAR2"); |
| fieldPROVINCE.setSize(80); |
| fieldPROVINCE.setSubSize(0); |
| fieldPROVINCE.setIsPrimaryKey(false); |
| fieldPROVINCE.setIsIdentity(false); |
| fieldPROVINCE.setUnique(false); |
| fieldPROVINCE.setShouldAllowNull(true); |
| table.addField(fieldPROVINCE); |
| |
| FieldDefinition fieldSTREET = new FieldDefinition(); |
| fieldSTREET.setName("STREET"); |
| fieldSTREET.setTypeName("VARCHAR2"); |
| fieldSTREET.setSize(80); |
| fieldSTREET.setSubSize(0); |
| fieldSTREET.setIsPrimaryKey(false); |
| fieldSTREET.setIsIdentity(false); |
| fieldSTREET.setUnique(false); |
| fieldSTREET.setShouldAllowNull(true); |
| table.addField(fieldSTREET); |
| |
| FieldDefinition fieldCOUNTORY = new FieldDefinition(); |
| fieldCOUNTORY.setName("COUNTORY"); |
| fieldCOUNTORY.setTypeName("VARCHAR2"); |
| fieldCOUNTORY.setSize(80); |
| fieldCOUNTORY.setSubSize(0); |
| fieldCOUNTORY.setIsPrimaryKey(false); |
| fieldCOUNTORY.setIsIdentity(false); |
| fieldCOUNTORY.setUnique(false); |
| fieldCOUNTORY.setShouldAllowNull(true); |
| table.addField(fieldCOUNTORY); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| //fieldVERSION.setTypeName("DATE"); because DATE can't be translated to TIMESTAMP in DB2 |
| fieldVERSION.setTypeName("TIMESTAMP"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| return table; |
| } |
| |
| public TableDefinition buildADDRESSTLIOTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("ADDRESSTLIO"); |
| |
| FieldDefinition fieldADDRESS_ID = new FieldDefinition(); |
| fieldADDRESS_ID.setName("ADDRESS_ID"); |
| fieldADDRESS_ID.setTypeName("NUMBER"); |
| fieldADDRESS_ID.setSize(0); |
| fieldADDRESS_ID.setSubSize(0); |
| fieldADDRESS_ID.setIsPrimaryKey(true); |
| fieldADDRESS_ID.setIsIdentity(true); |
| fieldADDRESS_ID.setUnique(false); |
| fieldADDRESS_ID.setShouldAllowNull(false); |
| table.addField(fieldADDRESS_ID); |
| |
| FieldDefinition fieldP_CODE = new FieldDefinition(); |
| fieldP_CODE.setName("P_CODE"); |
| fieldP_CODE.setTypeName("VARCHAR2"); |
| fieldP_CODE.setSize(20); |
| fieldP_CODE.setSubSize(0); |
| fieldP_CODE.setIsPrimaryKey(false); |
| fieldP_CODE.setIsIdentity(false); |
| fieldP_CODE.setUnique(false); |
| fieldP_CODE.setShouldAllowNull(true); |
| table.addField(fieldP_CODE); |
| |
| FieldDefinition fieldCITY = new FieldDefinition(); |
| fieldCITY.setName("CITY"); |
| fieldCITY.setTypeName("VARCHAR2"); |
| fieldCITY.setSize(80); |
| fieldCITY.setSubSize(0); |
| fieldCITY.setIsPrimaryKey(false); |
| fieldCITY.setIsIdentity(false); |
| fieldCITY.setUnique(false); |
| fieldCITY.setShouldAllowNull(true); |
| table.addField(fieldCITY); |
| |
| FieldDefinition fieldPROVINCE = new FieldDefinition(); |
| fieldPROVINCE.setName("PROVINCE"); |
| fieldPROVINCE.setTypeName("VARCHAR2"); |
| fieldPROVINCE.setSize(80); |
| fieldPROVINCE.setSubSize(0); |
| fieldPROVINCE.setIsPrimaryKey(false); |
| fieldPROVINCE.setIsIdentity(false); |
| fieldPROVINCE.setUnique(false); |
| fieldPROVINCE.setShouldAllowNull(true); |
| table.addField(fieldPROVINCE); |
| |
| FieldDefinition fieldSTREET = new FieldDefinition(); |
| fieldSTREET.setName("STREET"); |
| fieldSTREET.setTypeName("VARCHAR2"); |
| fieldSTREET.setSize(80); |
| fieldSTREET.setSubSize(0); |
| fieldSTREET.setIsPrimaryKey(false); |
| fieldSTREET.setIsIdentity(false); |
| fieldSTREET.setUnique(false); |
| fieldSTREET.setShouldAllowNull(true); |
| table.addField(fieldSTREET); |
| |
| FieldDefinition fieldCOUNTRY = new FieldDefinition(); |
| fieldCOUNTRY.setName("COUNTRY"); |
| fieldCOUNTRY.setTypeName("VARCHAR2"); |
| fieldCOUNTRY.setSize(80); |
| fieldCOUNTRY.setSubSize(0); |
| fieldCOUNTRY.setIsPrimaryKey(false); |
| fieldCOUNTRY.setIsIdentity(false); |
| fieldCOUNTRY.setUnique(false); |
| fieldCOUNTRY.setShouldAllowNull(true); |
| table.addField(fieldCOUNTRY); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| //fieldVERSION.setTypeName("DATE"); |
| fieldVERSION.setTypeName("TIMESTAMP"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| return table; |
| } |
| |
| public TableDefinition buildADDRESSVLICTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("ADDRESSVLIC"); |
| |
| FieldDefinition fieldADDRESS_ID = new FieldDefinition(); |
| fieldADDRESS_ID.setName("ADDRESS_ID"); |
| fieldADDRESS_ID.setTypeName("NUMBER"); |
| fieldADDRESS_ID.setSize(0); |
| fieldADDRESS_ID.setSubSize(0); |
| fieldADDRESS_ID.setIsPrimaryKey(true); |
| fieldADDRESS_ID.setIsIdentity(true); |
| fieldADDRESS_ID.setUnique(false); |
| fieldADDRESS_ID.setShouldAllowNull(false); |
| table.addField(fieldADDRESS_ID); |
| |
| FieldDefinition fieldP_CODE = new FieldDefinition(); |
| fieldP_CODE.setName("P_CODE"); |
| fieldP_CODE.setTypeName("VARCHAR2"); |
| fieldP_CODE.setSize(20); |
| fieldP_CODE.setSubSize(0); |
| fieldP_CODE.setIsPrimaryKey(false); |
| fieldP_CODE.setIsIdentity(false); |
| fieldP_CODE.setUnique(false); |
| fieldP_CODE.setShouldAllowNull(true); |
| table.addField(fieldP_CODE); |
| |
| FieldDefinition fieldCITY = new FieldDefinition(); |
| fieldCITY.setName("CITY"); |
| fieldCITY.setTypeName("VARCHAR2"); |
| fieldCITY.setSize(80); |
| fieldCITY.setSubSize(0); |
| fieldCITY.setIsPrimaryKey(false); |
| fieldCITY.setIsIdentity(false); |
| fieldCITY.setUnique(false); |
| fieldCITY.setShouldAllowNull(true); |
| table.addField(fieldCITY); |
| |
| FieldDefinition fieldPROVINCE = new FieldDefinition(); |
| fieldPROVINCE.setName("PROVINCE"); |
| fieldPROVINCE.setTypeName("VARCHAR2"); |
| fieldPROVINCE.setSize(80); |
| fieldPROVINCE.setSubSize(0); |
| fieldPROVINCE.setIsPrimaryKey(false); |
| fieldPROVINCE.setIsIdentity(false); |
| fieldPROVINCE.setUnique(false); |
| fieldPROVINCE.setShouldAllowNull(true); |
| table.addField(fieldPROVINCE); |
| |
| FieldDefinition fieldSTREET = new FieldDefinition(); |
| fieldSTREET.setName("STREET"); |
| fieldSTREET.setTypeName("VARCHAR2"); |
| fieldSTREET.setSize(80); |
| fieldSTREET.setSubSize(0); |
| fieldSTREET.setIsPrimaryKey(false); |
| fieldSTREET.setIsIdentity(false); |
| fieldSTREET.setUnique(false); |
| fieldSTREET.setShouldAllowNull(true); |
| table.addField(fieldSTREET); |
| |
| FieldDefinition fieldCOUNTRY = new FieldDefinition(); |
| fieldCOUNTRY.setName("COUNTRY"); |
| fieldCOUNTRY.setTypeName("VARCHAR2"); |
| fieldCOUNTRY.setSize(80); |
| fieldCOUNTRY.setSubSize(0); |
| fieldCOUNTRY.setIsPrimaryKey(false); |
| fieldCOUNTRY.setIsIdentity(false); |
| fieldCOUNTRY.setUnique(false); |
| fieldCOUNTRY.setShouldAllowNull(true); |
| table.addField(fieldCOUNTRY); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| fieldVERSION.setTypeName("NUMBER"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| return table; |
| } |
| |
| public TableDefinition buildADDRESSVLIOTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("ADDRESSVLIO"); |
| |
| FieldDefinition fieldADDRESS_ID = new FieldDefinition(); |
| fieldADDRESS_ID.setName("ADDRESS_ID"); |
| fieldADDRESS_ID.setTypeName("NUMBER"); |
| fieldADDRESS_ID.setSize(0); |
| fieldADDRESS_ID.setSubSize(0); |
| fieldADDRESS_ID.setIsPrimaryKey(true); |
| fieldADDRESS_ID.setIsIdentity(true); |
| fieldADDRESS_ID.setUnique(false); |
| fieldADDRESS_ID.setShouldAllowNull(false); |
| table.addField(fieldADDRESS_ID); |
| |
| FieldDefinition fieldP_CODE = new FieldDefinition(); |
| fieldP_CODE.setName("P_CODE"); |
| fieldP_CODE.setTypeName("VARCHAR2"); |
| fieldP_CODE.setSize(20); |
| fieldP_CODE.setSubSize(0); |
| fieldP_CODE.setIsPrimaryKey(false); |
| fieldP_CODE.setIsIdentity(false); |
| fieldP_CODE.setUnique(false); |
| fieldP_CODE.setShouldAllowNull(true); |
| table.addField(fieldP_CODE); |
| |
| FieldDefinition fieldCITY = new FieldDefinition(); |
| fieldCITY.setName("CITY"); |
| fieldCITY.setTypeName("VARCHAR2"); |
| fieldCITY.setSize(80); |
| fieldCITY.setSubSize(0); |
| fieldCITY.setIsPrimaryKey(false); |
| fieldCITY.setIsIdentity(false); |
| fieldCITY.setUnique(false); |
| fieldCITY.setShouldAllowNull(true); |
| table.addField(fieldCITY); |
| |
| FieldDefinition fieldPROVINCE = new FieldDefinition(); |
| fieldPROVINCE.setName("PROVINCE"); |
| fieldPROVINCE.setTypeName("VARCHAR2"); |
| fieldPROVINCE.setSize(80); |
| fieldPROVINCE.setSubSize(0); |
| fieldPROVINCE.setIsPrimaryKey(false); |
| fieldPROVINCE.setIsIdentity(false); |
| fieldPROVINCE.setUnique(false); |
| fieldPROVINCE.setShouldAllowNull(true); |
| table.addField(fieldPROVINCE); |
| |
| FieldDefinition fieldSTREET = new FieldDefinition(); |
| fieldSTREET.setName("STREET"); |
| fieldSTREET.setTypeName("VARCHAR2"); |
| fieldSTREET.setSize(80); |
| fieldSTREET.setSubSize(0); |
| fieldSTREET.setIsPrimaryKey(false); |
| fieldSTREET.setIsIdentity(false); |
| fieldSTREET.setUnique(false); |
| fieldSTREET.setShouldAllowNull(true); |
| table.addField(fieldSTREET); |
| |
| FieldDefinition fieldCOUNTRY = new FieldDefinition(); |
| fieldCOUNTRY.setName("COUNTRY"); |
| fieldCOUNTRY.setTypeName("VARCHAR2"); |
| fieldCOUNTRY.setSize(80); |
| fieldCOUNTRY.setSubSize(0); |
| fieldCOUNTRY.setIsPrimaryKey(false); |
| fieldCOUNTRY.setIsIdentity(false); |
| fieldCOUNTRY.setUnique(false); |
| fieldCOUNTRY.setShouldAllowNull(true); |
| table.addField(fieldCOUNTRY); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| fieldVERSION.setTypeName("NUMBER"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| return table; |
| } |
| |
| public TableDefinition buildEMPLOYEETLICTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("EMPLOYEETLIC"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldF_NAME = new FieldDefinition(); |
| fieldF_NAME.setName("F_NAME"); |
| fieldF_NAME.setTypeName("VARCHAR2"); |
| fieldF_NAME.setSize(40); |
| fieldF_NAME.setSubSize(0); |
| fieldF_NAME.setIsPrimaryKey(false); |
| fieldF_NAME.setIsIdentity(false); |
| fieldF_NAME.setUnique(false); |
| fieldF_NAME.setShouldAllowNull(true); |
| table.addField(fieldF_NAME); |
| |
| FieldDefinition fieldL_NAME = new FieldDefinition(); |
| fieldL_NAME.setName("L_NAME"); |
| fieldL_NAME.setTypeName("VARCHAR2"); |
| fieldL_NAME.setSize(40); |
| fieldL_NAME.setSubSize(0); |
| fieldL_NAME.setIsPrimaryKey(false); |
| fieldL_NAME.setIsIdentity(false); |
| fieldL_NAME.setUnique(false); |
| fieldL_NAME.setShouldAllowNull(true); |
| table.addField(fieldL_NAME); |
| |
| FieldDefinition fieldGENDER = new FieldDefinition(); |
| fieldGENDER.setName("GENDER"); |
| fieldGENDER.setTypeName("CHAR"); |
| fieldGENDER.setSize(20); |
| fieldGENDER.setSubSize(0); |
| fieldGENDER.setIsPrimaryKey(false); |
| fieldGENDER.setIsIdentity(false); |
| fieldGENDER.setUnique(false); |
| fieldGENDER.setShouldAllowNull(true); |
| table.addField(fieldGENDER); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| //fieldVERSION.setTypeName("DATE"); |
| fieldVERSION.setTypeName("TIMESTAMP"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| FieldDefinition fieldADDR_ID = new FieldDefinition(); |
| fieldADDR_ID.setName("ADDR_ID"); |
| fieldADDR_ID.setTypeName("NUMBER"); |
| fieldADDR_ID.setSize(0); |
| fieldADDR_ID.setSubSize(0); |
| fieldADDR_ID.setIsPrimaryKey(false); |
| fieldADDR_ID.setIsIdentity(false); |
| fieldADDR_ID.setUnique(false); |
| fieldADDR_ID.setShouldAllowNull(true); |
| table.addField(fieldADDR_ID); |
| |
| FieldDefinition fieldSALARY = new FieldDefinition(); |
| fieldSALARY.setName("SALARY"); |
| fieldSALARY.setTypeName("NUMBER"); |
| fieldSALARY.setSize(0); |
| fieldSALARY.setSubSize(0); |
| fieldSALARY.setIsPrimaryKey(false); |
| fieldSALARY.setIsIdentity(false); |
| fieldSALARY.setUnique(false); |
| fieldSALARY.setShouldAllowNull(true); |
| table.addField(fieldSALARY); |
| |
| return table; |
| } |
| |
| public TableDefinition buildEMPLOYEETLIOTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("EMPLOYEETLIO"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldF_NAME = new FieldDefinition(); |
| fieldF_NAME.setName("F_NAME"); |
| fieldF_NAME.setTypeName("VARCHAR2"); |
| fieldF_NAME.setSize(40); |
| fieldF_NAME.setSubSize(0); |
| fieldF_NAME.setIsPrimaryKey(false); |
| fieldF_NAME.setIsIdentity(false); |
| fieldF_NAME.setUnique(false); |
| fieldF_NAME.setShouldAllowNull(true); |
| table.addField(fieldF_NAME); |
| |
| FieldDefinition fieldL_NAME = new FieldDefinition(); |
| fieldL_NAME.setName("L_NAME"); |
| fieldL_NAME.setTypeName("VARCHAR2"); |
| fieldL_NAME.setSize(40); |
| fieldL_NAME.setSubSize(0); |
| fieldL_NAME.setIsPrimaryKey(false); |
| fieldL_NAME.setIsIdentity(false); |
| fieldL_NAME.setUnique(false); |
| fieldL_NAME.setShouldAllowNull(true); |
| table.addField(fieldL_NAME); |
| |
| FieldDefinition fieldGENDER = new FieldDefinition(); |
| fieldGENDER.setName("GENDER"); |
| fieldGENDER.setTypeName("CHAR"); |
| fieldGENDER.setSize(20); |
| fieldGENDER.setSubSize(0); |
| fieldGENDER.setIsPrimaryKey(false); |
| fieldGENDER.setIsIdentity(false); |
| fieldGENDER.setUnique(false); |
| fieldGENDER.setShouldAllowNull(true); |
| table.addField(fieldGENDER); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| //fieldVERSION.setTypeName("DATE"); |
| fieldVERSION.setTypeName("TIMESTAMP"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| FieldDefinition fieldADDR_ID = new FieldDefinition(); |
| fieldADDR_ID.setName("ADDR_ID"); |
| fieldADDR_ID.setTypeName("NUMBER"); |
| fieldADDR_ID.setSize(0); |
| fieldADDR_ID.setSubSize(0); |
| fieldADDR_ID.setIsPrimaryKey(false); |
| fieldADDR_ID.setIsIdentity(false); |
| fieldADDR_ID.setUnique(false); |
| fieldADDR_ID.setShouldAllowNull(true); |
| table.addField(fieldADDR_ID); |
| |
| FieldDefinition fieldSALARY = new FieldDefinition(); |
| fieldSALARY.setName("SALARY"); |
| fieldSALARY.setTypeName("NUMBER"); |
| fieldSALARY.setSize(0); |
| fieldSALARY.setSubSize(0); |
| fieldSALARY.setIsPrimaryKey(false); |
| fieldSALARY.setIsIdentity(false); |
| fieldSALARY.setUnique(false); |
| fieldSALARY.setShouldAllowNull(true); |
| table.addField(fieldSALARY); |
| |
| return table; |
| } |
| |
| public TableDefinition buildEMPLOYEEVLICTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("EMPLOYEEVLIC"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldF_NAME = new FieldDefinition(); |
| fieldF_NAME.setName("F_NAME"); |
| fieldF_NAME.setTypeName("VARCHAR2"); |
| fieldF_NAME.setSize(40); |
| fieldF_NAME.setSubSize(0); |
| fieldF_NAME.setIsPrimaryKey(false); |
| fieldF_NAME.setIsIdentity(false); |
| fieldF_NAME.setUnique(false); |
| fieldF_NAME.setShouldAllowNull(true); |
| table.addField(fieldF_NAME); |
| |
| FieldDefinition fieldL_NAME = new FieldDefinition(); |
| fieldL_NAME.setName("L_NAME"); |
| fieldL_NAME.setTypeName("VARCHAR2"); |
| fieldL_NAME.setSize(40); |
| fieldL_NAME.setSubSize(0); |
| fieldL_NAME.setIsPrimaryKey(false); |
| fieldL_NAME.setIsIdentity(false); |
| fieldL_NAME.setUnique(false); |
| fieldL_NAME.setShouldAllowNull(true); |
| table.addField(fieldL_NAME); |
| |
| FieldDefinition fieldGENDER = new FieldDefinition(); |
| fieldGENDER.setName("GENDER"); |
| fieldGENDER.setTypeName("CHAR"); |
| fieldGENDER.setSize(20); |
| fieldGENDER.setSubSize(0); |
| fieldGENDER.setIsPrimaryKey(false); |
| fieldGENDER.setIsIdentity(false); |
| fieldGENDER.setUnique(false); |
| fieldGENDER.setShouldAllowNull(true); |
| table.addField(fieldGENDER); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| fieldVERSION.setTypeName("NUMBER"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| FieldDefinition fieldADDR_ID = new FieldDefinition(); |
| fieldADDR_ID.setName("ADDR_ID"); |
| fieldADDR_ID.setTypeName("NUMBER"); |
| fieldADDR_ID.setSize(0); |
| fieldADDR_ID.setSubSize(0); |
| fieldADDR_ID.setIsPrimaryKey(false); |
| fieldADDR_ID.setIsIdentity(false); |
| fieldADDR_ID.setUnique(false); |
| fieldADDR_ID.setShouldAllowNull(true); |
| table.addField(fieldADDR_ID); |
| |
| FieldDefinition fieldSALARY = new FieldDefinition(); |
| fieldSALARY.setName("SALARY"); |
| fieldSALARY.setTypeName("NUMBER"); |
| fieldSALARY.setSize(0); |
| fieldSALARY.setSubSize(0); |
| fieldSALARY.setIsPrimaryKey(false); |
| fieldSALARY.setIsIdentity(false); |
| fieldSALARY.setUnique(false); |
| fieldSALARY.setShouldAllowNull(true); |
| table.addField(fieldSALARY); |
| |
| return table; |
| } |
| |
| public TableDefinition buildEMPLOYEEVLIOTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("EMPLOYEEVLIO"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldF_NAME = new FieldDefinition(); |
| fieldF_NAME.setName("F_NAME"); |
| fieldF_NAME.setTypeName("VARCHAR2"); |
| fieldF_NAME.setSize(40); |
| fieldF_NAME.setSubSize(0); |
| fieldF_NAME.setIsPrimaryKey(false); |
| fieldF_NAME.setIsIdentity(false); |
| fieldF_NAME.setUnique(false); |
| fieldF_NAME.setShouldAllowNull(true); |
| table.addField(fieldF_NAME); |
| |
| FieldDefinition fieldL_NAME = new FieldDefinition(); |
| fieldL_NAME.setName("L_NAME"); |
| fieldL_NAME.setTypeName("VARCHAR2"); |
| fieldL_NAME.setSize(40); |
| fieldL_NAME.setSubSize(0); |
| fieldL_NAME.setIsPrimaryKey(false); |
| fieldL_NAME.setIsIdentity(false); |
| fieldL_NAME.setUnique(false); |
| fieldL_NAME.setShouldAllowNull(true); |
| table.addField(fieldL_NAME); |
| |
| FieldDefinition fieldGENDER = new FieldDefinition(); |
| fieldGENDER.setName("GENDER"); |
| fieldGENDER.setTypeName("CHAR"); |
| fieldGENDER.setSize(20); |
| fieldGENDER.setSubSize(0); |
| fieldGENDER.setIsPrimaryKey(false); |
| fieldGENDER.setIsIdentity(false); |
| fieldGENDER.setUnique(false); |
| fieldGENDER.setShouldAllowNull(true); |
| table.addField(fieldGENDER); |
| |
| FieldDefinition fieldVERSION = new FieldDefinition(); |
| fieldVERSION.setName("VERSION"); |
| fieldVERSION.setTypeName("NUMBER"); |
| fieldVERSION.setSize(0); |
| fieldVERSION.setSubSize(0); |
| fieldVERSION.setIsPrimaryKey(false); |
| fieldVERSION.setIsIdentity(false); |
| fieldVERSION.setUnique(false); |
| fieldVERSION.setShouldAllowNull(true); |
| table.addField(fieldVERSION); |
| |
| FieldDefinition fieldADDR_ID = new FieldDefinition(); |
| fieldADDR_ID.setName("ADDR_ID"); |
| fieldADDR_ID.setTypeName("NUMBER"); |
| fieldADDR_ID.setSize(0); |
| fieldADDR_ID.setSubSize(0); |
| fieldADDR_ID.setIsPrimaryKey(false); |
| fieldADDR_ID.setIsIdentity(false); |
| fieldADDR_ID.setUnique(false); |
| fieldADDR_ID.setShouldAllowNull(true); |
| table.addField(fieldADDR_ID); |
| |
| FieldDefinition fieldSALARY = new FieldDefinition(); |
| fieldSALARY.setName("SALARY"); |
| fieldSALARY.setTypeName("NUMBER"); |
| fieldSALARY.setSize(0); |
| fieldSALARY.setSubSize(0); |
| fieldSALARY.setIsPrimaryKey(false); |
| fieldSALARY.setIsIdentity(false); |
| fieldSALARY.setUnique(false); |
| fieldSALARY.setShouldAllowNull(true); |
| table.addField(fieldSALARY); |
| |
| return table; |
| } |
| |
| public TableDefinition buildPHONETLICTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("PHONETLIC"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldTYPE = new FieldDefinition(); |
| fieldTYPE.setName("TYPE"); |
| fieldTYPE.setTypeName("VARCHAR2"); |
| fieldTYPE.setSize(15); |
| fieldTYPE.setSubSize(0); |
| fieldTYPE.setIsPrimaryKey(true); |
| fieldTYPE.setIsIdentity(false); |
| fieldTYPE.setUnique(false); |
| fieldTYPE.setShouldAllowNull(false); |
| table.addField(fieldTYPE); |
| |
| FieldDefinition fieldAREA_CODE = new FieldDefinition(); |
| fieldAREA_CODE.setName("AREA_CODE"); |
| fieldAREA_CODE.setTypeName("VARCHAR2"); |
| fieldAREA_CODE.setSize(3); |
| fieldAREA_CODE.setSubSize(0); |
| fieldAREA_CODE.setIsPrimaryKey(false); |
| fieldAREA_CODE.setIsIdentity(false); |
| fieldAREA_CODE.setUnique(false); |
| fieldAREA_CODE.setShouldAllowNull(true); |
| table.addField(fieldAREA_CODE); |
| |
| FieldDefinition fieldP_NUMBER = new FieldDefinition(); |
| fieldP_NUMBER.setName("P_NUMBER"); |
| fieldP_NUMBER.setTypeName("VARCHAR2"); |
| fieldP_NUMBER.setSize(7); |
| fieldP_NUMBER.setSubSize(0); |
| fieldP_NUMBER.setIsPrimaryKey(false); |
| fieldP_NUMBER.setIsIdentity(false); |
| fieldP_NUMBER.setUnique(false); |
| fieldP_NUMBER.setShouldAllowNull(true); |
| table.addField(fieldP_NUMBER); |
| |
| return table; |
| } |
| |
| public TableDefinition buildPHONETLIOTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("PHONETLIO"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldTYPE = new FieldDefinition(); |
| fieldTYPE.setName("TYPE"); |
| fieldTYPE.setTypeName("VARCHAR2"); |
| fieldTYPE.setSize(15); |
| fieldTYPE.setSubSize(0); |
| fieldTYPE.setIsPrimaryKey(true); |
| fieldTYPE.setIsIdentity(false); |
| fieldTYPE.setUnique(false); |
| fieldTYPE.setShouldAllowNull(false); |
| table.addField(fieldTYPE); |
| |
| FieldDefinition fieldAREA_CODE = new FieldDefinition(); |
| fieldAREA_CODE.setName("AREA_CODE"); |
| fieldAREA_CODE.setTypeName("VARCHAR2"); |
| fieldAREA_CODE.setSize(3); |
| fieldAREA_CODE.setSubSize(0); |
| fieldAREA_CODE.setIsPrimaryKey(false); |
| fieldAREA_CODE.setIsIdentity(false); |
| fieldAREA_CODE.setUnique(false); |
| fieldAREA_CODE.setShouldAllowNull(true); |
| table.addField(fieldAREA_CODE); |
| |
| FieldDefinition fieldP_NUMBER = new FieldDefinition(); |
| fieldP_NUMBER.setName("P_NUMBER"); |
| fieldP_NUMBER.setTypeName("VARCHAR2"); |
| fieldP_NUMBER.setSize(7); |
| fieldP_NUMBER.setSubSize(0); |
| fieldP_NUMBER.setIsPrimaryKey(false); |
| fieldP_NUMBER.setIsIdentity(false); |
| fieldP_NUMBER.setUnique(false); |
| fieldP_NUMBER.setShouldAllowNull(true); |
| table.addField(fieldP_NUMBER); |
| |
| return table; |
| } |
| |
| public TableDefinition buildPHONEVLICTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("PHONEVLIC"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldTYPE = new FieldDefinition(); |
| fieldTYPE.setName("TYPE"); |
| fieldTYPE.setTypeName("VARCHAR2"); |
| fieldTYPE.setSize(15); |
| fieldTYPE.setSubSize(0); |
| fieldTYPE.setIsPrimaryKey(true); |
| fieldTYPE.setIsIdentity(false); |
| fieldTYPE.setUnique(false); |
| fieldTYPE.setShouldAllowNull(false); |
| table.addField(fieldTYPE); |
| |
| FieldDefinition fieldAREA_CODE = new FieldDefinition(); |
| fieldAREA_CODE.setName("AREA_CODE"); |
| fieldAREA_CODE.setTypeName("VARCHAR2"); |
| fieldAREA_CODE.setSize(3); |
| fieldAREA_CODE.setSubSize(0); |
| fieldAREA_CODE.setIsPrimaryKey(false); |
| fieldAREA_CODE.setIsIdentity(false); |
| fieldAREA_CODE.setUnique(false); |
| fieldAREA_CODE.setShouldAllowNull(true); |
| table.addField(fieldAREA_CODE); |
| |
| FieldDefinition fieldP_NUMBER = new FieldDefinition(); |
| fieldP_NUMBER.setName("P_NUMBER"); |
| fieldP_NUMBER.setTypeName("VARCHAR2"); |
| fieldP_NUMBER.setSize(7); |
| fieldP_NUMBER.setSubSize(0); |
| fieldP_NUMBER.setIsPrimaryKey(false); |
| fieldP_NUMBER.setIsIdentity(false); |
| fieldP_NUMBER.setUnique(false); |
| fieldP_NUMBER.setShouldAllowNull(true); |
| table.addField(fieldP_NUMBER); |
| |
| return table; |
| } |
| |
| public TableDefinition buildPHONEVLIOTable() { |
| TableDefinition table = new TableDefinition(); |
| table.setName("PHONEVLIO"); |
| |
| FieldDefinition fieldEMP_ID = new FieldDefinition(); |
| fieldEMP_ID.setName("EMP_ID"); |
| fieldEMP_ID.setTypeName("NUMBER"); |
| fieldEMP_ID.setSize(0); |
| fieldEMP_ID.setSubSize(0); |
| fieldEMP_ID.setIsPrimaryKey(true); |
| fieldEMP_ID.setIsIdentity(false); |
| fieldEMP_ID.setUnique(false); |
| fieldEMP_ID.setShouldAllowNull(false); |
| table.addField(fieldEMP_ID); |
| |
| FieldDefinition fieldTYPE = new FieldDefinition(); |
| fieldTYPE.setName("TYPE"); |
| fieldTYPE.setTypeName("VARCHAR2"); |
| fieldTYPE.setSize(15); |
| fieldTYPE.setSubSize(0); |
| fieldTYPE.setIsPrimaryKey(true); |
| fieldTYPE.setIsIdentity(false); |
| fieldTYPE.setUnique(false); |
| fieldTYPE.setShouldAllowNull(false); |
| table.addField(fieldTYPE); |
| |
| FieldDefinition fieldAREA_CODE = new FieldDefinition(); |
| fieldAREA_CODE.setName("AREA_CODE"); |
| fieldAREA_CODE.setTypeName("VARCHAR2"); |
| fieldAREA_CODE.setSize(3); |
| fieldAREA_CODE.setSubSize(0); |
| fieldAREA_CODE.setIsPrimaryKey(false); |
| fieldAREA_CODE.setIsIdentity(false); |
| fieldAREA_CODE.setUnique(false); |
| fieldAREA_CODE.setShouldAllowNull(true); |
| table.addField(fieldAREA_CODE); |
| |
| FieldDefinition fieldP_NUMBER = new FieldDefinition(); |
| fieldP_NUMBER.setName("P_NUMBER"); |
| fieldP_NUMBER.setTypeName("VARCHAR2"); |
| fieldP_NUMBER.setSize(7); |
| fieldP_NUMBER.setSubSize(0); |
| fieldP_NUMBER.setIsPrimaryKey(false); |
| fieldP_NUMBER.setIsIdentity(false); |
| fieldP_NUMBER.setUnique(false); |
| fieldP_NUMBER.setShouldAllowNull(true); |
| table.addField(fieldP_NUMBER); |
| |
| return table; |
| } |
| |
| } |