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 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 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 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;
}
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 static TableDefinition buildCREDITLINESTable() {
TableDefinition table = new TableDefinition();
table.setName("EMP_CREDITLINES");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("EMP_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
table.addField(fieldID);
FieldDefinition fieldBANK = new FieldDefinition();
fieldBANK.setName("BANK");
fieldBANK.setTypeName("VARCHAR");
fieldBANK.setSize(4);
fieldBANK.setShouldAllowNull(false);
fieldBANK.setIsPrimaryKey(false);
fieldBANK.setUnique(true);
fieldBANK.setIsIdentity(false);
table.addField(fieldBANK);
FieldDefinition fieldACCOUNT = new FieldDefinition();
fieldACCOUNT.setName("ACCOUNT");
fieldACCOUNT.setTypeName("VARCHAR");
fieldACCOUNT.setSize(10);
fieldACCOUNT.setShouldAllowNull(false);
fieldACCOUNT.setIsPrimaryKey(false);
fieldACCOUNT.setUnique(false);
fieldACCOUNT.setIsIdentity(false);
table.addField(fieldACCOUNT);
return table;
}
public static TableDefinition buildCREDITCARDSTable() {
TableDefinition table = new TableDefinition();
table.setName("XMLEmployee_CREDITCARDS");
FieldDefinition fieldID = new FieldDefinition();
fieldID.setName("EMP_ID");
fieldID.setTypeName("NUMERIC");
fieldID.setSize(15);
fieldID.setShouldAllowNull(false);
fieldID.setIsPrimaryKey(false);
fieldID.setUnique(false);
fieldID.setIsIdentity(false);
fieldID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
table.addField(fieldID);
FieldDefinition fieldCARD = new FieldDefinition();
fieldCARD.setName("CARD");
fieldCARD.setTypeName("VARCHAR");
fieldCARD.setSize(2);
fieldCARD.setShouldAllowNull(false);
fieldCARD.setIsPrimaryKey(false);
fieldCARD.setUnique(true);
fieldCARD.setIsIdentity(false);
table.addField(fieldCARD);
FieldDefinition fieldNUMB = new FieldDefinition();
fieldNUMB.setName("NUMB");
fieldNUMB.setTypeName("VARCHAR");
fieldNUMB.setSize(10);
fieldNUMB.setShouldAllowNull(false);
fieldNUMB.setIsPrimaryKey(false);
fieldNUMB.setUnique(false);
fieldNUMB.setIsIdentity(false);
table.addField(fieldNUMB);
return table;
}
public static TableDefinition buildDEALERTable() {
TableDefinition table = new TableDefinition();
table.setName("CMP3_XML_DEALER");
FieldDefinition field = new FieldDefinition();
field.setName("DEALER_ID");
field.setTypeName("NUMERIC");
field.setSize(15);
field.setShouldAllowNull(false);
field.setIsPrimaryKey(true);
field.setUnique(false);
field.setIsIdentity(true);
table.addField(field);
FieldDefinition field0 = new FieldDefinition();
field0.setName("FK_EMP_ID");
field0.setTypeName("NUMERIC");
field0.setSize(15);
field0.setShouldAllowNull(true);
field0.setIsPrimaryKey(false);
field0.setUnique(false);
field0.setIsIdentity(false);
field0.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
table.addField(field0);
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);
FieldDefinition field3 = new FieldDefinition();
field3.setName("STATUS");
field3.setTypeName("VARCHAR");
field3.setSize(40);
field3.setShouldAllowNull(true);
field3.setIsPrimaryKey(false);
field3.setUnique(false);
field3.setIsIdentity(false);
table.addField(field3);
FieldDefinition field4 = new FieldDefinition();
field4.setName("VERSION");
field4.setTypeName("NUMERIC");
field4.setSize(15);
field4.setShouldAllowNull(true);
field4.setIsPrimaryKey(false);
field4.setUnique(false);
field4.setIsIdentity(false);
table.addField(field4);
return table;
}
