使用file_column生成uuid图片名称

CREATE TABLE "epai_opss"."portal_supplier" ( "id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL, "name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "biz_type" varchar(20) COLLATE "pg_catalog"."default", "phone" varchar(20) COLLATE "pg_catalog"."default", "email" varchar(100) COLLATE "pg_catalog"."default", "bl_file_id" varchar(255) COLLATE "pg_catalog"."default", "bl_thumbnail" text COLLATE "pg_catalog"."default", "qc_file_id" varchar(255) COLLATE "pg_catalog"."default", "qc_thumbnail" text COLLATE "pg_catalog"."default", "sort_order" int4, "status" int2 NOT NULL, "deleted" int2 NOT NULL, "create_time" timestamp(6), "update_time" timestamp(6), "create_user" varchar(50) COLLATE "pg_catalog"."default", "update_user" varchar(50) COLLATE "pg_catalog"."default" ); COMMENT ON COLUMN "epai_opss"."portal_supplier"."id" IS '主键id'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."name" IS '供应商名称'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."biz_type" IS '供应商业务类型'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."phone" IS '联系方式'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."email" IS '邮箱'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."bl_file_id" IS '营业执照文件id'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."bl_thumbnail" IS '营业执照base64'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."qc_file_id" IS '资质证书文件id'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."qc_thumbnail" IS '资质证书base64'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."sort_order" IS '排序号'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."status" IS '状态(默认为1启用,0为禁用)'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."deleted" IS '是否删除(默认0非删除,1为删除)'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."create_time" IS '创建时间'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."update_time" IS '修改时间'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."create_user" IS '创建人'; COMMENT ON COLUMN "epai_opss"."portal_supplier"."update_user" IS '修改人'; COMMENT ON TABLE "epai_opss"."portal_supplier" IS '供应商表'; ALTER TABLE "epai_opss"."portal_supplier" ADD CONSTRAINT "portal_supplier_pkey" PRIMARY KEY ("id"); 帮忙生产mybaits mapper xml 文件
03-31
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值