migrate/1783476516_create_s2_customer_openid.up.sql
2026-07-08 10:13:04 +08:00

8 lines
377 B
SQL

CREATE TABLE `health`.`ufutx_s2_customer_openid` (
`id` INT NOT NULL AUTO_INCREMENT,
`code` VARCHAR(50) NOT NULL COMMENT "唯一码",
`openid` VARCHAR(100) NOT NULL COMMENT "微信公众号openid",
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB COMMENT = '客户openid记录表';