create table ot_act_dtl (apd_id number,apd_pm_cd varchar2(12), apd_qty number , apd_comp_yn_num number);

create sequence apd_id start with 1 increment by 1 cache 20

select apd_id.nextval from dual

ALTER TABLE ot_act_dtl ADD (
  CONSTRAINT AP_pk
 PRIMARY KEY
 (APD_ID))

insert into ot_act_dtl (apd_id,apd_pm_cd,apd_qty,apd_comp_yn_num) values ( apd_id.nextval,'A',1,null);

insert into ot_act_dtl (apd_id,apd_pm_cd,apd_qty,apd_comp_yn_num) values ( apd_id.nextval,'B',1,null);

COMMIT;


create table ot_act_dtl_ref (apr_apd_id number , apr_id number, apr_pm_code varchar2(12),apr_qty number,apr_comp_yn_num number);

ALTER TABLE ot_act_dtl_ref ADD (
  CONSTRAINT APr_pk
 PRIMARY KEY
 (APr_ID))
 
 
ALTER TABLE OT_act_dtl_ref ADD (
  CONSTRAINT APr_FK
 FOREIGN KEY (APr_apd_ID) 
 REFERENCES OT_ACT_DTL (APd_ID)); 

create sequence apr_id start with 1 increment by 1 cache 20

insert into ot_act_dtl_ref (apr_apd_id , apr_id , apr_pm_code ,apr_qty ,apr_comp_yn_num ) values ( 3,apr_id.nextval,'C',1,NULL)

insert into ot_act_dtl_ref (apr_apd_id , apr_id , apr_pm_code ,apr_qty ,apr_comp_yn_num ) values ( 4,apr_id.nextval,'D',2,NULL)

Commit;