CREATE TABLE acs_mail_lite_send_msg_id_map ( msg_id text(-5) PRIMARY KEY NOT NULL, package_id integer, party_id integer, object_id integer, datetime_cs integer, other text(-5), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_mail_lite_send_msg_id_map_pkey REFERENCES acs_objects (), CONSTRAINT aml_from_external_object_id_fk REFERENCES acs_objects (), CONSTRAINT aml_from_external_party_id_fk REFERENCES acs_objects (), CONSTRAINT aml_package_id_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT aml_package_id_fk REFERENCES parties (), CONSTRAINT aml_from_external_party_id_fk REFERENCES parties (), CONSTRAINT aml_from_external_object_id_fk REFERENCES parties (), CONSTRAINT acs_mail_lite_send_msg_id_map_pkey REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT aml_package_id_fk REFERENCES apm_packages (), CONSTRAINT acs_mail_lite_send_msg_id_map_pkey REFERENCES apm_packages (), CONSTRAINT aml_from_external_object_id_fk REFERENCES apm_packages (), CONSTRAINT aml_from_external_party_id_fk REFERENCES apm_packages () ); CREATE INDEX acs_mail_lite_send_msg_id_map_object_id_idx ON acs_mail_lite_send_msg_id_map (object_id); CREATE INDEX acs_mail_lite_send_msg_id_map_package_id_idx ON acs_mail_lite_send_msg_id_map (package_id); CREATE INDEX acs_mail_lite_send_msg_id_map_party_id_idx ON acs_mail_lite_send_msg_id_map (party_id); CREATE TRIGGER RI_ConstraintTrigger_c_340624 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340625 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340629 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340630 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340634 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340635 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 22,536,192 bytes -- Table rows: 164,091
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: acs_mail_lite_send_msg_id_map
Begin main content
