| id |
bigint(20)
|
|
|
|
| company_id |
bigint(20)
|
|
|
|
| product_category_id |
bigint(20)
|
|
|
|
| sku |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| brand |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| model |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| unit_type |
enum('pcs', 'meters', 'box', 'roll', 'pair', 'set', 'packet')
|
utf8mb4_unicode_ci
|
|
|
| serial_required |
tinyint(1)
|
|
|
|
| mac_required |
tinyint(1)
|
|
|
|
| warranty_required |
tinyint(1)
|
|
|
|
| warranty_months |
int(10)
|
|
|
|
| minimum_stock_level |
decimal(14,3)
|
|
|
|
| branch_allowed |
tinyint(1)
|
|
|
|
| active_monitoring_device |
tinyint(1)
|
|
|
|
| qr_barcode_enabled |
tinyint(1)
|
|
|
|
| approval_status |
enum('draft', 'pending', 'approved', 'rejected')
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_unicode_ci
|
|
|
| created_by |
bigint(20)
|
|
|
|
| updated_by |
bigint(20)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| deleted_at |
timestamp
|
|
|
|
| stock_movement_class |
enum('normal', 'frequent', 'rare')
|
utf8mb4_unicode_ci
|
|
|
| image_required |
tinyint(1)
|
|
|
|
| minimum_order_quantity |
decimal(14,3)
|
|
|
|
