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 |
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: