省市大学院系数据库表结构

CREATE TABLE `t_city_section` (
`cityquid` mediumint(8) NOT NULL auto_increment,
`cityquname` varchar(20) NOT NULL default '',
`cityid` mediumint(8) NOT NULL default '0',
`flag` tinyint(4) default '2',
PRIMARY KEY (`cityquid`)
) ENGINE=InnoDB AUTO_INCREMENT=2793 DEFAULT CHARSET=utf8


CREATE TABLE `t_university` (
`universityid` mediumint(8) NOT NULL auto_increment,
`universityname` varchar(20) NOT NULL default '',
`provinceid` tinyint(4) NOT NULL default '0',
`oriuniversityid` mediumint(8) NOT NULL default '0',
`note` varchar(20) default NULL,
PRIMARY KEY (`universityid`)
) ENGINE=InnoDB AUTO_INCREMENT=2552 DEFAULT CHARSET=utf8

CREATE TABLE `t_department` (
`departmentid` mediumint(8) NOT NULL auto_increment,
`departmentname` varchar(20) NOT NULL default '',
`oriuniversityid` mediumint(8) NOT NULL default '0',
`note` varchar(20) default NULL,
PRIMARY KEY (`departmentid`),
KEY `oriuniversityid` (`oriuniversityid`)
) ENGINE=InnoDB AUTO_INCREMENT=31293 DEFAULT CHARSET=utf8