ctlgs/ videogames
Login
ESC

Config: videogames

Catalog Schema
catalog game game title original_title [alt_titles] type [genres] year series [companies] → profile [external_links] company company title original_name country profile [external_links] game:companies->company release release title [games] → platform → [region] region_lock [countries] release_date edition [media] [packaging] [ratings] [identifying_codes] [languages] [companies] → contents variant_of → notes release:games->game release:variant_of->release platform platform title type manufacturer → year profile [external_links] release:platform->platform release:companies->company hardware hardware title type platform → [companies] → model_number [region] release_date edition color storage monitor_size monitor_type monitor_model [monitor_scan_rates] monitor_orientation wiring control_panel dimensions weight power [identifying_codes] [included_releases] → contents variant_of → notes [external_links] hardware:included_releases->release hardware:variant_of->hardware hardware:platform->platform hardware:companies->company platform:manufacturer->company

Entity Schemas

company
[:map
 [:title [:string {:default "Company Name"}]]
 [:original_name {:optional true} [:string {:default ""}]]
 [:country {:optional true} [:string {:default ""}]]
 [:profile {:optional true} [:string {:default ""}]]
 [:external_links
  {:optional true}
  [:vector
   [:map
    [:url {:form/col 8} [:string {:default ""}]]
    [:notes
     {:optional true, :form/col 4}
     [:string {:default "", :form/input :text}]]]]]]
game
[:map
 [:title [:string {:default "", :form/placeholder "Game Title"}]]
 [:original_title {:optional true} [:string {:default ""}]]
 [:alt_titles {:optional true} [:vector :string]]
 [:type
  {:optional true}
  [:string
   {:default "",
    :form/options
    ["Game"
     "Compilation"
     "Expansion"
     "Remaster"
     "Remake"
     "Port"
     "Demo"
     "Other"]}]]
 [:genres
  {:optional true}
  [:vector
   [:string
    {:form/options
     ["Action"
      "Adventure"
      "Beat 'em up"
      "Fighting"
      "Platformer"
      "Puzzle"
      "Racing"
      "Rhythm"
      "Role-Playing"
      "Shoot 'em up"
      "Shooter"
      "Simulation"
      "Sports"
      "Strategy"
      "Visual Novel"
      "Other"]}]]]
 [:year {:optional true} [:int {:min 1950, :max 2100}]]
 [:series {:optional true} [:string {:default ""}]]
 [:companies
  {:optional true}
  [:vector
   [:map
    [:name
     {:form/col 8}
     [:map
      [:id :int]
      [:etype [:= :company]]
      [:title :string]
      [:catkey {:optional true} :keyword]]]
    [:role
     {:optional true, :form/col 4}
     [:string
      {:default "",
       :form/options
       ["Developer"
        "Publisher"
        "Distributor"
        "Licensor"
        "Manufacturer"
        "Porting"
        "Original Arcade Developer"
        "Original Arcade Publisher"]}]]]]]
 [:profile {:optional true} [:string {:default ""}]]
 [:external_links
  {:optional true}
  [:vector
   [:map
    [:url {:form/col 8} [:string {:default ""}]]
    [:notes
     {:optional true, :form/col 4}
     [:string {:default "", :form/input :text}]]]]]]
