| id |
int(10)
|
|
|
|
| asset_id |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| product_id |
int(10)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| type |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| rarity |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| listed |
tinyint(1)
|
|
|
|
| available |
int(11)
|
|
|
|
| in_stock |
tinyint(1)
|
|
|
|
| keyed_for_itemsatis |
int(11)
|
|
|
|
| ref_price_tl |
decimal(10,2)
|
|
|
|
| price_override_tl |
decimal(10,2)
|
|
|
|
| margin_override |
decimal(6,2)
|
|
|
|
| image_override |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| in_catalogue |
tinyint(1)
|
|
|
|
| sync_error |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| raw_json |
text
|
utf8mb4_unicode_ci
|
|
|
| synced_at |
datetime
|
|
|
|
| created_at |
timestamp
|
|
|
|
| image_original |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| crop_x |
int(11)
|
|
|
|
| crop_y |
int(11)
|
|
|
|
| crop_size |
int(11)
|
|
|
|
| fit_mode |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|