Adding Table Columns

Prerequisites

The structure of your project QuickCarRentalDictionary is currently displayed in the Dictionary Explorer.

You have created the table QCR_RESERVATION.

Procedure

...

       1.      If not already done so, open the table editor by double-clicking the name of the newly created table QCR_RESERVATION in the Dictionary Explorer.

       2.      Enter the table description Table contains all reservation data for QuickCarRental example in the Description field.

       3.      Choose the icon  Add Column to create the first table column.

A wizard is started in which you can fully specify the table column.

       4.      On the Built-in Type tab, assign the following values to the selected properties:

Column Name

Built-in Type

Length

Key

Description

ID

string

10

activated

unique identifier for reservation

       5.      Confirm by choosing Finish

In creating this first column with the name ID, you have created the key element of the table.

       6.      Repeat the last steps for the other columns. Define the columns as follows:

Column Name

Built-in Type

Length

Not Null

Description

VEHICLETYPEID

string

20

activated

type of the car

RESERVATIONDATE

timestamp

activated

creation date for reservation data

DATEFROM

timestamp

activated

date, when reservation period is started

DATETO

timestamp

activated

date, when reservation period ends

PICKUPLOCATION

string

30

activated

pickup location

DROPOFFLOCATION

string

30

activated

dropoff location

STATUS

string

20

activated

status of reservation

Note that the assignment of the JDBC Type property results from the specifications for Built-in Type and Length and is automatically set by the wizard.

       7.      Save the new metadata by choosing the icon  (Save All Metadata) from the toolbar.

Result

You have created the table QCR_RESERVATION locally in your Dictionary project and fully specified it with table columns. As a component of the Java Dictionary, the table has a database-independent definition.

Next step:

Creating an SDA