全国大学名称与及相对应的院系列表

# MySQL-Front 3.2 (Build 14.8) /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='SYSTEM' */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; # Host: localhost Database: redekuai_development # ------------------------------------------------------ # Server version 5.0.18-nt /*!40101 SET NAMES utf8 */; # # Table structure for table schools # CREATE TABLE `schools` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `uid` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT; # # Dumping data for table schools # INSERT INTO `schools` VALUES (1001001,'中国语言文学系',1001); INSERT INTO `schools` VALUES (1001002,'人文社会科学学院',1001); INSERT INTO `schools` VALUES (1001003,'企业管理系',1001); INSERT INTO `schools` VALUES (1001004,'体育教研部',1001); INSERT INTO `schools` VALUES (1001005,'信息学院',1001); INSERT INTO `schools` VALUES (1001006,'信息艺术设计系',1001); INSERT INTO `schools` VALUES (1001007,'公共管理学院',1001); INSERT INTO `schools` VALUES (1001008,'化学工程系',1001); INSERT INTO `schools` VALUES (1001009,'化学系',1001); INSERT INTO `schools` VALUES (1001010,'医学系',1001); INSERT INTO `schools` VALUES (1001011,'协和医学院',1001); INSERT INTO `schools` VALUES (1001012,'历史系',1001); INSERT INTO `schools` VALUES (1001013,'哲学系',1001); INSERT INTO `schools` VALUES (1001014,'国际学院',1001); INSERT INTO `schools` VALUES (1001015,'国际贸易与金融系',1001); INSERT INTO `schools` VALUES (1001016,'国际问题研究所',1001); INSERT INTO `schools` VALUES (1001017,'土木工程系',1001); INSERT INTO `schools` VALUES (1001018,'城市规划系',1001); INSERT INTO `schools` VALUES (1001019,'基础科学班',1001); INSERT INTO `schools` VALUES (1001020,'外语系',1001); INSERT INTO `schools` VALUES (1001021,'对外交流中心',1001); INSERT INTO `schools` VALUES (1001022,'工业工程系',1001); INSERT INTO `schools` VALUES (1001023,'工业设计',1001); INSERT INTO `schools` VALUES (1001024,'工商管理',1001); INSERT INTO `schools` VALUES (1001025,'工程力学系',1001); INSERT INTO `schools` VALUES (1001026,'工程物理系',1001); INSERT INTO `schools` VALUES (1001027,'应用技术学院',1001); INSERT INTO `schools` VALUES (1001028,'建筑技术科学系',1001); INSERT INTO `schools` VALUES (1001029,'建筑系',1001); INSERT INTO `schools` VALUES (1001030,'建设管理系',1001); INSERT INTO `schools` VALUES (1001031,'微电子与纳电子学系',1001); INSERT INTO `schools` VALUES (1001032,'微电子学研究所',1001); INSERT INTO `schools` VALUES (1001033,'技术经济与管理系',1001); INSERT INTO `schools` VALUES (1001034,'政治学系',1001); INSERT INTO `schools` VALUES (1001035,'教育研究所',1001); INSERT INTO `schools` VALUES (1001036,'数学科学系',1001); INSERT INTO `schools` VALUES (1001037,'新加坡国立大学',1001); INSERT INTO `schools` VALUES (1001038,'新闻与传播学院',1001); INSERT INTO `schools` VALUES (1001039,'新闻学院',1001); INSERT INTO `schools` VALUES (1001040,'景观学系',1001); INSERT INTO `schools` VALUES (1001041,'机械工程系',1001); INSERT INTO `schools` VALUES (1001042,'机电',1001); INSERT INTO `schools` VALUES (1001043,'材料科学与工程系',1001); INSERT INTO `schools` VALUES (1001044,'核能与新能源技术研究院',1001); INSERT INTO `schools` VALUES (1001045,'水利水电工程系',1001); INSERT INTO `schools` VALUES (1001046,'汽车工程系',1001); INSERT INTO `schools` VALUES (1001047,'汽车设计',1001); INSERT INTO `schools` VALUES (1001048,'法学院',1001); INSERT INTO `schools` VALUES (1001049,'热能工程系',1001); INSERT INTO `schools` VALUES (1001050,'热能系',1001); INSERT INTO `schools` VALUES (1001051,'物理系',1001); INSERT INTO `schools` VALUES (1001052,'环境科学与工程系',1001); INSERT INTO `schools` VALUES (1001053,'环境艺术设计系',1001); INSERT INTO `schools` VALUES (1001054,'理学院',1001); INSERT INTO `schools` VALUES (1001055,'生物医学工程系',1001); INSERT INTO `schools` VALUES (1001056,'生物科学与技术系',1001); INSERT INTO `schools` VALUES (1001057,'电子工程系',1001); INSERT INTO `schools` VALUES (1001058,'电子系',1001); INSERT INTO `schools` VALUES (1001059,'电机工程与应用电子技术系',1001); INSERT INTO `schools` VALUES (1001060,'研究生院',1001); INSERT INTO `schools` VALUES (1001061,'社会学系',1001); INSERT INTO `schools` VALUES (1001062,'科技与社会研究所',1001); INSERT INTO `schools` VALUES (1001063,'第一附属医院',1001); INSERT INTO `schools` VALUES (1001064,'第二附属医院',1001); INSERT INTO `schools` VALUES (1001065,'管理科学与工程系',1001); INSERT INTO `schools` VALUES (1001066,'精密仪器与机械学系',1001); INSERT INTO `schools` VALUES (1001067,'经济学研究所',1001); INSERT INTO `schools` VALUES (1001068,'经济管理学院',1001); INSERT INTO `schools` VALUES (1001069,'经济系',1001); INSERT INTO `schools` VALUES (1001070,'继续教育学院',1001); INSERT INTO `schools` VALUES (1001071,'美术学院',1001); INSERT INTO `schools` VALUES (1001072,'美术学院（史论分部）',1001); INSERT INTO `schools` VALUES (1001073,'美术学院（工业设计系）',1001); INSERT INTO `schools` VALUES (1001074,'美术学院（环境艺术系）',1001); INSERT INTO `schools` VALUES (1001075,'美术学院（美术分部）',1001); INSERT INTO `schools` VALUES (1001076,'美术学院（设计分部）',1001); INSERT INTO `schools` VALUES (1001077,'美术学院（雕塑系）',1001); INSERT INTO `schools` VALUES (1001078,'自动化系',1001); INSERT INTO `schools` VALUES (1001079,'航天航空学院',1001); INSERT INTO `schools` VALUES (1001080,'艺术教育中心',1001); INSERT INTO `schools` VALUES (1001081,'药学系',1001); INSERT INTO `schools` VALUES (1001082,'计算器应用与维修',1001); INSERT INTO `schools` VALUES (1001083,'计算机科学与技术系',1001); INSERT INTO `schools` VALUES (1001084,'软件学院',1001); INSERT INTO `schools` VALUES (1001085,'金融系',1001); INSERT INTO `schools` VALUES (1001086,'高等研究中心',1001); INSERT INTO `schools` VALUES (1002001,'EECS',1002); INSERT INTO `schools` VALUES (1002002,'中国经济研究中心',1002); INSERT INTO `schools` VALUES (1002003,'中国语言文学系',1002); INSERT INTO `schools` VALUES (1002004,'中文系',1002); INSERT INTO `schools` VALUES (1002005,'人口研究所',1002); INSERT INTO `schools` VALUES (1002006,'伦敦政治经济学院',1002); INSERT INTO `schools` VALUES (1002007,'体育教研部',1002); INSERT INTO `schools` VALUES (1002008,'体育系',1002); INSERT INTO `schools` VALUES (1002009,'信息科学技术学院',1002); INSERT INTO `schools` VALUES (1002010,'信息管理系',1002); INSERT INTO `schools` VALUES (1002011,'元培计划',1002); INSERT INTO `schools` VALUES (1002012,'光华管理学院',1002); INSERT INTO `schools` VALUES (1002013,'公共卫生学院',1002); INSERT INTO `schools` VALUES (1002014,'其他院系',1002); INSERT INTO `schools` VALUES (1002015,'分子医学研究所',1002); INSERT INTO `schools` VALUES (1002016,'力学与工程科学系',1002); INSERT INTO `schools` VALUES (1002017,'化学与分子工程学院',1002); INSERT INTO `schools` VALUES (1002018,'北京大学第三医院',1002); INSERT INTO `schools` VALUES (1002019,'医学部',1002); INSERT INTO `schools` VALUES (1002020,'医学部公共卫生学院',1002); INSERT INTO `schools` VALUES (1002021,'医学部公共教学部',1002); INSERT INTO `schools` VALUES (1002022,'医学部基础医学院',1002