CREATE TABLE notification_types_del_methods ( type_id integer NOT NULL, delivery_method_id integer NOT NULL, PRIMARY KEY (type_id,delivery_method_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_type_del_meth_id_fk REFERENCES notification_delivery_methods (), CONSTRAINT notif_type_del_type_id_fk REFERENCES notification_delivery_methods (), CONSTRAINT notif_type_deliv_pk REFERENCES notification_delivery_methods () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_type_deliv_pk REFERENCES notification_types (), CONSTRAINT notif_type_del_meth_id_fk REFERENCES notification_types (), CONSTRAINT notif_type_del_type_id_fk REFERENCES notification_types () ); CREATE TRIGGER RI_ConstraintTrigger_a_342657 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342658 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342694 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342695 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342699 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342700 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to notification_types_del_methods: --notification_requests(notif_type_del_meth_id_fk) --notification_requests(notif_type_del_type_id_fk) --notification_requests(notif_type_deliv_pk) -- Table size: 8,192 bytes -- Table rows: 15
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: notification_types_del_methods
Begin main content
