database schema for ranking.sucretown.net

create_tables.rb

class CreateTables < ActiveRecord::Migration
  def change
    create_table :rankings do |t|
      t.string :name, null: false, unique: true
    end
    add_index :rankings, :name

    create_table :characters do |t|
      t.string :name, null: false, unique: true
    end
    add_index :characters, :name

    create_table :entries do |t|
      t.integer :ranking_id, null: false
      t.integer :character_id, null: false
    end
    add_index :entries, [ :ranking_id, :character_id ], unique: true

    create_table :votes do |t|
      t.integer :entry_id, null: false
      t.integer :status_id, null: false, unique: true
      t.date :date, null: false
      t.integer :user_id, null: false
      t.string  :status, null: false
    end
    add_index :votes, [ :entry_id, :date, :user_id ], unique: true
  end
end