临海小憇

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 413|回复: 0

2019-05-28MHS寻源产品代码复查

[复制链接]

51

主题

65

帖子

8347

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8347
发表于 2019-5-28 10:59:30 | 显示全部楼层 |阅读模式

-- 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';


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|临海小憇 ( 鲁ICP备16010828号-2

GMT+8, 2019-10-20 17:29 , Processed in 0.042277 second(s), 7 queries , File On.

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表