Generate the tutorial database schema |
The tutorial application uses a three database tables to store each employee's information: EMPLOYEE, ADDRESS and PHONE. Table: Tutorial Database Schema describes the columns for each table.
You can download SQL scripts to build and populate the database tables with sample data from http://www.eclipse.org/dali/docs/dbscripts.zip
.
Tutorial Database Schema
Table | Column | Type | Details |
---|---|---|---|
EMPLOYEE
|
EMP_ID |
NUMBER(15) |
Primary Key |
F_NAME |
VARCHAR(40) |
|
|
L_NAME |
VARCHAR(40) |
|
|
ADDR_ID |
NUMBER(15) |
Foreign Key, references ADDRESS.ADDRES_ID |
|
VERSION |
NUMBER(15) |
|
|
ADDRESS
|
ADDRESS_ID |
NUMBER(15) |
Primary Key |
PROVINCE |
VARCHAR(80) |
|
|
COUNTRY |
VARCHAR(80) |
|
|
STREET |
VARCHAR(80) |
|
|
P_CODE |
VARCHAR(20) |
|
|
CITY |
VARCHAR(80) |
|
|
PHONE
|
EMP_ID |
NUMBER(15) |
Foreign Key, reference to EMPLOYEE.EMP_ID |
AREA_CODE |
VARCHAR(3) |
|
|
P_NUMBER |
VARCHAR(7) |
Primary key |
|
TYPE |
VARCHAR(15) |
|
Next, you will Create a database connection.