CREATE TABLE request_monitor_community_activities ( user_id integer, peer_address text(-5), community_id integer, start_time timestamptz, end_time timestamptz, clicks integer, reason text(-5), ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT request_monitor_community_activities_community_id_fkey REFERENCES acs_objects (), CONSTRAINT request_monitor_community_activities_user_id_fkey REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT request_monitor_community_activities_user_id_fkey REFERENCES parties (), CONSTRAINT request_monitor_community_activities_community_id_fkey REFERENCES parties () ); CREATE INDEX request_monitor_community_activities_community_id_idx ON request_monitor_community_activities (community_id); CREATE INDEX request_monitor_community_activities_end_time_idx ON request_monitor_community_activities (end_time); CREATE INDEX request_monitor_community_activities_start_time_idx ON request_monitor_community_activities (start_time); CREATE INDEX request_monitor_community_activities_user_id_idx ON request_monitor_community_activities (user_id); CREATE TRIGGER RI_ConstraintTrigger_c_342889 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342890 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342894 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342895 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 4,235,264 bytes -- Table rows: 50,146
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: request_monitor_community_activities
Begin main content
