content_full_text


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bpchar 32 null
content_text_file_export.content_full_text_id content_text_file_export_full_text_fkey C
content_header_id bpchar 32 null
content_header.id content_full_text_content_header_fkey C
full_text text 2147483647 √ null
extracted_at timestamptz 35,6 now()
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
extraction_method varchar 64 √ null
extraction_status varchar 32 'success'::character varying
error_message text 2147483647 √ null
source_kind varchar 32 √ null
extracted_url text 2147483647 √ null
autopagerize_dataset_id int8 19 √ null
autopagerize_rule.dataset_id content_full_text_autopagerize_rule_fkey R
autopagerize_dataset.id content_full_text_autopagerize_dataset_fkey R
autopagerize_rule_ordinal int4 10 √ null
autopagerize_rule.ordinal content_full_text_autopagerize_rule_fkey R
pagination_page_count int4 10 √ null
pagination_stop_reason varchar 64 √ null
pagination_complete bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
content_full_text_pkey Primary key Asc id
content_full_text_content_header_id_key Must be unique Asc content_header_id

Check Constraints

Constraint Name Constraint
content_full_text_pagination_page_count_check ((pagination_page_count IS NULL) OR (pagination_page_count >= 1))
content_full_text_autopagerize_rule_pair_check ((autopagerize_rule_ordinal IS NULL) OR (autopagerize_dataset_id IS NOT NULL))

Relationships

Close relationships within degrees of separation