class CreateCycleSteroids < ActiveRecord::Migration[6.1]
  def change

    create_table :cycles do |t|
      t.references :user,     null: true, foreign_key: true
      t.string :name,         default: ""
      t.integer :number,      default: 0
      t.boolean :template,    default: false
      t.text :instructions
      t.integer :duration,    default: 4
      t.date :init
    end

    create_table :steroids do |t|
      t.string :name,           default: ""
      t.string :presentation,   default: ""
      t.string :link,           default: ""
      t.string :administration
      t.text :secondary_effects
      t.text :recommendations
    end

    create_table :cycle_steroids do |t|
      t.references :steroid,  null: false, foreign_key: true
      t.references :cycle,    null: false, foreign_key: true
      t.integer :number,      default: 0
      
      t.integer :quantity
      t.string :unit,         default: ""
      
      t.integer :intake
      t.string :time_unit,    default: "hr"
      
      t.string :notes,        default: ""
    end

  end
end