class User < ActiveRecord::Base

  has_many :manager, class_name: "User", foreign_key: "admin_id"
  belongs_to :admin, class_name: "User"

  has_many :team_leader, class_name: "User", foreign_key: "manager_id"
  belongs_to :manager, class_name: "User"

  has_many :staff, class_name: "User", foreign_key: "team_leader_id"
  belongs_to :team_leader, class_name: "User"

  has_many :client, class_name: "User", foreign_key: "team_leader_id"
  belongs_to :team_leader, class_name: "User"

  has_and_belongs_to_many :client , class_name: "User", foreign_key: "client_id"
  has_and_belongs_to_many :staff , class_name: "User", foreign_key: "staff_id"

end

class CreateUsers < ActiveRecord::Migration
  def change
    create_table :users do |t|
      t.string :name
      t.integer :user_id
      t.integer :admin_id
      t.integer :manager_id
      t.integer :team_leader_id
      t.integer :staff_id
      t.integer :client_id

      t.timestamps null: false
    end
  end
end