专业名称代码 sql创建脚本

代码来源网址：http://bj.xdf.cn/publish/portal24/tab13076/info900320.htm（2017年普通高等学校本科专业目录）

根据教育部相关规定，所有的大学专业共分为12个大学科门类，包括：哲学、经济学、法学、教育学、文学、历史学、理学、工学、农学、医学、管理学、艺术学。它规定了专业划分、名称及所属门类，是设置和调整专业、实施人才培养、安排招生、授予学位、指导就业，进行教育统计和人才需求预测等工作的重要依据。

　　新目录分为基本专业（352种）和特设专业（154种），并确定了62种专业为国家控制布点专业。特设专业和国家控制布点专业分别在专业代码后加“T”和“K”表示，以示区分。

创建 专业名称表

CREATE TABLE [dbo].[Major]([ID] [int] IDENTITY(1,1) NOT NULL,[MajorCode] [nvarchar](20) NULL,[MajorName] [nvarchar](20) NULL,        [MajorState] [int] NULL, [ParentID] [nvarchar](20) NULL, CONSTRAINT [PK_Major] PRIMARY KEY CLUSTERED ([ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]

插入语句（修正后）

INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1','学科门类：哲学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101','哲学类',1,'1');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('10101','哲学',1,'101');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('10102','逻辑学',1,'101');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('010103K','宗教学',1,'101');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('2','学科门类：经济学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('201','经济学类',1,'2');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20101','经济学',1,'201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20102','经济统计学',1,'201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('202','财政学类',1,'2');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020201K','财政学',1,'202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20202','税收学',1,'202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('203','金融学类',1,'2');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020301K','金融学',1,'203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20302','金融工程',1,'203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20303','保险学',1,'203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20304','投资学',1,'203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('204','经济与贸易类',1,'2');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20401','国际经济与贸易',1,'204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('20402','贸易经济',1,'204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('3','学科门类：法学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('301','法学类',1,'3');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030101K','法学',1,'301');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('302','政治学类',1,'3');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30201','政治学与行政学',1,'302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30202','国际政治',1,'302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30203','外交学',1,'302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('303','社会学类',1,'3');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30301','社会学',1,'303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30302','社会工作',1,'303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('304','民族学类',1,'3');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30401','民族学',1,'304');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('305','马克思主义理论类',1,'3');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30501','科学社会主义',1,'305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30502','中国共产党历史',1,'305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('30503','思想政治教育',1,'305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('306','公安学类',1,'3');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030601K','治安学',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030602K','侦查学',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030603K','边防管理',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('4','学科门类：教育学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('401','教育学类',1,'4');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40101','教育学',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40102','科学教育',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40103','人文教育',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40104','教育技术学',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40105','艺术教育',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40106','学前教育',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40107','小学教育',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40108','特殊教育',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('402','体育学类',1,'4');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40201','体育教育',1,'402');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('040202K','运动训练',1,'402');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40203','社会体育指导与管理',1,'402');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('040204K','武术与民族传统体育',1,'402');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('40205','运动人体科学',1,'402');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('5','学科门类：文学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('501','中国语言文学类',1,'5');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50101','汉语言文学',1,'501');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50102','汉语言',1,'501');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50103','汉语国际教育',1,'501');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50104','中国少数民族语言文学',1,'501');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50105','古典文献学',1,'501');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('502','外国语言文学类',1,'5');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50201','英语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50202','俄语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50203','德语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50204','法语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50205','西班牙语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50206','阿拉伯语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50207','日语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50208','波斯语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50209','朝鲜语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50210','菲律宾语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50211','梵语巴利语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50212','印度尼西亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50213','印地语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50214','柬埔寨语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50215','老挝语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50216','缅甸语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50217','马来语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50218','蒙古语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50219','僧伽罗语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50220','泰语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50221','乌尔都语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50222','希伯来语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50223','越南语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50224','豪萨语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50225','斯瓦希里语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50226','阿尔巴尼亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50227','保加利亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50228','波兰语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50229','捷克语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50230','斯洛伐克语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50231','罗马尼亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50232','葡萄牙语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50233','瑞典语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50234','塞尔维亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50235','土耳其语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50236','希腊语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50237','匈牙利语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50238','意大利语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50239','泰米尔语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50240','普什图语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50241','世界语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50242','孟加拉语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50243','尼泊尔语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50244','克罗地亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50245','荷兰语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50246','芬兰语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50247','乌克兰语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50248','挪威语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50249','丹麦语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50250','冰岛语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50251','爱尔兰语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50252','拉脱维亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50253','立陶宛语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50254','斯洛文尼亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50255','爱沙尼亚语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50256','马耳他语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50257','哈萨克语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50258','乌兹别克语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50259','祖鲁语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50260','拉丁语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50261','翻译',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50262','商务英语',1,'502');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('503','新闻传播学类',1,'5');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50301','新闻学',1,'503');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50302','广播电视学',1,'503');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50303','广告学',1,'503');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50304','传播学',1,'503');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('50305','编辑出版学',1,'503');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('6','学科门类：历史学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('601','历史学类',1,'6');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('60101','历史学',1,'601');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('60102','世界史',1,'601');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('60103','考古学',1,'601');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('60104','文物与博物馆学',1,'601');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('7','学科门类：理学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('701','数学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70101','数学与应用数学',1,'701');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70102','信息与计算科学',1,'701');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('702','物理学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70201','物理学',1,'702');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70202','应用物理学',1,'702');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70203','核物理',1,'702');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('703','化学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70301','化学',1,'703');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70302','应用化学',1,'703');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('704','天文学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70401','天文学',1,'704');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('705','地理科学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70501','地理科学',1,'705');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70502','自然地理与资源环境',1,'705');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70503','人文地理与城乡规划',1,'705');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70504','地理信息科学',1,'705');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('706','大气科学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70601','大气科学',1,'706');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70602','应用气象学',1,'706');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('707','海洋科学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70701','海洋科学',1,'707');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70702','海洋技术',1,'707');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('708','地球物理学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70801','地球物理学',1,'708');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70802','空间科学与技术',1,'708');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('709','地质学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70901','地质学',1,'709');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('70902','地球化学',1,'709');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('710','生物科学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71001','生物科学',1,'710');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71002','生物技术',1,'710');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71003','生物信息学',1,'710');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71004','生态学',1,'710');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('711','心理学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71101','心理学',1,'711');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71102','应用心理学',1,'711');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('712','统计学类',1,'7');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71201','统计学',1,'712');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('71202','应用统计学',1,'712');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('8','学科门类：工学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('801','力学类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80101','理论与应用力学',1,'801');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80102','工程力学',1,'801');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('802','机械类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80201','机械工程',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80202','机械设计制造及其自动化',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80203','材料成型及控制工程',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80204','机械电子工程',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80205','工业设计',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80206','过程装备与控制工程',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80207','车辆工程',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80208','汽车服务工程',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('803','仪器类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80301','测控技术与仪器',1,'803');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('804','材料类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80401','材料科学与工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80402','材料物理',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80403','材料化学',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80404','冶金工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80405','金属材料工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80406','无机非金属材料工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80407','高分子材料与工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80408','复合材料与工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('805','能源动力类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80501','能源与动力工程',1,'805');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('806','电气类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80601','电气工程及其自动化',1,'806');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('807','电子信息类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80701','电子信息工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80702','电子科学与技术',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80703','通信工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80704','微电子科学与工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80705','光电信息科学与工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80706','信息工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('808','自动化类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80801','自动化',1,'808');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('809','计算机类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80901','计算机科学与技术',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80902','软件工程',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80903','网络工程',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080904K','信息安全',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80905','物联网工程',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('80906','数字媒体技术',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('810','土木类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81001','土木工程',1,'810');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81002','建筑环境与能源应用工程',1,'810');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81003','给排水科学与工程',1,'810');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81004','建筑电气与智能化',1,'810');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('811','水利类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81101','水利水电工程',1,'811');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81102','水文与水资源工程',1,'811');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81103','港口航道与海岸工程',1,'811');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('812','测绘类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81201','测绘工程',1,'812');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81202','遥感科学与技术',1,'812');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('813','化工与制药类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81301','化学工程与工艺',1,'813');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81302','制药工程',1,'813');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('814','地质类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81401','地质工程',1,'814');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81402','勘查技术与工程',1,'814');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81403','资源勘查工程',1,'814');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('815','矿业类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81501','采矿工程',1,'815');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81502','石油工程',1,'815');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81503','矿物加工工程',1,'815');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81504','油气储运工程',1,'815');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('816','纺织类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81601','纺织工程',1,'816');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81602','服装设计与工程',1,'816');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('817','轻工类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81701','轻化工程',1,'817');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81702','包装工程',1,'817');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81703','印刷工程',1,'817');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('818','交通运输类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81801','交通运输',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81802','交通工程',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081803K','航海技术',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081804K','轮机工程',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081805K','飞行技术',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('819','海洋工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('81901','船舶与海洋工程',1,'819');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('820','航空航天类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82001','航空航天工程',1,'820');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82002','飞行器设计与工程',1,'820');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82003','飞行器制造工程',1,'820');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82004','飞行器动力工程',1,'820');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82005','飞行器环境与生命保障工程',1,'820');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('821','兵器类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82101','武器系统与工程',1,'821');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82102','武器发射工程',1,'821');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82103','探测制导与控制技术',1,'821');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82104','弹药工程与爆炸技术',1,'821');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82105','特种能源技术与工程',1,'821');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82106','装甲车辆工程',1,'821');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82107','信息对抗技术',1,'821');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('822','核工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82201','核工程与核技术',1,'822');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82202','辐射防护与核安全',1,'822');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82203','工程物理',1,'822');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82204','核化工与核燃料工程',1,'822');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('823','农业工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82301','农业工程',1,'823');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82302','农业机械化及其自动化',1,'823');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82303','农业电气化',1,'823');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82304','农业建筑环境与能源工程',1,'823');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82305','农业水利工程',1,'823');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('824','林业工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82401','森林工程',1,'824');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82402','木材科学与工程',1,'824');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82403','林产化工',1,'824');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('825','环境科学与工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82501','环境科学与工程',1,'825');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82502','环境工程',1,'825');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82503','环境科学',1,'825');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82504','环境生态工程',1,'825');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('826','生物医学工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82601','生物医学工程',1,'826');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('827','食品科学与工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82701','食品科学与工程',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82702','食品质量与安全',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82703','粮食工程',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82704','乳品工程',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82705','酿酒工程',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('828','建筑类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82801','建筑学',1,'828');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82802','城乡规划',1,'828');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82803','风景园林',1,'828');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('829','安全科学与工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('82901','安全工程',1,'829');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('830','生物工程类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('83001','生物工程',1,'830');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('831','公安技术类',1,'8');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083101K','刑事科学技术',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083102K','消防工程',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('9','学科门类：农学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('901','植物生产类',1,'9');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90101','农学',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90102','园艺',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90103','植物保护',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90104','植物科学与技术',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90105','种子科学与工程',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90106','设施农业科学与工程',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('902','自然保护与环境生态类',1,'9');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90201','农业资源与环境',1,'902');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90202','野生动物与自然保护区管理',1,'902');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90203','水土保持与荒漠化防治',1,'902');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('903','动物生产类',1,'9');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90301','动物科学',1,'903');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('904','动物医学类',1,'9');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90401','动物医学',1,'904');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90402','动物药学',1,'904');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('905','林学类',1,'9');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90501','林学',1,'905');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90502','园林',1,'905');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90503','森林保护',1,'905');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('906','水产类',1,'9');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90601','水产养殖学',1,'906');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90602','海洋渔业科学与技术',1,'906');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('907','草学类',1,'9');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('90701','草业科学',1,'907');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('10','学科门类：医学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1001','基础医学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100101K','基础医学',1,'1001');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1002','临床医学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100201K','临床医学',1,'1002');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1003','口腔医学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100301K','口腔医学',1,'1003');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1004','公共卫生与预防医学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100401K','预防医学',1,'1004');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100402','食品卫生与营养学',1,'1004');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1005','中医学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100501K','中医学',1,'1005');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100502K','针灸推拿学',1,'1005');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100503K','藏医学',1,'1005');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100504K','蒙医学',1,'1005');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100505K','维医学',1,'1005');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100506K','壮医学',1,'1005');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100507K','哈医学',1,'1005');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1006','中西医结合类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100601K','中西医临床医学',1,'1006');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1007','药学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100701','药学',1,'1007');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100702','药物制剂',1,'1007');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1008','中药学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100801','中药学',1,'1008');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100802','中药资源与开发',1,'1008');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1009','法医学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100901K','法医学',1,'1009');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1010','医学技术类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101001','医学检验技术',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101002','医学实验技术',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101003','医学影像技术',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101004','眼视光学',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101005','康复治疗学',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101006','口腔医学技术',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101007','卫生检验与检疫',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1011','护理学类',1,'10');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101101','护理学',1,'1011');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('12','学科门类：管理学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1201','管理科学与工程类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120101','管理科学',1,'1201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120102','信息管理与信息系统',1,'1201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120103','工程管理',1,'1201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120104','房地产开发与管理',1,'1201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120105','工程造价',1,'1201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1202','工商管理类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120201K','工商管理',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120202','市场营销',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120203K','会计学',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120204','财务管理',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120205','国际商务',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120206','人力资源管理',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120207','审计学',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120208','资产评估',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120209','物业管理',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120210','文化产业管理',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1203','农业经济管理类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120301','农林经济管理',1,'1203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120302','农村区域发展',1,'1203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1204','公共管理类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120401','公共事业管理',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120402','行政管理',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120403','劳动与社会保障',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120404','土地资源管理',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120405','城市管理',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1205','图书情报与档案管理类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120501','图书馆学',1,'1205');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120502','档案学',1,'1205');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120503','信息资源管理',1,'1205');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1206','物流管理与工程类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120601','物流管理',1,'1206');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120602','物流工程',1,'1206');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1207','工业工程类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120701','工业工程',1,'1207');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1208','电子商务类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120801','电子商务',1,'1208');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1209','旅游管理类',1,'12');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120901K','旅游管理',1,'1209');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120902','酒店管理',1,'1209');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120903','会展经济与管理',1,'1209');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('13','学科门类：艺术学',1,null);INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1301','艺术学理论类',1,'13');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130101','艺术史论',1,'1301');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1302','音乐与舞蹈学类',1,'13');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130201','音乐表演',1,'1302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130202','音乐学',1,'1302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130203','作曲与作曲技术理论',1,'1302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130204','舞蹈表演',1,'1302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130205','舞蹈学',1,'1302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130206','舞蹈编导',1,'1302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1303','戏剧与影视学类',1,'13');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130301','表演',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130302','戏剧学',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130303','电影学',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130304','戏剧影视文学',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130305','广播电视编导',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130306','戏剧影视导演',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130307','戏剧影视美术设计',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130308','录音艺术',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130309','播音与主持艺术',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130310','动画',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1304','美术学类',1,'13');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130401','美术学',1,'1304');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130402','绘画',1,'1304');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130403','雕塑',1,'1304');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130404','摄影',1,'1304');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('1305','设计学类',1,'13');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130501','艺术设计学',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130502','视觉传达设计',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130503','环境设计',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130504','产品设计',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130505','服装与服饰设计',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130506','公共艺术',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130507','工艺美术',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130508','数字媒体艺术',1,'1305');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('010104T','伦理学',1,'101');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020103T','国民经济管理',1,'201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020104T','资源与环境经济学',1,'201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020105T','商务经济学',1,'201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020106T','能源经济',1,'201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020305T','金融数学',1,'203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020306T','信用管理',1,'203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('020307T','经济与金融',1,'203');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030102T','知识产权',1,'301');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030103T','监狱学',1,'301');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030204T','国际事务与国际关系',1,'302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030205T','政治学、经济学与哲学',1,'302');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030303T','人类学',1,'303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030304T','女性学',1,'303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030305T','家政学',1,'303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030604TK','禁毒学',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030605TK','警犬技术',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030606TK','经济犯罪侦查',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030607TK','边防指挥',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030608TK','消防指挥',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030609TK','警卫学',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030610TK','公安情报学',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030611TK','犯罪学',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030612TK','公安管理学',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030613TK','涉外警务',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030614TK','国内安全保卫',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('030615TK','警务指挥与战术',1,'306');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('040109T','华文教育',1,'401');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('040206T','运动康复',1,'402');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('040207T','休闲体育',1,'402');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('050106T','应用语言学',1,'501');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('050107T','秘书学',1,'501');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('050306T','网络与新媒体',1,'503');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('050307T','数字出版',1,'503');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('060105T','文物保护技术',1,'601');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('060106T','外国语言与外国历史',1,'601');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070103T','数理基础科学',1,'701');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070204T','声学',1,'702');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070303T','化学生物学',1,'703');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070304T','分子科学与工程',1,'703');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070703T','海洋资源与环境',1,'707');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070704T','军事海洋学',1,'707');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070903T','地球信息科学与技术',1,'709');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('070904T','古生物学',1,'709');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080209T','机械工艺技术',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080210T','微机电系统工程',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080211T','机电技术教育',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080212T','汽车维修工程教育',1,'802');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080409T','粉体材料科学与工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080410T','宝石及材料工艺学',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080411T','焊接技术与工程',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080412T','功能材料',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080413T','纳米材料与技术',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080414T','新能源材料与器件',1,'804');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080502T','能源与环境系统工程',1,'805');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080503T','新能源科学与工程',1,'805');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080602T','智能电网信息工程',1,'806');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080603T','光源与照明',1,'806');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080604T','电气工程与智能控制',1,'806');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080707T','广播电视工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080708T','水声工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080709T','电子封装技术',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080710T','集成电路设计与集成系统',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080711T','医学信息工程',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080712T','电磁场与无线技术',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080713T','电波传播与天线',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080714T','电子信息科学与技术',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080715T','电信工程及管理',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080716T','应用电子技术教育',1,'807');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080802T','轨道交通信号与控制',1,'808');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080907T','智能科学与技术',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080908T','空间信息与数字技术',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('080909T','电子与计算机工程',1,'809');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081005T','城市地下空间工程',1,'810');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081006T','道路桥梁与渡河工程',1,'810');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081104T','水务工程',1,'811');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081203T','导航工程',1,'812');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081204T','地理国情监测',1,'812');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081303T','资源循环科学与工程',1,'813');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081304T','能源化学工程',1,'813');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081305T','化学工程与工业生物工程',1,'813');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081404T','地下水科学与工程',1,'814');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081505T','矿物资源工程',1,'815');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081506T','海洋油气工程',1,'815');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081603T','非织造材料与工程',1,'816');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081604T','服装设计与工艺教育',1,'816');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081806T','交通设备与控制工程',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081807T','救助与打捞工程',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081808TK','船舶电子电气工程',1,'818');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081902T','海洋工程与技术',1,'819');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('081903T','海洋资源开发技术',1,'819');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082006T','飞行器质量与可靠性',1,'820');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082007T','飞行器适航技术',1,'820');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082505T','环保设备工程',1,'825');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082506T','资源环境科学',1,'825');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082507T','水质科学与技术',1,'825');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082602T','假肢矫形工程',1,'826');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082706T','葡萄与葡萄酒工程',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082707T','食品营养与检验教育',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082708T','烹饪与营养教育',1,'827');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('082804T','历史建筑保护工程',1,'828');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083002T','生物制药',1,'830');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083103TK','交通管理工程',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083104TK','安全防范工程',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083105TK','公安视听技术',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083106TK','抢险救援指挥与技术',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083107TK','火灾勘查',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083108TK','网络安全与执法',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('083109TK','核生化消防',1,'831');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090107T','茶学',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090108T','烟草',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090109T','应用生物科学',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090110T','农艺教育',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090111T','园艺教育',1,'901');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090302T','蚕学',1,'903');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090303T','蜂学',1,'903');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090403T','动植物检疫',1,'904');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('090603T','水族科学与技术',1,'906');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100202TK','麻醉学',1,'1002');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100203TK','医学影像学',1,'1002');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100204TK','眼视光医学',1,'1002');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100205TK','精神医学',1,'1002');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100206TK','放射医学',1,'1002');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100403TK','妇幼保健医学',1,'1004');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100404TK','卫生监督',1,'1004');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100405TK','全球健康学',1,'1004');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100703TK','临床药学',1,'1007');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100704T','药事管理',1,'1007');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100705T','药物分析',1,'1007');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100706T','药物化学',1,'1007');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100707T','海洋药学',1,'1007');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100803T','藏药学',1,'1008');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100804T','蒙药学',1,'1008');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100805T','中药制药',1,'1008');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('100806T','中草药栽培与鉴定',1,'1008');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('101008T','听力与言语康复学',1,'1010');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120106TK','保密管理',1,'1201');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120211T','劳动关系',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120212T','体育经济与管理',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120213T','财务会计教育',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120214T','市场营销教育',1,'1202');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120406TK','海关管理',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120407T','交通管理',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120408T','海事管理',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120409T','公共关系学',1,'1204');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120603T','采购管理',1,'1206');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120702T','标准化工程',1,'1207');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120703T','质量管理工程',1,'1207');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120802T','电子商务及法律',1,'1208');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('120904T','旅游管理与服务教育',1,'1209');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130311T','影视摄影与制作',1,'1303');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130405T','书法学',1,'1304');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130406T','中国画',1,'1304');INSERT INTO Major (MajorCode,MajorName,MajorState,ParentID) VALUES ('130509T','艺术与科技',1,'1305');