Skip to content

Instantly share code, notes, and snippets.

@vicmaster
Last active June 14, 2024 06:06
Show Gist options
  • Save vicmaster/13832fe122ce067d883677c691c5a78d to your computer and use it in GitHub Desktop.
Save vicmaster/13832fe122ce067d883677c691c5a78d to your computer and use it in GitHub Desktop.
Database Schema
ActiveRecord::Schema.define(version: 20160930181923) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
create_table "categories", force: :cascade do |t|
t.string "name"
end
create_table "categories_products", id: false, force: :cascade do |t|
t.integer "product_id", null: false
t.integer "category_id", null: false
end
add_index "categories_products", ["category_id"], name: "index_categories_products_on_category_id", using: :btree
add_index "categories_products", ["product_id"], name: "index_categories_products_on_product_id", using: :btree
create_table "line_items", force: :cascade do |t|
t.integer "order_id"
t.integer "product_id"
t.integer "quantity", null: false
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "line_items", ["order_id"], name: "index_line_items_on_order_id", using: :btree
add_index "line_items", ["product_id"], name: "index_line_items_on_product_id", using: :btree
create_table "orders", force: :cascade do |t|
t.string "number", limit: 15
t.decimal "item_total", precision: 8, scale: 2, default: 0.0, null: false
t.decimal "total", precision: 8, scale: 2, default: 0.0, null: false
t.datetime "created_at"
t.datetime "updated_at"
t.string "state"
t.datetime "completed_at"
t.integer "bill_address_id"
t.decimal "payment_total", precision: 8, scale: 2, default: 0.0
t.string "payment_state"
t.string "email"
t.integer "user_id"
end
create_table "products", force: :cascade do |t|
t.string "name", default: "", null: false
t.text "description"
t.datetime "available_on"
t.datetime "deleated_at"
t.datetime "created_at"
t.datetime "updated_at"
t.string "sku", default: "", null: false
t.decimal "price", precision: 8, scale: 2, null: false
end
create_table "roles", force: :cascade do |t|
t.string "name"
t.integer "resource_id"
t.string "resource_type"
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "roles", ["name", "resource_type", "resource_id"], name: "index_roles_on_name_and_resource_type_and_resource_id", using: :btree
add_index "roles", ["name"], name: "index_roles_on_name", using: :btree
create_table "users", force: :cascade do |t|
t.string "email", default: "", null: false
t.string "encrypted_password", default: "", null: false
t.string "reset_password_token"
t.datetime "reset_password_sent_at"
t.datetime "remember_created_at"
t.integer "sign_in_count", default: 0, null: false
t.datetime "current_sign_in_at"
t.datetime "last_sign_in_at"
t.inet "current_sign_in_ip"
t.inet "last_sign_in_ip"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
end
add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
create_table "users_roles", id: false, force: :cascade do |t|
t.integer "user_id"
t.integer "role_id"
end
add_index "users_roles", ["user_id", "role_id"], name: "index_users_roles_on_user_id_and_role_id", using: :btree
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment