ChatDB_Magic/table_schema.py at main · dst1213/ChatDB_Magic · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
achievements = """
CREATE TABLE achievements (
	id INTEGER NOT NULL,
	doctor_id VARCHAR,
	type VARCHAR,
	info VARCHAR,
	time VARCHAR,
	PRIMARY KEY (id)
);
"""

doctor = """
CREATE TABLE doctor (
	id INTEGER NOT NULL,
	doctor_id VARCHAR,
	name VARCHAR,
	english_name VARCHAR,
	email VARCHAR,
	sex VARCHAR,
	title VARCHAR,
	position VARCHAR,
	contact VARCHAR,
	biography VARCHAR,
	expertise VARCHAR,
	visit_time VARCHAR,
	qualification VARCHAR,
	insurance VARCHAR,
	language VARCHAR,
	PRIMARY KEY (id)
);
"""
publications = """
CREATE TABLE publications (
	id INTEGER NOT NULL,
	doctor_id VARCHAR,
	type VARCHAR,
	info VARCHAR,
	time VARCHAR,
	PRIMARY KEY (id)
);
"""

clinical_trials_detail = """
CREATE TABLE clinical_trials_detail (
	id INTEGER NOT NULL,
	doctor_id VARCHAR,
	nct_no VARCHAR,
	brief_title VARCHAR,
	inclusion_criteria VARCHAR,
	exclusion_criteria VARCHAR,
	PRIMARY KEY (id)
);
"""

medical_research = """
CREATE TABLE medical_research (
	id INTEGER NOT NULL,
	doctor_id VARCHAR,
	type VARCHAR,
	info VARCHAR,
	time VARCHAR,
	PRIMARY KEY (id)
);
"""

personal_experience = """
CREATE TABLE personal_experience (
	id INTEGER NOT NULL,
	doctor_id VARCHAR,
	type VARCHAR,
	info VARCHAR,
	time VARCHAR,
	PRIMARY KEY (id)
);
"""

pubmed_detail = """
CREATE TABLE pubmed_detail (
	id INTEGER NOT NULL,
	doctor_id VARCHAR,
	pid VARCHAR,
	title VARCHAR,
	PRIMARY KEY (id)
);
"""

tables = [doctor, publications, achievements,clinical_trials_detail,medical_research,personal_experience,pubmed_detail]