class CreateInvPhotographerBillingLines < ActiveRecord::Migration[6.0]
  def change
    create_table :inv_photographer_billing_lines do |t|
      t.integer "photographer_billing_id", null: false
      t.integer "product_type_id", null: false
      t.integer "image_id"
      t.text "description"
      t.integer "quantity", default: 1, null: false
      t.decimal "price_ht", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "vat", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "discount", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "total_ht", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "total_ttc", precision: 10, scale: 3, default: "0.0", null: false
      t.boolean "retribution", default: false, null: false, unsigned: true
      t.text "usage"
      t.index "photographer_billing_id"
    end
  end
end
