"Table inheritance" in Oracle [message #448927] |
Thu, 25 March 2010 17:40  |
rivvorz
Messages: 2 Registered: March 2010 Location: UK
|
Junior Member |
|
|
Hello there,
Please excuse the crude example below, but I am finding the Object Relational implementation rather confusing!
If Employee and Customer are sub-types of Person, when creating the object tables, how can you name the necessary Nested Tables to represent the relationships of the Child objects?
[PERSON]
|
__________|__________
| |
| |
[EMPLOYEE] [CUSTOMER]
|1 |1
| |
| organises | attends
|(organisedBy) | (isAttendedBy)
| |
|* |*
------[EVENTS]-------
CREATE TABLE Person_TBL of Person (Person# PRIMARY KEY)
NESTED TABLE organises STORE AS EventListType;
Am I right in thinking that the Person table will hold both Employee and Customer objects (object types have been declared such)?
But then how would the Nested tables of Employee.organises and Customer.attends be named?
Advice much appreciated!
|
|
|
|
|
|
|