Class | ActiveRecord::ConnectionAdapters::TableDefinition |
In: |
lib/active_record/connection_adapters/abstract/schema_definitions.rb
|
Parent: | Object |
Represents a SQL table in an abstract way. Columns are stored as ColumnDefinition in the columns attribute.
columns | [RW] |
Instantiates a new column for the table. The type parameter must be one of the following values: :primary_key, :string, :text, :integer, :float, :decimal, :datetime, :timestamp, :time, :date, :binary, :boolean.
Available options are (none of these exists by default):
Please be aware of different RDBMS implementations behavior with :decimal columns:
This method returns self.
# Assuming td is an instance of TableDefinition td.column(:granted, :boolean) #=> granted BOOLEAN td.column(:picture, :binary, :limit => 2.megabytes) #=> picture BLOB(2097152) td.column(:sales_stage, :string, :limit => 20, :default => 'new', :null => false) #=> sales_stage VARCHAR(20) DEFAULT 'new' NOT NULL def.column(:bill_gates_money, :decimal, :precision => 15, :scale => 2) #=> bill_gates_money DECIMAL(15,2) def.column(:sensor_reading, :decimal, :precision => 30, :scale => 20) #=> sensor_reading DECIMAL(30,20) # While <tt>:scale</tt> defaults to zero on most databases, it # probably wouldn't hurt to include it. def.column(:huge_integer, :decimal, :precision => 30) #=> huge_integer DECIMAL(30)