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 static TableDefinition buildEMPLOYEE_SEQTable() { TableDefinition table = new TableDefinition(); table.setName("CMP3_XML_EMPLOYEE_SEQ"); FieldDefinition fieldSEQ_COUNT = new FieldDefinition(); fieldSEQ_COUNT.setName("SEQ_COUNT"); fieldSEQ_COUNT.setTypeName("NUMBER"); fieldSEQ_COUNT.setSize(15); fieldSEQ_COUNT.setSubSize(0); fieldSEQ_COUNT.setIsPrimaryKey(false); fieldSEQ_COUNT.setIsIdentity(false); fieldSEQ_COUNT.setUnique(false); fieldSEQ_COUNT.setShouldAllowNull(false); table.addField(fieldSEQ_COUNT); FieldDefinition fieldSEQ_NAME = new FieldDefinition(); fieldSEQ_NAME.setName("SEQ_NAME"); fieldSEQ_NAME.setTypeName("VARCHAR2"); fieldSEQ_NAME.setSize(80); fieldSEQ_NAME.setSubSize(0); fieldSEQ_NAME.setIsPrimaryKey(true); fieldSEQ_NAME.setIsIdentity(false); fieldSEQ_NAME.setUnique(false); fieldSEQ_NAME.setShouldAllowNull(false); table.addField(fieldSEQ_NAME); return table; }
public TableDefinition buildAboutToInsertSingleTable() { TableDefinition table = new TableDefinition(); table.setName("AboutToInsertSingle"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(28); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(false); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); FieldDefinition fieldNUMBER = new FieldDefinition(); fieldNUMBER.setName("EXTRA_NUMBER"); fieldNUMBER.setTypeName("NUMERIC"); fieldNUMBER.setSize(28); fieldNUMBER.setSubSize(0); fieldNUMBER.setIsPrimaryKey(false); fieldNUMBER.setIsIdentity(false); fieldNUMBER.setUnique(false); fieldNUMBER.setShouldAllowNull(true); table.addField(fieldNUMBER); return table; }
public static TableDefinition buildENGINETable() { // CREATE TABLE JPA_OR_ENGINE (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL, PRIMARY KEY // (ID)) TableDefinition table = new TableDefinition(); table.setName("JPA_OR_ENGINE"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(10); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setShouldAllowNull(false); fieldID.setUnique(false); table.addField(fieldID); FieldDefinition fieldSERIALNUMBER = new FieldDefinition(); fieldSERIALNUMBER.setName("SERIALNUMBER"); fieldSERIALNUMBER.setTypeName("NUMERIC"); fieldSERIALNUMBER.setSize(18); fieldSERIALNUMBER.setSubSize(0); fieldSERIALNUMBER.setIsPrimaryKey(false); fieldSERIALNUMBER.setIsIdentity(false); fieldSERIALNUMBER.setShouldAllowNull(true); fieldSERIALNUMBER.setUnique(false); table.addField(fieldSERIALNUMBER); return table; }
public static TableDefinition buildTIREDETAILTable() { // 474752 :CREATE TABLE TIREDETAIL (ID NUMBER(10) NOT NULL, DETAIL VARCHAR2(255), PRIMARY KEY // (ID)) TableDefinition table = new TableDefinition(); table.setName("OR_TIREDETAIL"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("TIRE_ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(10); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setShouldAllowNull(false); fieldID.setUnique(false); table.addField(fieldID); FieldDefinition fieldDetail = new FieldDefinition(); fieldDetail.setName("DETAIL"); fieldDetail.setTypeName("VARCHAR"); fieldDetail.setSize(255); fieldDetail.setSubSize(0); fieldDetail.setIsPrimaryKey(false); fieldDetail.setIsIdentity(false); fieldDetail.setShouldAllowNull(true); fieldDetail.setUnique(false); table.addField(fieldDetail); 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 static TableDefinition buildSALARYTable() { TableDefinition table = new TableDefinition(); table.setName("CMP3_XML_SALARY"); FieldDefinition fieldEMP_ID = new FieldDefinition(); fieldEMP_ID.setName("E_ID"); fieldEMP_ID.setTypeName("NUMERIC"); fieldEMP_ID.setSize(15); fieldEMP_ID.setSubSize(0); fieldEMP_ID.setIsPrimaryKey(true); fieldEMP_ID.setIsIdentity(false); fieldEMP_ID.setUnique(false); fieldEMP_ID.setShouldAllowNull(false); fieldEMP_ID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID"); table.addField(fieldEMP_ID); FieldDefinition fieldSALARY = new FieldDefinition(); fieldSALARY.setName("SALARY"); fieldSALARY.setTypeName("NUMBER"); fieldSALARY.setSize(15); fieldSALARY.setSubSize(0); fieldSALARY.setIsPrimaryKey(false); fieldSALARY.setIsIdentity(false); fieldSALARY.setUnique(false); fieldSALARY.setShouldAllowNull(true); table.addField(fieldSALARY); return table; }
public static TableDefinition buildCHASSISTable() { // CREATE TABLE JPA_OR_CHASSIS (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL, PRIMARY // KEY (ID)) TableDefinition table = new TableDefinition(); table.setName("JPA_OR_CHASSIS"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(10); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setShouldAllowNull(false); fieldID.setUnique(false); table.addField(fieldID); FieldDefinition serialNumber = new FieldDefinition(); serialNumber.setName("SERIALNUMBER"); serialNumber.setTypeName("NUMERIC"); serialNumber.setSize(18); serialNumber.setSubSize(0); serialNumber.setIsPrimaryKey(false); serialNumber.setIsIdentity(false); serialNumber.setShouldAllowNull(true); serialNumber.setUnique(false); table.addField(serialNumber); return table; }
public static TableDefinition buildPARTNERLINKTable() { TableDefinition table = new TableDefinition(); table.setName("XML_MW"); FieldDefinition fieldMID = new FieldDefinition(); fieldMID.setName("M"); fieldMID.setTypeName("NUMERIC"); fieldMID.setSize(15); fieldMID.setSubSize(0); fieldMID.setIsPrimaryKey(false); fieldMID.setIsIdentity(false); fieldMID.setUnique(false); fieldMID.setShouldAllowNull(true); fieldMID.setForeignKeyFieldName("XML_MAN.ID"); table.addField(fieldMID); FieldDefinition fieldWID = new FieldDefinition(); fieldWID.setName("W"); fieldWID.setTypeName("NUMERIC"); fieldWID.setSize(15); fieldWID.setSubSize(0); fieldWID.setIsPrimaryKey(false); fieldWID.setIsIdentity(false); fieldWID.setUnique(false); fieldWID.setShouldAllowNull(true); fieldWID.setForeignKeyFieldName("XML_WOMAN.ID"); table.addField(fieldWID); 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 static TableDefinition buildSPARKPLUGTable() { // CREATE TABLE JPA_OR_SPARK_PLUG (ID NUMBER(10) NOT NULL, SERIALNUMBER NUMBER(19) NULL, // ENGINE_ID NUMBER(10) NULL, PRIMARY KEY (ID)) TableDefinition table = new TableDefinition(); table.setName("JPA_OR_SPARK_PLUG"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(10); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setShouldAllowNull(false); fieldID.setUnique(false); table.addField(fieldID); FieldDefinition fieldSERIALNUMBER = new FieldDefinition(); fieldSERIALNUMBER.setName("SERIALNUMBER"); fieldSERIALNUMBER.setTypeName("NUMERIC"); fieldSERIALNUMBER.setSize(18); fieldSERIALNUMBER.setSubSize(0); fieldSERIALNUMBER.setIsPrimaryKey(false); fieldSERIALNUMBER.setIsIdentity(false); fieldSERIALNUMBER.setShouldAllowNull(true); fieldSERIALNUMBER.setUnique(false); table.addField(fieldSERIALNUMBER); FieldDefinition fieldENGINE = new FieldDefinition(); fieldENGINE.setName("ENGINE_ID"); fieldENGINE.setTypeName("NUMERIC"); fieldENGINE.setSize(10); fieldENGINE.setSubSize(0); fieldENGINE.setIsPrimaryKey(false); fieldENGINE.setIsIdentity(false); fieldENGINE.setShouldAllowNull(true); fieldENGINE.setUnique(false); table.addField(fieldENGINE); // ALTER TABLE JPA_OR_SPARK_PLUG ADD CONSTRAINT JPA_OR_SPARK_PLUG_ENGINE_ID FOREIGN KEY // (ENGINE_ID) REFERENCES JPA_OR_ENGINE (ID) ForeignKeyConstraint foreignKeySPARKPLUG_ENGINE = new ForeignKeyConstraint(); foreignKeySPARKPLUG_ENGINE.setName("FK_SPK_PG_ENG_ID"); foreignKeySPARKPLUG_ENGINE.setTargetTable("JPA_OR_ENGINE"); foreignKeySPARKPLUG_ENGINE.addSourceField("ENGINE_ID"); foreignKeySPARKPLUG_ENGINE.addTargetField("ID"); table.addForeignKeyConstraint(foreignKeySPARKPLUG_ENGINE); 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; }
public TableDefinition buildRewardTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_REWARD"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); FieldDefinition fieldDescription = new FieldDefinition(); fieldDescription.setName("DESCRIP"); fieldDescription.setTypeName("VARCHAR2"); fieldDescription.setSize(60); fieldDescription.setSubSize(0); fieldDescription.setIsPrimaryKey(false); fieldDescription.setIsIdentity(false); fieldDescription.setUnique(false); fieldDescription.setShouldAllowNull(true); table.addField(fieldDescription); FieldDefinition fieldTenantId = new FieldDefinition(); fieldTenantId.setName("T_ID"); fieldTenantId.setTypeName("VARCHAR2"); fieldTenantId.setSize(10); fieldTenantId.setSubSize(0); fieldTenantId.setIsPrimaryKey(false); fieldTenantId.setIsIdentity(false); fieldTenantId.setUnique(false); fieldTenantId.setShouldAllowNull(false); table.addField(fieldTenantId); FieldDefinition fieldMafiosoId = new FieldDefinition(); fieldMafiosoId.setName("MAFIOSO_ID"); fieldMafiosoId.setTypeName("NUMERIC"); fieldMafiosoId.setSize(15); fieldMafiosoId.setShouldAllowNull(false); fieldMafiosoId.setIsPrimaryKey(true); fieldMafiosoId.setUnique(false); fieldMafiosoId.setIsIdentity(false); fieldMafiosoId.setForeignKeyFieldName("JPA_MAFIOSO.ID"); table.addField(fieldMafiosoId); return table; }
public TableDefinition buildContractTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_CONTRACT"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); FieldDefinition fieldDescription = new FieldDefinition(); fieldDescription.setName("DESCRIP"); fieldDescription.setTypeName("VARCHAR2"); fieldDescription.setSize(60); fieldDescription.setSubSize(0); fieldDescription.setIsPrimaryKey(false); fieldDescription.setIsIdentity(false); fieldDescription.setUnique(false); fieldDescription.setShouldAllowNull(true); table.addField(fieldDescription); FieldDefinition fieldVersion = new FieldDefinition(); fieldVersion.setName("VERSION"); fieldVersion.setTypeName("NUMERIC"); fieldVersion.setSize(15); fieldVersion.setShouldAllowNull(true); fieldVersion.setIsPrimaryKey(false); fieldVersion.setUnique(false); fieldVersion.setIsIdentity(false); table.addField(fieldVersion); FieldDefinition fieldTenantId = new FieldDefinition(); fieldTenantId.setName("TENANT_ID"); fieldTenantId.setTypeName("VARCHAR2"); fieldTenantId.setSize(10); fieldTenantId.setSubSize(0); fieldTenantId.setIsPrimaryKey(false); fieldTenantId.setIsIdentity(false); fieldTenantId.setUnique(false); fieldTenantId.setShouldAllowNull(false); table.addField(fieldTenantId); return table; }
public TableDefinition buildMafiaFamily_TagsTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_FAMILY_TAGS"); FieldDefinition fieldFamilyId = new FieldDefinition(); fieldFamilyId.setName("FAMILY_ID"); fieldFamilyId.setTypeName("NUMERIC"); fieldFamilyId.setSize(15); fieldFamilyId.setIsPrimaryKey(false); fieldFamilyId.setIsIdentity(false); fieldFamilyId.setUnique(false); fieldFamilyId.setShouldAllowNull(false); // fieldFamilyId.setForeignKeyFieldName("JPA_MAFIA_FAMILY.ID"); table.addField(fieldFamilyId); FieldDefinition fieldTag = new FieldDefinition(); fieldTag.setName("TAG"); fieldTag.setTypeName("VARCHAR2"); fieldTag.setSize(60); fieldTag.setSubSize(0); fieldTag.setIsPrimaryKey(false); fieldTag.setIsIdentity(false); fieldTag.setUnique(false); fieldTag.setShouldAllowNull(true); table.addField(fieldTag); return table; }
public TableDefinition buildMafiaFamily_RevenueTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_FAMILY_REVENUE"); FieldDefinition fieldFamilyId = new FieldDefinition(); fieldFamilyId.setName("ID"); fieldFamilyId.setTypeName("NUMERIC"); fieldFamilyId.setSize(15); fieldFamilyId.setIsPrimaryKey(false); fieldFamilyId.setIsIdentity(false); fieldFamilyId.setUnique(false); fieldFamilyId.setShouldAllowNull(false); // fieldFamilyId.setForeignKeyFieldName("JPA_MAFIA_FAMILY.ID"); table.addField(fieldFamilyId); FieldDefinition fieldRevenue = new FieldDefinition(); fieldRevenue.setName("REVENUE"); fieldRevenue.setTypeName("NUMBER"); fieldRevenue.setSize(15); fieldRevenue.setSubSize(0); fieldRevenue.setIsPrimaryKey(false); fieldRevenue.setIsIdentity(false); fieldRevenue.setUnique(false); fieldRevenue.setShouldAllowNull(true); table.addField(fieldRevenue); 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 static TableDefinition buildWHEELNUTTable() { // CREATE TABLE JPA_OR_WHEEL_NUT (ID NUMBER(10) NOT NULL, WHEEL_ID NUMBER(10) NULL, PRIMARY KEY // (ID)) TableDefinition table = new TableDefinition(); table.setName("JPA_OR_WHEEL_NUT"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(10); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setShouldAllowNull(false); fieldID.setUnique(false); table.addField(fieldID); FieldDefinition fieldWHEEL = new FieldDefinition(); fieldWHEEL.setName("WHEEL_ID"); fieldWHEEL.setTypeName("NUMERIC"); fieldWHEEL.setSize(10); fieldWHEEL.setSubSize(0); fieldWHEEL.setIsPrimaryKey(false); fieldWHEEL.setIsIdentity(false); fieldWHEEL.setShouldAllowNull(true); fieldWHEEL.setUnique(false); table.addField(fieldWHEEL); // ALTER TABLE JPA_OR_WHEEL_NUT ADD CONSTRAINT FK_JPA_OR_WHEEL_NUT_WHEEL_ID FOREIGN KEY // (WHEEL_ID) REFERENCES JPA_OR_WHEEL (ID) ForeignKeyConstraint foreignKeyWHEELNUT_WHEEL = new ForeignKeyConstraint(); foreignKeyWHEELNUT_WHEEL.setName("FK_WH_NUT_WL_ID"); foreignKeyWHEELNUT_WHEEL.setTargetTable("JPA_OR_WHEEL"); foreignKeyWHEELNUT_WHEEL.addSourceField("WHEEL_ID"); foreignKeyWHEELNUT_WHEEL.addTargetField("ID"); table.addForeignKeyConstraint(foreignKeyWHEELNUT_WHEEL); return table; }
public TableDefinition buildMafiaFamilyTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_MAFIA_FAMILY"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); FieldDefinition fieldName = new FieldDefinition(); fieldName.setName("NAME"); fieldName.setTypeName("VARCHAR2"); fieldName.setSize(60); fieldName.setSubSize(0); fieldName.setIsPrimaryKey(false); fieldName.setIsIdentity(false); fieldName.setUnique(false); fieldName.setShouldAllowNull(true); table.addField(fieldName); FieldDefinition fieldTenantId = new FieldDefinition(); fieldTenantId.setName("TENANT_ID"); fieldTenantId.setTypeName("VARCHAR2"); fieldTenantId.setSize(10); fieldTenantId.setSubSize(0); fieldTenantId.setIsPrimaryKey(false); fieldTenantId.setIsIdentity(false); fieldTenantId.setUnique(false); fieldTenantId.setShouldAllowNull(false); table.addField(fieldTenantId); return table; }
public static TableDefinition buildCACHEABLE_FORCE_PROTECTED_ENTITYTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_CACHEABLE_FORCE_PROTECTED"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setShouldAllowNull(false); fieldID.setIsPrimaryKey(true); fieldID.setUnique(false); fieldID.setIsIdentity(true); table.addField(fieldID); FieldDefinition fieldNAME = new FieldDefinition(); fieldNAME.setName("NAME"); fieldNAME.setTypeName("VARCHAR"); fieldNAME.setSize(75); fieldNAME.setShouldAllowNull(true); fieldNAME.setIsPrimaryKey(false); fieldNAME.setUnique(false); fieldNAME.setIsIdentity(false); table.addField(fieldNAME); FieldDefinition fieldDTYPE = new FieldDefinition(); fieldDTYPE.setName("DTYPE"); fieldDTYPE.setTypeName("VARCHAR2"); fieldDTYPE.setSize(15); fieldDTYPE.setSubSize(0); fieldDTYPE.setIsPrimaryKey(false); fieldDTYPE.setIsIdentity(false); fieldDTYPE.setUnique(false); fieldDTYPE.setShouldAllowNull(true); table.addField(fieldDTYPE); FieldDefinition falseFK = new FieldDefinition(); falseFK.setName("FALSE_FK"); falseFK.setTypeName("NUMERIC"); falseFK.setSize(15); falseFK.setShouldAllowNull(true); falseFK.setIsPrimaryKey(false); falseFK.setUnique(false); falseFK.setIsIdentity(false); table.addField(falseFK); return table; }
public static TableDefinition buildREADONLYCLASSTable() { TableDefinition table = new TableDefinition(); table.setName("CMP3_XML_READONLY"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); return table; }
public static TableDefinition buildWHEELRIMTable() { // CREATE TABLE JPA_OR_WHEEL_RIM (ID NUMBER(10) NOT NULL, PRIMARY KEY (ID)) TableDefinition table = new TableDefinition(); table.setName("JPA_OR_WHEEL_RIM"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(10); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setShouldAllowNull(false); fieldID.setUnique(false); table.addField(fieldID); return table; }
public static TableDefinition buildWOMANTable() { TableDefinition table = new TableDefinition(); table.setName("XML_WOMAN"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); FieldDefinition field1 = new FieldDefinition(); field1.setName("F_NAME"); field1.setTypeName("VARCHAR"); field1.setSize(40); field1.setShouldAllowNull(true); field1.setIsPrimaryKey(false); field1.setUnique(false); field1.setIsIdentity(false); table.addField(field1); FieldDefinition field2 = new FieldDefinition(); field2.setName("L_NAME"); field2.setTypeName("VARCHAR"); field2.setSize(40); field2.setShouldAllowNull(true); field2.setIsPrimaryKey(false); field2.setUnique(false); field2.setIsIdentity(false); table.addField(field2); return table; }
public TableDefinition buildMafiosoTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_MAFIOSO"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setShouldAllowNull(false); fieldID.setIsPrimaryKey(true); fieldID.setUnique(false); fieldID.setIsIdentity(true); table.addField(fieldID); FieldDefinition fieldFirstName = new FieldDefinition(); fieldFirstName.setName("FIRSTNAME"); fieldFirstName.setTypeName("VARCHAR"); fieldFirstName.setSize(30); fieldFirstName.setShouldAllowNull(true); fieldFirstName.setIsPrimaryKey(false); fieldFirstName.setUnique(false); fieldFirstName.setIsIdentity(false); table.addField(fieldFirstName); FieldDefinition fieldLastName = new FieldDefinition(); fieldLastName.setName("LASTNAME"); fieldLastName.setTypeName("VARCHAR"); fieldLastName.setSize(30); fieldLastName.setShouldAllowNull(true); fieldLastName.setIsPrimaryKey(false); fieldLastName.setUnique(false); fieldLastName.setIsIdentity(false); table.addField(fieldLastName); FieldDefinition fieldNickname = new FieldDefinition(); fieldNickname.setName("NICKNAME"); fieldNickname.setTypeName("VARCHAR"); fieldNickname.setSize(30); fieldNickname.setShouldAllowNull(true); fieldNickname.setIsPrimaryKey(false); fieldNickname.setUnique(false); fieldNickname.setIsIdentity(false); table.addField(fieldNickname); FieldDefinition fieldGender = new FieldDefinition(); fieldGender.setName("GENDER"); fieldGender.setTypeName("VARCHAR"); fieldGender.setSize(1); fieldGender.setShouldAllowNull(true); fieldGender.setIsPrimaryKey(false); fieldGender.setUnique(false); fieldGender.setIsIdentity(false); table.addField(fieldGender); FieldDefinition fieldFamily = new FieldDefinition(); fieldFamily.setName("FAMILY_ID"); fieldFamily.setTypeName("NUMERIC"); fieldFamily.setSize(15); fieldFamily.setShouldAllowNull(true); fieldFamily.setIsPrimaryKey(false); fieldFamily.setUnique(false); fieldFamily.setIsIdentity(false); // fieldFamily.setForeignKeyFieldName("JPA_MAFIA_FAMILY.ID"); table.addField(fieldFamily); FieldDefinition fielDiscriminatorType = new FieldDefinition(); fielDiscriminatorType.setName("DTYPE"); fielDiscriminatorType.setTypeName("VARCHAR"); fielDiscriminatorType.setSize(20); fielDiscriminatorType.setShouldAllowNull(false); fielDiscriminatorType.setIsPrimaryKey(false); fielDiscriminatorType.setUnique(false); fielDiscriminatorType.setIsIdentity(false); table.addField(fielDiscriminatorType); FieldDefinition fieldAddress = new FieldDefinition(); fieldAddress.setName("ADDRESS_ID"); fieldAddress.setTypeName("NUMERIC"); fieldAddress.setSize(15); fieldAddress.setShouldAllowNull(true); fieldAddress.setIsPrimaryKey(false); fieldAddress.setUnique(false); fieldAddress.setIsIdentity(false); table.addField(fieldAddress); FieldDefinition fieldTenantId = new FieldDefinition(); fieldTenantId.setName("TENANT_ID"); fieldTenantId.setTypeName("VARCHAR2"); fieldTenantId.setSize(10); fieldTenantId.setSubSize(0); fieldTenantId.setIsPrimaryKey(false); fieldTenantId.setIsIdentity(false); fieldTenantId.setUnique(false); fieldTenantId.setShouldAllowNull(false); table.addField(fieldTenantId); return table; }
public static TableDefinition buildADDRESSTable() { TableDefinition table = new TableDefinition(); table.setName("CMP3_XML_ADDRESS"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ADDRESS_ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); FieldDefinition fieldSTREET = new FieldDefinition(); fieldSTREET.setName("STREET"); fieldSTREET.setTypeName("VARCHAR2"); fieldSTREET.setSize(60); 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(60); 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(60); fieldPROVINCE.setSubSize(0); fieldPROVINCE.setIsPrimaryKey(false); fieldPROVINCE.setIsIdentity(false); fieldPROVINCE.setUnique(false); fieldPROVINCE.setShouldAllowNull(true); table.addField(fieldPROVINCE); FieldDefinition fieldPOSTALCODE = new FieldDefinition(); fieldPOSTALCODE.setName("P_CODE"); fieldPOSTALCODE.setTypeName("VARCHAR2"); fieldPOSTALCODE.setSize(67); fieldPOSTALCODE.setSubSize(0); fieldPOSTALCODE.setIsPrimaryKey(false); fieldPOSTALCODE.setIsIdentity(false); fieldPOSTALCODE.setUnique(false); fieldPOSTALCODE.setShouldAllowNull(true); table.addField(fieldPOSTALCODE); FieldDefinition fieldCOUNTRY = new FieldDefinition(); fieldCOUNTRY.setName("COUNTRY"); fieldCOUNTRY.setTypeName("VARCHAR2"); fieldCOUNTRY.setSize(60); fieldCOUNTRY.setSubSize(0); fieldCOUNTRY.setIsPrimaryKey(false); fieldCOUNTRY.setIsIdentity(false); fieldCOUNTRY.setUnique(false); fieldCOUNTRY.setShouldAllowNull(true); table.addField(fieldCOUNTRY); FieldDefinition fieldType = new FieldDefinition(); fieldType.setName("TYPE"); fieldType.setTypeName("VARCHAR2"); fieldType.setSize(150); fieldType.setSubSize(0); fieldType.setIsPrimaryKey(false); fieldType.setIsIdentity(false); fieldType.setUnique(false); fieldType.setShouldAllowNull(true); table.addField(fieldType); return table; }
public TableDefinition buildAddressTable() { TableDefinition table = new TableDefinition(); table.setName("JPA_MAFIOSO_ADDRESS"); FieldDefinition fieldID = new FieldDefinition(); fieldID.setName("ADDRESS_ID"); fieldID.setTypeName("NUMERIC"); fieldID.setSize(15); fieldID.setSubSize(0); fieldID.setIsPrimaryKey(true); fieldID.setIsIdentity(true); fieldID.setUnique(false); fieldID.setShouldAllowNull(false); table.addField(fieldID); FieldDefinition fieldStreet = new FieldDefinition(); fieldStreet.setName("STREET"); fieldStreet.setTypeName("VARCHAR2"); fieldStreet.setSize(60); 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(60); 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(60); fieldProvince.setSubSize(0); fieldProvince.setIsPrimaryKey(false); fieldProvince.setIsIdentity(false); fieldProvince.setUnique(false); fieldProvince.setShouldAllowNull(true); table.addField(fieldProvince); FieldDefinition fieldPostalCode = new FieldDefinition(); fieldPostalCode.setName("P_CODE"); fieldPostalCode.setTypeName("VARCHAR2"); fieldPostalCode.setSize(67); fieldPostalCode.setSubSize(0); fieldPostalCode.setIsPrimaryKey(false); fieldPostalCode.setIsIdentity(false); fieldPostalCode.setUnique(false); fieldPostalCode.setShouldAllowNull(true); table.addField(fieldPostalCode); FieldDefinition fieldCountry = new FieldDefinition(); fieldCountry.setName("COUNTRY"); fieldCountry.setTypeName("VARCHAR2"); fieldCountry.setSize(60); 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("NUMERIC"); fieldVersion.setSize(15); fieldVersion.setIsPrimaryKey(false); fieldVersion.setUnique(false); fieldVersion.setIsIdentity(false); fieldVersion.setShouldAllowNull(true); table.addField(fieldVersion); FieldDefinition fieldTenantId = new FieldDefinition(); fieldTenantId.setName("TENANT_ID"); fieldTenantId.setTypeName("VARCHAR2"); fieldTenantId.setSize(10); fieldTenantId.setSubSize(0); fieldTenantId.setIsPrimaryKey(false); fieldTenantId.setIsIdentity(false); fieldTenantId.setUnique(false); fieldTenantId.setShouldAllowNull(false); table.addField(fieldTenantId); 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 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; }