Constraints

9 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
autopagerize_rule_dataset_id_fkey
autopagerize_rule.dataset_id
autopagerize_dataset.id
Cascade on delete
autopagerize_rule_rejection_dataset_id_fkey
autopagerize_rule_rejection.dataset_id
autopagerize_dataset.id
Cascade on delete
autopagerize_state_active_dataset_id_fkey
autopagerize_state.active_dataset_id
autopagerize_dataset.id
Restrict delete
content_header_feed_url_fkey
content_header.feed_url_id
feed_url.id
Cascade on delete
content_full_text_content_header_fkey
content_full_text.content_header_id
content_header.id
Cascade on delete
content_full_text_autopagerize_dataset_fkey
content_full_text.autopagerize_dataset_id
autopagerize_dataset.id
Restrict delete
content_full_text_autopagerize_rule_fkey
content_full_text.autopagerize_dataset_id
content_full_text.autopagerize_rule_ordinal
autopagerize_rule.dataset_id
autopagerize_rule.ordinal
Restrict delete
content_text_file_export_header_fkey
content_text_file_export.content_header_id
content_header.id
Cascade on delete
content_text_file_export_full_text_fkey
content_text_file_export.content_full_text_id
content_full_text.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
autopagerize_rule autopagerize_rule_match_order_check (match_order >= 0)
autopagerize_rule autopagerize_rule_ordinal_check (ordinal >= 0)
autopagerize_rule_rejection autopagerize_rule_rejection_errors_shape_check (jsonb_typeof(errors) = ANY (ARRAY['array'::text, 'object'::text]))
autopagerize_rule_rejection autopagerize_rule_rejection_ordinal_check (ordinal >= 0)
autopagerize_state autopagerize_state_singleton_check (id = 1)
feed_url feed_url_full_text_method_check ((full_text_method)::text = ANY ((ARRAY['feed'::character varying, 'http'::character varying, 'http_readability'::character varying, 'http_autopagerize'::character varying, 'http_autopagerize_readability'::character varying, 'playwright'::character varying, 'playwright_readability'::character varying, 'playwright_autopagerize'::character varying, 'playwright_autopagerize_readability'::character varying])::text[]))
feed_url feed_url_status_check (status = ANY (ARRAY['active'::text, 'unsubscribed'::text]))
feed_url feed_url_unsubscribe_reason_check ((unsubscribe_reason IS NULL) OR (unsubscribe_reason = ANY (ARRAY['not_interested'::text, 'site_closed'::text, 'feed_dead'::text, 'moved'::text, 'other'::text])))
autopagerize_dataset autopagerize_dataset_counts_check ((input_item_count >= 0) AND (accepted_rule_count >= 0) AND (rejected_rule_count >= 0) AND ((accepted_rule_count + rejected_rule_count) = input_item_count))
autopagerize_dataset autopagerize_dataset_format_check ((format)::text = 'wedata-autopagerize-items-all'::text)
autopagerize_dataset autopagerize_dataset_source_sha256_check (source_sha256 ~ '^[0-9a-f]{64}$'::text)
content_full_text content_full_text_autopagerize_rule_pair_check ((autopagerize_rule_ordinal IS NULL) OR (autopagerize_dataset_id IS NOT NULL))
content_full_text content_full_text_pagination_page_count_check ((pagination_page_count IS NULL) OR (pagination_page_count >= 1))
content_text_file_export content_text_file_export_file_size_check (file_size_bytes >= 0)
content_text_file_export content_text_file_export_relative_path_no_directory_check (relative_path !~ '/'::text)
content_text_file_export content_text_file_export_relative_path_not_absolute_check (relative_path !~ '^/'::text)
content_text_file_export content_text_file_export_relative_path_txt_check (relative_path ~ '^[0-9a-f]{32}\.txt$'::text)