insert into  obj     (OBJ_ID ,NAME) values ( 1 ,"Он");
insert into  house (OBJ_ID,...)       values ( 1 ,...);
insert into  people (OBJ_ID,...)      values ( 1 ,...);

CREATE TABLE anketa_head
    (ank_id                         NUMBER NOT NULL,
    ank_type_id                    NUMBER,
    ankh_city_id                   NUMBER)
/

ALTER TABLE anketa_head
ADD CONSTRAINT pk_ank_head PRIMARY KEY (ank_id)
USING INDEX
/
ALTER TABLE anketa_head
ADD CONSTRAINT uq1_ank_head UNIQUE (ank_id, ank_type_id )
USING INDEX
/

CREATE TABLE anketa_auto(  
    ank_id        NUMBER NOT NULL,
    ank_type_id   NUMBER DEFAULT  101  CHECK (ank_type =  101  ),
    lift_num         NUMBER,
    test_bench_num   NUMBER,
    paint_room_num   NUMBER
    )
/


ALTER TABLE anketa_auto
ADD CONSTRAINT pk_ank_auto PRIMARY KEY (ank_id)
USING INDEX
/
-- Foreign Key
ALTER TABLE anketa_auto
ADD CONSTRAINT fk_uq1_ank_head FOREIGN KEY (ank_id, ank_type_id)
REFERENCES anketa_head (ank_id, ank_type_id)
/

TABLE type (type_id) PK (type_id);

TABLE object (obj_id, type_id) PK (obj_id) UNIQUE (obj_id, type_id) 
  FK ((type_id) REF type (type_id)) ;
TABLE type<x> (obj_id, type_id CONST(x)) PK (obj_id) 
  FK ((obj_id, type_id) REF object (obj_id, type_id));

TABLE role (role_id) PK (role_id);
TABLE role_type (role_id,type_id) PK (role_id,type_id) 
  FK ((type_id) REF type (type_id))  FK ((role_id) REF role (role_id));

TABLE role<y> (obj_id, type_id, role_id CONST(y)) PK (obj_id) 
  FK ((obj_id, type_id) REF object (obj_id, type_id)) 
  FK ((type_id, role_id) REF role_type (role_id,type_id));