******************* TERM ^;
/***************************************** *******************/
/*** Triggers for tables ***/
/***************************************** *******************/
/* Trigger: OTDEL_BI0 */OR ALTER TRIGGER OTDEL_BI0 FOR OTDEL_KNIGBEFORE INSERT OR UPDATE POSITION 0 (NEW. nomer_otdela is null) then. nomer_otdela=gen_id (gen_otdel_knig, 1);
^
SET TERM; ^
/* Fields descriptions */
COMMENT ON COLUMN OTDEL_KNIG. NOMER_OTDELA IS
VALUE gt; 0 raquo ;; ON COLUMN OTDEL_KNIG. KOL_VO_KNIG IS
VALUE gt; 0 raquo ;; ON COLUMN OTDEL_KNIG. NOMER_BIBLIOTEKORYA IS
VALUE gt; 0 raquo ;;
Видача книг
CREATE TABLE VIDA4A_KNIG (_ZAPISI D_INDEXTYPE NOT NULL/* D_INDEXTYPE=INTEGER NOT NULL * /, _ KNIGI D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, _ BIBLIOTEKORYA D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, _CHITATELYA D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, _ VYDA4I_KNIGI D_DATETYPE/* D_DATETYPE=DATE NOT NULL * /, _ VOZVRATA_KNIGI D_DATETYPE/* D_DATETYPE=DATE NOT NULL */
);
/***************************************** *******************/
/*** Primary Keys ***/
/***************************************** *******************/TABLE VIDA4A_KNIG ADD CONSTRAINT PK_VIDA4A_KNIG PRIMARY KEY (NOMER_ZAPISI);
/***************************************** *****************/
/*** Foreign Keys ***/
/***************************************** *******************/
ALTER TABLE VIDA4A_KNIG ADD CONSTRAINT FK_VIDA4A_KNIG_1 FOREIGN KEY (NOMER_KNIGI) REFERENCES KNIGI (NOMER_KNIGI); TABLE VIDA4A_KNIG ADD CONSTRAINT FK_VIDA4A_KNIG_2 FOREIGN KEY (NOMER_BIBLIOTEKORYA) REFERENCES BIBLIOTEKOR (NOMER_BIBLIOTEKORYA);
/***************************************** *******************/
/*** Triggers ***/
/***************************************** *******************/
SET TERM ^;
/***************************************** *******************/
/*** Triggers for tables ***/
/***************************************** *******************/
/* Trigger: VYDACHA_KNIG_BI0 */OR ALTER TRIGGER VYDACHA_KNIG_BI0 FOR VIDA4A_KNIGBEFORE INSERT OR UPDATE POSITION 0 (NEW. nomer_zapisi is null) then. nomer_zapisi=gen_id (gen_vida4a_knig, 1); ^ TERM; ^
/* Fields descriptions */ON COLUMN VIDA4A_KNIG. NOMER_ZAPISI IS
VALUE gt; 0 raquo ;; ON COLUMN VIDA4A_KNIG. NOMER_KNIGI IS
VALUE gt; 0 raquo ;; ON COLUMN VIDA4A_KNIG. NOMER_BIBLIOTEKORYA IS
VALUE gt; 0 raquo ;; ON COLUMN VIDA4A_KNIG. NOMER_CHITATELYA IS
VALUE gt; 0 raquo ;;
Уявлення
/* View: KNIGI_VIEW */VIEW KNIGI_VIEW (_KNIGI, _OTDELA, _KNIGI, _VO_STRANIC,) knigi. nomer_knigi, otdel_knig. nomer_otdela, knigi. nazvanie_knigi, knigi. kol_vo_stranic, knigi. avtorknigi, otdel_knigknigi. nomer_otdela=otdel_knig. nomer_otdela
;
/* View: VOZVRAT_VIEW */VIEW VOZVRAT_VIEW (_CHITATELYA, _CHITATELYA ,, _ CHITATELYA, _KNIGI, _KNIGI, _VOZVRATA_KNIGI) chitatel. familiya_chitatelya, chitatel. imya_chitatelya, chitatel. otchestvo, a_knig. nomer_chitatelya, vida4a_knig. nomer_knigi, knigi. nazvanie_knigi, a_knig. data_vozvrata_knigichitatel, vida4a_knig, knigichitatel. nomer_chitatelya=vida4a_knig. nomer_chitatelya and knigi. nomer_knigi=vida4a_knig. nomer_knigi
;
Збережені процедури Редагування та видалення даних
beginINTO chitatel (chitatel. familiya_chitatelya, chitatel. imya_chitatelya, chitatel. otchestvo ,. ulica, chitatel. nomer_doma, chitatel. telefon) (: familiya ,: name ,: otchestvo ,: ulica,:n_doma ,: tel) ;; INTO bibliotekor (bibliotekor. nomer_otdela ,. familiya_bibliotekorya ,. name_bibliotekorya) (: n_otdel ,: familiya ,: name) ;;
begininto vida4a_knig (nomer_knigi, nomer_chitatelya, _bibliotekorya, data_vyda4i_knigi, data_vozvrata_knigi) (: n_knigi ,: n_biblio ,: n_4itatelya ,: data_vyd ,: data_vozv) ;; into otdel_knig (otdel_knig. nazvanie_otdela, otdel_knig. kol_vo_knig, _knig. TELEFON, otdel_knig. nomer_bibliotekorya) (: nazvanie ,: kol_knig ,: telefon ,: n_bi...
