CREATE TABLE `boshi_personalcenter` (
`PersonalCenterId` int(11) NOT NULL COMMENT '(id)',
`PersonalCenterIntegral` int(11) DEFAULT NULL COMMENT '(个人积分)',
`PersonalCenterSZ` varchar(300) DEFAULT NULL COMMENT '(身份证正面)',
`PersonalCenterSF` varchar(300) DEFAULT NULL COMMENT '(身份证反面)',
`PersonalCenterXZ` varchar(300) DEFAULT NULL COMMENT '(学生证正面)',
`PersonalCenterXF` varchar(300) DEFAULT NULL COMMENT '(学生证反面)',
`PersonalCenterCredit` int(11) DEFAULT NULL COMMENT '(信用度)',
KEY `PersonalCenterId` (`PersonalCenterId`),
CONSTRAINT `boshi_personalcenter_ibfk_2` FOREIGN KEY (`PersonalCenterId`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `boshi_personalcenter` */
insert into `boshi_personalcenter`(`PersonalCenterId`,`PersonalCenterIntegral`,`PersonalCenterSZ`,`PersonalCenterSF`,`PersonalCenterXZ`,`PersonalCenterXF`,`PersonalCenterCredit`) values (1,10,'tu','tu','tu','tu',100),(2,20,'tu','tu','tu','tu',100),(3,30,'tu','tu','tu','tu',100),(1,50,'身份证正面','身份证反面','学生证正面','学生证反面',10),(1,50,'身份证正面','身份证反面','学生证正面','学生证反面',10),(1,50,'身份证正面','身份证反面','学生证正面','学生证反面',10);
/*Table structure for table `boshi_profile` */
DROP TABLE IF EXISTS `boshi_profile`;
CREATE TABLE `boshi_profile` (
`ProfilePeoId` int(11) DEFAULT NULL COMMENT '（用户ID信息） 外键',
`ProfileName` varchar(300) DEFAULT NULL COMMENT '（姓名）',
`ProfilePhp` varchar(300) DEFAULT NULL COMMENT '（联系方式）',
`ProfileAddress` varchar(300) DEFAULT NULL COMMENT '（地址）',
`ProfileId` int(11) NOT NULL AUTO_INCREMENT COMMENT '(地址id)',
PRIMARY KEY (`ProfileId`),
KEY `ProfilePeoId` (`ProfilePeoId`),
CONSTRAINT `boshi_profile_ibfk_1` FOREIGN KEY (`ProfilePeoId`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
/*Data for the table `boshi_profile` */
insert into `boshi_profile`(`ProfilePeoId`,`ProfileName`,`ProfilePhp`,`ProfileAddress`,`ProfileId`) values (2,'赵六','1366663435','合肥',2),(2,'斩三','13214326346','合肥',5),(2,'李四','12334453654','北大青鸟',6),(2,'李四','1888555555','包河区',7),(2,'赵六','1366663435','合肥',8),(2,'赵六','12354697883','上海市',9),(2,'赵六','12354697883','上海市',10),(2,'赵六','12354697883','上海市',11),(1,'张三','17776462665','合肥市包河区',12),(1,'王五','1423534534654','合肥市',13),(2,'赵六','1366663435','合肥',14),(1,'赵六','17776462665','北大青鸟',20);
/*Table structure for table `boshi_putaway` */
DROP TABLE IF EXISTS `boshi_putaway`;
525
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
