Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Newer
Older
100644 192 lines (168 sloc) 5.375 kb
083dd1d table descriptions by mysql
bosborne authored
1 ANALYSIS
2 Field Type Null Key Default Extra
3 analysis_id int(10) unsigned PRI NULL auto_increment
4 created datetime 0000-00-00 00:00:00
5 logic_name varchar(40)
6 runnable varchar(80) YES NULL
7 db varchar(120) YES NULL
8 db_version varchar(40) YES NULL
9 db_file varchar(120) YES NULL
10 program varchar(80) YES NULL
11 program_version varchar(40) YES NULL
12 program_file varchar(80) YES NULL
13 data_monger_id int(10) unsigned YES 0
14 runnable_parameters varchar(255) YES NULL
15 analysis_parameters varchar(255) YES NULL
16 gff_source varchar(40) YES NULL
17 gff_feature varchar(40) YES NULL
18 node_group_id int(10) unsigned 0
19
20 ANALYSIS_IOHANDLER
21 Field Type Null Key Default Extra
22 analysis_id int(10) MUL 0
23 iohandler_id int(10) 0
24 converter_id int(10) YES NULL
25 converter_rank int(2) YES NULL
26
27 ARGUMENT
28 Field Type Null Key Default Extra
29 argument_id int(10) unsigned PRI NULL auto_increment
30 datahandler_id int(10) unsigned 0
31 tag varchar(40) YES
32 value varchar(255) YES
33 rank int(10) 1
34 type enum('SCALAR','ARRAY') SCALAR
35
36 COMPLETED_JOBS
37 Field Type Null Key Default Extra
38 completed_job_id int(10) unsigned PRI NULL auto_increment
39 process_id varchar(100) NEW
40 analysis_id int(10) unsigned YES MUL 0
41 queue_id int(10) unsigned YES 0
42 stdout_file varchar(100)
43 stderr_file varchar(100)
44 object_file varchar(100)
45 time datetime 0000-00-00 00:00:00
46 retry_count int(11) YES 0
47
48 CONVERTER_ARGUMENTS
49 Field Type Null Key Default Extra
50 converter_argument_id int(10) unsigned PRI NULL auto_increment
51 converter_method_id int(10) unsigned 0
52 tag varchar(40) YES NULL
53 value varchar(40)
54 rank int(2) unsigned YES NULL
55
56 CONVERTER_METHODS
57 Field Type Null Key Default Extra
58 converter_method_id int(10) unsigned PRI NULL auto_increment
59 converter_id int(10) unsigned 0
60 name varchar(40)
61 rank int(2) YES NULL
62
63 CONVERTERS
64 Field Type Null Key Default Extra
65 converter_id int(10) unsigned PRI NULL auto_increment
66 module varchar(255)
67
68 DATAHANDLER
69 Field Type Null Key Default Extra
70 datahandler_id int(10) unsigned PRI NULL auto_increment
71 iohandler_id int(10) MUL 0
72 method varchar(60)
73 rank int(10) 1
74
75 DBADAPTOR
76 Field Type Null Key Default Extra
77 dbadaptor_id int(10) unsigned PRI NULL auto_increment
78 dbname varchar(40)
79 driver varchar(40)
80 host varchar(40) YES
81 port int(10) unsigned YES 0
82 user varchar(40) YES
83 pass varchar(40) YES
84 module varchar(100) YES
85
86 DYNAMIC_ARGUMENT
87 Field Type Null Key Default Extra
88 input_id int(10) unsigned PRI 0
89 datahandler_id int(10) unsigned PRI 0
90 tag varchar(40) YES
91 value varchar(40) YES
92 rank int(10) PRI 1
93 type enum('SCALAR','ARRAY') SCALAR
94
95 FILTER
96 Field Type Null Key Default Extra
97 filter_id int(10) unsigned PRI NULL auto_increment
98 data_monger_id int(10) unsigned 0
99 module varchar(40) YES
100 rank int(10) 1
101
102 FILTER_ARGUMENT
103 Field Type Null Key Default Extra
104 filter_argument_id int(10) unsigned PRI NULL auto_increment
105 filter_id int(10) unsigned 0
106 tag varchar(40) YES
107 value varchar(255) YES
108
109 INPUT
110 Field Type Null Key Default Extra
111 input_id int(10) unsigned PRI NULL auto_increment
112 name varchar(255)
113 tag varchar(40) YES
114 job_id int(10) unsigned MUL 0
115 iohandler_id int(10) unsigned YES MUL NULL
116
117 INPUT_CREATE
118 Field Type Null Key Default Extra
119 input_create_id int(10) unsigned PRI NULL auto_increment
120 data_monger_id int(10) unsigned 0
121 module varchar(40)
122 rank int(10) 1
123
124 INPUT_CREATE_ARGUMENT
125 Field Type Null Key Default Extra
126 input_create_argument_id int(10) unsigned PRI NULL auto_increment
127 input_create_id int(10) unsigned 0
128 tag varchar(40) YES
129 value varchar(255) YES
130
131 IOHANDLER
132 Field Type Null Key Default Extra
133 iohandler_id int(10) unsigned PRI NULL auto_increment
134 adaptor_id int(10) MUL 0
135 type enum('INPUT','CREATE_INPUT','OUTPUT','NEW_INPUT') INPUT
136 adaptor_type enum('DB','STREAM') DB
137
138 IOHANDLER_MAP
139 Field Type Null Key Default Extra
140 prev_iohandler_id int(10) PRI 0
141 analysis_id int(10) PRI 0
142 map_iohandler_id int(10) 0
143
144 JOB
145 Field Type Null Key Default Extra
146 job_id int(10) unsigned PRI NULL auto_increment
147 process_id varchar(100) MUL NEW
148 analysis_id int(10) unsigned YES MUL 0
149 queue_id int(10) unsigned YES 0
150 stdout_file varchar(100) YES
151 stderr_file varchar(100) YES
152 object_file varchar(100) YES
153 status varchar(20) NEW
154 stage varchar(20) YES
155 time datetime 0000-00-00 00:00:00
156 retry_count int(11) YES 0
157
158 NEW_INPUT
159 Field Type Null Key Default Extra
160 input_id int(10) unsigned PRI NULL auto_increment
161 job_id int(10) unsigned 0
162 name varchar(40)
163
164 NODE
165 Field Type Null Key Default Extra
166 node_id int(10) unsigned PRI NULL auto_increment
167 node_name varchar(40)
168 group_id int(10) unsigned PRI 0
169
170 NODE_GROUP
171 Field Type Null Key Default Extra
172 node_group_id int(10) unsigned PRI NULL auto_increment
173 name varchar(40) MUL
174 description varchar(255)
175
176 OUTPUT
177 Field Type Null Key Default Extra
178 job_id int(10) unsigned PRI 0
179 output_name varchar(40) PRI
180
181 RULE
182 Field Type Null Key Default Extra
183 rule_id int(10) unsigned PRI NULL auto_increment
184 current int(10) unsigned YES 0
185 next int(10) unsigned 0
186 action enum('WAITFORALL','WAITFORALL_AND_UPDATE','UPDATE','NOTHING','COPY_INPUT','COPY_ID','CREATE_INPUT','COPY_ID_FILE') YES NULL
187
188 STREAMADAPTOR
189 Field Type Null Key Default Extra
190 streamadaptor_id int(10) unsigned PRI NULL auto_increment
191 module varchar(40)
Something went wrong with that request. Please try again.