# Generate the tutorial database schema

The tutorial application uses 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.