Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bpchar | 32 | null |
|
|
||||||
| url | text | 2147483647 | null |
|
|
||||||
| created_at | timestamptz | 35,6 | now() |
|
|
||||||
| updated_at | timestamptz | 35,6 | now() |
|
|
||||||
| status | text | 2147483647 | 'active'::text |
|
|
||||||
| unsubscribe_reason | text | 2147483647 | √ | null |
|
|
|||||
| unsubscribed_at | timestamptz | 35,6 | √ | null |
|
|
|||||
| note | text | 2147483647 | √ | null |
|
|
|||||
| full_text_method | varchar | 64 | 'http'::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| feed_url_pkey | Primary key | Asc | id |
| feed_url_url_key | Must be unique | Asc | url |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| 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]))) |
| feed_url_status_check | (status = ANY (ARRAY['active'::text, 'unsubscribed'::text])) |
| 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[])) |