pommit webpage
Tables (16)
analysis_sections
- id — varchar(64)
- owner_type — varchar(20) — NOT NULL
- owner_version_id — varchar(64) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- sort_order — integer — NOT NULL
- created_at — timestamptz — NOT NULL
analysis_sources
- id — varchar(64)
- owner_type — varchar(20) — NOT NULL
- owner_version_id — varchar(64) — NOT NULL
- source_type — varchar(20) — NOT NULL
- title — varchar(255) — NOT NULL
- url — text
- file_name — varchar(255)
- file_type — varchar(20)
- sort_order — integer — NOT NULL
- created_at — timestamptz — NOT NULL
company_analysis_groups
- id — varchar(64)
- user_id — varchar(64) — Foreign key → users.id — NOT NULL
- company_name — varchar(200) — NOT NULL
- jd_url — text — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
company_analysis_versions
- id — varchar(64)
- group_id — varchar(64) — Foreign key → company_analysis_groups.id — NOT NULL
- version_number — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- pdf_url — text
generation_job_files
- id — varchar(64)
- job_id — varchar(64) — Foreign key → generation_jobs.id — NOT NULL
- file_name — varchar(255) — NOT NULL
- file_type — varchar(20) — NOT NULL
- file_size — bigint
- uploaded_at — timestamptz — NOT NULL
generation_job_urls
- id — bigserial
- job_id — varchar(64) — Foreign key → generation_jobs.id — NOT NULL
- url — text — NOT NULL
- sort_order — integer — NOT NULL
generation_jobs
- id — varchar(64)
- user_id — varchar(64) — Foreign key → users.id — NOT NULL
- asset_type — varchar(20) — NOT NULL
- status — varchar(20) — NOT NULL
- target_group_id — varchar(64)
- target_version_id — varchar(64)
- message — text
- requested_at — timestamptz — NOT NULL
- completed_at — timestamptz
pricing_plans
- id — varchar(20)
- name — varchar(50) — NOT NULL
- price — integer — NOT NULL
- portfolio_limit — integer — NOT NULL
- material_limit — integer — NOT NULL
- can_regenerate — boolean — NOT NULL
tailored_portfolio_company_analysis_map
- tailored_version_id — varchar(64) — Foreign key → tailored_portfolio_versions.id — NOT NULL
- company_analysis_version_id — varchar(64) — Foreign key → company_analysis_versions.id — NOT NULL
tailored_portfolio_groups
- id — varchar(64)
- user_id — varchar(64) — Foreign key → users.id — NOT NULL
- title — varchar(255) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
tailored_portfolio_user_analysis_map
- tailored_version_id — varchar(64) — Foreign key → tailored_portfolio_versions.id — NOT NULL
- user_analysis_version_id — varchar(64) — Foreign key → user_analysis_versions.id — NOT NULL
tailored_portfolio_versions
- id — varchar(64)
- group_id — varchar(64) — Foreign key → tailored_portfolio_groups.id — NOT NULL
- version_number — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- pdf_url — text
user_analysis_groups
- id — varchar(64)
- user_id — varchar(64) — Foreign key → users.id — NOT NULL
- repository_url — text — NOT NULL
- repository_name — varchar(200) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
user_analysis_versions
- id — varchar(64)
- group_id — varchar(64) — Foreign key → user_analysis_groups.id — NOT NULL
- version_number — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- pdf_url — text
user_settings
- user_id — varchar(64) — Foreign key → users.id
- name — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- github_connected — boolean — NOT NULL
- github_username — varchar(100)
- current_plan_id — varchar(20) — Foreign key → pricing_plans.id — NOT NULL
- updated_at — timestamptz — NOT NULL
users
- id — varchar(64)
- name — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- avatar_url — text
- github_username — varchar(100)
- plan_id — varchar(20) — Foreign key → pricing_plans.id — NOT NULL
- is_logged_in — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL