Class: ViewBookBusinessActivity

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

Overview

== Schema Information

Table name: view_book_business_activities
Database name: primary

id :bigint
activity :decimal(, )
gl_date :date
report_grouping :string
state :string(255)
customer_id :integer
primary_sales_rep_id :integer
source_id :integer
store_id :integer

Indexes

index_view_book_business_activities_on_customer_id (customer_id)
index_view_book_business_activities_on_gl_date (gl_date)
index_view_book_business_activities_on_id (id) UNIQUE
index_view_book_business_activities_on_primary_sales_rep_id (primary_sales_rep_id)
index_view_book_business_activities_on_report_grouping (report_grouping)
index_view_book_business_activities_on_source_id (source_id)
index_view_book_business_activities_on_state (state)
index_view_book_business_activities_on_store_id (store_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 



28
29
30
 
# File 'app/models/view_book_business_activity.rb', line 28

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