Database Reference
In-Depth Information
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.