Property | View | Edit | Required | Storage Type | Default Value | Nullable |
---|---|---|---|---|---|---|
assembly_time | Owner | Owner | No | int | 0 | No |
box | Everyone | Owner | No | tinyint | 0 | No |
box_insert | Everyone | Owner | No | tinyint | 0 | No |
category | Everyone | Owner | No | varchar | Yes | |
color | Everyone | Owner | No | varchar | Pictured | No |
cost | Owner | Owner | No | float | 0.0001 | No |
date_created | Everyone | Read Only | No | datetime | No | |
date_published | Everyone | Admin | No | datetime | No | |
date_updated | Everyone | Read Only | No | datetime | No | |
departments | Everyone | Owner | No | mediumblob | Yes | |
depth | Everyone | Owner | No | float | 0 | No |
description | Everyone | Owner | No | text | Yes | |
designer_id | Owner | Owner | No | char | Yes | |
discontinued | Everyone | Owner | No | tinyint | 0 | No |
family | Everyone | Owner | No | varchar | Yes | |
filament_meters_per_batch | Owner | Owner | No | float | 1 | No |
for_resale | Everyone | Owner | No | tinyint | 0 | No |
height | Everyone | Owner | No | float | 0 | No |
id | Everyone | Read Only | No | char | No | |
in_game_sales | Owner | Admin | No | bigint | 0 | No |
in_production | Owner | Owner | No | tinyint | 0 | No |
in_production_on_machine | Owner | Owner | No | varchar | Yes | |
interior_depth | Everyone | Owner | No | float | 0 | No |
interior_height | Everyone | Owner | No | float | 0 | No |
interior_width | Everyone | Owner | No | float | 0 | No |
is_3d_printed | Everyone | Owner | No | tinyint | 0 | No |
keywords | Everyone | Owner | No | text | Yes | |
last_order_date | Owner | Owner | No | date | No | |
last_order_quantity | Owner | Owner | No | int | 0 | No |
last_price_change | Everyone | Owner | No | datetime | No | |
last_sale_date | Owner | Admin | No | datetime | No | |
low_quantity | Owner | Owner | No | int | 1 | No |
low_volume | Everyone | Owner | No | tinyint | 0 | No |
made_in_the_usa | Everyone | Owner | No | tinyint | 0 | No |
made_on_demand | Everyone | Owner | No | tinyint | 0 | No |
markup_percent | Owner | Owner | No | float | 2 | No |
markup_percent_10 | Owner | Owner | No | float | 1.5 | No |
markup_percent_100 | Owner | Owner | No | float | 1 | No |
markup_percent_1000 | Owner | Owner | No | float | 0.5 | No |
material | Everyone | Owner | No | varchar | Yes | |
minutes_per_batch | Owner | Owner | No | int | 1 | No |
msrp | Everyone | Owner | No | float | 0 | No |
msrp_10 | Everyone | Owner | No | float | 0 | No |
msrp_100 | Everyone | Owner | No | float | 0 | No |
msrp_1000 | Everyone | Owner | No | float | 0 | No |
name | Everyone | Owner | Yes | varchar | No | |
natural_sales | Owner | Admin | No | bigint | 0 | No |
nibbles | Owner | Admin | No | bigint | 0 | No |
notes | Owner | Owner | No | text | Yes | |
number_of_sides | Everyone | Owner | No | tinyint | 0 | No |
on_sale | Everyone | Owner | No | tinyint | 0 | No |
owner_carton_label | Everyone | Owner | No | varchar | Yes | |
owner_sku | Everyone | Owner | No | varchar | Yes | |
page_views | Owner | Admin | No | bigint | 0 | No |
photo_id | Owner | Owner | No | char | Yes | |
production_start | Owner | Owner | No | datetime | No | |
public | Everyone | Owner | No | tinyint | 0 | No |
quantity | Everyone | Admin | No | int | 0 | No |
quantity_per_batch | Owner | Owner | No | int | 1 | No |
sale_ends | Everyone | Owner | No | datetime | No | |
sale_price | Everyone | Owner | No | float | 0 | No |
size_in_mm | Everyone | Owner | No | tinyint | 0 | No |
skip_boxing_in_game | Owner | Owner | No | tinyint | 0 | No |
sku_id | Everyone | Read Only | No | char | Yes | |
spare_parts | Everyone | Owner | No | tinyint | 0 | No |
supplier_id | Owner | Owner | No | char | Yes | |
supplier_order_ratio | Owner | Owner | No | int | 1 | No |
supplier_part_number | Owner | Owner | No | varchar | Yes | |
supplier_product_url | Owner | Owner | No | text | Yes | |
supplies | Everyone | Owner | No | tinyint | 0 | No |
tgc_order_ratio | Owner | Owner | No | int | 1 | No |
units_per_carton | Everyone | Owner | No | int | 1 | No |
upc | Everyone | Owner | No | varchar | Yes | |
uri_part | Everyone | Read Only | No | varchar | No | |
usable_in_games | Everyone | Owner | No | tinyint | 1 | No |
use_insert_with_boxes | Everyone | Owner | No | mediumblob | Yes | |
use_insert_with_parts_boxes | Everyone | Owner | No | mediumblob | Yes | |
vintage | Everyone | Owner | No | tinyint | 0 | No |
virtual | Everyone | Owner | No | tinyint | 0 | No |
weight | Everyone | Owner | No | float | 0 | No |
width | Everyone | Owner | No | float | 0 | No |
youtube_video_id | Everyone | Owner | No | varchar | Yes |