DB_51aspx/gymdb.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50018
Source Host           : localhost:3306
Source Database       : gymdb

Target Server Type    : MYSQL
Target Server Version : 50018
File Encoding         : 65001

Date: 2017-05-16 00:40:17
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `billing`
-- ----------------------------
DROP TABLE IF EXISTS `billing`;
CREATE TABLE `billing` (
  `BillingId` int(11) NOT NULL auto_increment,
  `ClientCode` varchar(45) default NULL,
  `CourtCode` varchar(45) default NULL,
  `DateFrom` datetime default NULL,
  `DateTo` datetime default NULL,
  `BillingStatus` varchar(45) default NULL,
  `BillingInfo` varchar(200) default NULL,
  `BillingCode` varchar(45) default NULL,
  PRIMARY KEY  (`BillingId`),
  UNIQUE KEY `BillingId_UNIQUE` (`BillingId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of billing
-- ----------------------------
INSERT INTO `billing` VALUES ('1', 'h2013001', 'c001', '2017-04-10 01:09:00', '2017-04-10 05:55:00', '预定', '', null);
INSERT INTO `billing` VALUES ('2', 'h2013001', 'c001', '2017-04-10 08:08:00', '2017-04-10 10:08:00', '使用', '', null);
INSERT INTO `billing` VALUES ('3', 'h2013001', 'c001', '2017-04-10 09:22:00', '2017-04-10 10:22:00', '预定', '', null);
INSERT INTO `billing` VALUES ('5', 'h2013001', 'c001', '2017-04-10 20:27:00', '2017-04-10 22:57:00', '预定', '', null);
INSERT INTO `billing` VALUES ('6', 'h2013002', 'c001', '2017-04-11 21:00:00', '2017-04-11 22:57:00', '预定', '', null);
INSERT INTO `billing` VALUES ('7', 'h2013002', 'c001', '2017-04-11 20:00:00', '2017-04-11 23:37:00', '预定', '', null);
INSERT INTO `billing` VALUES ('8', 'h2013002', 'c001', '2017-04-11 20:10:00', '2017-04-11 22:00:00', '预定', '', null);
INSERT INTO `billing` VALUES ('9', 'h2013001', 'c001', '2017-04-09 20:00:00', '2017-04-10 22:00:00', '预订', '', 'p130408225030354');

-- ----------------------------
-- Table structure for `billingsubjoin`
-- ----------------------------
DROP TABLE IF EXISTS `billingsubjoin`;
CREATE TABLE `billingsubjoin` (
  `BillingSubjoinId` int(11) NOT NULL auto_increment,
  `BillingId` int(11) default NULL,
  `EquipageCode` varchar(45) default NULL,
  `BillingPattern` varchar(45) default NULL,
  PRIMARY KEY  (`BillingSubjoinId`),
  UNIQUE KEY `BillingSubjoinId_UNIQUE` (`BillingSubjoinId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------