Help with constraints on object relational tables

Hi

I hope I am posting in the correct places. I am looking for some help that is hopefully explained in the example below:

I am looking to create an object relational database with a check constraint on the relationships. For example:

• I have table called person_tab which is a table of person_t type.
• Person_t type is inherited by the manager_t type and the applicant_t type.
• I have a second table called interview_tab of interview_t type.
• The interview table has two columns (manager and appilcant) that are scope restrained to the person table.
• I would also like to put check constraints on these columns to say: ----- Manager: check the person_number is less than 20000 ----- Applicant: check the person_number is greater than 19999

Can anyone tell me if this is possible and if so how can it be done?

Thanks in advance
Stephen Received on Wed Mar 29 2006 - 03:17:09 CST