lake/ip_company_logo.md

+# 企业logo
+
+# 存储信息
+    aliyun-mysql-rds
+
+* host: bdp-rds-003.mysql.rds.aliyuncs.com
+* port: 3306
+* user: **
+* password: **
+* database: utn_ng_biz_info
+
+# 建表语句
+
+```sql
+CREATE TABLE `company_logo` (
+  `id` int(10) NOT NULL AUTO_INCREMENT,
+  `company_name` varchar(255) NOT NULL COMMENT '公司名',
+  `logo_address` varchar(255) NOT NULL COMMENT 'logo在oss上的地址',
+  `logo_address_out` varchar(255) DEFAULT NULL COMMENT 'logo在oss上的另一个无水印地址',
+  `source` varchar(10) NOT NULL COMMENT 'logo来源 可以是 lagou liepin 等',
+  `source_url` varchar(300) NOT NULL,
+  `crawled_time` datetime DEFAULT NULL COMMENT 'logo抓取的时间',
+  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  `deleted` int(2) DEFAULT '0',
+  `company_name_digest` char(32) DEFAULT NULL COMMENT '对应主体唯一键',
+  `shuidi_logo_url` varchar(300) DEFAULT NULL,
+  `company_id` char(32) DEFAULT NULL COMMENT '对应主体唯一键',
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `company_name` (`company_name`),
+  KEY `index_name` (`company_name`),
+  KEY `index_source` (`source`),
+  KEY `idx_digest` (`company_name_digest`)
+) ENGINE=InnoDB AUTO_INCREMENT=6539321 DEFAULT CHARSET=utf8;
+```
+
+# 数据字典
+
+| 表名 | 字段名 | 字段类型 | 注释 |
+| ------ | ------ | ------ | ------ |
+| | id | int(10) | 自增主键 |
+| | company_name | varchar(255) | 企业名称 |
+| | logo_address | varchar(255) | logo在oss上的地址（无用）|
+| | logo_address_out | varchar(255) | logo在oss上的另一个无水印地址（无用）|
+| | source | varchar(10) | logo来源 可以是 lagou liepin 等 |
+| company_logo | source_url | varchar(300) | |
+| | crawled_time | datetime | logo抓取的时间 |
+| | update_time | timestamp | 更新时间 |
+| | deleted | int(2) | 是否删除，0有效，1删除 |
+| | company_name_digest | char(32) | 主体唯一键 |
+| | shuidi_logo_url | varchar(300) | 水滴logo存储地址 |
+| | company_id | char(32) | 主体唯一键（对外） |
+
+
+# 说明
+
+* 水滴logo图片获取方法： https://filecdn.shuidi.cn/img/upload/images_{shuidi_logo_url}/0x0.jpg, 样例： https://filecdn.shuidi.cn/img/upload/images_logo/c5/96/82/c59682c4e425b73a9c6c6664a9017051.png/0x0.jpg
+
+# 数据样例
+
+| id | company_name | logo_address | logo_address_out | source | source_url | crawled_time | update_time | deleted | company_name_digest | shuidi_logo_url | company_id |
+| ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | 
+| 28 | 北斗航天卫星应用科技集团有限公司 | logo/lll/822bfdf7feab3ccf0823257e0e31b37d.png | api/6fd514de0e0983c8ffc451a200056001.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/00/60/CgYXBlTUXU2AR1rbAACRvQfgMrs893.png | 2017-03-08 00:00:00 | 2021-02-23 00:00:00 | 0 | d18d4d2c67d4dd6c1c0ceb495f0f1253 | logo/b9/04/ea/b904eaa65072371cffa4cab0bdd22798.png | 48c84acef105f50ee27d46d34548e54f |
+| 29 | 北京龙源创新信息技术有限公司 | logo/lll/366fb4b0f6a4fd0992e7c39bd33265e0.png | api/412d2754c570e89259e2f2a0523d67d8.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/00/43/Cgo8PFTUXNKACoj7AAB2VQUVlGU393.jpg | 2017-03-08 20:28:58 | 2019-05-15 23:10:31 | 0 | 3a0134c582293a5000d138e17ab432ed | logo/ff/0a/d6/ff0ad6f7bdfd485340e9cda3481e17bf.png | 7a877002c0295717b17ad6eb54f2a4b4 |
+| 30 | 北京麒麟网文化股份有限公司 | logo/lll/5a9ae5a049599e5b0d5d4a7dac34ea49.png | api/a970f402877cd59a6ea79438de0129e4.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/40/B5/CgYXBlXEfuCAGh6wAAAMnCAKug4463.png?cc=0.3379634872544557 | 2017-03-08 20:31:10 | 2019-05-15 23:10:31 | 0 | c6bb937c0d71bc730daf6d069a545628 | logo/c3/03/ba/c303ba496f142098b8d79b4f6721ef2c.png | 3520f72f0d4337b7d735fa4659799d63 |
+| 31 | 北京鸿蒙网科技有限公司 | logo/lll/e7e9977c86f226e07fd89a701879dada.png | api/b24713e1c09f5c48f7d7f676c87080fd.png | lagou | www.lgstatic.com/thumbnail_160x160/image2/M00/0A/7B/CgpzWlYV2hGACfFeAAAX1JjcFrw768.png | 2017-03-08 20:31:38 | 2019-05-15 23:10:32 | 0 | 4108d534e14f14b496475397e66a544b | logo/30/1c/ef/301cef083b176f5f10f1afab44da8de2.png | 0fbbdcb19b2fa7e93ca35b8552eeb684 |
+| 32 | 北京高阳捷迅信息技术有限公司 | logo/lll/abf23a18380c6d6212d70c794c67b0c5.png | api/56b5c96e3f3d3564ed6ab0dd08e337b9.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/00/03/CgYXBlTUV_yAcLJxAAAXFAVAf_U965.JPG | 2017-03-08 20:37:49 | 2019-05-15 23:10:32 | 0 | 0ffdcc4ec8ad0dd6e6ab9de8aa6425ee | logo/4b/04/04/4b040457b685860685a319a0edab1f8f.png | 0e65848fe3d476549246066e6746cc88 |
+| 33 | 北京随锐科技有限公司 | logo/lll/c3213f16f39ede1809631e4ca41335db.png | api/b0238d31ba9262a5399e19aa7b3f4401.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/00/06/CgYXBlTUWAaATjUMAABqmbOFQew374.jpg | 2017-03-08 20:39:43 | 2019-05-15 23:10:32 | 0 | 1ef0f68cc2cfc75e94b20915a772f1da | logo/9d/bb/1d/9dbb1d528859bbb89ef290488592680f.png | 449bfd41b505caf5bfe5af955cafeec3 |
+| 34 | 北京非凡伟业科技发展有限公司 | logo/lll/b9b40a4fed5131d9248864f50131233d.png | api/b4be605cfc217eec80ca00cbe6067644.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/00/66/Cgo8PFTUXWeATpAxAABXWBLmqcA860.jpg | 2017-03-08 20:39:46 | 2019-05-15 23:10:32 | 0 | efd576f389facb34ec740bcaaaa73042 | logo/cb/97/6f/cb976f6ab7be3832cb505eb4777f014d.png | afb2d03b7e23317f7b0fdddfa48ed7db |
+| 35 | 北京雄鹰教育科技有限公司 | logo/lll/196f95ce12c1dfdeeebb4c7daad4c9a7.png | api/d864f28778c412f8548930e7df79296d.png | lagou | www.lgstatic.com/thumbnail_160x160/i/image/M00/24/2E/Cgp3O1cZt7OAMbPiAAAL3I-dHfw256.jpg | 2017-03-08 20:39:49 | 2019-05-15 23:10:32 | 0 | b9c170b75a4703a5d04d2ce0de9f9aa4 | logo/5b/1a/da/5b1ada145f1a71a4d4565ea71711306d.png | 25e5bec0d8296a0bed993d29e34bc72d |
+| 36 | 北京阳光印易科技有限公司 | logo/lll/83e1e59f4aad081b030f42dad75d023c.png | api/89f9ec161f2dcf421a05375d369bc2c9.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/0E/09/CgYXBlT5TmqAQC9gAABkMLhR-P8055.jpg | 2017-03-08 20:39:50 | 2019-05-15 23:10:32 | 0 | 7c0edfb8f4f691cc9e101fd8c5b73745 | logo/f3/b9/a1/f3b9a1c500a680f73f3b68e94b8dffc6.png | bf719f559810e5e6d7f335f4f1fc8487 |
+| 37 | 北京远宽通信技术有限公司 | logo/lll/10111d65450ad00ae5d3a7a4593e3c17.png | api/30b6c2f1ae500a4ea760147ac4813c4f.png | lagou | www.lgstatic.com/thumbnail_160x160/image1/M00/00/3C/Cgo8PFTUXLWAYZQPAACoS49m8zI255.png | 2017-03-08 20:40:00 | 2019-05-15 23:10:32 | 0 | 739654d7567d4362bd14256634468dd5 | logo/83/37/21/83372186f52d24f5531c431ed9f400ad.png | 9475f6880d6c374ec6dc96e6471b2e8f |
\ No newline at end of file