/*
Navicat MySQL Data Transfer
Source Server : test
Source Server Version : 50540
Source Host : localhost:3306
Source Database : dmall
Target Server Type : MYSQL
Target Server Version : 50540
File Encoding : 65001
Date: 2020-06-19 22:41:42
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`receiverAddress` varchar(255) DEFAULT NULL,
`receiverName` varchar(255) DEFAULT NULL,
`receiverGender` varchar(255) DEFAULT NULL,
`receiverPhone` varchar(255) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
CONSTRAINT `address_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (
`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES ('1', '北京市海淀区', '天使宝贝', '女
', '18511336397', '7');
INSERT INTO `address` VALUES ('2', '上海市奉贤区', '天使大宝贝', '女
', '18511336397', '7');
评论0