| 12345678910 |
- -- 客户主档：通用个人档案字段
- -- Spec: docs/superpowers/specs/2026-10-08-customer-profile-expand-sync-design.md
- SET NAMES utf8mb4;
- ALTER TABLE `biz_customer`
- ADD COLUMN `birth_ym` char(6) DEFAULT NULL COMMENT '出生年月YYYYMM' AFTER `age`,
- ADD COLUMN `ethnic` varchar(32) DEFAULT NULL COMMENT '民族' AFTER `birth_ym`,
- ADD COLUMN `email` varchar(128) DEFAULT NULL COMMENT '邮箱' AFTER `ethnic`,
- ADD COLUMN `address` varchar(512) DEFAULT NULL COMMENT '家庭住址' AFTER `email`;
|
