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