-- create tables create table ch20_psm ( id number generated by default on null as identity constraint ch20_psm_id_pk primary key, description varchar2(80 char) not null, unit_of_measure varchar2(5 char) constraint ch20_psm_unit_of_measure_ck check (unit_of_measure in ('MM','CM','M','PIECE')) not null, price number not null ) ; create table ch20_bom ( id number generated by default on null as identity constraint ch20_bom_id_pk primary key, subprt_id number constraint ch20_bom_subprt_id_fk references ch20_psm on delete cascade not null, aggreg_id number constraint ch20_bom_aggreg_id_fk references ch20_psm on delete cascade not null, quantity number not null ) ; -- table index to prevent duplicate pairs (aggreg_id+subprt_id) create unique index ch20_bom_ui on ch20_bom (subprt_id,aggreg_id); -- load data -- Generated by Quick SQL Monday January 23, 2023 16:48:49 /* ch20_psm description vc80 /nn, unit_of_measure vc4 /check 'mm','cm','m', 'piece' /nn, price num /nn ch20_bom subprt_id num /fk ch20_psm /nn, aggreg_id num /fk ch20_psm /nn, quantity num /nn # settings = { semantics: "CHAR", language: "EN", APEX: true } */