About the SROUTEDB database

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:

A diagram summarizing the interactions between the message flow and the user database.

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.

A diagram showing how the two tables relate to each other, as described in the text.

The DEPARTMENT table

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

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

Back to About the Simplified Database Routing sample