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