Collection table from entity "business/project.ef" is expanded by the SoProMach[tm] into the list of table columns of lines 6-14. This is the first of the two steps of Software Mold "DB/mold1-.sql". The second one translates collection pkey to the primary key of line 15. The heading and trailing parts of the file are respectively derived from scripts "DB/mold1-.sql/file.hdr" (lines 1-5) and "DB/mold1-.sql/file.trl" (lines 16-18).

    1      --
    2      -- This SQL script created by somusar/SoProMach[tm]
    3      --
    4      
    5      create table project (
    6          projid                    varchar(10),
    7          projname                  varchar(40),
    8          descr                     varchar(200),
    9          companyname               varchar(80),
   10          budget                    decimal(10,2),
   11          teammembersemplid         int,
   12          manageremplid             int,
   13          deptid                    varchar(10),
   14          internal                  char(1),
   15          constraint pk_project     primary key    (projid)
   16      )
   17      ;
   18      
	       

Some notes about the correspondence between the contents of the Software Entity file business/project.ef and the contents of the generated Java file:

• The comment at the beginning of project.ef has been carried over and properly formatted (lines 10-12);

• Sisendel enumeration proj_status has been mapped to a Java int and a set of values (lines 22-25 and 121-128);

• Relationships to other Software Entities have been mapped to members corresponding to the primary keys (pkey) of each related-to Software Entity: for example, the link to department in project.ef is implemented by member departmentDeptId (line 34), as department.ef defines dept_id as its pkey.

    1      /*
    2       * This Java class generated by somusar/SoProMach[tm].
    3       */
    4      
    5      package com.somusar.entdemo.business;
    6      
    7      /**
    8       *   Class Project:
    9       *
   10       *   A project within a company, some information about it, 
   11       *   a project manager, the involved personnel, a project 
   12       *   plan and budget.
   13       */
   14      
   15      import com.somusar.entdemo.business.Customer;
   16      import com.somusar.entdemo.company.Employee;
   17      import java.util.Collection;
   18      import com.somusar.entdemo.company.Department;
   19      
   20      public class Project {
   21      
   22          // Map enum 'Proj. status' onto an int with a set of values
   23          public final int OK                 = 0; // OK
   24          public final int LATE               = 1; // Late
   25          public final int DANGER             = 2; // Danger
   26      
   27          private String       projId;             
   28          private String       projName;           
   29          private String       descr;              
   30          private String       customerCompanyName;   // relationship to Customer
   31          private double       budget;             // range 0-1000
   32          private Collection   teamMembers;        
   33          private int          managerEmplId;      // relationship to Employee
   34          private String       departmentDeptId;   // relationship to Department
   35          private boolean      internal;           
   36          
   37          /*
   38           *   Get methods
   39           */
   40      
   41          public String getProjId() {
   42              return projId;
   43          }
   44      
   45          public String getProjName() {
   46              return projName;
   47          }
   48      
   49          public String getDescr() {
   50              return descr;
   51          }
   52      
   53          public String getCustomerCompanyName() {
   54              return customerCompanyName;
   55          }
   56      
   57          public double getBudget() {
   58              return budget;
   59          }
   60      
   61          public Collection getTeamMembers() {
   62              return teamMembers;
   63          }
   64      
   65          public int getManagerEmplId() {
   66              return managerEmplId;
   67          }
   68      
   69          public String getDepartmentDeptId() {
   70              return departmentDeptId;
   71          }
   72      
   73          public boolean getInternal() {
   74              return internal;
   75          }
   76      
   77          /*
   78           *   Set methods
   79           */
   80      
   81          public void setProjId( String projId ) {
   82              this.projId = projId;
   83          }
   84      
   85          public void setProjName( String projName ) {
   86              this.projName = projName;
   87          }
   88      
   89          public void setDescr( String descr ) {
   90              this.descr = descr;
   91          }
   92      
   93          public void setCustomerCompanyName( String customerCompanyName ) {
   94              this.customerCompanyName = customerCompanyName;
   95          }
   96      
   97          public void setBudget( double budget ) {
   98              this.budget = budget;
   99          }
  100      
  101          public void setTeamMembers( Collection teamMembers ) {
  102              this.teamMembers = teamMembers;
  103          }
  104      
  105          public void setManagerEmplId( int managerEmplId ) {
  106              this.managerEmplId = managerEmplId;
  107          }
  108      
  109          public void setDepartmentDeptId( String departmentDeptId ) {
  110              this.departmentDeptId = departmentDeptId;
  111          }
  112      
  113          public void setInternal( boolean internal ) {
  114              this.internal = internal;
  115          }
  116      
  117          /**
  118           *   Method 'Current proj. status'
  119           */
  120      
  121          // Return type corresponds to enum 'Proj. status'
  122          public int curStatus (
  123                          Object plan,
  124                          double budget
  125                 )
  126          {
  127              // insert your Java method code here
  128          }
  129      
  130      }