Oracle® Application Server TopLink Mapping Workbench User's Guide
10g Release 2 (10.1.2) Part No. B15900-01 |
|
Previous |
Next |
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. |
Column Name | Column Type | Details |
---|---|---|
EMP_ID | NUMERIC(15) | Primary key |
F_NAME | VARCHAR(40) |
|
L_NAME | VARCHAR(40) |
|
ADDRESS_ID | NUMERIC(15) |
|
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) |
|
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.