SQL & PL/SQL

Hi

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