jmeeuynz_digitalso
Tables products
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| slug | varchar(500) | NULL | MUL | |
| product_type | varchar(20) | physical | ||
| listing_type | varchar(20) | sell_on_site | ||
| sku | varchar(100) | NULL | MUL | |
| category_id | int | NULL | MUL | |
| price | bigint | NULL | MUL | |
| price_discounted | bigint | NULL | MUL | |
| currency | varchar(20) | NULL | ||
| discount_rate | smallint | NULL | MUL | |
| vat_rate | double | NULL | ||
| user_id | int | NULL | MUL | |
| status | tinyint(1) | NULL | MUL | |
| is_promoted | tinyint(1) | NULL | MUL | |
| promote_start_date | timestamp | NULL | ||
| promote_end_date | timestamp | NULL | ||
| promote_plan | varchar(100) | NULL | ||
| promote_day | int | NULL | ||
| is_special_offer | tinyint(1) | NULL | MUL | |
| special_offer_date | timestamp | NULL | ||
| visibility | tinyint(1) | 1 | MUL | |
| rating | varchar(50) | NULL | MUL | |
| pageviews | int | NULL | ||
| demo_url | varchar(1000) | NULL | ||
| external_link | varchar(1000) | NULL | ||
| files_included | varchar(255) | NULL | ||
| stock | int | 1 | ||
| shipping_class_id | int | NULL | ||
| shipping_delivery_time_id | int | NULL | ||
| multiple_sale | tinyint(1) | 1 | ||
| digital_file_download_link | varchar(500) | NULL | ||
| country_id | int | NULL | MUL | |
| state_id | int | NULL | MUL | |
| city_id | int | NULL | MUL | |
| address | varchar(500) | NULL | ||
| zip_code | varchar(50) | NULL | ||
| brand_id | int | NULL | MUL | |
| is_sold | tinyint(1) | NULL | MUL | |
| is_deleted | tinyint(1) | NULL | MUL | |
| is_draft | tinyint(1) | NULL | MUL | |
| is_edited | tinyint(1) | NULL | MUL | |
| is_active | tinyint(1) | 1 | MUL | |
| is_free_product | tinyint(1) | NULL | ||
| is_rejected | tinyint(1) | NULL | ||
| reject_reason | varchar(1000) | NULL | ||
| is_affiliate | tinyint(1) | NULL | ||
| updated_at | timestamp | NULL | ||
| created_at | timestamp | CURRENT_TIMESTAMP |