CREATE TABLE notification_requests (
	request_id	 integer PRIMARY KEY NOT NULL,
	type_id	 integer,
	user_id	 integer,
	object_id	 integer,
	interval_id	 integer NOT NULL,
	delivery_method_id	 integer NOT NULL,
	format	 varchar(100) DEFAULT 'text'::character varying,
	dynamic_p	 bool DEFAULT false,
	CONSTRAINT notif_request_format_ch REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_id_fk REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_deliv_fk REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_id_pk REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_interv_fk REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_object_id_fk REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_type_id_fk REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_user_id_fk REFERENCES notification_types_del_methods (),
	CONSTRAINT notification_requests_un REFERENCES notification_types_del_methods (),
	CONSTRAINT notif_request_deliv_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_format_ch REFERENCES acs_objects (),
	CONSTRAINT notif_request_id_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_id_pk REFERENCES acs_objects (),
	CONSTRAINT notif_request_interv_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_object_id_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_type_id_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_user_id_fk REFERENCES acs_objects (),
	CONSTRAINT notification_requests_un REFERENCES acs_objects (),
	CONSTRAINT notif_request_id_fk REFERENCES notification_types_intervals (),
	CONSTRAINT notif_request_deliv_fk REFERENCES notification_types_intervals (),
	CONSTRAINT notif_request_format_ch REFERENCES notification_types_intervals (),
	CONSTRAINT notif_request_id_pk REFERENCES notification_types_intervals (),
	CONSTRAINT notif_request_interv_fk REFERENCES notification_types_intervals (),
	CONSTRAINT notif_request_object_id_fk REFERENCES notification_types_intervals (),
	CONSTRAINT notif_request_type_id_fk REFERENCES notification_types_intervals (),
	CONSTRAINT notif_request_user_id_fk REFERENCES notification_types_intervals (),
	CONSTRAINT notification_requests_un REFERENCES notification_types_intervals () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
	CONSTRAINT notif_request_interv_fk REFERENCES acs_objects (),
	CONSTRAINT notification_requests_un REFERENCES acs_objects (),
	CONSTRAINT notif_request_user_id_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_type_id_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_object_id_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_id_pk REFERENCES acs_objects (),
	CONSTRAINT notif_request_id_fk REFERENCES acs_objects (),
	CONSTRAINT notif_request_format_ch REFERENCES acs_objects (),
	CONSTRAINT notif_request_deliv_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
	CONSTRAINT notif_request_user_id_fk REFERENCES notification_types (),
	CONSTRAINT notification_requests_un REFERENCES notification_types (),
	CONSTRAINT notif_request_type_id_fk REFERENCES notification_types (),
	CONSTRAINT notif_request_object_id_fk REFERENCES notification_types (),
	CONSTRAINT notif_request_interv_fk REFERENCES notification_types (),
	CONSTRAINT notif_request_id_pk REFERENCES notification_types (),
	CONSTRAINT notif_request_id_fk REFERENCES notification_types (),
	CONSTRAINT notif_request_format_ch REFERENCES notification_types (),
	CONSTRAINT notif_request_deliv_fk REFERENCES notification_types () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
	CONSTRAINT notification_requests_un REFERENCES users (),
	CONSTRAINT notif_request_user_id_fk REFERENCES users (),
	CONSTRAINT notif_request_type_id_fk REFERENCES users (),
	CONSTRAINT notif_request_object_id_fk REFERENCES users (),
	CONSTRAINT notif_request_interv_fk REFERENCES users (),
	CONSTRAINT notif_request_id_pk REFERENCES users (),
	CONSTRAINT notif_request_id_fk REFERENCES users (),
	CONSTRAINT notif_request_format_ch REFERENCES users (),
	CONSTRAINT notif_request_deliv_fk REFERENCES users ()
);

CREATE INDEX notif_requests_intvl ON notification_requests (interval_id);
CREATE INDEX notif_requests_object_id_idx ON notification_requests (object_id);
CREATE INDEX notif_requests_typ_delmeth_ix ON notification_requests (type_id, delivery_method_id);
CREATE INDEX notif_requests_typ_intvl_idx ON notification_requests (type_id, interval_id);
CREATE INDEX notif_requests_user_id_idx ON notification_requests (user_id);
CREATE INDEX notification_requests_object_id_idx ON notification_requests (object_id);
CREATE INDEX notification_requests_t_o_idx ON notification_requests (type_id, object_id);
CREATE INDEX notification_requests_type_obj_ ON notification_requests (type_id, object_id);
CREATE UNIQUE INDEX notification_requests_un ON notification_requests (type_id, user_id, object_id);
CREATE INDEX notification_requests_user_id_idx ON notification_requests (user_id);

CREATE TRIGGER RI_ConstraintTrigger_c_342659 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342660 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342664 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342665 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342669 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342670 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342674 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342675 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342679 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342680 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342684 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342685 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)

-- Table size: 1,122,304 bytes
-- Table rows: 18,520

