|
project_id
|
int(11)
|
|
|
0
|
|
project_no
|
varchar(50)
|
|
|
|
|
project_name
|
varchar(255)
|
|
|
|
|
transaction_id
|
int(11)
|
|
|
0
|
|
product_id
|
int(11)
|
|
|
|
|
sku
|
varchar(100)
|
|
|
|
|
name_tw
|
varchar(255)
|
|
|
|
|
type
|
varchar(50)
|
|
|
|
|
qty
|
int(11)
|
|
|
0
|
|
before_stock
|
int(11)
|
|
|
0
|
|
after_stock
|
int(11)
|
|
|
0
|
|
serial_number
|
varchar(150)
|
|
|
|
|
location
|
varchar(255)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|