yvjia/db/b2c_member_recipient.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/09/05 00:20:22
*/

DROP TABLE IF EXISTS `b2c_member_recipient`;
CREATE TABLE `b2c_member_recipient` (
   PRIMARY KEY (`id`),
   `id` BIGINT AUTO_INCREMENT,
   `member_id` BIGINT NOT NULL COMMENT '会员ID',
   `recipient_name` VARCHAR(20) NOT NULL COMMENT '收货人姓名',
   `recipient_phone` VARCHAR(20) NOT NULL COMMENT '手机号码',
   `recipient_address` VARCHAR(500) NOT NULL COMMENT '地址',
   `recipient_point` POINT NOT NULL COMMENT '地址坐标',
   `tag` VARCHAR(20) COMMENT '标签',
   `is_default` TINYINT(1) DEFAULT '-1' COMMENT '是否默认(-1否, 1是)',
   `notes` VARCHAR(200) DEFAULT NULL COMMENT '备注',
   `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='会员表';

INSERT INTO b2c_member_recipient(member_id, recipient_name, recipient_phone, recipient_address, recipient_point, tag, is_default) VALUES
    (1, '杨生', '13670511519', '广东省深圳市南山区科技中一路123号', ST_GeomFromText('POINT(113.9333 22.5431)'), '家', -1),
    (1, '王小红', '13012345678', '北京市海淀区中关村大街1号', ST_GeomFromText('POINT(116.323782 39.984491)'), '公司', 1),
    (1, '李建国', '13123456789', '上海市黄浦区南京东路100号', ST_GeomFromText('POINT(121.490309 31.237762)'), '', -1),
    (1, '张丽华', '13234567890', '广东省深圳市福田区华强北路1002号', ST_GeomFromText('POINT(114.063971 22.541059)'), '', -1),
    (1, '刘小明', '13011112222', '浙江省杭州市西湖区延安路88号', ST_GeomFromText('POINT(120.155064 30.271505)'), '', -1)
;