oracle表继承,SQL Oracle继承关系数据库

这是一张图片：

这是我进入编码的程度：

CREATE TYPE appointment_list_type AS TABLE OF REF appointment_type;

/

CREATE OR REPLACE TYPE person_type AS OBJECT (

personID NUMBER,

Surname varchar2(10),

Forname varchar2(10),

dateOfBirth date,

AddressLine1 varchar2(30),

AddressLine2 varchar2(30),

Town varchar2(10),

contacTel1 varchar2(10),

contacTel2 varchar2(10)) NOT FINAL;

/

CREATE TYPE applicant_type UNDER person_type(

applicantID NUMBER,

maxPrice number(7,2),

desiredArea varchar2(10),

Attends appointment_list_type

);

/

CREATE TYPE salesperson_type UNDER person_type(

salespersonID NUMBER,

manager varchar2(10),

Makes appointment_list_type

);

/

这就是创建将其分为销售人员和申请人的继承人的类型.

CREATE TYPE appointment_type AS OBJECT(

appointmentID NUMBER,

Appdate date,

Apptime timestamp,

appointmentType varchar2(10),

levelOfInterest varchar2(10),

offerMade varchar2(10),

Made_by REF salesperson_type,

Attends_by REF applicant_type

);

/

这是约会类型,引用可以将它们联系在一起.

用于创建表：

CREATE TABLE person_table OF person_type (

personID PRIMARY KEY NOT NULL)

NESTED TABLE Attends STORE AS attend_meeting_table;

CREATE TABLE applicant_table OF applicant_type (

personID PRIMARY KEY NOT NULL)

NESTED TABLE Attends STORE AS attend_meeting_table;

CREATE TABLE salesperson_table OF salesperson_type (

personID PRIMARY KEY NOT NULL)

NESTED TABLE Makes STORE AS makes_meeting_table;

CREATE TABLE appointment_table OF appointment_type (

appointmentID PRIMARY KEY NOT NULL,

SCOPE FOR (Made_by) IS person_table,

SCOPE FOR (Attends_by) IS person_table);

这里还有一些我所做的代码,现在我的问题是：

继承如何直接在约会中执行1到多个？

我真的很困惑.任何人都可以帮助我如何做到这一点？