2019-05-28MHS寻源产品代码复查
<p>-- Add comments to the table </p><p>comment on table tb_mps_source_product</p><p> is '寻源产品信息表';</p><p>-- Add comments to the columns </p><p>comment on column tb_mps_source_product.product_id</p><p> is '产品id';</p><p>comment on column tb_mps_source_product.product_name</p><p> is '产品名称';</p><p>comment on column tb_mps_source_product.company_id</p><p> is '公司id';</p><p>comment on column tb_mps_source_product.company_name</p><p> is '公司名称';</p><p>comment on column tb_mps_source_product.product_en_name</p><p> is '产品英文名';</p><p>comment on column tb_mps_source_product.spec</p><p> is '产品规格';</p><p>comment on column tb_mps_source_product.model</p><p> is '产品型号';</p><p>comment on column tb_mps_source_product.product_unit</p><p> is '产品单位:最小单位';</p><p>comment on column tb_mps_source_product.unit_price</p><p> is '最小单位价格';</p><p>comment on column tb_mps_source_product.purchase_price</p><p> is '采购价';</p><p>comment on column tb_mps_source_product.purchase_unit</p><p> is '采购单位';</p><p> comment on column tb_mps_source_product.purchase_unit_rate</p><p> is '采购单位与最小单位换算比';</p><p>comment on column tb_mps_source_product.import_type</p><p> is '是否进口';</p><p>comment on column tb_mps_source_product.instrument_type</p><p> is '器械分类等级:01:不分类,02:Ⅰ类,02:Ⅱ类,03:Ⅲ类';</p><p>comment on column tb_mps_source_product.product_desc</p><p> is '产品描述';</p><p>comment on column tb_mps_source_product.use_desc</p><p> is '使用说明';</p><p>comment on column tb_mps_source_product.prodcut_picture1</p><p> is '产品图片1';</p><p>comment on column tb_mps_source_product.prodcut_picture2</p><p> is '产品图片2';</p><p>comment on column tb_mps_source_product.prodcut_picture3</p><p> is '产品图片3';</p><p>comment on column tb_mps_source_product.prodcut_picture4</p><p> is '产品图片4';</p><p>comment on column tb_mps_source_product.prodcut_picture5</p><p> is '产品图片5';</p><p>comment on column tb_mps_source_product.create_by</p><p> is '创建人';</p><p>comment on column tb_mps_source_product.create_date</p><p> is '创建时间';</p><p>comment on column tb_mps_source_product.update_by</p><p> is '更新人';</p><p>comment on column tb_mps_source_product.update_date</p><p> is '更新时间';</p><p>comment on column tb_mps_source_product.del_flag</p><p> is '删除标识,删除:Y,可用:N';</p><p><br/></p>
页:
[1]