Creating the Database Schema

The ACME employee system stores the employee data in three database tables. Later in this tutorial, you will be able to create these tables from the OracleAS TopLink Mapping Workbench or import them from your database application.

Note: The column types listed here are generic; the actual column types depend on the database used.

Table B-1 EMPLOYEE Table

Column Name	Column Type	Details
EMP_ID	NUMERIC(15)	Primary key
F_NAME	VARCHAR(40)
L_NAME	VARCHAR(40)
ADDRESS_ID	NUMERIC(15)

Table B-2 ADDRESS Table

Column Name	Column Type	Details
ADDRESS_ID	NUMERIC(15)	Primary key
COUNTRY	VARCHAR(80)
STREET	VARCHAR(80)
CITY	VARCHAR(80)
PROVINCE	VARCHAR(80)
P_CODE	VARCHAR(20)

Table B-3 PHONE Table

Column Name	Column Type	Details
EMP_ID	NUMERIC(15)	Primary key
AREA_CODE	CHAR(3)
P_NUMBER	CHAR(7)
TYPE	VARCHAR(15)	Primary key

Table B-4 SEQUENCE Table

Column Name	Column Type	Details
SEQ_NAME	NUMERIC(38)
SEQ_COUNT	NUMERIC(38)	Primary key

After creating these ACME database tables, you are ready to begin the tutorial.