diff options
Diffstat (limited to 'course/db/schema.rb')
| -rw-r--r-- | course/db/schema.rb | 89 |
1 files changed, 89 insertions, 0 deletions
diff --git a/course/db/schema.rb b/course/db/schema.rb new file mode 100644 index 0000000..537983f --- /dev/null +++ b/course/db/schema.rb @@ -0,0 +1,89 @@ +# This file is auto-generated from the current state of the database. Instead +# of editing this file, please use the migrations feature of Active Record to +# incrementally modify your database, and then regenerate this schema definition. +# +# This file is the source Rails uses to define your schema when running `rails +# db:schema:load`. When creating a new database, `rails db:schema:load` tends to +# be faster and is potentially less error prone than running all of your +# migrations from scratch. Old migrations may fail to apply correctly if those +# migrations use external dependencies or application code. +# +# It's strongly recommended that you check this file into your version control system. + +ActiveRecord::Schema.define(version: 0) do + + # These are extensions that must be enabled in order to support this database + enable_extension "plpgsql" + + create_table "account", id: :bigint, default: nil, force: :cascade do |t| + t.text "name", null: false + t.decimal "amount", precision: 10, scale: 2, null: false + t.index ["id", "name"], name: "account_id_name_idx" + end + + create_table "guard_on_duty", id: false, force: :cascade do |t| + t.text "prison", null: false + t.text "guard", null: false + end + + create_table "part", id: false, force: :cascade do |t| + t.bigint "id", null: false + t.datetime "created_at", null: false + t.text "data" + end + + create_table "part_2018", id: false, force: :cascade do |t| + t.bigint "id", null: false + t.datetime "created_at", null: false + t.text "data" + end + + create_table "part_2019", id: false, force: :cascade do |t| + t.bigint "id", null: false + t.datetime "created_at", null: false + t.text "data" + end + + create_table "part_2020", id: false, force: :cascade do |t| + t.bigint "id", null: false + t.datetime "created_at", null: false + t.text "data" + end + + create_table "part_2021", id: false, force: :cascade do |t| + t.bigint "id", null: false + t.datetime "created_at", null: false + t.text "data" + end + + create_table "pgbench_accounts", primary_key: "aid", id: :integer, default: nil, force: :cascade do |t| + t.integer "bid" + t.integer "abalance" + t.string "filler", limit: 84 + end + + create_table "pgbench_branches", primary_key: "bid", id: :integer, default: nil, force: :cascade do |t| + t.integer "bbalance" + t.string "filler", limit: 88 + end + + create_table "pgbench_history", id: false, force: :cascade do |t| + t.integer "tid" + t.integer "bid" + t.integer "aid" + t.integer "delta" + t.datetime "mtime" + t.string "filler", limit: 22 + end + + create_table "pgbench_tellers", primary_key: "tid", id: :integer, default: nil, force: :cascade do |t| + t.integer "bid" + t.integer "tbalance" + t.string "filler", limit: 84 + end + + create_table "waltest", id: false, force: :cascade do |t| + t.integer "id" + end + +end |
