Conference Corpus Query Event_crossref Schema
# |
cid |
name |
type |
notnull |
dflt_value |
pk |
1 |
0 |
sponsor |
TEXT |
0 |
|
0 |
2 |
1 |
acronym |
TEXT |
0 |
|
0 |
3 |
2 |
name |
TEXT |
0 |
|
0 |
4 |
3 |
location |
TEXT |
0 |
|
0 |
5 |
4 |
source |
TEXT |
0 |
|
0 |
6 |
5 |
title |
TEXT |
0 |
|
0 |
7 |
6 |
ordinal |
INTEGER |
0 |
|
0 |
8 |
7 |
eventId |
TEXT |
0 |
|
0 |
9 |
8 |
doi |
TEXT |
0 |
|
0 |
10 |
9 |
lookupAcronym |
TEXT |
0 |
|
0 |
11 |
10 |
url |
TEXT |
0 |
|
0 |
12 |
11 |
city |
TEXT |
0 |
|
0 |
13 |
12 |
cityWikidataid |
TEXT |
0 |
|
0 |
14 |
13 |
region |
TEXT |
0 |
|
0 |
15 |
14 |
regionIso |
TEXT |
0 |
|
0 |
16 |
15 |
regionWikidataid |
TEXT |
0 |
|
0 |
17 |
16 |
country |
TEXT |
0 |
|
0 |
18 |
17 |
countryIso |
TEXT |
0 |
|
0 |
19 |
18 |
countryWikidataid |
TEXT |
0 |
|
0 |
20 |
19 |
startDate |
DATE |
0 |
|
0 |
21 |
20 |
year |
INTEGER |
0 |
|
0 |
22 |
21 |
month |
INTEGER |
0 |
|
0 |
23 |
22 |
endDate |
DATE |
0 |
|
0 |
24 |
23 |
number |
TEXT |
0 |
|
0 |
25 |
24 |
theme |
TEXT |
0 |
|
0 |