CREATE TABLE "BLUDES"
( "ID" VARCHAR2(10) NOT NULL ENABLE,
"B_NAME" VARCHAR2(64) NOT NULL ENABLE,
"B_INGRES" NUMBER,
"PRICE" NUMBER,
"IMAGE" BFILE,
"B_TYPE" NUMBER,
CONSTRAINT "BLUDES_PK" PRIMARY KEY ("ID") ENABLE
)
/

CREATE OR REPLACE TRIGGER "BI_BLUDES"
before insert on "BLUDES"
for each row
begin
if :NEW."ID" is null then
select "BLUDES_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;

/
ALTER TRIGGER "BI_BLUDES" ENABLE
/

CREATE TABLE "INGTES"
( "ID" NUMBER,
"I_NAME" VARCHAR2(64) NOT NULL ENABLE,
"I_DATE" DATE NOT NULL ENABLE,
"I_PRICE" NUMBER(6,2) NOT NULL ENABLE,
"I_COUNT" NUMBER(7,3) NOT NULL ENABLE,
"I_TYPE" NUMBER,
CONSTRAINT "INGTES_PK" PRIMARY KEY ("ID") ENABLE
)
/

CREATE OR REPLACE TRIGGER "BI_INGTES"
before insert on "INGTES"
for each row
begin
if :NEW."ID" is null then
select "INGTES_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;

/
ALTER TRIGGER "BI_INGTES" ENABLE
/

CREATE TABLE "INGRES_FOR_BLUD"
( "ID" NUMBER NOT NULL ENABLE,
"B_ID" NUMBER,
"I_ID" NUMBER,
"COUNT" NUMBER,
CONSTRAINT "INGRES_FOR_BLUD_PK" PRIMARY KEY ("ID") ENABLE
)
/

CREATE OR REPLACE TRIGGER "BI_INGRES_FOR_BLUD"
before insert on "INGRES_FOR_BLUD"
for each row
begin
if :NEW."ID" is null then
select "INGRES_FOR_BLUD_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;

/
ALTER TRIGGER "BI_INGRES_FOR_BLUD" ENABLE
/