Class: ViewReturnedItem

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

Overview

== Schema Information

Table name: view_returned_items
Database name: primary

id :bigint
discounted_price :decimal(10, 2)
exchange_rate :float
quantity :integer
report_grouping :string(255)
rma_date :date
sqft :decimal(, )
state :string(255)
unit_cogs :decimal(10, 4)
catalog_item_id :integer
company_id :integer
customer_id :integer
invoice_id :integer
item_id :integer
line_item_id :integer
order_id :integer
primary_product_line_id :integer
primary_sr_id :integer
product_category_id :integer
rma_id :integer
rma_items_id :integer
shipping_address_id :integer

Indexes

index_view_returned_items_on_catalog_item_id (catalog_item_id)
index_view_returned_items_on_company_id (company_id)
index_view_returned_items_on_customer_id (customer_id)
index_view_returned_items_on_id (id) UNIQUE
index_view_returned_items_on_invoice_id (invoice_id)
index_view_returned_items_on_item_id (item_id)
index_view_returned_items_on_line_item_id (line_item_id)
index_view_returned_items_on_order_id (order_id)
index_view_returned_items_on_primary_product_line_id (primary_product_line_id)
index_view_returned_items_on_primary_sr_id (primary_sr_id)
index_view_returned_items_on_product_category_id (product_category_id)
index_view_returned_items_on_report_grouping (report_grouping)
index_view_returned_items_on_rma_date (rma_date)
index_view_returned_items_on_rma_id (rma_id)
index_view_returned_items_on_rma_items_id (rma_items_id)
index_view_returned_items_on_shipping_address_id (shipping_address_id)
index_view_returned_items_on_state (state)

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 



50
51
52
 
# File 'app/models/view_returned_item.rb', line 50

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