news_monitoring
Tables (7)
articles
- id — BIGSERIAL PRIMARY KEY — Primary key — NOT NULL
- source_type — VARCHAR(50)
- source_article_id — VARCHAR(200)
- url — TEXT
- title — TEXT
- publisher — VARCHAR(255)
- published_at — TIMESTAMPTZ
- content — TEXT
- created_at — TIMESTAMPTZ
crawl_runs
- id — BIGSERIAL PRIMARY KEY — Primary key — NOT NULL
- id (user_id) — BIGSERIAL PRIMARY KEY — Foreign key → users.id — NOT NULL
- id (keyword_id) — BIGSERIAL PRIMARY KEY — Foreign key → keywords.id — NOT NULL
- source_type — VARCHAR(50)
- status — VARCHAAR(20)
- started_at — TIMESTAMPTZ
- finished_at — TIMESTAMPTZ
- error_message — TEXT
feedbacks
- user_id — BIGSERIAL PRIMARY KEY — Foreign key → users.id — NOT NULL
- id (id2) — BIGSERIAL PRIMARY KEY — Foreign key → articles.id — NOT NULL
keywords
- id — BIGSERIAL PRIMARY KEY — Primary key — NOT NULL
- keyword_text — VARCHAR(255)
- is_active — BOOLEAN
- created_at — TIMESTAMPTZ
- user_id — BIGSERIAL PRIMARY KEY — Foreign key → users.id — NOT NULL
users
- id — BIGSERIAL PRIMARY KEY — Primary key — NOT NULL
- name — VARCHAR(100)
- created_at — TIMESTAMPTZ
- email — VARCHAR(255) — NOT NULL