Newsletter

Tables (9)

histories

  • id — SERIAL — Primary key
  • info_id — SERIAL — Foreign key → info.id
  • title — TEXT
  • content — TEXT
  • send_status — TEXT
  • sent_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

info

  • id — SERIAL — Primary key
  • user_id — SERIAL — Foreign key → users.id
  • format_id — SERIAL — Foreign key → newletter_formats.id
  • name — TEXT
  • description — TEXT
  • custom_prompt — TEXT
  • send_frequency — TEXT — NOT NULL
  • next_scheduled — TIMESTAMP
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

newletter_formats (newsletter_formats)

  • id — SERIAL — Primary key
  • name — TEXT — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

newsletter_sources

  • id — SERIAL — Primary key
  • source_id — SERIAL — Foreign key → sources.id
  • info_id — SERIAL — Foreign key → info.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

newsletter_topics

  • id — SERIAL — Primary key
  • info_id — SERIAL — Foreign key → info.id
  • topic_id — SERIAL — Foreign key → topics.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

sources

  • id — SERIAL — Primary key
  • source_url — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

subscribers

  • id — SERIAL — Primary key — NOT NULL
  • info_id — INT — Foreign key → info.id
  • email — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

topics

  • id — SERIAL — Primary key
  • name — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — SERIAL — Primary key
  • email — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP