-- 客户档案多收货地址 CREATE TABLE IF NOT EXISTS crm_customer_address ( id BIGINT NOT NULL AUTO_INCREMENT COMMENT '编号', customer_id BIGINT NOT NULL COMMENT '客户编号', receiver_name VARCHAR(64) NOT NULL COMMENT '收货人姓名', receiver_mobile VARCHAR(32) NOT NULL COMMENT '收货人手机号', area_id INT NULL COMMENT '所在地编号', detail_address VARCHAR(255) NOT NULL COMMENT '详细地址', default_flag BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否默认收货地址', remark VARCHAR(500) NULL COMMENT '备注', creator VARCHAR(64) NULL DEFAULT '' COMMENT '创建者', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', updater VARCHAR(64) NULL DEFAULT '' COMMENT '更新者', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', deleted BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (id), KEY idx_customer_id (customer_id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = 'CRM 客户收货地址';