aboutsummaryrefslogtreecommitdiff
path: root/db/schema.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb35
1 files changed, 34 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb
index b10373b..ef4f4cd 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -10,9 +10,42 @@
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 0) do
+ActiveRecord::Schema.define(version: 2020_10_05_155004) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
+ create_table "agencies", force: :cascade do |t|
+ t.bigint "agent_id", null: false
+ t.bigint "user_id", null: false
+ t.integer "roles", limit: 2, default: 0, null: false
+ t.datetime "created_at", precision: 6, null: false
+ t.datetime "updated_at", precision: 6, null: false
+ t.index ["agent_id", "user_id"], name: "index_agencies_on_agent_id_and_user_id", unique: true
+ t.index ["agent_id"], name: "index_agencies_on_agent_id"
+ t.index ["user_id"], name: "index_agencies_on_user_id"
+ end
+
+ create_table "agents", force: :cascade do |t|
+ t.string "name"
+ t.uuid "uuid"
+ t.datetime "created_at", precision: 6, null: false
+ t.datetime "updated_at", precision: 6, null: false
+ t.index ["uuid"], name: "index_agents_on_uuid", unique: true
+ end
+
+ create_table "users", force: :cascade do |t|
+ t.string "name"
+ t.string "username"
+ t.string "email"
+ t.bigint "external_id"
+ t.string "avatar_url"
+ t.datetime "created_at", precision: 6, null: false
+ t.datetime "updated_at", precision: 6, null: false
+ t.index ["email"], name: "index_users_on_email", unique: true
+ t.index ["external_id"], name: "index_users_on_external_id", unique: true
+ end
+
+ add_foreign_key "agencies", "agents"
+ add_foreign_key "agencies", "users"
end