Image Source: netbeans.org

Ruby Migrations support all the basic data types like string, text, integer, float, datetime, timestamp, time, date, binary and boolean.

• string is basically used for small data types such as a title.
• text is used for longer pieces of text data, such as the description.
• float is used for decimals.
• integer is used for whole numbers.
• date and time is used to store either the date only or time only.
• boolean is used for storing true or false values.
• binary is used for storing data like images, audio, or movies.
• datetime and timestamp is used to store the date and time into a column.

Rails Migration activities can be done using any front end GUI or direct on SQL prompt. Rails Migration makes all those activities very easy. Valid column options are: limit (:limit => “50”), default (:default => “blah”), null (:null => false implies Not Null)