CREATE TABLE IF NOT EXISTS `supplier_user_address` (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT '地址主键ID',
  `addressId` VARCHAR(191) NOT NULL COMMENT '地址业务ID',
  `supplierId` VARCHAR(191) NOT NULL COMMENT '供应商ID',
  `userId` VARCHAR(191) NOT NULL COMMENT '用户ID',
  `name` VARCHAR(191) NOT NULL COMMENT '收货人姓名',
  `tel` VARCHAR(191) NOT NULL COMMENT '收货人手机号',
  `province` VARCHAR(191) NULL COMMENT '省',
  `city` VARCHAR(191) NULL COMMENT '市',
  `county` VARCHAR(191) NULL COMMENT '区县',
  `addressDetail` TEXT NULL COMMENT '详细地址',
  `areaCode` VARCHAR(191) NULL COMMENT '地区编码',
  `postalCode` VARCHAR(191) NULL COMMENT '邮政编码',
  `isDefault` BOOLEAN NOT NULL DEFAULT FALSE COMMENT '是否默认地址',
  `createTime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updateTime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` INT NOT NULL DEFAULT 0 COMMENT '删除状态：0未删除，1已删除',
  PRIMARY KEY (`id`),
  UNIQUE KEY `supplier_user_address_addressId_key` (`addressId`),
  KEY `supplier_user_address_supplierId_userId_idx` (`supplierId`, `userId`),
  KEY `supplier_user_address_supplierId_userId_isDefault_idx` (`supplierId`, `userId`, `isDefault`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='供应商用户收货地址表';