hardware
[:map
 [:title [:string {:default "", :form/placeholder "Model Name"}]]
 [:type
  {:optional true}
  [:string
   {:default "",
    :form/options
    ["Console"
     "Handheld"
     "Arcade Cabinet"
     "Arcade Board"
     "Controller"
     "Accessory"
     "Other"]}]]
 [:platform
  {:optional true}
  [:map
   [:id :int]
   [:etype [:= :platform]]
   [:title :string]
   [:catkey {:optional true} :keyword]]]
 [:companies
  {:optional true}
  [:vector
   [:map
    [:name
     {:form/col 8}
     [:map
      [:id :int]
      [:etype [:= :company]]
      [:title :string]
      [:catkey {:optional true} :keyword]]]
    [:role
     {:optional true, :form/col 4}
     [:string
      {:default "",
       :form/options
       ["Developer"
        "Publisher"
        "Distributor"
        "Licensor"
        "Manufacturer"
        "Porting"
        "Original Arcade Developer"
        "Original Arcade Publisher"]}]]]]]
 [:model_number {:optional true} [:string {:default ""}]]
 [:region
  {:optional true}
  [:vector
   [:string
    {:form/options
     ["NTSC-J"
      "NTSC-U"
      "PAL"
      "NTSC-Asia"
      "NTSC-K"
      "NTSC-C"
      "Brazil"
      "Region Free"]}]]]
 [:release_date
  {:optional true}
  [:string {:default "", :form/placeholder "YYYY-MM-DD"}]]
 [:edition
  {:optional true}
  [:string
   {:default "",
    :form/options
    ["Standard"
     "Limited Edition"
     "Collector's Edition"
     "Special Edition"
     "First Print"
     "Budget Reprint"
     "Console Bundle"
     "Not for Resale"
     "Demo"]}]]
 [:color {:optional true} [:string {:default ""}]]
 [:storage {:optional true} [:string {:default ""}]]
 [:monitor_size
  {:optional true}
  [:string {:default "", :form/placeholder "29\""}]]
 [:monitor_type
  {:optional true}
  [:string
   {:default "",
    :form/options ["CRT" "LCD" "OLED" "Projection" "Vector CRT"]}]]
 [:monitor_model
  {:optional true}
  [:string {:default "", :form/placeholder "Nanao MS9-29"}]]
 [:monitor_scan_rates
  {:optional true}
  [:vector [:string {:form/options ["15 kHz" "24 kHz" "31 kHz"]}]]]
 [:monitor_orientation
  {:optional true}
  [:string
   {:default "", :form/options ["Horizontal" "Vertical" "Rotates"]}]]
 [:wiring
  {:optional true}
  [:string
   {:default "", :form/options ["JAMMA" "JVS" "Proprietary" "Other"]}]]
 [:control_panel {:optional true} [:string {:default ""}]]
 [:dimensions
  {:optional true}
  [:string {:default "", :form/placeholder "W × D × H mm"}]]
 [:weight {:optional true} [:string {:default ""}]]
 [:power {:optional true} [:string {:default ""}]]
 [:identifying_codes
  {:optional true}
  [:vector
   [:map
    [:type
     {:form/col 4}
     [:string
      {:default "",
       :form/options
       ["Barcode"
        "Catalog Number"
        "Part Number"
        "Model Number"
        "Serial Number"
        "Disc Ring Code"
        "Other"]}]]
    [:code {:form/col 8} [:string {:default ""}]]]]]
 [:included_releases
  {:optional true}
  [:vector
   [:map
    [:id :int]
    [:etype [:= :release]]
    [:title :string]
    [:catkey {:optional true} :keyword]]]]
 [:contents {:optional true} [:string {:default ""}]]
 [:variant_of
  {:optional true, :form/exclude-self true}
  [:map
   [:id :int]
   [:etype [:= :hardware]]
   [:title :string]
   [:catkey {:optional true} :keyword]]]
 [:notes {:optional true} [:string {:default ""}]]
 [:external_links
  {:optional true}
  [:vector
   [:map
    [:url {:form/col 8} [:string {:default ""}]]
    [:notes
     {:optional true, :form/col 4}
     [:string {:default "", :form/input :text}]]]]]]
platform
[:map
 [:title [:string {:default "", :form/placeholder "Platform Name"}]]
 [:type
  {:optional true}
  [:string
   {:default "",
    :form/options
    ["Home Console"
     "Handheld"
     "Arcade"
     "Arcade Board"
     "Computer"
     "Add-on"
     "Other"]}]]
 [:manufacturer
  {:optional true}
  [:map
   [:id :int]
   [:etype [:= :company]]
   [:title :string]
   [:catkey {:optional true} :keyword]]]
 [:year {:optional true} [:int {:min 1950, :max 2100}]]
 [:profile {:optional true} [:string {:default ""}]]
 [:external_links
  {:optional true}
  [:vector
   [:map
    [:url {:form/col 8} [:string {:default ""}]]
    [:notes
     {:optional true, :form/col 4}
     [:string {:default "", :form/input :text}]]]]]]
