Databases Reference
In-Depth Information
Figure 4-3.
Defining the table's primary key
6.
Select the
Populated from a new sequence
radio button. After the screen changes, select
TICKET_ID (NUMBER)
for the primary key. Click
Next
.
7.
You're not going to create any foreign keys in this table just yet, so leave the defaults and
click
Next
.
The Constraints screen in Figure
4-4
allows you to add either Unique or Check constraints to the table definition.
You add a constraint by defining the constraint in the Add Constraints region and clicking the Add button to add it to
the list. Below the Add Constraints region are two help regions. Clicking the arrow to the left of the region title expands
the help and shows the columns you defined in the table and examples of how to code various check constraints.
Figure 4-4.
The Constraints definition step
