create table OT_INSP_HEAD
(IH_SYS_ID NUMBER,
IH_TXN_CODE VARCHAR2(12),
IH_NO       NUMBER);

CREATE UNIQUE INDEX OT_INSP_HEAD_PK ON OT_INSP_HEAD
(IH_SYS_ID);

ALTER TABLE OT_INSP_HEAD ADD (
  CONSTRAINT OT_INSP_HEAD_PK
 PRIMARY KEY
 (IH_SYS_ID));


create table OT_INSP_ITEM
(II_SYS_ID NUMBER,
II_ITEM_CODE VARCHAR2(12),
II_QTY        NUMBER,
II_QTY_LS      NUMBER);

CREATE UNIQUE INDEX OT_INSP_ITEM_UK ON OT_INSP_ITEM
(II_SYS_ID);

CREATE INDEX OT_INSP_ITEM_NX_01 ON OT_INSP_ITEM
(II_IH_SYS_ID);


ALTER TABLE OT_INSP_ITEM ADD (
  CONSTRAINT OT_INSP_ITEM_FK_01 
 FOREIGN KEY (II_IH_SYS_ID) 
 REFERENCES OT_INSP_HEAD (IH_SYS_ID));

create table OT_INSP_HEAT
(IG_SYS_ID NUMBER,
IG_II_SYS_ID NUMBER,
IG_QTY       NUMBER);

CREATE INDEX OT_INSP_HEAT_IDX_01 ON OT_INSP_HEAT
(IG_II_SYS_ID);

CREATE UNIQUE INDEX OT_INSP_HEAT_PK ON OT_INSP_HEAT
(IG_SYS_ID);


ALTER TABLE OT_INSP_HEAT ADD (
  CONSTRAINT OT_INSP_HEAT_PK
 PRIMARY KEY
 (IG_SYS_ID));


ALTER TABLE OT_INSP_HEAT ADD (
  CONSTRAINT OT_INSP_HEAT_FK_1 
 FOREIGN KEY (IG_II_SYS_ID) 
 REFERENCES OT_INSP_ITEM (II_SYS_ID));

                                                  OT_INSP_HEAT
			 OT_INSP_ITEM             ==============
OT_INSP_HEAD             =================        IG_SYS_ID (PK)
==============           II_SYS_ID (PK)     <---- IG_II_SYS_ID (FK)
IH_SYS_ID (PK)   <-----  II_IH_SYS_ID (FK)

ig_ii_sys_id = ii_sys_id