news_monitoring

Tables (7)

Untitled3

    Untitled6

      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