jA8AChrU

1CREATE DATABASE IF NOT EXISTS `knowledge_graph` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE knowledge_graph;
3CREATE TABLE IF NOT EXISTS company (
4                      id varchar(20) PRIMARY KEY,
5                      label varchar(20),
6                      create_time datetime,
7                      update_time datetime,
8                      industry varchar(20),
9                      first_register_addr varchar(100),
10                      security_short_name varchar(20),
11                      legal_entity varchar(20),
12                      manager varchar(20),
13                      code int NOT NULL UNIQUE KEY,
14                      company_address varchar(100),
15                      register_number varchar(50),
16                      zipcode varchar(20),
17                      company_name varchar(100))
18                      DEFAULT CHARSET=utf8;
19CREATE TABLE IF NOT EXISTS management (
20                      company_id varchar(20) NOT NULL,
21                      title varchar(50),
22                      person_id varchar(20) NOT NULL,
23                      type varchar(20) NOT NULL,
24                      create_time datetime,
25                      update_time datetime,
26                      UNIQUE KEY (person_id, company_id))
27                      DEFAULT CHARSET=utf8;
28CREATE TABLE IF NOT EXISTS spo (
29                      subj varchar(100),
30                      pred varchar(100),
31                      obj varchar(500),
32                      type varchar(20),
33                      create_time datetime,
34		              update_time datetime,
35                      UNIQUE KEY (subj, pred, obj))
36                      DEFAULT CHARSET=utf8;
37 CREATE TABLE IF NOT EXISTS person (
38                      id varchar(20) PRIMARY KEY,
39                      label varchar(20),
40                      create_time datetime,
41                      update_time datetime,
42                      education varchar(50),
43                      birth varchar(20),
44                      name varchar(20),
45                      sex varchar(20),
46                      UNIQUE KEY (birth, sex, name))
47                      DEFAULT CHARSET=utf8;
48
49
50LOAD DATA LOCAL INFILE 'company_node.txt' INTO TABLE company CHARACTER SET utf8 FIELDS TERMINATED BY '\t' IGNORE 1 LINES;
51LOAD DATA LOCAL INFILE 'person_node.txt' INTO TABLE person CHARACTER SET utf8 FIELDS TERMINATED BY '\t' IGNORE 1 LINES;
52LOAD DATA LOCAL INFILE 'management_edge.txt' INTO TABLE management CHARACTER SET utf8 FIELDS TERMINATED BY '\t' IGNORE 1 LINES;
53LOAD DATA LOCAL INFILE 'spo.txt' INTO TABLE spo CHARACTER SET utf8 FIELDS TERMINATED BY '\t' IGNORE 1 LINES;