Class: ViewVisitsConversionFact

Inherits:

ApplicationViewRecord

• Object
• ActiveRecord::Base
• ApplicationRecord
• ApplicationViewRecord
• ViewVisitsConversionFact

Defined in:

app/models/view_visits_conversion_fact.rb

Overview

== Schema Information

Table name: view_visits_conversion_facts
Database name: primary

id(Primary key) :bigint
conversion_from(Source of the conversion attribution) :text
opp_recpt_type(Opportunity receipt type) :string(255)
ord_recpt_type(Order receipt type) :string(255)
revenue(Revenue amount in USD) :decimal(8, 2)
state(Conversion state/stage) :string(255)
visit_date(Date of the visit) :date
company_id(Company ID (1 = US, 2 = Canada)) :integer
opportunity_id(FK → opportunities.id (NULL if no opportunity created)) :integer
order_id(FK → orders.id (NULL if no order placed)) :integer
visit_id(FK → visits.id) :bigint

Indexes

index_view_visits_conversion_facts_on_company_id (company_id)
index_view_visits_conversion_facts_on_conversion_from (conversion_from)
index_view_visits_conversion_facts_on_id (id) UNIQUE
index_view_visits_conversion_facts_on_opp_recpt_type (opp_recpt_type)
index_view_visits_conversion_facts_on_opportunity_id (opportunity_id)
index_view_visits_conversion_facts_on_ord_recpt_type (ord_recpt_type)
index_view_visits_conversion_facts_on_order_id (order_id)
index_view_visits_conversion_facts_on_state (state)
index_view_visits_conversion_facts_on_visit_date (visit_date)
index_view_visits_conversion_facts_on_visit_id (visit_id)

Class Method Summary

• .refresh ⇒ Object

Methods inherited from ApplicationViewRecord

create, create!, #readonly?

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation

Methods included from Models::EventPublishable

#publish_event

Class Method Details

.refresh ⇒ Object

# File 'app/models/view_visits_conversion_fact.rb', line 32

def self.refresh
  Scenic.database.refresh_materialized_view(table_name, concurrently: true, cascade: false)
end