| id |
int(11)
|
|
|
|
| product_code |
varchar(50)
|
utf8_thai_520_w2
|
|
|
| brand |
varchar(100)
|
utf8_thai_520_w2
|
|
|
| category |
varchar(100)
|
utf8_thai_520_w2
|
|
|
| product_name |
varchar(255)
|
utf8_thai_520_w2
|
|
|
| quantity |
double
|
|
|
|
| unit |
varchar(50)
|
utf8_thai_520_w2
|
|
|
| barcode |
varchar(100)
|
utf8_thai_520_w2
|
|
|
| shelf |
varchar(50)
|
utf8_thai_520_w2
|
|
|
| location |
varchar(50)
|
utf8_thai_520_w2
|
|
|
| created_by |
varchar(100)
|
utf8_thai_520_w2
|
|
|
| image |
varchar(255)
|
utf8_thai_520_w2
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| price |
decimal(10,5)
|
|
|
|
| cost |
decimal(10,5)
|
|
|
|
| supplier |
varchar(255)
|
utf8_thai_520_w2
|
|
|
| minimum_stock |
int(11)
|
|
|
|
| status |
enum('active', 'inactive', 'pending')
|
utf8_thai_520_w2
|
|
|
| description |
text
|
utf8_thai_520_w2
|
|
|