market.sql

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

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

/*
MySQL Data Transfer
Source Host: localhost
Source Database: market
Target Host: localhost
Target Database: market
Date: 2018/5/12/周六 22:32:55
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for m_area
-- ----------------------------
DROP TABLE IF EXISTS `m_area`;
CREATE TABLE `m_area` (
  `ID` varchar(50) NOT NULL,
  `AREA_NAME` varchar(10) NOT NULL,
  `AREA_DESC` varchar(100) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Index_2` (`AREA_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for m_class
-- ----------------------------
DROP TABLE IF EXISTS `m_class`;
CREATE TABLE `m_class` (
  `ID` varchar(50) NOT NULL,
  `DEP_ID` varchar(50) NOT NULL,
  `CLASS_NAME` varchar(10) NOT NULL,
  `CLASS_DESC` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Index_2` (`CLASS_NAME`),
  KEY `FK_M_CLASS_1` (`DEP_ID`),
  CONSTRAINT `FK_M_CLASS_1` FOREIGN KEY (`DEP_ID`) REFERENCES `m_dep` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for m_dep
-- ----------------------------
DROP TABLE IF EXISTS `m_dep`;
CREATE TABLE `m_dep` (
  `ID` varchar(50) NOT NULL,
  `DEP_NAME` varchar(10) NOT NULL,
  `DEP_DESC` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Index_2` (`DEP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for m_student
-- ----------------------------
DROP TABLE IF EXISTS `m_student`;
CREATE TABLE `m_student` (
  `ID` varchar(12) NOT NULL DEFAULT '',
  `STU_NAME` varchar(10) NOT NULL,
  `CLASS_ID` varchar(50) NOT NULL,
  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;