| id |
int(10)
|
|
|
|
| salla_id |
bigint(20)
|
|
|
|
| category_id |
int(10)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| sku |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| mpn |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| aliases |
text
|
utf8mb4_unicode_ci
|
|
|
| description |
mediumtext
|
utf8mb4_unicode_ci
|
|
|
| price |
decimal(12,2)
|
|
|
|
| regular_price |
decimal(12,2)
|
|
|
|
| cost |
decimal(12,2)
|
|
|
|
| quantity |
int(11)
|
|
|
|
| default_qty |
int(11)
|
|
|
|
| low_stock_threshold |
int(11)
|
|
|
|
| image_url |
text
|
utf8mb4_unicode_ci
|
|
|
| local_image |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| product_url |
text
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('sale', 'out', 'hidden', 'archived')
|
utf8mb4_unicode_ci
|
|
|
| source |
enum('local', 'salla', 'import')
|
utf8mb4_unicode_ci
|
|
|
| raw_data |
longtext
|
utf8mb4_bin
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| brand_id |
int(10)
|
|
|
|
| unlimited_quantity |
tinyint(1)
|
|
|
|
| salla_hash |
char(64)
|
utf8mb4_unicode_ci
|
|
|
| sync_state |
enum('local', 'synced', 'local_newer', 'remote_newer', 'conflict', 'error')
|
utf8mb4_unicode_ci
|
|
|
| sync_error |
text
|
utf8mb4_unicode_ci
|
|
|
| salla_synced_at |
datetime
|
|
|
|
