Game Properties
| Property | View | Edit | Required | Storage Type | Default Value | Nullable |
|---|
| accolade_count | Everyone | Admin | No | bigint | 0 | No |
| advertisement_id | Everyone | Owner | No | char | | Yes |
| approved_for_showcase | Owner | Admin | No | tinyint | 0 | No |
| archived | Owner | Owner | No | int | 0 | Yes |
| average_rating | Everyone | Read Only | No | tinyint | 0 | No |
| average_score | Everyone | Read Only | No | float | 0 | No |
| backdrop_id | Everyone | Owner | No | char | | Yes |
| bayesian_ranking | Everyone | Read Only | No | float | 0 | No |
| bgg_id | Everyone | Owner | No | int | 0 | No |
| box_required | Owner | Owner | No | tinyint | 1 | No |
| calculation_warnings | Everyone | Read Only | No | mediumblob | | Yes |
| category | Everyone | Owner | No | varchar | | Yes |
| collection | Owner | Owner | No | varchar | | Yes |
| community_verified | Owner | Admin | No | tinyint | 0 | Yes |
| component_list | Everyone | Read Only | No | mediumblob | | Yes |
| contains_gore | Everyone | Owner | No | int | 0 | Yes |
| contains_laser_cut | Everyone | Read Only | No | tinyint | 0 | No |
| contains_nudity | Everyone | Owner | No | int | 0 | Yes |
| contains_profanity | Everyone | Owner | No | int | 0 | Yes |
| contains_sexuality | Everyone | Owner | No | int | 0 | Yes |
| contains_substance_abuse | Everyone | Owner | No | int | 0 | Yes |
| cool_factor_1 | Everyone | Owner | No | varchar | | Yes |
| cool_factor_2 | Everyone | Owner | No | varchar | | Yes |
| cool_factor_3 | Everyone | Owner | No | varchar | | Yes |
| crafterseconds1 | Owner | Read Only | No | int | | Yes |
| crafterseconds10 | Owner | Read Only | No | int | | Yes |
| crafterseconds100 | Owner | Read Only | No | int | | Yes |
| crafterseconds1000 | Owner | Read Only | No | int | | Yes |
| crafterseconds500 | Owner | Read Only | No | int | | Yes |
| date_created | Everyone | Read Only | No | datetime | | No |
| date_published | Everyone | Admin | No | datetime | | No |
| date_updated | Everyone | Read Only | No | datetime | | No |
| department | Everyone | Owner | No | varchar | games | No |
| depth | Everyone | Read Only | No | float | 10.75 | No |
| description | Everyone | Owner | No | mediumtext | | No |
| description_html | Everyone | Read Only | No | mediumtext | | No |
| designer_id | Everyone | Owner | Yes | char | | No |
| desired_markup | Owner | Owner | No | float | 5 | No |
| digital_delivery | Everyone | Read Only | No | tinyint | 0 | No |
| dotd | Everyone | Read Only | No | tinyint | 0 | No |
| edition | Everyone | Owner | No | varchar | First | No |
| enable_linen_texture | Everyone | Owner | No | tinyint | 0 | No |
| enable_uv_coating | Everyone | Owner | No | tinyint | 0 | No |
| featured | Everyone | Admin | No | tinyint | 0 | No |
| featured_expires | Owner | Admin | No | datetime | | No |
| goat_code | Everyone | Owner | No | varchar | | Yes |
| has_promoed_featured | Owner | Admin | No | int | 0 | No |
| has_promoed_showcase | Owner | Admin | No | int | 0 | No |
| height | Everyone | Read Only | No | float | 1.75 | No |
| id | Everyone | Read Only | No | char | | No |
| last_sale_date | Owner | Admin | No | datetime | | No |
| logo_id | Everyone | Owner | No | char | | Yes |
| max_players | Everyone | Owner | No | tinyint | 99 | No |
| min_age | Everyone | Owner | No | char | 18+ | No |
| min_players | Everyone | Owner | No | tinyint | 1 | No |
| msrp | Everyone | Owner | No | float | 0.99 | No |
| name | Everyone | Owner | Yes | varchar | | No |
| nibbles | Owner | Admin | No | bigint | 0 | No |
| oncrowdsale | Everyone | Read Only | No | tinyint | 0 | No |
| page_views | Owner | Admin | No | bigint | 0 | No |
| parts_only | Everyone | Read Only | No | tinyint | 0 | No |
| perma_lock | Owner | Admin | No | tinyint | 0 | No |
| play_time | Everyone | Owner | No | varchar | 30-60 | No |
| price1 | Owner | Owner | No | float | 0 | No |
| price10 | Owner | Owner | No | float | 0 | No |
| price100 | Owner | Owner | No | float | 0 | No |
| price1000 | Owner | Owner | No | float | 0 | No |
| price500 | Owner | Owner | No | float | 0 | No |
| private_sales | Owner | Owner | No | tinyint | 0 | No |
| private_viewing | Owner | Owner | No | tinyint | 0 | No |
| promo_markup | Owner | Owner | No | float | 1 | No |
| promo_opt_in | Owner | Owner | No | int | 0 | No |
| public | Everyone | Read Only | No | tinyint | 0 | No |
| ratings_at_1 | Everyone | Read Only | No | int | 0 | No |
| ratings_at_2 | Everyone | Read Only | No | int | 0 | No |
| ratings_at_3 | Everyone | Read Only | No | int | 0 | No |
| ratings_at_4 | Everyone | Read Only | No | int | 0 | No |
| ratings_at_5 | Everyone | Read Only | No | int | 0 | No |
| review_quote | Everyone | Owner | No | text | | Yes |
| review_reviewer | Everyone | Owner | No | varchar | | Yes |
| review_uri | Everyone | Owner | No | text | | Yes |
| sales | Owner | Admin | No | bigint | 0 | No |
| short_description | Everyone | Owner | No | varchar | | Yes |
| showcase | Everyone | Admin | No | tinyint | 0 | No |
| showcase_expires | Owner | Admin | No | datetime | | No |
| sku_id | Everyone | Read Only | No | char | | Yes |
| staff_pick | Everyone | Admin | No | tinyint | 0 | No |
| sws_markup | Owner | Owner | No | float | 1 | No |
| sws_opt_in | Owner | Owner | No | int | 0 | No |
| trashed | Everyone | Admin | No | tinyint | 0 | No |
| uri_part | Everyone | Read Only | No | varchar | | No |
| use_automatic_pricing | Owner | Owner | No | int | 1 | Yes |
| website_uri | Everyone | Owner | No | text | | Yes |
| weight | Everyone | Read Only | No | float | 0 | No |
| width | Everyone | Read Only | No | float | 10.75 | No |