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