SHOW:
|
|
- or go back to the newest paste.
1 | CREATE TABLE "Documents" ( | |
2 | id INTEGER PRIMARY KEY AUTOINCREMENT, | |
3 | added INT, | |
4 | chapter VARCHAR, | |
5 | citationKey VARCHAR, | |
6 | city VARCHAR, | |
7 | confirmed INT, | |
8 | deletionPending INT, | |
9 | doi VARCHAR, | |
10 | edition VARCHAR, | |
11 | importer INT, | |
12 | institution VARCHAR, | |
13 | isbn VARCHAR, | |
14 | issn VARCHAR, | |
15 | issue VARCHAR, | |
16 | MONTH INT, | |
17 | note VARCHAR, | |
18 | onlyReference INT, | |
19 | originalPublication VARCHAR, | |
20 | pages VARCHAR, | |
21 | privacy INT, | |
22 | publication VARCHAR, | |
23 | publisher VARCHAR, | |
24 | reprintEdition VARCHAR, | |
25 | revisionNumber VARCHAR, | |
26 | series VARCHAR, | |
27 | shortTitle VARCHAR, | |
28 | sourceType VARCHAR, | |
29 | title VARCHAR, | |
30 | TYPE VARCHAR, | |
31 | uuid VARCHAR UNIQUE NOT NULL, | |
32 | volume VARCHAR, | |
33 | YEAR INT, | |
34 | favourite INT, | |
35 | READ INT, | |
36 | abstract VARCHAR, | |
37 | modified INT, | |
38 | advisor VARCHAR, | |
39 | articleColumn VARCHAR, | |
40 | applicationNumber VARCHAR, | |
41 | arxivId VARCHAR, | |
42 | code VARCHAR, | |
43 | codeNumber VARCHAR, | |
44 | codeSection VARCHAR, | |
45 | codeVolume VARCHAR, | |
46 | committee VARCHAR, | |
47 | counsel VARCHAR, | |
48 | country VARCHAR, | |
49 | dateAccessed VARCHAR, | |
50 | department VARCHAR, | |
51 | genre VARCHAR, | |
52 | internationalAuthor VARCHAR, | |
53 | internationalNumber VARCHAR, | |
54 | internationalTitle VARCHAR, | |
55 | internationalUserType VARCHAR, | |
56 | LANGUAGE VARCHAR, | |
57 | lastUpdate VARCHAR, | |
58 | legalStatus VARCHAR, | |
59 | LENGTH VARCHAR, | |
60 | medium VARCHAR, | |
61 | OWNER VARCHAR, | |
62 | pmid BIGINT, | |
63 | publicLawNumber VARCHAR, | |
64 | reviewedArticle VARCHAR, | |
65 | sections VARCHAR, | |
66 | seriesEditor VARCHAR, | |
67 | seriesNumber VARCHAR, | |
68 | SESSION VARCHAR, | |
69 | userType VARCHAR, | |
70 | DAY INT, | |
71 | hideFromMendeleyWebIndex INT, | |
72 | deduplicated INT | |
73 | ); |