Skip to content

GitLab

Last edited by songzp
Page history

ip_company_logo

企业logo

存储信息

aliyun-mysql-rds
  • host: bdp-rds-003.mysql.rds.aliyuncs.com
  • port: 3306
  • user: **
  • password: **
  • database: utn_ng_biz_info

建表语句

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) 主体唯一键（对外）

说明

数据样例

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