Databases Reference
In-Depth Information
The next set of steps is purposefully a bit more vague than the previous ones. You should be used to using the
Create Table Wizard by now, but if you need a refresher, just look at the previous steps.
12.
Choose
Populate from a new sequence
for the primary key, select
TICKET_DETAILS_ID(NUMBER)
as the
Primary Key
column, and click
Next
.
13.
Add a foreign key between the
TICKET_ID
in the
TICKET_DETAILS
table and the
TICKET_ID
in the
TICKETS
table. Make sure the Delete action is set to
Cascade Delete
. Your screen
should look similar to that in Figure
4-7
. Additionally, make sure you tab out of the
References Table field in order to cause APEX to display the shuttle control that allows you
to choose the referenced columns.
Figure 4-7.
Defining a cascade-delete foreign key for
TICKET_ID
14.
Click the
Add
button to add the new foreign-key constraint.
15.
Click
Next
(see Figure
4-8
).
Figure 4-8.
Foreign key as defined in the table wizard
16.
No constraints are required for this table. Click
Next
.
17.
Review the SQL, and click
Create Table
to complete the wizard.