public static TableDefinition buildCACHEABLE_PROTECTED_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_CACHEABLE_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);

    return table;
  }
 public static TableDefinition tableDefinition() {
   TableDefinition definition = new TableDefinition();
   definition.setName("CALENDARTOTSTZ_BINDING");
   definition.addField("TEST_ID", Integer.class);
   definition.addField("TSTZ_DATA", TIMESTAMPTZ.class);
   return definition;
 }
  public TableDefinition buildSoldierTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_SOLDIER");

    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);
    // fieldID.setForeignKeyFieldName("JPA_MAFIOSO.ID");
    table.addField(fieldID);

    FieldDefinition fieldCapo = new FieldDefinition();
    fieldCapo.setName("CAPO_ID");
    fieldCapo.setTypeName("NUMERIC");
    fieldCapo.setSize(15);
    fieldCapo.setShouldAllowNull(false);
    fieldCapo.setIsPrimaryKey(false);
    fieldCapo.setUnique(false);
    fieldCapo.setIsIdentity(false);
    // fieldCapo.setForeignKeyFieldName("JPA_CAPO.ID");
    table.addField(fieldCapo);

    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 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 buildCapoTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_CAPO");

    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);
    // fieldID.setForeignKeyFieldName("JPA_MAFIOSO.ID");
    table.addField(fieldID);

    FieldDefinition fieldUnderboss = new FieldDefinition();
    fieldUnderboss.setName("UNDERBOSS_ID");
    fieldUnderboss.setTypeName("NUMERIC");
    fieldUnderboss.setSize(15);
    fieldUnderboss.setShouldAllowNull(false);
    fieldUnderboss.setIsPrimaryKey(false);
    fieldUnderboss.setUnique(false);
    fieldUnderboss.setIsIdentity(false);
    // fieldUnderboss.setForeignKeyFieldName("JPA_UNDERBOSS.ID");
    table.addField(fieldUnderboss);

    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 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 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 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 TableDefinition buildContract_SoldierTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_CONTRACT_SOLDIER");

    FieldDefinition fieldContractId = new FieldDefinition();
    fieldContractId.setName("CONTRACT_ID");
    fieldContractId.setTypeName("NUMERIC");
    fieldContractId.setSize(15);
    fieldContractId.setShouldAllowNull(false);
    fieldContractId.setIsPrimaryKey(true);
    fieldContractId.setUnique(false);
    fieldContractId.setIsIdentity(false);
    fieldContractId.setForeignKeyFieldName("JPA_CONTRACT.ID");
    table.addField(fieldContractId);

    FieldDefinition fieldSoldierId = new FieldDefinition();
    fieldSoldierId.setName("SOLDIER_ID");
    fieldSoldierId.setTypeName("NUMERIC");
    fieldSoldierId.setSize(15);
    fieldSoldierId.setShouldAllowNull(false);
    fieldSoldierId.setIsPrimaryKey(true);
    fieldSoldierId.setUnique(false);
    fieldSoldierId.setIsIdentity(false);
    fieldSoldierId.setForeignKeyFieldName("JPA_SOLDIER.ID");
    table.addField(fieldSoldierId);

    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 static TableDefinition buildPROJECT_EMPTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_XML_PROJ_EMP");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("PROJ_ID");
    field1.setTypeName("NUMERIC");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    field1.setForeignKeyFieldName("CMP3_XML_PROJECT.PROJ_ID");
    table.addField(field1);

    return table;
  }
  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 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 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 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 buildCACHEABLE_FALSE_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_CACHEABLE_FALSE");

    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 protectedFK = new FieldDefinition();
    protectedFK.setName("PROTECTED_FK");
    protectedFK.setTypeName("NUMERIC");
    protectedFK.setSize(15);
    protectedFK.setShouldAllowNull(true);
    protectedFK.setIsPrimaryKey(false);
    protectedFK.setUnique(false);
    protectedFK.setIsIdentity(false);
    table.addField(protectedFK);

    return table;
  }
  public static TableDefinition buildRESPONSTable() {
    TableDefinition table = new TableDefinition();
    // SECTION: TABLE
    table.setName("CMP3_XML_RESPONS");

    // SECTION: FIELD
    FieldDefinition field = new FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(false);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    FieldDefinition field1 = new FieldDefinition();
    field1.setName("DESCRIPTION");
    field1.setTypeName("VARCHAR");
    field1.setSize(200);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    return table;
  }
Exemplo n.º 20
0
  public static TableDefinition tableDefinition() {
    TableDefinition table = new TableDefinition();

    table.setName("INT_COMP");
    table.addField("SERNUM", java.math.BigDecimal.class, 15);
    table.addField("DESCRIP", String.class, 50);

    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;
  }
Exemplo n.º 22
0
  /** Return a platform independant definition of the LPROJECT database table. */
  public static TableDefinition tableDefinition() {
    TableDefinition definition = new TableDefinition();

    definition.setName("BUDGET");
    definition.addIdentityField("ID", BigInteger.class, 15);
    definition.addField("CUR", String.class, 3);
    definition.addField("AMNT", Double.class, 15, 2);

    return definition;
  }
  public static TableDefinition buildPHONENUMBERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_PHONENUMBER");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("OWNER_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("TYPE");
    field1.setTypeName("VARCHAR");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field2.setName("AREA_CODE");
    field2.setTypeName("VARCHAR");
    field2.setSize(3);
    field2.setShouldAllowNull(true);
    field2.setIsPrimaryKey(false);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    table.addField(field2);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field3.setName("NUMB");
    field3.setTypeName("VARCHAR");
    field3.setSize(8);
    field3.setShouldAllowNull(true);
    field3.setIsPrimaryKey(false);
    field3.setUnique(false);
    field3.setIsIdentity(false);
    table.addField(field3);

    return table;
  }
Exemplo n.º 24
0
  public static TableDefinition tableDefinition() {
    TableDefinition definition = new TableDefinition();

    definition.setName("STUDENT2");

    definition.addPrimaryKeyField("COURSE_ID", java.math.BigDecimal.class, 15);
    definition.addField("PROF", String.class, 40);
    definition.addField("COURSENAME", String.class, 40);

    return definition;
  }
Exemplo n.º 25
0
  /** Return a platform independant definition of the database table. */
  public static TableDefinition tableDefinition() {
    TableDefinition definition = new TableDefinition();

    definition.setName("OWNER_A");

    definition.addIdentityField("ID", java.math.BigDecimal.class, 15);
    definition.addField("NAME", String.class, 10);
    definition.addField("ONE_TO_ONE_", java.math.BigDecimal.class, 15);
    definition.addForeignKeyConstraint("OWNER_A_ONE_TO_ONE", "ONE_TO_ONE_", "ID", "OWNER_B");

    return definition;
  }
Exemplo n.º 26
0
  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 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 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;
  }
  /** Return a platform independant definition of the database table. */
  public static TableDefinition tableDefinition(Session session) {
    TableDefinition definition = TypeTester.tableDefinition();
    FieldDefinition fieldDef;

    definition.setName("BOOLEANS");
    fieldDef = new FieldDefinition("BOOLEANV", Boolean.class);
    fieldDef.setShouldAllowNull(false);
    definition.addField(fieldDef);

    fieldDef = new FieldDefinition("BOOLEANC", Boolean.class);
    fieldDef.setShouldAllowNull(false);
    definition.addField(fieldDef);

    return definition;
  }
  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;
  }