标段(包)分类 字典sql

招标公共服务平台所需标段(包)分类字典sql

INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A000000’, ‘工程’, ‘A’, ‘0’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A010000’, ‘规划’, ‘A01’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A020000’, ‘投资策划与决策’, ‘A02’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A030000’, ‘勘察’, ‘A03’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A040000’, ‘设计’, ‘A04’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A050000’, ‘监理’, ‘A05’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A060000’, ‘工程造价’, ‘A06’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A070000’, ‘项目管理(含代建)’, ‘A07’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A080000’, ‘工程施工’, ‘A08’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘A090000’, ‘其他工程’, ‘A09’, ‘A000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B000000’, ‘货物’, ‘B’, ‘0’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B010000’, ‘机械、设备类’, ‘B01’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B020000’, ‘医疗器械’, ‘B02’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B030000’, ‘金属材料’, ‘B03’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B040000’, ‘石油及其制品’, ‘B04’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B050000’, ‘煤炭煤层气及其制品’, ‘B05’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B060000’, ‘化工材料及其制品’, ‘B06’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B070000’, ‘建筑材料’, ‘B07’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘B080000’, ‘药品’, ‘B08’, ‘B000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C000000’, ‘服务’, ‘C’, ‘0’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C010000’, ‘勘查与调查’, ‘C01’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C020000’, ‘公共咨询’, ‘C02’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C030000’, ‘经济管理’, ‘C03’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C040000’, ‘工商管理’, ‘C04’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C050000’, ‘金融’, ‘C05’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C060000’, ‘法律’, ‘C06’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C070000’, ‘修理’, ‘C07’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C080000’, ‘租赁’, ‘C08’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C090000’, ‘交通运输与物流’, ‘C09’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C100000’, ‘节能服务’, ‘C10’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C110000’, ‘高新技术服务’, ‘C11’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C120000’, ‘其他服务’, ‘C12’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130000’, ‘招标代理服务’, ‘C13’, ‘C000000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130100’, ‘工程类代理’, ‘C1301’, ‘C130000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130101’, ‘中央投资项目’, ‘C130101’, ‘C130100’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130102’, ‘政府采购项目’, ‘C130102’, ‘C130100’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130103’, ‘机电国际招标项目’, ‘C130103’, ‘C130100’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130104’, ‘通讯建设项目’, ‘C130104’, ‘C130100’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130105’, ‘其他’, ‘C130105’, ‘C130100’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130200’, ‘货物类代理’, ‘C1302’, ‘C130000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130300’, ‘服务类代理’, ‘C1303’, ‘C130000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130400’, ‘产权类代理’, ‘C1304’, ‘C130000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘C130500’, ‘土地类代理’, ‘C1305’, ‘C130000’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘D000000’, ‘产权’, ‘D’, ‘0’);
INSERT INTO bid_classify_code (id, text, value, parent_id) VALUES (‘E000000’, ‘土地’, ‘E’, ‘0’);