/* Domain definitions */
CREATE DOMAIN "A100" AS VARCHAR(100);
CREATE DOMAIN "A15" AS VARCHAR(15);
CREATE DOMAIN "A2" AS VARCHAR(2);
CREATE DOMAIN "A20" AS VARCHAR(20);
CREATE DOMAIN "A50" AS VARCHAR(50);
CREATE DOMAIN "LINT" AS INTEGER;
CREATE DOMAIN "SJ" AS DATE;
/* Table: CUSTOMER, Owner: SYSDBA */
CREATE TABLE "CUSTOMER"
(
"CNO" "LINT" NOT NULL,
"NAME" "A20" NOT NULL,
"SEX" "A2",
"BIRTH" "SJ",
"HYMEN" "A20",
"JOB" "A20",
"RENTE" "A20",
"ID" "A20",
"SOURCE" "A20",
"KNOW" "A20",
"EXTENT" "A20",
"NEAR" "A20",
"MEET" "A20",
"COMMEND" "A20",
"COMPANY" "A50",
"CADDER" "A50",
"CTEL" "A15",
"HOMEADDER" "A50",
"HTEL" "A15",
"PTEL" "A15",
"BP" "A15",
"DEMAND" "A100",
"GRADATE" "A20",
PRIMARY KEY ("CNO")
);
SET TERM ^ ;
/* Triggers only will work for SQL triggers */
CREATE TRIGGER "DEL_B_D_R" FOR "CUSTOMER"
ACTIVE BEFORE DELETE POSITION 0
as
begin
delete from bf where bh=old.cno;
delete from jd where bh=old.cno;
delete from jr where bh=old.cno;
end
^
COMMIT WORK ^
SET TERM ;^