gistfile1.rb

class CreateFriends < ActiveRecord::Migration
  
  def option_1
    create_table :friends do |t|
      t.string :user_guid, null: false
      t.string :friend_guid, null: false
      t.boolean :reciprocal, default: false
      t.string :name, null: false
    end

    add_index :friends, [:user_guid, :reciprocal, :name]
    add_index :friends, :friend_guid
  end

  def option_2_normalized
    create_table :friends_relation do |t|
      t.string :user_guid, null: false
      t.string :friend_guid, null: false
      t.boolean :reciprocal, default: false
    end

    create_table :friends_name, id: false do |t|
      t.string :guid, null: false # primary key
      t.string :name, null: false 
    end

    add_index :friends_relation, [:user_guid, :friend_guid, :reciprocal]
    add_index :friends_name, :name
  end
  
end