/*******************************************************************************
* 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
******************************************************************************/
package org.eclipse.persistence.testing.models.insurance;
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 InsuranceTableCreator extends TableCreator {
public InsuranceTableCreator() {
setName("Insurance");
addTableDefinition(buildCHILDNAMTable());
addTableDefinition(buildCLAIMTable());
addTableDefinition(buildHOLDERTable());
addTableDefinition(buildINS_ADDRTable());
addTableDefinition(buildINS_PHONETable());
addTableDefinition(buildPOLICYTable());
addTableDefinition(buildVHCL_CLMTable());
addTableDefinition(buildVHCL_POLTable());
addTableDefinition(buildBCCL_POLTable());
}
public TableDefinition buildCHILDNAMTable() {
TableDefinition table = new TableDefinition();
table.setName("CHILDNAM");
FieldDefinition fieldHOLDER_ID = new FieldDefinition();
fieldHOLDER_ID.setName("HOLDER_ID");
fieldHOLDER_ID.setTypeName("NUMBER");
fieldHOLDER_ID.setSize(18);
fieldHOLDER_ID.setSubSize(0);
fieldHOLDER_ID.setIsPrimaryKey(true);
fieldHOLDER_ID.setIsIdentity(false);
fieldHOLDER_ID.setUnique(false);
fieldHOLDER_ID.setShouldAllowNull(false);
table.addField(fieldHOLDER_ID);
FieldDefinition fieldCHILD_NAME = new FieldDefinition();
fieldCHILD_NAME.setName("CHILD_NAME");
fieldCHILD_NAME.setTypeName("VARCHAR2");
fieldCHILD_NAME.setSize(30);
fieldCHILD_NAME.setSubSize(0);
fieldCHILD_NAME.setIsPrimaryKey(true);
fieldCHILD_NAME.setIsIdentity(false);
fieldCHILD_NAME.setUnique(false);
fieldCHILD_NAME.setShouldAllowNull(false);
table.addField(fieldCHILD_NAME);
ForeignKeyConstraint foreignKeyFK_CHILDNAM_HOLDER_ID = new ForeignKeyConstraint();
foreignKeyFK_CHILDNAM_HOLDER_ID.setName("CHILD_HOLDER");
foreignKeyFK_CHILDNAM_HOLDER_ID.setTargetTable("HOLDER");
foreignKeyFK_CHILDNAM_HOLDER_ID.addSourceField("HOLDER_ID");
foreignKeyFK_CHILDNAM_HOLDER_ID.addTargetField("SSN");
table.addForeignKeyConstraint(foreignKeyFK_CHILDNAM_HOLDER_ID);
return table;
}
public TableDefinition buildCLAIMTable() {
TableDefinition table = new TableDefinition();
table.setName("CLAIM");
FieldDefinition fieldCLM_ID = new FieldDefinition();
fieldCLM_ID.setName("CLM_ID");
fieldCLM_ID.setTypeName("NUMBER");
fieldCLM_ID.setSize(18);
fieldCLM_ID.setSubSize(0);
fieldCLM_ID.setIsPrimaryKey(true);
fieldCLM_ID.setIsIdentity(false);
fieldCLM_ID.setUnique(false);
fieldCLM_ID.setShouldAllowNull(false);
table.addField(fieldCLM_ID);
FieldDefinition fieldPOL_ID = new FieldDefinition();
fieldPOL_ID.setName("POL_ID");
fieldPOL_ID.setTypeName("NUMBER");
fieldPOL_ID.setSize(18);
fieldPOL_ID.setSubSize(0);
fieldPOL_ID.setIsPrimaryKey(false);
fieldPOL_ID.setIsIdentity(false);
fieldPOL_ID.setUnique(false);
fieldPOL_ID.setShouldAllowNull(true);
table.addField(fieldPOL_ID);
FieldDefinition fieldCLM_TYPE = new FieldDefinition();
fieldCLM_TYPE.setName("CLM_TYPE");
fieldCLM_TYPE.setTypeName("VARCHAR2");
fieldCLM_TYPE.setSize(20);
fieldCLM_TYPE.setSubSize(0);
fieldCLM_TYPE.setIsPrimaryKey(false);
fieldCLM_TYPE.setIsIdentity(false);
fieldCLM_TYPE.setUnique(false);
fieldCLM_TYPE.setShouldAllowNull(true);
table.addField(fieldCLM_TYPE);
FieldDefinition fieldAMOUNT = new FieldDefinition();
fieldAMOUNT.setName("AMOUNT");
fieldAMOUNT.setTypeName("FLOAT");
fieldAMOUNT.setSize(18);
fieldAMOUNT.setSubSize(4);
fieldAMOUNT.setIsPrimaryKey(false);
fieldAMOUNT.setIsIdentity(false);
fieldAMOUNT.setUnique(false);
fieldAMOUNT.setShouldAllowNull(true);
table.addField(fieldAMOUNT);
FieldDefinition fieldDISEASE = new FieldDefinition();
fieldDISEASE.setName("DISEASE");
fieldDISEASE.setTypeName("VARCHAR2");
fieldDISEASE.setSize(50);
fieldDISEASE.setSubSize(0);
fieldDISEASE.setIsPrimaryKey(false);
fieldDISEASE.setIsIdentity(false);
fieldDISEASE.setUnique(false);
fieldDISEASE.setShouldAllowNull(true);
table.addField(fieldDISEASE);
FieldDefinition fieldAREA = new FieldDefinition();
fieldAREA.setName("AREA");
fieldAREA.setTypeName("NUMBER");
fieldAREA.setSize(18);
fieldAREA.setSubSize(4);
fieldAREA.setIsPrimaryKey(false);
fieldAREA.setIsIdentity(false);
fieldAREA.setUnique(false);
fieldAREA.setShouldAllowNull(true);
table.addField(fieldAREA);
ForeignKeyConstraint foreignKeyFK_CLAIM_POL_ID = new ForeignKeyConstraint();
foreignKeyFK_CLAIM_POL_ID.setName("CLAIM_POL");
foreignKeyFK_CLAIM_POL_ID.setTargetTable("POLICY");
foreignKeyFK_CLAIM_POL_ID.addSourceField("POL_ID");
foreignKeyFK_CLAIM_POL_ID.addTargetField("POL_ID");
table.addForeignKeyConstraint(foreignKeyFK_CLAIM_POL_ID);
return table;
}
public TableDefinition buildHOLDERTable() {
TableDefinition table = new TableDefinition();
table.setName("HOLDER");
FieldDefinition fieldSSN = new FieldDefinition();
fieldSSN.setName("SSN");
fieldSSN.setTypeName("NUMBER");
fieldSSN.setSize(18);
fieldSSN.setSubSize(0);
fieldSSN.setIsPrimaryKey(true);
fieldSSN.setIsIdentity(false);
fieldSSN.setUnique(false);
fieldSSN.setShouldAllowNull(false);
table.addField(fieldSSN);
FieldDefinition fieldF_NAME = new FieldDefinition();
fieldF_NAME.setName("F_NAME");
fieldF_NAME.setTypeName("VARCHAR2");
fieldF_NAME.setSize(20);
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(20);
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 fieldSEX = new FieldDefinition();
fieldSEX.setName("SEX");
fieldSEX.setTypeName("CHAR");
fieldSEX.setSize(1);
fieldSEX.setSubSize(0);
fieldSEX.setIsPrimaryKey(false);
fieldSEX.setIsIdentity(false);
fieldSEX.setUnique(false);
fieldSEX.setShouldAllowNull(true);
table.addField(fieldSEX);
FieldDefinition fieldBDATE = new FieldDefinition();
fieldBDATE.setName("BDATE");
fieldBDATE.setTypeName("DATE");
fieldBDATE.setSize(7);
fieldBDATE.setSubSize(0);
fieldBDATE.setIsPrimaryKey(false);
fieldBDATE.setIsIdentity(false);
fieldBDATE.setUnique(false);
fieldBDATE.setShouldAllowNull(true);
table.addField(fieldBDATE);
FieldDefinition fieldOCC = new FieldDefinition();
fieldOCC.setName("OCC");
fieldOCC.setTypeName("VARCHAR2");
fieldOCC.setSize(20);
fieldOCC.setSubSize(0);
fieldOCC.setIsPrimaryKey(false);
fieldOCC.setIsIdentity(false);
fieldOCC.setUnique(false);
fieldOCC.setShouldAllowNull(true);
table.addField(fieldOCC);
return table;
}
public TableDefinition buildINS_ADDRTable() {
TableDefinition table = new TableDefinition();
table.setName("INS_ADDR");
FieldDefinition fieldSSN = new FieldDefinition();
fieldSSN.setName("SSN");
fieldSSN.setTypeName("NUMBER");
fieldSSN.setSize(18);
fieldSSN.setSubSize(0);
fieldSSN.setIsPrimaryKey(true);
fieldSSN.setIsIdentity(false);
fieldSSN.setUnique(false);
fieldSSN.setShouldAllowNull(false);
table.addField(fieldSSN);
FieldDefinition fieldSTREET = new FieldDefinition();
fieldSTREET.setName("STREET");
fieldSTREET.setTypeName("VARCHAR2");
fieldSTREET.setSize(30);
fieldSTREET.setSubSize(0);
fieldSTREET.setIsPrimaryKey(false);
fieldSTREET.setIsIdentity(false);
fieldSTREET.setUnique(false);
fieldSTREET.setShouldAllowNull(true);
table.addField(fieldSTREET);
FieldDefinition fieldCITY = new FieldDefinition();
fieldCITY.setName("CITY");
fieldCITY.setTypeName("VARCHAR2");
fieldCITY.setSize(25);
fieldCITY.setSubSize(0);
fieldCITY.setIsPrimaryKey(false);
fieldCITY.setIsIdentity(false);
fieldCITY.setUnique(false);
fieldCITY.setShouldAllowNull(true);
table.addField(fieldCITY);
FieldDefinition fieldSTATE = new FieldDefinition();
fieldSTATE.setName("STATE");
fieldSTATE.setTypeName("VARCHAR2");
fieldSTATE.setSize(2);
fieldSTATE.setSubSize(0);
fieldSTATE.setIsPrimaryKey(false);
fieldSTATE.setIsIdentity(false);
fieldSTATE.setUnique(false);
fieldSTATE.setShouldAllowNull(true);
table.addField(fieldSTATE);
FieldDefinition fieldCOUNTRY = new FieldDefinition();
fieldCOUNTRY.setName("COUNTRY");
fieldCOUNTRY.setTypeName("VARCHAR2");
fieldCOUNTRY.setSize(20);
fieldCOUNTRY.setSubSize(0);
fieldCOUNTRY.setIsPrimaryKey(false);
fieldCOUNTRY.setIsIdentity(false);
fieldCOUNTRY.setUnique(false);
fieldCOUNTRY.setShouldAllowNull(true);
table.addField(fieldCOUNTRY);
FieldDefinition fieldZIPCODE = new FieldDefinition();
fieldZIPCODE.setName("ZIPCODE");
fieldZIPCODE.setTypeName("VARCHAR2");
fieldZIPCODE.setSize(10);
fieldZIPCODE.setSubSize(0);
fieldZIPCODE.setIsPrimaryKey(false);
fieldZIPCODE.setIsIdentity(false);
fieldZIPCODE.setUnique(false);
fieldZIPCODE.setShouldAllowNull(true);
table.addField(fieldZIPCODE);
ForeignKeyConstraint foreignKeyFK_INS_ADDR_SSN = new ForeignKeyConstraint();
foreignKeyFK_INS_ADDR_SSN.setName("ADDRESS_HOLDER");
foreignKeyFK_INS_ADDR_SSN.setTargetTable("HOLDER");
foreignKeyFK_INS_ADDR_SSN.addSourceField("SSN");
foreignKeyFK_INS_ADDR_SSN.addTargetField("SSN");
table.addForeignKeyConstraint(foreignKeyFK_INS_ADDR_SSN);
return table;
}
public TableDefinition buildINS_PHONETable() {
TableDefinition table = new TableDefinition();
table.setName("INS_PHONE");
FieldDefinition fieldHOLDER_SSN = new FieldDefinition();
fieldHOLDER_SSN.setName("HOLDER_SSN");
fieldHOLDER_SSN.setTypeName("NUMBER");
fieldHOLDER_SSN.setSize(18);
fieldHOLDER_SSN.setSubSize(0);
fieldHOLDER_SSN.setIsPrimaryKey(true);
fieldHOLDER_SSN.setIsIdentity(false);
fieldHOLDER_SSN.setUnique(false);
fieldHOLDER_SSN.setShouldAllowNull(false);
table.addField(fieldHOLDER_SSN);
FieldDefinition fieldTYPE = new FieldDefinition();
fieldTYPE.setName("TYPE");
fieldTYPE.setTypeName("VARCHAR2");
fieldTYPE.setSize(10);
fieldTYPE.setSubSize(0);
fieldTYPE.setIsPrimaryKey(true);
fieldTYPE.setIsIdentity(false);
fieldTYPE.setUnique(false);
fieldTYPE.setShouldAllowNull(false);
table.addField(fieldTYPE);
FieldDefinition fieldAREACODE = new FieldDefinition();
fieldAREACODE.setName("AREACODE");
fieldAREACODE.setTypeName("NUMBER");
fieldAREACODE.setSize(3);
fieldAREACODE.setSubSize(0);
fieldAREACODE.setIsPrimaryKey(false);
fieldAREACODE.setIsIdentity(false);
fieldAREACODE.setUnique(false);
fieldAREACODE.setShouldAllowNull(true);
table.addField(fieldAREACODE);
FieldDefinition fieldPHONE_NUMBER = new FieldDefinition();
fieldPHONE_NUMBER.setName("PHONE_NUMBER");
fieldPHONE_NUMBER.setTypeName("NUMBER");
fieldPHONE_NUMBER.setSize(10);
fieldPHONE_NUMBER.setSubSize(0);
fieldPHONE_NUMBER.setIsPrimaryKey(false);
fieldPHONE_NUMBER.setIsIdentity(false);
fieldPHONE_NUMBER.setUnique(false);
fieldPHONE_NUMBER.setShouldAllowNull(true);
table.addField(fieldPHONE_NUMBER);
ForeignKeyConstraint foreignKeyFK_INS_PHONE_HOLDER_SSN = new ForeignKeyConstraint();
foreignKeyFK_INS_PHONE_HOLDER_SSN.setName("INS_PHONE_HOLDER");
foreignKeyFK_INS_PHONE_HOLDER_SSN.setTargetTable("HOLDER");
foreignKeyFK_INS_PHONE_HOLDER_SSN.addSourceField("HOLDER_SSN");
foreignKeyFK_INS_PHONE_HOLDER_SSN.addTargetField("SSN");
table.addForeignKeyConstraint(foreignKeyFK_INS_PHONE_HOLDER_SSN);
return table;
}
public TableDefinition buildPOLICYTable() {
TableDefinition table = new TableDefinition();
table.setName("POLICY");
FieldDefinition fieldPOL_ID = new FieldDefinition();
fieldPOL_ID.setName("POL_ID");
fieldPOL_ID.setTypeName("NUMBER");
fieldPOL_ID.setSize(18);
fieldPOL_ID.setSubSize(0);
fieldPOL_ID.setIsPrimaryKey(true);
fieldPOL_ID.setIsIdentity(false);
fieldPOL_ID.setUnique(false);
fieldPOL_ID.setShouldAllowNull(false);
table.addField(fieldPOL_ID);
FieldDefinition fieldSSN = new FieldDefinition();
fieldSSN.setName("SSN");
fieldSSN.setTypeName("NUMBER");
fieldSSN.setSize(18);
fieldSSN.setSubSize(0);
fieldSSN.setIsPrimaryKey(false);
fieldSSN.setIsIdentity(false);
fieldSSN.setUnique(false);
fieldSSN.setShouldAllowNull(true);
table.addField(fieldSSN);
FieldDefinition fieldDESCRIPT = new FieldDefinition();
fieldDESCRIPT.setName("DESCRIPT");
fieldDESCRIPT.setTypeName("VARCHAR2");
fieldDESCRIPT.setSize(100);
fieldDESCRIPT.setSubSize(0);
fieldDESCRIPT.setIsPrimaryKey(false);
fieldDESCRIPT.setIsIdentity(false);
fieldDESCRIPT.setUnique(false);
fieldDESCRIPT.setShouldAllowNull(true);
table.addField(fieldDESCRIPT);
FieldDefinition fieldPOL_TYPE = new FieldDefinition();
fieldPOL_TYPE.setName("POL_TYPE");
fieldPOL_TYPE.setTypeName("NUMBER");
fieldPOL_TYPE.setSize(1);
fieldPOL_TYPE.setSubSize(0);
fieldPOL_TYPE.setIsPrimaryKey(false);
fieldPOL_TYPE.setIsIdentity(false);
fieldPOL_TYPE.setUnique(false);
fieldPOL_TYPE.setShouldAllowNull(true);
table.addField(fieldPOL_TYPE);
FieldDefinition fieldMAX_COV = new FieldDefinition();
fieldMAX_COV.setName("MAX_COV");
fieldMAX_COV.setTypeName("NUMBER");
fieldMAX_COV.setSize(18);
fieldMAX_COV.setSubSize(4);
fieldMAX_COV.setIsPrimaryKey(false);
fieldMAX_COV.setIsIdentity(false);
fieldMAX_COV.setUnique(false);
fieldMAX_COV.setShouldAllowNull(true);
table.addField(fieldMAX_COV);
FieldDefinition fieldCOV_RATE = new FieldDefinition();
fieldCOV_RATE.setName("COV_RATE");
//NUMBER corresponds to long which is mapped to INTEGER data type in some database such as DB2 and MySQL.
//FLOAT should be used which reflect float java type.
fieldCOV_RATE.setTypeName("FLOAT(16)");
fieldCOV_RATE.setSize(18);
fieldCOV_RATE.setSubSize(4);
fieldCOV_RATE.setIsPrimaryKey(false);
fieldCOV_RATE.setIsIdentity(false);
fieldCOV_RATE.setUnique(false);
fieldCOV_RATE.setShouldAllowNull(true);
table.addField(fieldCOV_RATE);
FieldDefinition fieldCNST_DTE = new FieldDefinition();
fieldCNST_DTE.setName("CNST_DTE");
fieldCNST_DTE.setTypeName("DATE");
fieldCNST_DTE.setSize(7);
fieldCNST_DTE.setSubSize(0);
fieldCNST_DTE.setIsPrimaryKey(false);
fieldCNST_DTE.setIsIdentity(false);
fieldCNST_DTE.setUnique(false);
fieldCNST_DTE.setShouldAllowNull(true);
table.addField(fieldCNST_DTE);
ForeignKeyConstraint foreignKeyFK_POLICY_SSN = new ForeignKeyConstraint();
foreignKeyFK_POLICY_SSN.setName("POLICY_HOLDER");
foreignKeyFK_POLICY_SSN.setTargetTable("HOLDER");
foreignKeyFK_POLICY_SSN.addSourceField("SSN");
foreignKeyFK_POLICY_SSN.addTargetField("SSN");
table.addForeignKeyConstraint(foreignKeyFK_POLICY_SSN);
return table;
}
public TableDefinition buildVHCL_CLMTable() {
TableDefinition table = new TableDefinition();
table.setName("VHCL_CLM");
FieldDefinition fieldCLM_ID = new FieldDefinition();
fieldCLM_ID.setName("CLM_ID");
fieldCLM_ID.setTypeName("NUMBER");
fieldCLM_ID.setSize(18);
fieldCLM_ID.setSubSize(0);
fieldCLM_ID.setIsPrimaryKey(true);
fieldCLM_ID.setIsIdentity(false);
fieldCLM_ID.setUnique(false);
fieldCLM_ID.setShouldAllowNull(false);
table.addField(fieldCLM_ID);
FieldDefinition fieldPART = new FieldDefinition();
fieldPART.setName("PART");
fieldPART.setTypeName("VARCHAR2");
fieldPART.setSize(30);
fieldPART.setSubSize(0);
fieldPART.setIsPrimaryKey(false);
fieldPART.setIsIdentity(false);
fieldPART.setUnique(false);
fieldPART.setShouldAllowNull(true);
table.addField(fieldPART);
FieldDefinition fieldPART_DESC = new FieldDefinition();
fieldPART_DESC.setName("PART_DESC");
fieldPART_DESC.setTypeName("VARCHAR2");
fieldPART_DESC.setSize(30);
fieldPART_DESC.setSubSize(0);
fieldPART_DESC.setIsPrimaryKey(false);
fieldPART_DESC.setIsIdentity(false);
fieldPART_DESC.setUnique(false);
fieldPART_DESC.setShouldAllowNull(true);
table.addField(fieldPART_DESC);
ForeignKeyConstraint foreignKeyFK_VHCL_CLM_CLM_ID = new ForeignKeyConstraint();
foreignKeyFK_VHCL_CLM_CLM_ID.setName("VHCL_CLM_CLAIM");
foreignKeyFK_VHCL_CLM_CLM_ID.setTargetTable("CLAIM");
foreignKeyFK_VHCL_CLM_CLM_ID.addSourceField("CLM_ID");
foreignKeyFK_VHCL_CLM_CLM_ID.addTargetField("CLM_ID");
table.addForeignKeyConstraint(foreignKeyFK_VHCL_CLM_CLM_ID);
return table;
}
public TableDefinition buildVHCL_POLTable() {
TableDefinition table = new TableDefinition();
table.setName("VHCL_POL");
FieldDefinition fieldPOL_ID = new FieldDefinition();
fieldPOL_ID.setName("POL_ID");
fieldPOL_ID.setTypeName("NUMBER");
fieldPOL_ID.setSize(18);
fieldPOL_ID.setSubSize(0);
fieldPOL_ID.setIsPrimaryKey(true);
fieldPOL_ID.setIsIdentity(false);
fieldPOL_ID.setUnique(false);
fieldPOL_ID.setShouldAllowNull(false);
table.addField(fieldPOL_ID);
FieldDefinition fieldMODEL = new FieldDefinition();
fieldMODEL.setName("MODEL");
fieldMODEL.setTypeName("VARCHAR2");
fieldMODEL.setSize(30);
fieldMODEL.setSubSize(0);
fieldMODEL.setIsPrimaryKey(false);
fieldMODEL.setIsIdentity(false);
fieldMODEL.setUnique(false);
fieldMODEL.setShouldAllowNull(true);
table.addField(fieldMODEL);
ForeignKeyConstraint foreignKeyFK_VHCL_POL_POL_ID = new ForeignKeyConstraint();
foreignKeyFK_VHCL_POL_POL_ID.setName("VHCL_POL_POLICY");
foreignKeyFK_VHCL_POL_POL_ID.setTargetTable("POLICY");
foreignKeyFK_VHCL_POL_POL_ID.addSourceField("POL_ID");
foreignKeyFK_VHCL_POL_POL_ID.addTargetField("POL_ID");
table.addForeignKeyConstraint(foreignKeyFK_VHCL_POL_POL_ID);
return table;
}
public TableDefinition buildBCCL_POLTable() {
TableDefinition table = new TableDefinition();
table.setName("BCCL_POL");
FieldDefinition fieldPOL_ID = new FieldDefinition();
fieldPOL_ID.setName("POL_ID");
fieldPOL_ID.setTypeName("NUMBER");
fieldPOL_ID.setSize(18);
fieldPOL_ID.setSubSize(0);
fieldPOL_ID.setIsPrimaryKey(true);
fieldPOL_ID.setIsIdentity(false);
fieldPOL_ID.setUnique(false);
fieldPOL_ID.setShouldAllowNull(false);
table.addField(fieldPOL_ID);
FieldDefinition fieldMODEL = new FieldDefinition();
fieldMODEL.setName("COLOR");
fieldMODEL.setTypeName("VARCHAR2");
fieldMODEL.setSize(30);
fieldMODEL.setSubSize(0);
fieldMODEL.setIsPrimaryKey(false);
fieldMODEL.setIsIdentity(false);
fieldMODEL.setUnique(false);
fieldMODEL.setShouldAllowNull(true);
table.addField(fieldMODEL);
ForeignKeyConstraint foreignKeyFK_BCCL_POL_POL_ID = new ForeignKeyConstraint();
foreignKeyFK_BCCL_POL_POL_ID.setName("BCCL_POL_POLICY");
foreignKeyFK_BCCL_POL_POL_ID.setTargetTable("POLICY");
foreignKeyFK_BCCL_POL_POL_ID.addSourceField("POL_ID");
foreignKeyFK_BCCL_POL_POL_ID.addTargetField("POL_ID");
table.addForeignKeyConstraint(foreignKeyFK_BCCL_POL_POL_ID);
return table;
}
}