---

Tables:

aa_test_final_results	category_search_index	ec_product_series_map_audit	request_monitor_community_activities
aa_test_results	category_search_results	ec_product_u_c_prices_audit	rss_gen_subscrs
acs_activities	category_synonym_index	ec_product_user_class_prices	s5_package
acs_activity_object_map	category_synonyms	ec_products	search_observer_queue
acs_attribute_descriptions	category_temp	ec_products_audit	sec_session_properties
acs_attribute_values	category_translations	ec_refunds	secret_tokens
acs_attributes	category_tree_map	ec_retailer_locations	site_node_object_mappings
acs_contents	category_tree_translations	ec_retailer_locations_audit	site_nodes
acs_data_links	category_trees	ec_retailers	site_nodes_selection
acs_datatypes	chat_msgs	ec_retailers_audit	sp_extant_files
acs_enum_values	chat_rooms	ec_sale_prices	sp_extant_folders
acs_event_party_map	chat_transcripts	ec_sale_prices_audit	sp_folders
acs_events	code_keyword_map_temp	ec_sales_tax_by_state	static_pages
acs_function_args	composition_rels	ec_sales_tax_by_state_audit	subsite_callbacks
acs_logs	countries	ec_shipments	subsite_themes
acs_magic_objects	country_names	ec_shipments_audit	syndication
acs_mail_bodies	cr_child_rels	ec_spam_log	target_place_list
acs_mail_body_headers	cr_content_mime_type_map	ec_subcat_prod_map_audit	template_demo_notes
acs_mail_gc_objects	cr_content_text	ec_subcategories	time_intervals
acs_mail_links	cr_doc_filter	ec_subcategories_audit	timespans
acs_mail_lite_bounce	cr_dummy	ec_subcategory_product_map	timezone_rules
acs_mail_lite_bounce_notif	cr_extension_mime_type_map	ec_subsubcat_prod_map_audit	timezones
acs_mail_lite_complex_queue	cr_extlinks	ec_subsubcategories	tmp_bt_save
acs_mail_lite_email_src_ext_id_map	cr_files_to_delete	ec_subsubcategories_audit	trackback_pings
acs_mail_lite_email_uid_id_map	cr_folder_type_map	ec_subsubcategory_product_map	tree_tmp
acs_mail_lite_from_external	cr_folders	ec_templates	ts
acs_mail_lite_ie_headers	cr_item_keyword_map	ec_templates_audit	txt
acs_mail_lite_ie_part_nv_pairs	cr_item_publish_audit	ec_user_class_user_map	us_counties
acs_mail_lite_ie_parts	cr_item_rels	ec_user_class_user_map_audit	us_states
acs_mail_lite_ie_section_ref_map	cr_item_template_map	ec_user_classes	user_portraits
acs_mail_lite_imap_conn	cr_items	ec_user_classes_audit	user_preferences
acs_mail_lite_mail_log	cr_keywords	ec_user_identification	user_profiles
acs_mail_lite_queue	cr_locales	ec_user_session_info	users
acs_mail_lite_send_msg_id_map	cr_mime_types	ec_user_session_offer_codes	users_email_image
acs_mail_lite_ui	cr_news	ec_user_sessions	view_aggregates
acs_mail_multipart_parts	cr_release_periods	email_images	view_aggregates_by_type
acs_mail_multiparts	cr_revision_attributes	etp_page_revisions	views_by_type
acs_mail_queue_incoming	cr_revisions	faq_q_and_as	views_views
acs_mail_queue_messages	cr_scheduled_release_job	faqs	weblogger_blogroll_entries
acs_mail_queue_outgoing	cr_scheduled_release_log	forums_forums	weblogger_channels
acs_messages	cr_symlinks	forums_messages	weblogger_ping_urls
acs_messages_outgoing	cr_template_use_contexts	forums_reading_info	weblogger_technorati_cache
acs_named_objects	cr_templates	fs_root_folders	wf_arcs
acs_object_type_tables	cr_text	fs_rss_subscrs	wf_article_cases
acs_object_types	cr_type_children	fs_simple_objects	wf_attribute_value_audit
acs_objects	cr_type_relations	fs_urls	wf_case_assignments
acs_permissions	cr_type_template_map	fts_conf	wf_case_deadlines
acs_permissions_lock	cr_wp_file_attachments	fts_unknown_lexem	wf_cases
acs_privilege_hierarchy	cr_wp_image_attachments	general_comments	wf_context_assignments
acs_privileges	cr_wp_presentations	general_objects	wf_context_role_info
acs_reference_repositories	cr_wp_presentations_aud	get_path_abs_cursor	wf_context_task_panels
acs_rel_roles	cr_wp_presentations_back	get_path_cursors	wf_context_transition_info
acs_rel_types	cr_wp_slides	get_path_rel_cursor	wf_context_workflow_info
acs_rels	cr_wp_slides_bullet_items	group_element_index	wf_contexts
acs_sc_bindings	cr_wp_slides_postamble	group_rels	wf_places
acs_sc_contracts	cr_wp_slides_preamble	group_type_rels	wf_roles
acs_sc_impl_aliases	cr_xml_docs	group_types	wf_task_assignments
acs_sc_impls	dav_site_node_folder_map	groups	wf_tasks
acs_sc_msg_type_elements	download_archive_descs	guard_list	wf_tokens
acs_sc_msg_types	download_archive_metadata	host_node_map	wf_transition_attribute_map
acs_sc_operations	download_archive_revisions	images	wf_transition_role_assign_map
acs_static_attr_values	download_archive_types	journal_entries	wf_transitions
ad_locale_user_prefs	download_archives	lang_message_keys	wf_workflows
ad_locales	download_downloads	lang_messages	workflow_action_allowed_roles
ad_template_sample_users	download_metadata_choices	lang_messages_audit	workflow_action_callbacks
admin_rels	download_reasons	lang_translate_columns	workflow_action_privileges
apm_applications	download_repository	lang_translation_registry	workflow_actions
apm_package_callbacks	download_revision_data	lang_user_timezone	workflow_callbacks
apm_package_dependencies	ec_addresses	language_639_2_codes	workflow_case_action_assignees
apm_package_downloads	ec_admin_settings	language_codes	workflow_case_enabled_actions
apm_package_owners	ec_admin_settings_audit	lob_data	workflow_case_fsm
apm_package_types	ec_automatic_email_log	lobs	workflow_case_log
apm_package_version_attr	ec_canned_responses	membership_rels	workflow_case_log_data
apm_package_versions	ec_cat_mailing_lists	migr_category_map	workflow_case_log_rev
apm_packages	ec_categories	migr_forum_map	workflow_case_role_party_map
apm_parameter_values	ec_categories_audit	migr_message_map	workflow_cases
apm_parameters	ec_category_product_map	migr_user_map	workflow_deputies
apm_services	ec_category_product_map_audit	nntp_articles	workflow_fsm_action_en_in_st
application_groups	ec_category_template_map	nntp_groups	workflow_fsm_actions
attachments	ec_creditcards	notification_delivery_methods	workflow_fsm_states
attachments_fs_root_folder_map	ec_cs_action_info_used_map	notification_email_hold	workflow_role_allowed_parties
auth_authorities	ec_cs_issue_type_map	notification_intervals	workflow_role_callbacks
auth_batch_job_entries	ec_custom_p_field_values_audit	notification_replies	workflow_role_default_parties
auth_batch_jobs	ec_custom_product_field_values	notification_requests	workflow_roles
auth_driver_params	ec_custom_product_fields	notification_types	workflows
bm_bookmarks	ec_custom_product_fields_audit	notification_types_del_methods	wp_styles
bm_in_closed_p	ec_customer_serv_interactions	notification_types_intervals	xolirc_package
bm_urls	ec_customer_service_actions	notification_user_map	xooauth_authorized_users
bt_bug_revisions	ec_customer_service_issues	notifications	xooauth_client_credentials
bt_bugs	ec_email_templates	oct_ballot	xooauth_client_metadata
bt_bugs_temp	ec_email_templates_audit	oct_candidate	xooauth_credentials
bt_components	ec_financial_transactions	oct_election	xooauth_packages
bt_default_keywords	ec_gift_certificate_usage	oct_vote	xooauth_server_metadata
bt_keyword_component_map	ec_gift_certificates	pa_albums	xooauth_temp_credentials
bt_patch_actions	ec_gift_certificates_audit	pa_collection_photo_map	xooauth_token_credentials
bt_patch_bug_map	ec_items	pa_collections	xowf_package
bt_patches	ec_offers	pa_package_root_folder_map	xowiki_autonames
bt_priority_codes	ec_offers_audit	pa_photos	xowiki_file
bt_projects	ec_orders	pages	xowiki_form
bt_severity_codes	ec_picklist_items	parties	xowiki_form_instance_item_index
bt_user_prefs	ec_picklist_items_audit	party_approved_member_map	xowiki_form_page
bt_versions	ec_problems_log	persons	xowiki_last_visited
btbug_revisions	ec_product_comments	pinds_blog_categories	xowiki_object
cal_item_types	ec_product_comments_audit	pinds_blog_entries	xowiki_package
cal_items	ec_product_links	previous_place_list	xowiki_page
cal_party_prefs	ec_product_links_audit	project_temp	xowiki_page_instance
cal_uids	ec_product_purchase_comb	rc_segment_required_seg_map	xowiki_page_template
calendars	ec_product_recommend_audit	recurrence_interval_types	xowiki_plain_page
categories	ec_product_recommendations	recurrences	xowiki_podcast_item
category_links	ec_product_reviews	rel_constraints	xowiki_references
category_object_map	ec_product_reviews_audit	rel_segments	xowiki_tags
category_search	ec_product_series_map	request_monitor_activities	xowiki_unresolved_references