-- MySQL dump 10.13  Distrib 8.0.23, for Linux (x86_64)
--
-- Host: localhost    Database: ehs
-- ------------------------------------------------------
-- Server version	8.0.23

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cp_enterprise`
--

DROP TABLE IF EXISTS `cp_enterprise`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cp_enterprise` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '企业名称',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '企业识别号',
  `country_id` int unsigned NOT NULL COMMENT '国家ID',
  `province_id` int unsigned DEFAULT NULL COMMENT '省份',
  `city_id` int unsigned DEFAULT NULL COMMENT '城市',
  `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '状态 1:正常 2:删除',
  `createtime` bigint unsigned NOT NULL COMMENT '创建时间',
  `lasttime` bigint unsigned DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `COUNTRY` (`country_id`) USING BTREE,
  KEY `PROVINCE` (`province_id`) USING BTREE,
  KEY `CITY` (`city_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cp_enterprise`
--

LOCK TABLES `cp_enterprise` WRITE;
/*!40000 ALTER TABLE `cp_enterprise` DISABLE KEYS */;
INSERT INTO `cp_enterprise` VALUES (2,'上海青手科技有限公司2','1882203938383930930G',3,73,NULL,1,1655279324091,1655279850967),(3,'上海青手网络科技有限公司-广州分公司','188198730661135MMMU',3,17,18,2,1655280147246,1655280170105),(4,'上海青手科技有限公司','1882203938383930930A',3,28,29,1,1655299913416,NULL),(5,'上海金茂律师事务所','313100004250127959',3,73,48,1,1658195086603,1680242652391),(6,'上海鹍远生物科技股份有限公司','913100003244893596',3,73,NULL,1,1661152238542,NULL),(7,'江苏鹍远生物技术有限公司','91321003MA2389AEXY',3,46,87,1,1661152269889,1661152298308),(8,'西雅衣家（上海）商务信息咨询有限公司','91310000594780402W',3,73,NULL,1,1661152348235,NULL),(9,'宜昌天美国际化妆品有限公司','9142050067035772XP',3,28,30,1,1661152385745,NULL),(10,'欧莱雅（中国）有限公司苏州分公司','91320594753217722T',3,46,48,1,1661152434948,NULL),(11,'台积电（南京）有限公司','91320100MA1MKUKH6T',3,46,47,1,1661152504764,NULL),(12,'苏州尚美国际化妆品有限公司','91320594608207624W',3,46,48,1,1661152532226,NULL),(13,'欧莱雅（中国）有限公司上海研发中心','91310000787839415B',3,73,NULL,1,1661163036573,NULL),(14,'欧莱雅北亚运营中心','无',3,73,NULL,1,1661163287745,NULL),(15,'美科化妆品（上海）有限公司','91310000607366420M',3,73,NULL,1,1661163350554,NULL),(16,'上海微荷医学检验所有限公司','91310115MA7E5N8J9W',3,73,NULL,1,1661237824197,NULL),(17,'复旦水务（上海）','91310000735430888G',3,73,NULL,1,1661238990889,1661239449006),(18,'上海奉贤西部污水处理有限公司','91310120787889199R',3,73,NULL,2,1661239083110,1661239452886),(19,'复旦水务（河南）','914101006767044119',3,37,38,1,1661239156023,1661239463139),(20,'南阳天冠水处理有限公司','91411300072686478Q',3,37,38,2,1661239215408,1661239466332),(21,'漯河格威特环保新能源有限公司','91411100068937393N',3,37,38,2,1661239250583,1661239470218),(22,'新乡市中汇污泥处理资源利用有限公司','9141070057101668XB',3,37,38,2,1661239283210,1661239473469),(23,'南阳市中汇污泥处理资源利用有限公司','914113005776306134',3,37,38,2,1661239372449,1661239475341),(24,'复旦水务（浙江）','/',3,75,76,1,1661239711195,NULL),(25,'复旦水务（山东）','/',3,63,64,1,1661239760793,NULL),(26,'复旦水务（江苏）','/',3,46,49,1,1661239788673,NULL),(27,'复旦水务（湖北）','/',3,28,29,1,1661239857404,NULL),(28,'宜家贸易服务（中国）有限公司','91440300573141775F',3,17,88,1,1661242082374,1661242136245),(29,'宜家贸易服务（中国）有限公司上海分公司','91310000583426694L',3,73,NULL,1,1661242188327,NULL),(30,'宜家贸易服务（中国）有限公司青岛分公司','913702005836617826',3,63,64,1,1661242208420,NULL),(31,'戴尔中国有限公司（上海）','91310000X073221413',3,73,NULL,1,1661247101119,NULL),(32,'戴尔中国有限公司（福建厦门）','91350200X122326778',3,14,15,1,1661247130070,NULL),(33,'戴尔中国有限公司（四川成都）','/',3,60,61,1,1661247171192,NULL),(34,'科学城（广州）环保产业投资集团有限公司','91440101MA5CRR6E0A',3,17,18,1,1661248112640,NULL),(35,'广州环科环保科技有限公司','91440101MA5CKQE57E',3,17,18,1,1661248131953,NULL),(36,'亨斯迈聚氨酯(中国)有限公司','91310112607207809X',3,73,NULL,1,1661834520077,NULL),(37,'亨斯迈化学研发中心(上海)有限公司','91310000666006695P',3,73,NULL,1,1661834548816,NULL),(38,'上海亨斯迈聚氨酯有限公司','913100007109366398',3,73,NULL,1,1661834579406,NULL),(39,'上海亨斯迈聚氨酯特种材料有限公司','9131000058520960X6',3,73,NULL,1,1661834632315,NULL),(40,'孚宝（上海）管理有限公司','91310000765595077A',3,73,NULL,1,1661847241985,NULL),(41,'上海孚宝港务有限公司','913100007366557713',3,73,NULL,1,1661848603054,NULL),(42,'张家港孚宝仓储有限公司','913205927682989673',3,46,48,1,1661848634796,NULL),(43,'孚宝渤化(天津)仓储有限公司','91120116697408849H',3,85,NULL,1,1661848666616,NULL),(44,'山东岚山孚宝仓储有限公司','91371100613802663K',3,63,64,1,1661848690804,NULL),(45,'孚宝(钦州)码头有限公司','91450700MA5P20HC6K',3,90,NULL,1,1661848731241,NULL),(46,'漳州古雷海腾码头投资管理有限公司','91350000687545735N',3,14,15,1,1661848770325,NULL),(47,'宁波孚宝仓储有限公司','91330200610259642X',3,75,86,1,1661848797624,NULL),(48,'西萨化工（上海）有限公司','91310000582115712Y',3,73,NULL,1,1661849731058,NULL),(49,'杜邦','\\',3,73,NULL,1,1661850488357,NULL),(50,'圣戈班投资（中国）有限公司','913100006000421407',3,73,NULL,1,1661852563763,NULL),(51,'圣戈班磨料磨具（上海）有限公司二厂','91310000607252546Q',3,73,NULL,1,1661852590647,NULL),(52,'圣戈班精细陶瓷（上海）有限公司','91310000607366973G',3,73,NULL,1,1661852709766,NULL),(53,'圣戈班伟伯（上海）建材有限公司','91310115766945251P',3,73,NULL,1,1661852733452,NULL),(54,'圣戈班伟伯（上海）建材有限公司武汉分公司','9142010034732002XL',3,28,29,1,1661852773403,NULL),(55,'圣戈班研发（上海）有限公司','91310000781504307J',3,73,NULL,1,1661852862107,NULL),(56,'圣戈班高科技材料（上海）有限公司','91310115607302785X',3,73,NULL,1,1661853169344,NULL),(57,'圣戈班陶瓷材料（连云港）有限公司','91320700608395776W',3,46,48,1,1661853214478,NULL),(58,'昆山永新玻璃制品有限公司','91320583608278844R',3,46,48,1,1661853236882,NULL),(59,'圣戈班科技材料（扬州）有限公司','91321091MA1X0K4764',3,46,87,1,1661853269489,1661853444196),(60,'圣戈班石膏建材（常州）有限公司','913204117724751295',3,46,48,1,1661853434125,NULL),(61,'圣戈班杭州汇杰新材料有限公司','91330109MA2CE64G0Q',3,75,76,1,1661853498847,NULL),(62,'圣戈班石膏建材（长兴）有限公司','91330500MA29JQ265E',3,75,76,1,1661853533481,NULL),(63,'圣戈班生物高新材料（杭州）有限公司','91330109744111192J',3,75,76,1,1661853558329,NULL),(64,'圣戈班汇杰（安徽）新材料有限公司','91341004MA2RRY0C3E',3,4,NULL,1,1661853595934,NULL),(65,'圣戈班高新科技材料（葫芦岛）有限公司','912114216961869579',3,91,NULL,1,1661853624993,1661853650818),(66,'北京西普耐火材料有限公司','911100006259021781',3,92,NULL,1,1661853701719,NULL),(67,'圣戈班伟伯（北京）建材有限公司','911100007609029205',3,92,NULL,1,1661853721875,NULL),(68,'青岛圣戈班玻璃有限公司','91370211756902856N',3,63,64,1,1661853745859,NULL),(69,'圣戈班中硝安全玻璃（青岛）有限公司','913702115720994138',3,63,64,1,1661853768558,NULL),(70,'临沂圣戈班耐火材料有限公司','91371300779703673G',3,63,64,1,1661853786554,NULL),(71,'圣戈班（广汉）陶粒有限公司','9151060076232372X1',3,60,61,1,1661853811359,NULL),(72,'圣戈班伟伯（河南）新材料有限公司','91411000MA9GF2K530',3,37,38,1,1661853830934,NULL),(73,'圣戈班磨料磨具（邯郸）有限公司','91130400554452420F',3,33,34,1,1661853857807,NULL),(74,'圣戈班安全玻璃（武汉）有限公司','91420100094280612K',3,28,29,1,1661853905727,NULL),(75,'菲尼克斯（中国）投资有限公司','91320100686703236P',3,46,47,1,1661919199895,NULL),(76,'诺力昂（总部）','\\',3,73,NULL,1,1661919307677,NULL),(77,'诺力昂化学品（宁波）有限公司','91330200668481377X',3,75,86,1,1661919452901,NULL),(78,'诺力昂化学品（嘉兴）有限公司','9133040069361088XQ',3,75,76,1,1661919483385,NULL),(79,'诺力昂氯乙酸化工（泰兴）有限公司','91321283718610115E',3,46,47,1,1661919710896,NULL),(80,'诺力昂化学品（天津）有限公司','91120116734241866X',3,85,NULL,1,1661919735963,NULL),(81,'诺力昂高效化学品（广州）有限公司','91440116783762879C',3,17,18,1,1661919767021,NULL),(82,'诺力昂化学品（博兴）有限公司','913716007207052873',3,63,64,1,1661919790091,NULL),(83,'李尔（中国）投资有限公司','91310000082086150W',3,73,NULL,1,1661919963753,NULL),(84,'SABIC China','\\',3,73,NULL,1,1661920580403,NULL),(85,'特创工程塑料（上海）有限公司','91310000607409777B',3,73,NULL,1,1661920671575,NULL),(86,'SABIC STC-S','\\',3,73,NULL,1,1661920725915,NULL),(87,'SABIC Nansha','\\',3,17,18,1,1661920799898,NULL),(88,'沙伯基础创新塑料（重庆）有限公司','91500000585709145R',3,93,NULL,1,1661920832790,1661920863766),(89,'斯百全化学（上海）有限公司','91310000777627048K',3,73,NULL,1,1661936440974,NULL),(90,'路博润特种化工制造（上海）有限公司','913100007626430964',3,73,NULL,1,1661936961691,NULL),(91,'金陵力联思树脂有限公司','9132010060891461XK',3,46,47,1,1662021019822,NULL),(92,'丹纳赫（上海）企业管理有限公司','913100006607299997',3,73,NULL,1,1665372623454,NULL),(93,'上海世禄仪器有限公司','\\',3,73,NULL,1,1665473448618,NULL),(94,'美迪希实验仪器(上海)有限公司','\\',3,73,NULL,1,1665473470255,NULL),(95,'颇尔（中国）有限公司上海分公司','\\',3,73,NULL,1,1665473480046,NULL),(96,'徕卡显微系统（上海）有限公司','\\',3,73,NULL,1,1665473491478,NULL),(97,'格来赛生命科技（上海）有限公司','\\',3,73,NULL,1,1665473593107,NULL),(98,'颇尔（中国）有限公司','\\',3,92,NULL,1,1665473601903,NULL),(99,'上海爱博才思分析仪器贸易有限公司','\\',3,92,NULL,1,1665473625043,NULL),(100,'颇尔生物科技（北京）有限公司','\\',3,92,NULL,1,1665473639954,NULL),(101,'赛沛（苏州）医疗科技有限公司','\\',3,46,48,1,1665473670533,NULL),(102,'贝克曼库尔特实验系统（苏州）有限公司','\\',3,46,48,1,1665473699057,NULL),(103,'贝克曼库尔特生物科技（苏州）有限公司','\\',3,46,48,1,1665473709772,NULL),(104,'珠海经济特区伟迪捷电子有限公司','\\',3,17,18,1,1665473750605,NULL),(105,'天津博纳艾杰尔科技有限公司','\\',3,85,NULL,1,1665473761570,NULL),(106,'思拓凡生物科技（杭州）有限公司','\\',3,75,76,1,1665473773620,NULL),(107,'安美特（中国）化学有限公司','914401166184784016',3,17,18,1,1673324281637,NULL);
/*!40000 ALTER TABLE `cp_enterprise` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-05-25  7:42:19
