|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
maincode
|
varchar(100)
|
|
|
XXXX
|
|
part_number
|
varchar(25)
|
|
|
|
|
category
|
varchar(100)
|
|
|
|
|
type
|
varchar(100)
|
|
|
Good
|
|
cost
|
decimal(26,6)
|
|
|
|
|
cost_usdollar
|
decimal(26,6)
|
|
|
|
|
currency_id
|
char(36)
|
|
|
|
|
price
|
decimal(26,6)
|
|
|
|
|
price_usdollar
|
decimal(26,6)
|
|
|
|
|
url
|
varchar(255)
|
|
|
|
|
contact_id
|
char(36)
|
|
|
|
|
product_image
|
varchar(255)
|
|
|
|
|
aos_product_category_id
|
char(36)
|
|
|
|