DB_51Aspx/db.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - yanglaoyaunguanlixitong
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`yanglaoyaunguanlixitong` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `yanglaoyaunguanlixitong`;

/*Table structure for table `chuangwei` */

DROP TABLE IF EXISTS `chuangwei`;

CREATE TABLE `chuangwei` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `fangjian_id` int(11) DEFAULT NULL COMMENT '房间',
  `chuangwei_name` varchar(200) DEFAULT NULL COMMENT '床位名称  Search111 ',
  `chuangwei_uuid_number` varchar(200) DEFAULT NULL COMMENT '床位编号',
  `chuangwei_photo` varchar(200) DEFAULT NULL COMMENT '床位照片',
  `chuangwei_address` varchar(200) DEFAULT NULL COMMENT '床位地点',
  `chuangwei_types` int(11) DEFAULT NULL COMMENT '床位类型 Search111',
  `chuangwei_content` longtext COMMENT '床位介绍 ',
  `chuangwei_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='床位';

/*Data for the table `chuangwei` */

insert  into `chuangwei`(`id`,`fangjian_id`,`chuangwei_name`,`chuangwei_uuid_number`,`chuangwei_photo`,`chuangwei_address`,`chuangwei_types`,`chuangwei_content`,`chuangwei_delete`,`insert_time`,`create_time`) values (1,1,'床位名称1','1682404126302','upload/chuangwei1.jpg','床位地点1',2,'床位介绍1',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(2,2,'床位名称2','1682404126328','upload/chuangwei2.jpg','床位地点2',1,'床位介绍2',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(3,3,'床位名称3','1682404126298','upload/chuangwei3.jpg','床位地点3',2,'床位介绍3',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(4,4,'床位名称4','1682404126336','upload/chuangwei4.jpg','床位地点4',2,'床位介绍4',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(5,5,'床位名称5','1682404126346','upload/chuangwei5.jpg','床位地点5',2,'床位介绍5',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(6,6,'床位名称6','1682404126299','upload/chuangwei6.jpg','床位地点6',1,'床位介绍6',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(7,7,'床位名称7','1682404126344','upload/chuangwei7.jpg','床位地点7',2,'床位介绍7',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(8,8,'床位名称8','1682404126350','upload/chuangwei8.jpg','床位地点8',2,'床位介绍8',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(9,9,'床位名称9','1682404126307','upload/chuangwei9.jpg','床位地点9',2,'床位介绍9',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(10,10,'床位名称10','1682404126325','upload/chuangwei10.jpg','床位地点10',1,'床位介绍10',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(11,11,'床位名称11','1682404126306','upload/chuangwei11.jpg','床位地点11',2,'床位介绍11',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(12,12,'床位名称12','1682404126296','upload/chuangwei12.jpg','床位地点12',1,'床位介绍12',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(13,13,'床位名称13','1682404126337','upload/chuangwei13.jpg','床位地点13',2,'床位介绍13',1,'2023-04-25 14:28:46','2023-04-25 14:28:46'),(14,14,'床位名称14','1682404126349','upload/chuangwei14.jpg','床位地点14',2,'床位介绍14',1,'2023-04-25 14:28:46','2023-04-25 14:28:46');

/*Table structure for table `chuangwei_yuyue` */

DROP TABLE IF EXISTS `chuangwei_yuyue`;

CREATE TABLE `chuangwei_yuyue` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `chuangwei_yuyue_uuid_number` varchar(200) DEFAULT NULL COMMENT '报名编号 Search111 ',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `laoren_id` int(11) DEFAULT NULL COMMENT '老人',
  `chuangwei_id` int(11) DEFAULT NULL COMMENT '床位',
  `chuangwei_yuyue_text` longtext COMMENT '报名理由',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '床位调动申请时间',
  `chuangwei_yuyue_yesno_types` int(11) DEFAULT NULL COMMENT '报名状态 Search111 ',
  `chuangwei_yuyue_yesno_text` longtext COMMENT '审核回复',
  `chuangwei_yuyue_shenhe_time` timestamp NULL DEFAULT NULL COMMENT '审核时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='床位调动申请';