-
Notifications
You must be signed in to change notification settings - Fork 0
/
Schemafile
62 lines (57 loc) · 2.54 KB
/
Schemafile
1
2
3
4
5
6
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
create_table "accounts", force: :cascade do |t|
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "provider", null: false
t.string "uid", null: false
t.integer "user_id"
t.json "credentials", default: {}
t.json "info", default: {}
t.index ["provider", "uid"], name: "index_accounts_on_provider_and_uid", unique: true, using: :btree
t.index ["user_id"], name: "index_accounts_on_user_id", using: :btree
end
create_table "activities", force: :cascade do |t|
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.date "day", null: false
t.string "detail"
t.index ["day"], name: "index_activities_on_day", unique: true, using: :btree
end
create_table "activity_comments", force: :cascade do |t|
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "activity_id", null: false
t.integer "game_id"
t.string "photo"
t.string "detail"
t.string "public_str", null: false
t.string "user_id"
t.index ["activity_id"], name: "index_activity_comments_on_activity_id", using: :btree
t.index ["game_id"], name: "index_activity_comments_on_game_id", using: :btree
t.index ["public_str"], name: "index_activity_comments_on_public_str", unique: true, using: :btree
t.index ["user_id"], name: "index_activity_comments_on_user_id", using: :btree
end
create_table "games", force: :cascade do |t|
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "title_ja", null: false
t.string "title_en"
t.integer "min_players"
t.integer "max_players"
t.integer "min_minutes"
t.integer "max_minutes"
t.string "photo"
t.string "public_str", null: false
t.boolean "at_feedforce", default: false, null: false
t.index ["public_str"], name: "index_games_on_public_str", unique: true, using: :btree
t.index ["title_en"], name: "index_games_on_title_en", using: :btree
end
create_table "users", force: :cascade do |t|
t.string "nickname"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.text "image_url"
t.integer "role", default: 0, null: false
t.string "socialplus_uid", null: false
t.index ["socialplus_uid"], name: "index_users_on_socialplus_uid", using: :btree
end
add_foreign_key "accounts", "users", name: "accounts_belongs_to_users"