CREATE TABLE notification_delivery_methods ( delivery_method_id integer PRIMARY KEY NOT NULL, sc_impl_id integer NOT NULL, short_name varchar(100) NOT NULL, pretty_name varchar(200) NOT NULL, CONSTRAINT notif_deliv_meth_fk REFERENCES acs_objects (), CONSTRAINT notif_deliv_meth_impl_id_fk REFERENCES acs_objects (), CONSTRAINT notif_deliv_meth_pk REFERENCES acs_objects (), CONSTRAINT notif_deliv_meth_pk REFERENCES acs_sc_impls (), CONSTRAINT notif_deliv_meth_fk REFERENCES acs_sc_impls (), CONSTRAINT notif_deliv_meth_impl_id_fk REFERENCES acs_sc_impls () ); CREATE UNIQUE INDEX notif_deliv_short_name_un ON notification_delivery_methods (short_name); CREATE TRIGGER RI_ConstraintTrigger_c_342609 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342610 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342614 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342615 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342692 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342693 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to notification_delivery_methods: --notification_types_del_methods(notif_deliv_meth_fk) --notification_types_del_methods(notif_deliv_meth_impl_id_fk) --notification_types_del_methods(notif_deliv_meth_pk) -- Table size: 8,192 bytes -- Table rows: 1
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: notification_delivery_methods
Begin main content
