Class: Factbook::CreateDb

Inherits:
Object
  • Object
show all
Defined in:
lib/factbook/db/schema.rb

Instance Method Summary collapse

Instance Method Details

#up ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/factbook/db/schema.rb', line 7

def up

ActiveRecord::Schema.define do

create_table :facts do |t|
  t.string  :code,   null: false   # country code e.g. au

  t.string  :name,   null: false   # country name e.g. Austria


  t.integer :area        # e.g. 83,871 sq km       

  t.integer :area_land   # e.g. 82,445 sq km    --use float - why? why not?

  t.integer :area_water  # e.g.  1,426 sq km


  t.integer :population            # e.g.  8,665,550 (July 2015 est.)  

  t.float   :population_growth     # e.g.  0.55% (2015 est.)

  t.float   :birth_rate            # e.g.  9.41 births/1,000 population (2015 est.)

  t.float   :death_rate            # e.g.  9.42 deaths/1,000 population (2015 est.)

  t.float   :migration_rate        # e.g.  5.56 migrant(s)/1,000 population (2015 est.)


  t.timestamps
end


end # block Schema.define


end