文件名称：notice.html
文件大小：9KB
文件格式：HTML
更新时间：2021-05-21 13:23:03
notice
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`;