Class: ViewOpportunitiesFact

Inherits:
ApplicationViewRecord show all
Defined in:
app/models/view_opportunities_fact.rb

Overview

== Schema Information

Table name: view_opportunities_facts
Database name: primary

id :bigint
con_first_discount_total :decimal(, )
con_first_discount_trade :decimal(, )
con_last_discount_total :decimal(, )
con_last_discount_trade :decimal(, )
consolidated_first_cogs :decimal(, )
consolidated_first_line_total :decimal(, )
consolidated_last_cogs :decimal(, )
consolidated_last_line_total :decimal(, )
consolidated_value :decimal(, )
customer_grouping :text
date :date
days_conversion :integer
first_quote_date :date
first_sqft :decimal(, )
group1 :text
group2 :text
inv_cogs :float
inv_discount_total :float
inv_discount_trade :float
inv_revenue :decimal(8, 2)
inv_sqft :decimal(, )
last_quote_date :date
last_sqft :decimal(, )
latitude :decimal(9, 6)
longitude :decimal(9, 6)
open_activity :string(255)
opp_reception_type :string(255)
opp_ref :string
opp_state :string(255)
opp_won_lost_date :date
order_size :integer
reception_type :string(255)
reference_number_fq :string(255)
reference_number_inv :string(255)
reference_number_lq :string(255)
reference_number_rc :string
report_grouping :string(255)
shipped_date :date
company_id :integer
customer_id :integer
first_quote_id :integer
invoice_id :integer
last_quote_id :integer
local_sr_id :integer
opportunity_id :integer
order_id :integer
primary_sr_id :integer
profile_id :integer
room_confg_id :integer
shp_address_id :integer
technical_sr_id :integer
technical_sr_sec_id :integer

Indexes

index_view_opportunities_facts_on_company_id (company_id)
index_view_opportunities_facts_on_customer_grouping (customer_grouping)
index_view_opportunities_facts_on_customer_id (customer_id)
index_view_opportunities_facts_on_date (date)
index_view_opportunities_facts_on_first_quote_date (first_quote_date)
index_view_opportunities_facts_on_first_quote_id (first_quote_id)
index_view_opportunities_facts_on_group1 (group1)
index_view_opportunities_facts_on_group2 (group2)
index_view_opportunities_facts_on_id (id) UNIQUE
index_view_opportunities_facts_on_invoice_id (invoice_id)
index_view_opportunities_facts_on_last_quote_date (last_quote_date)
index_view_opportunities_facts_on_last_quote_id (last_quote_id)
index_view_opportunities_facts_on_local_sr_id (local_sr_id)
index_view_opportunities_facts_on_opp_reception_type (opp_reception_type)
index_view_opportunities_facts_on_opp_state (opp_state)
index_view_opportunities_facts_on_opp_won_lost_date (opp_won_lost_date)
index_view_opportunities_facts_on_opportunity_id (opportunity_id)
index_view_opportunities_facts_on_order_id (order_id)
index_view_opportunities_facts_on_primary_sr_id (primary_sr_id)
index_view_opportunities_facts_on_profile_id (profile_id)
index_view_opportunities_facts_on_reception_type (reception_type)
index_view_opportunities_facts_on_report_grouping (report_grouping)
index_view_opportunities_facts_on_room_confg_id (room_confg_id)
index_view_opportunities_facts_on_shipped_date (shipped_date)
index_view_opportunities_facts_on_shp_address_id (shp_address_id)
index_view_opportunities_facts_on_technical_sr_id (technical_sr_id)
index_view_opportunities_facts_on_technical_sr_sec_id (technical_sr_sec_id)

Class Method Summary collapse

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 



91
92
93
 
# File 'app/models/view_opportunities_fact.rb', line 91

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