临海小憇

标题: 2019-05-28MHS寻源产品代码复查 [打印本页]

作者: lake 时间: 2019-5-28 10:59
标题: 2019-05-28MHS寻源产品代码复查

-- Add comments to the table

comment on table tb_mps_source_product

is '寻源产品信息表';

-- Add comments to the columns

comment on column tb_mps_source_product.product_id

is '产品id';

comment on column tb_mps_source_product.product_name

is '产品名称';

comment on column tb_mps_source_product.company_id

is '公司id';

comment on column tb_mps_source_product.company_name

is '公司名称';

comment on column tb_mps_source_product.product_en_name

is '产品英文名';

comment on column tb_mps_source_product.spec

is '产品规格';

comment on column tb_mps_source_product.model

is '产品型号';

comment on column tb_mps_source_product.product_unit

is '产品单位：最小单位';

comment on column tb_mps_source_product.unit_price

is '最小单位价格';

comment on column tb_mps_source_product.purchase_price

is '采购价';

comment on column tb_mps_source_product.purchase_unit

is '采购单位';

comment on column tb_mps_source_product.purchase_unit_rate

is '采购单位与最小单位换算比';

comment on column tb_mps_source_product.import_type

is '是否进口';

comment on column tb_mps_source_product.instrument_type

is '器械分类等级：01：不分类，02：Ⅰ类，02：Ⅱ类，03：Ⅲ类';

comment on column tb_mps_source_product.product_desc

is '产品描述';

comment on column tb_mps_source_product.use_desc

is '使用说明';

comment on column tb_mps_source_product.prodcut_picture1

is '产品图片1';

comment on column tb_mps_source_product.prodcut_picture2

is '产品图片2';

comment on column tb_mps_source_product.prodcut_picture3

is '产品图片3';

comment on column tb_mps_source_product.prodcut_picture4

is '产品图片4';

comment on column tb_mps_source_product.prodcut_picture5

is '产品图片5';

comment on column tb_mps_source_product.create_by

is '创建人';

comment on column tb_mps_source_product.create_date

is '创建时间';

comment on column tb_mps_source_product.update_by

is '更新人';

comment on column tb_mps_source_product.update_date

is '更新时间';

comment on column tb_mps_source_product.del_flag

is '删除标识，删除:Y,可用：N';

欢迎光临临海小憇 (http://czidea.cn/)