The SROUTEDB database contains two tables called EMPLOYEE and DEPARTMENT. The following diagram shows how the sample message flow interacts with the tables based on the content of the test messages:
The following diagram shows how the tables are linked through common values for columns EMPLOYEE.EMPNUM to DEPARTMENT.MGRNUM, and DEPARTMENT.DEPTNUM to EMPLOYEE.WORKDEPT.
The DEPARTMENT table contains information about the departments in the company. The Simplified Database Routing message flow queries the data in the table.
The following table shows the structure for the database table called DEPARTMENT that is used in the sample.
Field name | Data type | Null? | Content |
---|---|---|---|
DEPTNUM | CHAR(3) | No | The unique number for the department. |
DEPTNAME | VARCHAR(36) | No | The descriptive name of the department. |
MGRNUM | CHAR(6) | Yes | The unique manager number of the department's manager. |
The following table shows the contents of the database table called DEPARTMENT that is used in the sample.
DEPTNUM | DEPTNAME | MGRNUM |
---|---|---|
D00 | Personnel | 000010 |
D01 | Development | 000020 |
D02 | Support | 000030 |
The EMPLOYEE table contains employee data. The Simplified Database Routing message flow queries the data in the table.
The following table shows the structure for the database table called EMPLOYEE that is used in this sample.
Field name | Data type | Null? | Content |
---|---|---|---|
EMPNUM | CHAR(6) | No | The unique number for the employee. |
FIRSTNM | VARCHAR(20) | No | The first name of the employee. |
LASTNM | VARCHAR(15) | No | The last name of the employee. |
PHONENUM | CHAR(4) | Yes | The employee's internal company telephone extension number. |
WORKDEPT | CHAR(3) | Yes | The department number where the employee works in the company. |
YEARSSERVICE | INTEGER | Yes | The number of years of company service built up by the employee. |
AGEINYRS | INTEGER | Yes | The age of the employee in years. |
SEX | CHAR(1) | Yes | The employee's gender. |
SALARY | DECIMAL(9,2) | Yes | The annual salary of the employee. |
The following table shows the contents of the database table called EMPLOYEE that is used in the sample.
EMPNUM | FIRSTNM | LASTNM | PHONENUM | WORKDEPT | YEARSSERVICE | AGEINYRS | SEX | SALARY |
---|---|---|---|---|---|---|---|---|
000010 | DAVID | BROWN | 4501 | D01 | 10 | 54 | M | 23250.00 |
000020 | SALLY | KWAN | 4738 | D00 | 9 | 27 | F | 18375.00 |
000030 | JOHN | GEYER | 6789 | D01 | 22 | 47 | M | 53000.00 |
000040 | EVA | SMITH | 7831 | D00 | 12 | 37 | F | 29000.00 |