A Sample Ruby ActiveRecord DB Migrate File

orders_db_migrate_mock.rb

create_table :orders do |t|
  t.string 'name'
end
add_index :orders, :tags, using: 'gin'
add_index :orders, :ratings, using: 'gin'
 
# app/models/order.rb
class Order < ApplicationRecord
end
 
# Usage
Order.create name: "INV-100012",
            tags: ["books", "misc"],
            ratings: [1, 3]
 
Order.where("'books' = ANY (tags)") #orders tag by single
 
Order.where("tags @> ARRAY[?]::varchar[]", ["books", "misc"]) #orders tags by array
 
Order.where("array_length(ratings, 1) >= 3") #orders with 3 or more ratings