在此处输入标题

未分类

在此输入正文
Snapshot on 2016-09-19 13:59:53

Database: pms

mms_product

Field Type Allow Null Default Value
id bigint(20) No
pms_code varchar(100) No
name_cn varchar(300) No
name_en varchar(300) No
product_number varchar(200) No
bar_code varchar(300) No
country varchar(200) No
uom varchar(200) No
product_length varchar(200) No
width varchar(200) No
height varchar(200) No
volume varchar(200) No
gross_weight varchar(200) No
suttle_weight varchar(200) No
quality_guarante_period varchar(200) No
specification varchar(200) No
physical_form varchar(200) No
storagen_evironment varchar(200) No
is_domestic tinyint(1) No 0
origin_place varchar(200) No
package_content varchar(200) No
carton_specification varchar(200) No
product_type int(11) No 0
is_flammable tinyint(1) No 0
is_air_embargo tinyint(1) No 0
is_fragile_articles tinyint(1) No 0
is_valuable tinyint(1) No 0
package_style varchar(200) Yes
is_tracking_quality_guarante_period tinyint(1) No 0
comments text Yes
commodity_dynamic_field varchar(8000) Yes
brand_id varchar(300) No
brand_name varchar(500) No
category_id varchar(300) No
category_name varchar(500) No
creator_id varchar(300) No
creator_name varchar(200) No
created_time datetime No
modifier_id varchar(300) No
modifier_name varchar(200) No
modified_time datetime No
is_active tinyint(1) No 0
legacy_id varchar(200) No
data_type int(11) No 0
package_public_price decimal(11,2) No 0.00
package_sales_price decimal(11,2) No 0.00
product_status int(11) No 0