Skip to content
KevinTriplett edited this page Jan 25, 2011 · 3 revisions

Schema Diagram

  create_table "accounts", :force => true do |t|
    t.integer  "account_id"
    t.integer  "type_of_account_id",                 :null => false
    t.integer  "number"
    t.string   "name",               :default => ""
    t.string   "description"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "batches", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "journals", :force => true do |t|
    t.integer  "batch_id"
    t.string   "description", :default => ""
    t.string   "memo"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "postings", :force => true do |t|
    t.integer  "account_id",                                                       :null => false
    t.integer  "journal_id",                                                       :null => false
    t.integer  "type_of_asset_id",                                                 :null => false
    t.string   "memo"
    t.decimal  "amount",           :precision => 15, :scale => 2, :default => 0.0
    t.date     "transacted_on"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "type_of_accounts", :force => true do |t|
    t.string "name"
    t.string "description"
  end

  create_table "type_of_assets", :force => true do |t|
    t.string "name",        :default => ""
    t.string "description"
  end
Clone this wiki locally