Skip Headers
Oracle® Application Server TopLink Mapping Workbench User's Guide
10g Release 2 (10.1.2)
Part No. B15900-01
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

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.