WiP

bgg.clj

  [{:db/id          "ff"
    :bgg/id         "17"
    :publisher/name "Fantasy Flight Games"}

   {:db/id         "nate-french"
    :bgg/id        "11655"
    :designer/name "Nate French"}
   
   {:db/id         "matt-newman"
    :bgg/id        "40573"
    :designer/name "Matthew Newman"}
   
   {:db/id       "lcg"
    :family/id   "5337"
    :family/name "Living Card Game"}
   
   {:db/id        "solitaire"
    :family/id   "5666"
    :family/name "Solitaire Games"}

   {:db/id         "hand-mgmt"
    :mechanic/id   "2040"
    :mechanic/name "Hand Management"}
   
   {:db/id         "role-play"
    :mechanic/id   "2028"
    :mechanic/name "Role Playing"}

   {:db/id         "cards"
    :category/id   "1002"
    :category/name "Card Game"}
   
   {:db/id         "horror"
    :category/id   "1024"
    :category/name "Horror"}
   
   ;; Example game
   {:bgg/id         "205637"
    :game/title     "Arkham Horror: The Card Game"
    
    :game/version 
    [{:bgg/id         "320688"
      :published/date #inst "2016-11-10"
      :game/publisher "ff"}]
    
    :game/expansion
    [{:bgg/id "209728"
      :expansion/name "Curse of the Rougarou: Scenario Pack"
      :published/date #inst "2016"
      :expansion/publisher "ff"}]

    :game/designer
    ["nate-french" "matt-newman"]

    :game/min-player-count     1
    :game/max-player-count     2
    :game/optimal-player-count 1
    :game/campaign-support?    true

    :game/complexity  2.5
    :game/interaction 3
    :game/conflict    2
    :game/depth       2

    :game/classification
    ["lcg" "solitaire" "hand-mgmt" "role-play" "cards" "horror"]

    :count/information
    [{:player/count         1
      :count/suitability    7.5
      :my/plays             7
      :character/management [>= 2]
      :my/notes             "Played the Path to Carcossa campaign."}
     
     {:player/count         2
      :count/suitability    8
      :my/plays             3}]
    
    :time/setup        10
    :time/play-minimum 90
    :time/play-maximum 120
    
    :luck/factor   :luck/high
    :luck/dice?    true
    
    :my/desire            6.5
    :my/rating            7
    :my/rules-familiarity :familiarity/moderate
    :my/location          "back shelf"
    :my/notes             "A fun dungeon crawl."}]

schema.edn

[
 {:db/ident :bgg/id
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one
  :db/doc "BGG number."}

 {:db/ident :game/title
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/version
  :db/valueType :db.type/ref
  :db/isComponent true
  :db/cardinality :db.cardinality/many}
 
 {:db/ident :published/date
  :db/valueType :db.type/instant
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/publisher
  :db/valueType :db.type/ref
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :publisher/name
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/expansion
  :db/valueType :db.type/ref
  :db/cardinality :db.cardinality/many}

 {:db/ident :expansion/publisher
  :db/valueType :db.type/ref
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :expansion/title
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/designer
  :db/valueType :db.type/ref
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :designer/name
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/min-player-count
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/max-player-count
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/optimal-player-count
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/campaign-support?
  :db/valueType :db.type/boolean
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/complexity
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :game.complexity/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :game/interaction
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :game.interaction/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :game/conflict
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :game.conflict/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :game/depth
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :game.depth/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :game/classification
  :db/valueType :db.type/ref
  :db/cardinality :db.cardinality/many}

 {:db/ident :family/name
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :mechanic/name
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :category/name
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :count/information
  :db/valueType :db.type/ref
  :db/cardinality :db.cardinality/many}

 {:db/ident :player/count
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :count/suitability
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :count.suitability/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :character/management
  :db/valueType :db.type/tuple
  :db/tupleAttrs [:db.type/symbol :db.type/long]
  :db/cardinality :db.cardinality/one}

 {:db/ident :time/setup
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :time/play-minimum
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :time/play-maximum
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :luck/dice?
  :db/valueType :db.type/boolean
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :luck/factor
  :db/valueType :db.type/ref
  :db/cardinality :db.cardinality/one}

 {:db/ident :luck/lcr}
 {:db/ident :luck/complete}
 {:db/ident :luck/very-high}
 {:db/ident :luck/high}
 {:db/ident :luck/moderate}
 {:db/ident :luck/mediated}
 {:db/ident :luck/low}
 {:db/ident :luck/very-low}
 {:db/ident :luck/none}

 ;; personal tracking
 
 {:db/ident :my/plays
  :db/valueType :db.type/long
  :db/cardinality :db.cardinality/one}

 {:db/ident :my/notes
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one}

 {:db/ident :my/desire
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :my.desire/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}
 
 {:db/ident :my/rating
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :my.rating/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :my/rules-familiarity
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :my.rules-familiarity/range
  :db/valueType :db.type/double
  :db/cardinality :db.cardinality/one}

 {:db/ident :my/location
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one} 
 ]