Sequel::Model.db.create_table?(:parts) do
  primary_key :id
  DateTime :created_at
  DateTime :updated_at
  String :for
  String :title
  DateTime :ordered_on
  String :contact
  String :order_number
  String :ebay_id
  String :ships_from
  TrueClass :received, :default => false
end

Sequel::Model.plugin(:validation_helpers)

class Part < Sequel::Model
  plugin :timestamped, :using => :utc

  subset(:received, :received => true)
  subset(:needed, :received => false)

  def validate
    validates_presence([:title, :received])
  end
end