Звязанные таблициы в InterBase

/* Domain definitions */
CREATE DOMAIN "D_CAPTION" AS VARCHAR(100);
CREATE DOMAIN "D_HINT" AS BLOB SUB_TYPE TEXT SEGMENT SIZE 80;
CREATE DOMAIN "D_ID" AS NUMERIC(10, 0) NOT NULL;
CREATE DOMAIN "D_CATEGORY" AS INTEGER
     CHECK (VALUE in (0,1,2,3,4,5,6));

/* Table: CONSTANTS, Owner: SYSDBA */

CREATE TABLE "CONSTANTS"
(
  "ID"  "D_ID",
  "NAME"    "D_CAPTION" NOT NULL,
  "TYPE"    CHAR(20) NOT NULL,
  "HINT"    "D_HINT",
CONSTRAINT "CONSTANTS_PK" PRIMARY KEY ("ID")
);
SET TERM ^ ;


/* Triggers only will work for SQL triggers */

CREATE TRIGGER "CONSTANTS_BI_ID" FOR "CONSTANTS"
ACTIVE BEFORE INSERT POSITION 0
as
    BEGIN
        NEW.id = GEN_ID(CONSTANTS_id, 1);
    END
 ^

CREATE TRIGGER "CONSTANTS_AI_PE" FOR "CONSTANTS"
ACTIVE AFTER INSERT POSITION 0
AS
    BEGIN
        POST_EVENT 'INSERT_CONSTANTS';
    END
 ^

CREATE TRIGGER "CONSTANTS_AU_PE" FOR "CONSTANTS"
ACTIVE AFTER UPDATE POSITION 0
AS
    BEGIN
        POST_EVENT 'UPDATE_CONSTANTS';
    END
 ^

CREATE TRIGGER "CONSTANTS_AD_PE" FOR "CONSTANTS"
ACTIVE AFTER DELETE POSITION 0
AS
    BEGIN
        POST_EVENT 'DELETE_CONSTANTS';
    END
 ^

COMMIT WORK ^
SET TERM ;^

/* Table: TRAVELS, Owner: SYSDBA */

CREATE TABLE "TRAVELS"
(
  "ID"  "D_ID",
  "NAME"    "D_CAPTION" NOT NULL,
  "HINT"    "D_HINT",
  "END" INTEGER,
CONSTRAINT "TRAVELS_PK" PRIMARY KEY ("ID")
);
SET TERM ^ ;


/* Triggers only will work for SQL triggers */

CREATE TRIGGER "TRAVELS_BI_ID" FOR "TRAVELS"
ACTIVE BEFORE INSERT POSITION 0
as
    BEGIN
        NEW.id = GEN_ID(TRAVELS_id, 1);
    END
 ^

CREATE TRIGGER "TRAVELS_AI_PE" FOR "TRAVELS"
ACTIVE AFTER INSERT POSITION 0
AS
    BEGIN
        POST_EVENT 'INSERT_TRAVELS';
    END
 ^

CREATE TRIGGER "TRAVELS_AU_PE" FOR "TRAVELS"
ACTIVE AFTER UPDATE POSITION 0
AS
    BEGIN
        POST_EVENT 'UPDATE_TRAVELS';
    END
 ^

CREATE TRIGGER "TRAVELS_AD_PE" FOR "TRAVELS"
ACTIVE AFTER DELETE POSITION 0
AS
    BEGIN
        POST_EVENT 'DELETE_TRAVELS';
    END
 ^

COMMIT WORK ^
SET TERM ;^


/* Table: GROUPS, Owner: SYSDBA */

CREATE TABLE "GROUPS"
(
  "ID"  "D_ID",
  "TRAVEL"  "D_ID",
  "NUMBER"  INTEGER,
  "NAME"    "D_CAPTION",
  "HINT"    "D_HINT",
  "CATEGORY"    "D_CATEGORY",
  "TYPE"    "D_ID",
CONSTRAINT "GROUPS_PK" PRIMARY KEY ("ID")
);
ALTER TABLE "GROUPS" ADD CONSTRAINT "GRO_CON_FK" FOREIGN KEY ("TYPE") REFERENCES CONSTANTS ("ID") ON UPDATE CASCADE;
ALTER TABLE "GROUPS" ADD CONSTRAINT "GRO_TRA_FK" FOREIGN KEY ("TRAVEL") REFERENCES TRAVELS ("ID") ON UPDATE CASCADE ON DELETE CASCADE;
SET TERM ^ ;


/* Triggers only will work for SQL triggers */

CREATE TRIGGER "GROUPS_BI_ID" FOR "GROUPS"
ACTIVE BEFORE INSERT POSITION 0
as
    BEGIN
        NEW.id = GEN_ID(GROUPS_id, 1);
    END
 ^

CREATE TRIGGER "GROUPS_AI_PE" FOR "GROUPS"
ACTIVE AFTER INSERT POSITION 0
AS
    BEGIN
        POST_EVENT 'INSERT_GROUPS';
    END
 ^

CREATE TRIGGER "GROUPS_AU_PE" FOR "GROUPS"
ACTIVE AFTER UPDATE POSITION 0
AS
    BEGIN
        POST_EVENT 'UPDATE_GROUPS';
    END
 ^

CREATE TRIGGER "GROUPS_AD_PE" FOR "GROUPS"
ACTIVE AFTER DELETE POSITION 0
AS
    BEGIN
        POST_EVENT 'DELETE_GROUPS';
    END
 ^

COMMIT WORK ^
SET TERM ;^

"ID" "D_ID" NOT NULL UNIQUE

"TRAVEL""D_ID" REFERENCES TRAVELS (ID) ON DELETE CASCADE ON UPDATE CASCADE

"ID" "D_ID" NOT NULL UNIQUE

"TRAVEL""D_ID" REFERENCES TRAVELS (ID) ON DELETE CASCADE ON UPDATE CASCADE

CREATE TABLE "TRAVELS"
(
  "ID"  "D_ID",
  "NAME"    "D_CAPTION" NOT NULL,
  "HINT"    "D_HINT",
  "END" INTEGER,
CONSTRAINT "TRAVELS_PK" PRIMARY KEY ("ID")
)

ALTER TABLE "GROUPS" ADD CONSTRAINT "GRO_TRA_FK" FOREIGN KEY ("TRAVEL") REFERENCES TRAVELS ("ID") ON UPDATE CASCADE ON DELETE CASCADE;