axfin

Tables (14)

article_competitors

  • article_id — bigint — Foreign key → articles.id — NOT NULL
  • competitor_service_id — bigint — Foreign key → competitor_services.id — NOT NULL

article_domains

  • article_id — bigint — Foreign key → articles.id — NOT NULL
  • domain_id — bigint — Foreign key → service_domains.id — NOT NULL

articles

  • id — bigint — Primary key — NOT NULL
  • publisher — text — NOT NULL
  • title — text — NOT NULL
  • source_url — text — NOT NULL
  • summary_short — text — NOT NULL
  • summary_detail — text — NOT NULL
  • published_on — date

companies

  • id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL

competitor_contents

  • competitor_service_id — bigint — Foreign key → competitor_services.id — NOT NULL
  • official_content_id — bigint — Foreign key → official_contents.id — NOT NULL

competitor_services

  • id — bigint — Primary key — NOT NULL
  • company_id — bigint — NOT NULL
  • name — text — NOT NULL

competitor_sources

  • competitor_service_id — bigint — Foreign key → competitor_services.id — NOT NULL
  • official_source_id — bigint — Foreign key → official_sources.id — NOT NULL

official_contents

  • id — bigint — Primary key — NOT NULL
  • official_source_id — bigint — NOT NULL
  • source_url — text — NOT NULL
  • title — text — NOT NULL
  • body_text — text — NOT NULL
  • summary_short — text — NOT NULL
  • summary_detail — text — NOT NULL
  • published_on — date

official_source_types

  • id — bigint — Primary key — NOT NULL
  • code — text — NOT NULL
  • name — text — NOT NULL

official_sources

  • id — bigint — Primary key — NOT NULL
  • source_type_id — bigint — NOT NULL
  • source_uri — text — NOT NULL

own_services

  • id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL
  • original_pdf_uri — text — NOT NULL
  • service_profile — jsonb — NOT NULL
  • domain_id — bigint — NOT NULL

service_competitors

  • own_service_id — bigint — Foreign key → own_services.id — NOT NULL
  • competitor_service_id — bigint — Foreign key → competitor_services.id — NOT NULL

service_details

  • id — bigint — Primary key — NOT NULL
  • own_service_id — bigint — NOT NULL
  • title — text — NOT NULL
  • content — text — NOT NULL
  • sort_order — integer — NOT NULL

service_domains

  • id — bigint — Primary key — NOT NULL
  • code — text — NOT NULL
  • name — text — NOT NULL
  • keywords — text — NOT NULL