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