release
[:map
 [:title
  [:string
   {:default "", :form/placeholder "Title as printed on the box"}]]
 [:games
  {:optional true}
  [:vector
   [:map
    [:id :int]
    [:etype [:= :game]]
    [:title :string]
    [:catkey {:optional true} :keyword]]]]
 [:platform
  {:optional true}
  [:map
   [:id :int]
   [:etype [:= :platform]]
   [:title :string]
   [:catkey {:optional true} :keyword]]]
 [:region
  {:optional true}
  [:vector
   [:string
    {:form/options
     ["NTSC-J"
      "NTSC-U"
      "PAL"
      "NTSC-Asia"
      "NTSC-K"
      "NTSC-C"
      "Brazil"
      "Region Free"]}]]]
 [:region_lock
  {:optional true}
  [:string
   {:default "",
    :form/options ["Region Locked" "Region Free" "Unknown"]}]]
 [:countries {:optional true} [:vector :string]]
 [:release_date
  {:optional true}
  [:string {:default "", :form/placeholder "YYYY-MM-DD"}]]
 [:edition
  {:optional true}
  [:string
   {:default "",
    :form/options
    ["Standard"
     "Limited Edition"
     "Collector's Edition"
     "Special Edition"
     "First Print"
     "Budget Reprint"
     "Console Bundle"
     "Not for Resale"
     "Demo"]}]]
 [:media
  {:optional true}
  [:vector
   [:map
    [:type
     {:form/col 5}
     [:string
      {:default "",
       :form/options
       ["Cartridge"
        "CD-ROM"
        "GD-ROM"
        "DVD"
        "Blu-ray"
        "UMD"
        "Mini DVD"
        "HuCard"
        "Card"
        "Cassette"
        "Floppy Disk"
        "Download Code"
        "Other"]}]]
    [:description
     {:optional true, :form/col 5}
     [:string {:default "", :form/input :text}]]
    [:quantity
     {:optional true, :form/col 2}
     [:int {:min 1, :default 1}]]]]]
 [:packaging
  {:optional true}
  [:vector
   [:string
    {:form/options
     ["Jewel Case"
      "Keep Case"
      "Cardboard Box"
      "Big Box"
      "Spine Card (Obi)"
      "Slipcover"
      "SteelBook"
      "Box Set"
      "Clamshell"
      "Other"]}]]]
 [:ratings
  {:optional true}
  [:vector
   [:map
    [:board
     {:form/col 4}
     [:string
      {:default "",
       :form/options
       ["CERO"
        "ESRB"
        "PEGI"
        "USK"
        "ACB"
        "GRB"
        "ClassInd"
        "ELSPA"
        "BBFC"
        "Other"]}]]
    [:rating {:form/col 8} [:string {:default ""}]]]]]
 [:identifying_codes
  {:optional true}
  [:vector
   [:map
    [:type
     {:form/col 4}
     [:string
      {:default "",
       :form/options
       ["Barcode"
        "Catalog Number"
        "Part Number"
        "Model Number"
        "Serial Number"
        "Disc Ring Code"
        "Other"]}]]
    [:code {:form/col 8} [:string {:default ""}]]]]]
 [:languages {:optional true} [:vector :string]]
 [:companies
  {:optional true}
  [:vector
   [:map
    [:name
     {:form/col 8}
     [:map
      [:id :int]
      [:etype [:= :company]]
      [:title :string]
      [:catkey {:optional true} :keyword]]]
    [:role
     {:optional true, :form/col 4}
     [:string
      {:default "",
       :form/options
       ["Developer"
        "Publisher"
        "Distributor"
        "Licensor"
        "Manufacturer"
        "Porting"
        "Original Arcade Developer"
        "Original Arcade Publisher"]}]]]]]
 [:contents {:optional true} [:string {:default ""}]]
 [:variant_of
  {:optional true, :form/exclude-self true}
  [:map
   [:id :int]
   [:etype [:= :release]]
   [:title :string]
   [:catkey {:optional true} :keyword]]]
 [:notes {:optional true} [:string {:default ""}]]]