|
1 |
-- Dump File
|
|
2 |
--
|
|
3 |
-- Database is ported from MS Access
|
|
4 |
----------------------------------------------------------
|
|
5 |
-- Program Version 3.0.148
|
|
6 |
|
|
7 |
CREATE DATABASE "cvs-archive-2012-12-04";
|
|
8 |
|
|
9 |
-- NOTICE: At this place you need to connect to the new database and run the rest of the statements.
|
|
10 |
|
|
11 |
--
|
|
12 |
-- Table structure for table 'address'
|
|
13 |
--
|
|
14 |
|
|
15 |
DROP TABLE IF EXISTS "address";
|
|
16 |
|
|
17 |
CREATE TABLE "address" (
|
|
18 |
"ADDRESS_ID" SERIAL NOT NULL,
|
|
19 |
"party_ID" INTEGER NOT NULL,
|
|
20 |
"organization_ID" INTEGER,
|
|
21 |
"orgPosition" VARCHAR(50),
|
|
22 |
"email" VARCHAR(100),
|
|
23 |
"deliveryPoint" VARCHAR(200),
|
|
24 |
"city" VARCHAR(50),
|
|
25 |
"administrativeArea" VARCHAR(50),
|
|
26 |
"postalCode" VARCHAR(10),
|
|
27 |
"country" VARCHAR(50),
|
|
28 |
"currentFlag" BOOLEAN DEFAULT E'0',
|
|
29 |
"addressStartDate" TIMESTAMP,
|
|
30 |
"dba_src_ID" INTEGER,
|
|
31 |
PRIMARY KEY ("ADDRESS_ID")
|
|
32 |
);
|
|
33 |
|
|
34 |
--
|
|
35 |
-- Table structure for table 'archiveLog'
|
|
36 |
--
|
|
37 |
|
|
38 |
DROP TABLE IF EXISTS "archiveLog";
|
|
39 |
|
|
40 |
CREATE TABLE "archiveLog" (
|
|
41 |
"archiveLog_ID" SERIAL NOT NULL,
|
|
42 |
"archiveLogUser" VARCHAR(50),
|
|
43 |
"archiveLogComment" TEXT,
|
|
44 |
"commentDate" TIMESTAMP DEFAULT E'=Now()',
|
|
45 |
PRIMARY KEY ("archiveLog_ID")
|
|
46 |
);
|
|
47 |
|
|
48 |
--
|
|
49 |
-- Table structure for table 'aux_Role'
|
|
50 |
--
|
|
51 |
|
|
52 |
DROP TABLE IF EXISTS "aux_Role";
|
|
53 |
|
|
54 |
CREATE TABLE "aux_Role" (
|
|
55 |
"ROLE_ID" SERIAL NOT NULL,
|
|
56 |
"roleCode" VARCHAR(30) NOT NULL,
|
|
57 |
"roleDescription" VARCHAR(200),
|
|
58 |
"accessionCode" VARCHAR(100),
|
|
59 |
"roleProject" INTEGER,
|
|
60 |
"roleObservation" INTEGER,
|
|
61 |
"roleTaxonInt" INTEGER,
|
|
62 |
"roleClassInt" INTEGER,
|
|
63 |
"dba_src_ID" INTEGER,
|
|
64 |
PRIMARY KEY ("ROLE_ID")
|
|
65 |
);
|
|
66 |
|
|
67 |
--
|
|
68 |
-- Table structure for table 'classContributor'
|
|
69 |
--
|
|
70 |
|
|
71 |
DROP TABLE IF EXISTS "classContributor";
|
|
72 |
|
|
73 |
CREATE TABLE "classContributor" (
|
|
74 |
"CLASSCONTRIBUTOR_ID" SERIAL NOT NULL,
|
|
75 |
"COMMCLASS_ID" INTEGER NOT NULL,
|
|
76 |
"PARTY_ID" INTEGER NOT NULL,
|
|
77 |
"ROLE_ID" INTEGER,
|
|
78 |
"dba_src_ID" INTEGER,
|
|
79 |
PRIMARY KEY ("CLASSCONTRIBUTOR_ID")
|
|
80 |
);
|
|
81 |
|
|
82 |
--
|
|
83 |
-- Table structure for table 'commClass'
|
|
84 |
--
|
|
85 |
|
|
86 |
DROP TABLE IF EXISTS "commClass";
|
|
87 |
|
|
88 |
CREATE TABLE "commClass" (
|
|
89 |
"COMMCLASS_ID" SERIAL NOT NULL,
|
|
90 |
"OBSERVATION_ID" INTEGER NOT NULL,
|
|
91 |
"classStartDate" TIMESTAMP,
|
|
92 |
"classStopDate" TIMESTAMP,
|
|
93 |
"inspection" BOOLEAN DEFAULT E'0',
|
|
94 |
"tableAnalysis" BOOLEAN DEFAULT E'0',
|
|
95 |
"multivariateAnalysis" BOOLEAN DEFAULT E'0',
|
|
96 |
"expertSystem" TEXT,
|
|
97 |
"classPublication_ID" INTEGER,
|
|
98 |
"classNotes" TEXT,
|
|
99 |
"commName" VARCHAR(200),
|
|
100 |
"commCode" VARCHAR(200),
|
|
101 |
"commFramework" VARCHAR(200),
|
|
102 |
"commLevel" VARCHAR(200),
|
|
103 |
"accessionCode" VARCHAR(100),
|
|
104 |
"dba_src_ID" INTEGER,
|
|
105 |
"dba_dataSource" VARCHAR(255),
|
|
106 |
"classStopReason" VARCHAR(255),
|
|
107 |
PRIMARY KEY ("COMMCLASS_ID")
|
|
108 |
);
|
|
109 |
|
|
110 |
--
|
|
111 |
-- Table structure for table 'commConcept'
|
|
112 |
--
|
|
113 |
|
|
114 |
DROP TABLE IF EXISTS "commConcept";
|
|
115 |
|
|
116 |
CREATE TABLE "commConcept" (
|
|
117 |
"COMMCONCEPT_ID" SERIAL NOT NULL,
|
|
118 |
"COMMNAME_ID" INTEGER NOT NULL,
|
|
119 |
"reference_ID" INTEGER,
|
|
120 |
"commDescription" TEXT,
|
|
121 |
"accessionCode" VARCHAR(100),
|
|
122 |
"dba_src_ID" INTEGER,
|
|
123 |
"commName" VARCHAR(255),
|
|
124 |
"referenceText" VARCHAR(255),
|
|
125 |
"scientific" VARCHAR(255),
|
|
126 |
"translated" VARCHAR(255),
|
|
127 |
"code" VARCHAR(255),
|
|
128 |
"originalAuthorCode" VARCHAR(255),
|
|
129 |
"common" VARCHAR(255),
|
|
130 |
"commLevel" VARCHAR(80),
|
|
131 |
"alliance" VARCHAR(255),
|
|
132 |
"includeInPicklistNow" BOOLEAN DEFAULT E'-1',
|
|
133 |
"PhysGroup" VARCHAR(255),
|
|
134 |
"FormGroup" VARCHAR(255),
|
|
135 |
"EcolGroup" VARCHAR(255),
|
|
136 |
"4thApproxName" VARCHAR(255),
|
|
137 |
"NatureServeUID" VARCHAR(255),
|
|
138 |
"classificationSystem" VARCHAR(255),
|
|
139 |
PRIMARY KEY ("COMMCONCEPT_ID"),
|
|
140 |
UNIQUE ("classificationSystem", "code")
|
|
141 |
);
|
|
142 |
|
|
143 |
--
|
|
144 |
-- Table structure for table 'commCorrelation'
|
|
145 |
--
|
|
146 |
|
|
147 |
DROP TABLE IF EXISTS "commCorrelation";
|
|
148 |
|
|
149 |
CREATE TABLE "commCorrelation" (
|
|
150 |
"COMMCORRELATION_ID" SERIAL NOT NULL,
|
|
151 |
"COMMSTATUS_ID" INTEGER NOT NULL,
|
|
152 |
"COMMCONCEPT_ID" INTEGER NOT NULL,
|
|
153 |
"commConvergence" VARCHAR(20) NOT NULL,
|
|
154 |
"correlationStart" TIMESTAMP NOT NULL,
|
|
155 |
"correlationStop" TIMESTAMP,
|
|
156 |
"dba_src_ID" INTEGER,
|
|
157 |
PRIMARY KEY ("COMMCORRELATION_ID")
|
|
158 |
);
|
|
159 |
|
|
160 |
--
|
|
161 |
-- Table structure for table 'commInterpretation'
|
|
162 |
--
|
|
163 |
|
|
164 |
DROP TABLE IF EXISTS "commInterpretation";
|
|
165 |
|
|
166 |
CREATE TABLE "commInterpretation" (
|
|
167 |
"COMMINTERPRETATION_ID" SERIAL NOT NULL,
|
|
168 |
"COMMCLASS_ID" INTEGER NOT NULL,
|
|
169 |
"COMMCONCEPT_ID" INTEGER,
|
|
170 |
"commcode" VARCHAR(34),
|
|
171 |
"commname" VARCHAR(200),
|
|
172 |
"classFit" VARCHAR(50),
|
|
173 |
"classConfidence" VARCHAR(15),
|
|
174 |
"commAuthority_ID" INTEGER,
|
|
175 |
"notes" TEXT,
|
|
176 |
"type" BOOLEAN DEFAULT E'0',
|
|
177 |
"nomenclaturalType" BOOLEAN DEFAULT E'0',
|
|
178 |
"dba_src_ID" INTEGER,
|
|
179 |
"framework_id" INTEGER,
|
|
180 |
"primaryDetermination" BOOLEAN DEFAULT E'0',
|
|
181 |
"primaryDeterminationStatus" INTEGER DEFAULT 0,
|
|
182 |
"primaryComments" TEXT,
|
|
183 |
"primaryStartDate" TIMESTAMP,
|
|
184 |
"primarySTOPDate" TIMESTAMP,
|
|
185 |
"dba_interpretationStatus" VARCHAR(255),
|
|
186 |
"previousFit" VARCHAR(50),
|
|
187 |
"orderDeterminationForEvent" INTEGER,
|
|
188 |
"duplicateDetermination" BOOLEAN DEFAULT E'0',
|
|
189 |
PRIMARY KEY ("COMMINTERPRETATION_ID")
|
|
190 |
);
|
|
191 |
|
|
192 |
--
|
|
193 |
-- Table structure for table 'commLineage'
|
|
194 |
--
|
|
195 |
|
|
196 |
DROP TABLE IF EXISTS "commLineage";
|
|
197 |
|
|
198 |
CREATE TABLE "commLineage" (
|
|
199 |
"COMMLINEAGE_ID" SERIAL NOT NULL,
|
|
200 |
"parentCommStatus_ID" INTEGER NOT NULL,
|
|
201 |
"childCommStatus_ID" INTEGER NOT NULL,
|
|
202 |
"dba_src_ID" INTEGER,
|
|
203 |
PRIMARY KEY ("COMMLINEAGE_ID")
|
|
204 |
);
|
|
205 |
|
|
206 |
--
|
|
207 |
-- Table structure for table 'commName'
|
|
208 |
--
|
|
209 |
|
|
210 |
DROP TABLE IF EXISTS "commName";
|
|
211 |
|
|
212 |
CREATE TABLE "commName" (
|
|
213 |
"COMMNAME_ID" SERIAL NOT NULL,
|
|
214 |
"commName" TEXT NOT NULL,
|
|
215 |
"reference_ID" INTEGER,
|
|
216 |
"dateEntered" TIMESTAMP,
|
|
217 |
"dba_src_ID" INTEGER,
|
|
218 |
PRIMARY KEY ("COMMNAME_ID")
|
|
219 |
);
|
|
220 |
|
|
221 |
--
|
|
222 |
-- Table structure for table 'commStatus'
|
|
223 |
--
|
|
224 |
|
|
225 |
DROP TABLE IF EXISTS "commStatus";
|
|
226 |
|
|
227 |
CREATE TABLE "commStatus" (
|
|
228 |
"COMMSTATUS_ID" SERIAL NOT NULL,
|
|
229 |
"COMMCONCEPT_ID" INTEGER NOT NULL,
|
|
230 |
"reference_ID" INTEGER,
|
|
231 |
"commConceptStatus" VARCHAR(20) NOT NULL,
|
|
232 |
"commParent_ID" INTEGER,
|
|
233 |
"commLevel" VARCHAR(80),
|
|
234 |
"startDate" TIMESTAMP NOT NULL,
|
|
235 |
"stopDate" TIMESTAMP,
|
|
236 |
"commPartyComments" TEXT,
|
|
237 |
"PARTY_ID" INTEGER NOT NULL,
|
|
238 |
"dba_src_ID" INTEGER,
|
|
239 |
"accessionCode" VARCHAR(100),
|
|
240 |
PRIMARY KEY ("COMMSTATUS_ID")
|
|
241 |
);
|
|
242 |
|
|
243 |
--
|
|
244 |
-- Table structure for table 'commUsage'
|
|
245 |
--
|
|
246 |
|
|
247 |
DROP TABLE IF EXISTS "commUsage";
|
|
248 |
|
|
249 |
CREATE TABLE "commUsage" (
|
|
250 |
"COMMUSAGE_ID" SERIAL NOT NULL,
|
|
251 |
"COMMNAME_ID" INTEGER NOT NULL,
|
|
252 |
"commName" TEXT,
|
|
253 |
"COMMCONCEPT_ID" INTEGER,
|
|
254 |
"usageStart" TIMESTAMP,
|
|
255 |
"usageStop" TIMESTAMP,
|
|
256 |
"commNameStatus" VARCHAR(20),
|
|
257 |
"classSystem" VARCHAR(50),
|
|
258 |
"PARTY_ID" INTEGER,
|
|
259 |
"COMMSTATUS_ID" INTEGER,
|
|
260 |
"dba_src_ID" INTEGER,
|
|
261 |
PRIMARY KEY ("COMMUSAGE_ID")
|
|
262 |
);
|
|
263 |
|
|
264 |
--
|
|
265 |
-- Table structure for table 'coverIndex'
|
|
266 |
--
|
|
267 |
|
|
268 |
DROP TABLE IF EXISTS "coverIndex";
|
|
269 |
|
|
270 |
CREATE TABLE "coverIndex" (
|
|
271 |
"COVERINDEX_ID" SERIAL NOT NULL,
|
|
272 |
"COVERMETHOD_ID" INTEGER NOT NULL,
|
|
273 |
"coverCode" VARCHAR(10) NOT NULL,
|
|
274 |
"upperLimit" DOUBLE PRECISION NULL,
|
|
275 |
"lowerLimit" DOUBLE PRECISION NULL,
|
|
276 |
"coverPercent" DOUBLE PRECISION NULL NOT NULL,
|
|
277 |
"indexDescription" TEXT,
|
|
278 |
"dba_src_ID" INTEGER,
|
|
279 |
PRIMARY KEY ("COVERINDEX_ID")
|
|
280 |
);
|
|
281 |
|
|
282 |
--
|
|
283 |
-- Table structure for table 'coverMethod'
|
|
284 |
--
|
|
285 |
|
|
286 |
DROP TABLE IF EXISTS "coverMethod";
|
|
287 |
|
|
288 |
CREATE TABLE "coverMethod" (
|
|
289 |
"COVERMETHOD_ID" SERIAL NOT NULL,
|
|
290 |
"reference_ID" INTEGER,
|
|
291 |
"coverType" VARCHAR(30) NOT NULL,
|
|
292 |
"coverEstimationMethod" VARCHAR(80),
|
|
293 |
"accessionCode" VARCHAR(100),
|
|
294 |
"dba_src_ID" INTEGER,
|
|
295 |
PRIMARY KEY ("COVERMETHOD_ID")
|
|
296 |
);
|
|
297 |
|
|
298 |
--
|
|
299 |
-- Table structure for table 'cust_cvs_SoilDepth'
|
|
300 |
--
|
|
301 |
|
|
302 |
DROP TABLE IF EXISTS "cust_cvs_SoilDepth";
|
|
303 |
|
|
304 |
CREATE TABLE "cust_cvs_SoilDepth" (
|
|
305 |
"DepthID" SERIAL NOT NULL,
|
|
306 |
"observation_ID" INTEGER,
|
|
307 |
"module" VARCHAR(4),
|
|
308 |
"corner" VARCHAR(4),
|
|
309 |
"depth" DOUBLE PRECISION NULL,
|
|
310 |
PRIMARY KEY ("DepthID")
|
|
311 |
);
|
|
312 |
|
|
313 |
--
|
|
314 |
-- Table structure for table 'cvs_taxonAlt_translate'
|
|
315 |
--
|
|
316 |
|
|
317 |
DROP TABLE IF EXISTS "cvs_taxonAlt_translate";
|
|
318 |
|
|
319 |
CREATE TABLE "cvs_taxonAlt_translate" (
|
|
320 |
"CVS_taxonAlt_ID" SERIAL NOT NULL,
|
|
321 |
"SppID" INTEGER,
|
|
322 |
"sciNAmeComplex" VARCHAR(200),
|
|
323 |
"sciNAme" VARCHAR(200),
|
|
324 |
"plantAccessionCode" VARCHAR(80),
|
|
325 |
PRIMARY KEY ("CVS_taxonAlt_ID")
|
|
326 |
);
|
|
327 |
|
|
328 |
--
|
|
329 |
-- Table structure for table 'definedValue'
|
|
330 |
--
|
|
331 |
|
|
332 |
DROP TABLE IF EXISTS "definedValue";
|
|
333 |
|
|
334 |
CREATE TABLE "definedValue" (
|
|
335 |
"DEFINEDVALUE_ID" SERIAL NOT NULL,
|
|
336 |
"USERDEFINED_ID" INTEGER NOT NULL,
|
|
337 |
"tableRecord_ID" INTEGER NOT NULL,
|
|
338 |
"definedValue" TEXT NOT NULL,
|
|
339 |
"dba_src_ID" INTEGER,
|
|
340 |
PRIMARY KEY ("DEFINEDVALUE_ID")
|
|
341 |
);
|
|
342 |
|
|
343 |
--
|
|
344 |
-- Table structure for table 'disturbanceObs'
|
|
345 |
--
|
|
346 |
|
|
347 |
DROP TABLE IF EXISTS "disturbanceObs";
|
|
348 |
|
|
349 |
CREATE TABLE "disturbanceObs" (
|
|
350 |
"disturbanceObs_ID" SERIAL NOT NULL,
|
|
351 |
"OBSERVATION_ID" INTEGER NOT NULL,
|
|
352 |
"disturbanceType" VARCHAR(30) NOT NULL,
|
|
353 |
"disturbanceIntensity" VARCHAR(30),
|
|
354 |
"disturbanceAge" DOUBLE PRECISION NULL,
|
|
355 |
"disturbanceExtent" DOUBLE PRECISION NULL,
|
|
356 |
"disturbanceComment" TEXT,
|
|
357 |
"dba_src_ID" INTEGER,
|
|
358 |
PRIMARY KEY ("disturbanceObs_ID")
|
|
359 |
);
|
|
360 |
|
|
361 |
--
|
|
362 |
-- Table structure for table 'embargo'
|
|
363 |
--
|
|
364 |
|
|
365 |
DROP TABLE IF EXISTS "embargo";
|
|
366 |
|
|
367 |
CREATE TABLE "embargo" (
|
|
368 |
"embargo_ID" SERIAL NOT NULL,
|
|
369 |
"plot_ID" INTEGER NOT NULL,
|
|
370 |
"embargoReason" TEXT NOT NULL,
|
|
371 |
"embargoStart" TIMESTAMP NOT NULL,
|
|
372 |
"embargoStop" TIMESTAMP NOT NULL,
|
|
373 |
"defaultStatus" INTEGER NOT NULL,
|
|
374 |
"dba_src_ID" INTEGER,
|
|
375 |
PRIMARY KEY ("embargo_ID")
|
|
376 |
);
|
|
377 |
|
|
378 |
--
|
|
379 |
-- Table structure for table 'entry_cover'
|
|
380 |
--
|
|
381 |
|
|
382 |
DROP TABLE IF EXISTS "entry_cover";
|
|
383 |
|
|
384 |
CREATE TABLE "entry_cover" (
|
|
385 |
"HerbLineID" SERIAL NOT NULL,
|
|
386 |
"AlternateOrder" DOUBLE PRECISION NULL,
|
|
387 |
"plotID" INTEGER NOT NULL,
|
|
388 |
"NC_Code" INTEGER,
|
|
389 |
"altReference_ID" INTEGER,
|
|
390 |
"unknownSp" VARCHAR(50),
|
|
391 |
"CBS_1" VARCHAR(1),
|
|
392 |
"CBS_2" VARCHAR(1),
|
|
393 |
"CBS_3" VARCHAR(1),
|
|
394 |
"CBS_4" VARCHAR(1),
|
|
395 |
"CBS_5" VARCHAR(1),
|
|
396 |
"CBS_6" VARCHAR(1),
|
|
397 |
"CBS_7" VARCHAR(1),
|
|
398 |
"CBS_8" VARCHAR(1),
|
|
399 |
"CBS_9" VARCHAR(1),
|
|
400 |
"CBS_10" VARCHAR(1),
|
|
401 |
"CBS_11" VARCHAR(1),
|
|
402 |
"CBS_12" VARCHAR(1),
|
|
403 |
"col1" VARCHAR(1),
|
|
404 |
"col2" VARCHAR(1),
|
|
405 |
"col3" VARCHAR(1),
|
|
406 |
"col4" VARCHAR(1),
|
|
407 |
"col5" VARCHAR(1),
|
|
408 |
"col6" VARCHAR(1),
|
|
409 |
"col7" VARCHAR(1),
|
|
410 |
"col8" VARCHAR(1),
|
|
411 |
"col9" VARCHAR(1),
|
|
412 |
"col10" VARCHAR(1),
|
|
413 |
"col11" VARCHAR(1),
|
|
414 |
"col12" VARCHAR(1),
|
|
415 |
"col13" VARCHAR(1),
|
|
416 |
"col14" VARCHAR(1),
|
|
417 |
"col15" VARCHAR(1),
|
|
418 |
"col16" VARCHAR(1),
|
|
419 |
"col17" VARCHAR(1),
|
|
420 |
"col18" VARCHAR(1),
|
|
421 |
"col19" VARCHAR(1),
|
|
422 |
"col20" VARCHAR(1),
|
|
423 |
"avcov" VARCHAR(1),
|
|
424 |
"notes" VARCHAR(255),
|
|
425 |
"errors" TEXT,
|
|
426 |
"NC_Code_History" TEXT,
|
|
427 |
"duplicate" INTEGER DEFAULT 0,
|
|
428 |
"TreeFillin" VARCHAR(50),
|
|
429 |
"userDefined1" VARCHAR(255),
|
|
430 |
"userDefined2" VARCHAR(255),
|
|
431 |
"userDefined3" VARCHAR(255),
|
|
432 |
"userDefined4" VARCHAR(255),
|
|
433 |
"userDefined5" VARCHAR(255),
|
|
434 |
"userDefined6" VARCHAR(255),
|
|
435 |
"userDefined7" VARCHAR(255),
|
|
436 |
"userDefined8" VARCHAR(255),
|
|
437 |
"userDefined9" VARCHAR(255),
|
|
438 |
"userDefined10" VARCHAR(255),
|
|
439 |
"userDefined11" VARCHAR(255),
|
|
440 |
"userDefined12" VARCHAR(255),
|
|
441 |
"userDefined13" VARCHAR(255),
|
|
442 |
"userDefined14" VARCHAR(255),
|
|
443 |
"userDefined15" VARCHAR(255),
|
|
444 |
"userDefined16" VARCHAR(255),
|
|
445 |
"log_createDate" TIMESTAMP DEFAULT E'Now()',
|
|
446 |
"log_createUser" VARCHAR(50),
|
|
447 |
"log_modifiedDate" TIMESTAMP DEFAULT E'Now()',
|
|
448 |
"log_modifiedUser" VARCHAR(50),
|
|
449 |
"collectionFlag" VARCHAR(1),
|
|
450 |
PRIMARY KEY ("HerbLineID")
|
|
451 |
);
|
|
452 |
|
|
453 |
--
|
|
454 |
-- Table structure for table 'entry_plots_cover'
|
|
455 |
--
|
|
456 |
|
|
457 |
DROP TABLE IF EXISTS "entry_plots_cover";
|
|
458 |
|
|
459 |
CREATE TABLE "entry_plots_cover" (
|
|
460 |
"plotID" SERIAL NOT NULL,
|
|
461 |
"project" INTEGER,
|
|
462 |
"team" VARCHAR(6),
|
|
463 |
"plot" VARCHAR(12),
|
|
464 |
"cvs_level" INTEGER,
|
|
465 |
"date" TIMESTAMP,
|
|
466 |
"depth" INTEGER,
|
|
467 |
"Ares_H" DOUBLE PRECISION NULL,
|
|
468 |
"notesPlot" VARCHAR(255),
|
|
469 |
"str1" VARCHAR(10) DEFAULT E'H',
|
|
470 |
"str2" VARCHAR(10) DEFAULT E'S',
|
|
471 |
"str3" VARCHAR(10) DEFAULT E'U',
|
|
472 |
"str4" VARCHAR(10) DEFAULT E'C',
|
|
473 |
"str5" VARCHAR(10) DEFAULT E'E',
|
|
474 |
"str6" VARCHAR(10),
|
|
475 |
"str7" VARCHAR(10),
|
|
476 |
"str8" VARCHAR(10),
|
|
477 |
"str9" VARCHAR(10),
|
|
478 |
"str10" VARCHAR(10),
|
|
479 |
"str11" VARCHAR(10),
|
|
480 |
"str12" VARCHAR(10),
|
|
481 |
"head1" VARCHAR(1),
|
|
482 |
"head2" VARCHAR(1),
|
|
483 |
"head3" VARCHAR(1),
|
|
484 |
"head4" VARCHAR(1),
|
|
485 |
"head5" VARCHAR(1),
|
|
486 |
"head6" VARCHAR(1),
|
|
487 |
"head7" VARCHAR(1),
|
|
488 |
"head8" VARCHAR(1),
|
|
489 |
"head9" VARCHAR(1),
|
|
490 |
"head10" VARCHAR(1),
|
|
491 |
"head11" VARCHAR(1),
|
|
492 |
"head12" VARCHAR(1),
|
|
493 |
"head13" VARCHAR(1),
|
|
494 |
"head14" VARCHAR(1),
|
|
495 |
"head15" VARCHAR(1),
|
|
496 |
"head16" VARCHAR(1),
|
|
497 |
"head17" VARCHAR(1),
|
|
498 |
"head18" VARCHAR(1),
|
|
499 |
"head19" VARCHAR(1),
|
|
500 |
"head20" VARCHAR(1),
|
|
501 |
"headerrors" TEXT,
|
|
502 |
"plotSrc" VARCHAR(50),
|
|
503 |
"log_pcreateDate" TIMESTAMP DEFAULT E'Now()',
|
|
504 |
"log_pcreateUser" VARCHAR(50),
|
|
505 |
"log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()',
|
|
506 |
"log_pmodifiedUser" VARCHAR(50),
|
|
507 |
"vmd_year" INTEGER DEFAULT 0,
|
|
508 |
"cp_entry_plotDone" BOOLEAN DEFAULT E'0',
|
|
509 |
"cp_yearNum" INTEGER,
|
|
510 |
"cp_authorObsCode" VARCHAR(255),
|
|
511 |
PRIMARY KEY ("plotID")
|
|
512 |
);
|
|
513 |
|
|
514 |
--
|
|
515 |
-- Table structure for table 'entry_plots_stems'
|
|
516 |
--
|
|
517 |
|
|
518 |
DROP TABLE IF EXISTS "entry_plots_stems";
|
|
519 |
|
|
520 |
CREATE TABLE "entry_plots_stems" (
|
|
521 |
"plotID" SERIAL NOT NULL,
|
|
522 |
"project" INTEGER,
|
|
523 |
"team" VARCHAR(6),
|
|
524 |
"plot" VARCHAR(12),
|
|
525 |
"cvs_level" INTEGER,
|
|
526 |
"date" TIMESTAMP,
|
|
527 |
"Ares" DOUBLE PRECISION NULL,
|
|
528 |
"PlotSubSeedling" INTEGER,
|
|
529 |
"PlotSubSapling" INTEGER,
|
|
530 |
"PlotSubTree" INTEGER,
|
|
531 |
"SubSamplingNarrative" TEXT,
|
|
532 |
"notesPlot" VARCHAR(255),
|
|
533 |
"notesPlot_indiv" VARCHAR(255),
|
|
534 |
"headerrors" TEXT,
|
|
535 |
"minimumDBH" DOUBLE PRECISION NULL,
|
|
536 |
"minimumdgh" DOUBLE PRECISION NULL,
|
|
537 |
"minimumHt" DOUBLE PRECISION NULL,
|
|
538 |
"AllStemsPlanted" BOOLEAN DEFAULT E'0',
|
|
539 |
"log_pcreateDate" TIMESTAMP DEFAULT E'Now()',
|
|
540 |
"log_pcreateUser" VARCHAR(50),
|
|
541 |
"log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()',
|
|
542 |
"log_pmodifiedUser" VARCHAR(50),
|
|
543 |
"vmd_year" INTEGER DEFAULT 0,
|
|
544 |
"cp_entry_plotDone" BOOLEAN DEFAULT E'0',
|
|
545 |
"cp_yearNum" INTEGER,
|
|
546 |
"cp_authorObsCode" VARCHAR(255),
|
|
547 |
"plotXYReversedOrientation" BOOLEAN DEFAULT E'0',
|
|
548 |
PRIMARY KEY ("plotID")
|
|
549 |
);
|
|
550 |
|
|
551 |
--
|
|
552 |
-- Table structure for table 'entry_stems'
|
|
553 |
--
|
|
554 |
|
|
555 |
DROP TABLE IF EXISTS "entry_stems";
|
|
556 |
|
|
557 |
CREATE TABLE "entry_stems" (
|
|
558 |
"TreeLineID" SERIAL NOT NULL,
|
|
559 |
"AlternateOrder" DOUBLE PRECISION NULL,
|
|
560 |
"plotID" INTEGER NOT NULL,
|
|
561 |
"NC_Code" INTEGER,
|
|
562 |
"altReference_ID" INTEGER,
|
|
563 |
"unknownSp" VARCHAR(50),
|
|
564 |
"Module" VARCHAR(2),
|
|
565 |
"isPlanted" VARCHAR(2),
|
|
566 |
"Subseedling" INTEGER,
|
|
567 |
"CHt_0_50" INTEGER DEFAULT 0,
|
|
568 |
"CHt_50_100" INTEGER DEFAULT 0,
|
|
569 |
"CHt_100_137" INTEGER DEFAULT 0,
|
|
570 |
"SubSapling" INTEGER,
|
|
571 |
"C0_1" INTEGER NOT NULL DEFAULT 0,
|
|
572 |
"C1_2" INTEGER NOT NULL DEFAULT 0,
|
|
573 |
"SubTree" INTEGER,
|
|
574 |
"C2Plus" INTEGER NOT NULL DEFAULT 0,
|
|
575 |
"C5Plus" INTEGER NOT NULL DEFAULT 0,
|
|
576 |
"C10Plus" INTEGER NOT NULL DEFAULT 0,
|
|
577 |
"C15Plus" INTEGER NOT NULL DEFAULT 0,
|
|
578 |
"C20Plus" INTEGER NOT NULL DEFAULT 0,
|
|
579 |
"C25Plus" INTEGER NOT NULL DEFAULT 0,
|
|
580 |
"C30Plus" INTEGER NOT NULL DEFAULT 0,
|
|
581 |
"C35Plus" INTEGER NOT NULL DEFAULT 0,
|
|
582 |
"BigStem1" INTEGER,
|
|
583 |
"BigStem2" INTEGER,
|
|
584 |
"BigStem3" INTEGER,
|
|
585 |
"BigStem4" INTEGER,
|
|
586 |
"BigStem5" INTEGER,
|
|
587 |
"BigStem6" INTEGER,
|
|
588 |
"BigStem7" INTEGER,
|
|
589 |
"BigStem8" INTEGER,
|
|
590 |
"BigStem9" INTEGER,
|
|
591 |
"BigStem10" INTEGER,
|
|
592 |
"BigStem11" INTEGER,
|
|
593 |
"BigStem12" INTEGER,
|
|
594 |
"Notes" VARCHAR(255),
|
|
595 |
"errors" TEXT,
|
|
596 |
"NC_Code_History" TEXT,
|
|
597 |
"duplicate" INTEGER DEFAULT 0,
|
|
598 |
"TreeSummarySamplingCase" DOUBLE PRECISION NULL,
|
|
599 |
"IsIndividualRecord" BOOLEAN DEFAULT E'0',
|
|
600 |
"stemIDCode" VARCHAR(20),
|
|
601 |
"stemSource" VARCHAR(10),
|
|
602 |
"stemHealth" VARCHAR(50),
|
|
603 |
"stemComment" VARCHAR(200),
|
|
604 |
"stemX" DOUBLE PRECISION NULL,
|
|
605 |
"stemY" DOUBLE PRECISION NULL,
|
|
606 |
"dgh" DOUBLE PRECISION NULL,
|
|
607 |
"Height" DOUBLE PRECISION NULL,
|
|
608 |
"DBH" DOUBLE PRECISION NULL,
|
|
609 |
"resprout" BOOLEAN DEFAULT E'0',
|
|
610 |
"userDefined1" VARCHAR(255),
|
|
611 |
"userDefined2" VARCHAR(255),
|
|
612 |
"userDefined3" VARCHAR(255),
|
|
613 |
"userDefined4" VARCHAR(255),
|
|
614 |
"userDefined5" VARCHAR(255),
|
|
615 |
"userDefined6" VARCHAR(255),
|
|
616 |
"userDefined7" VARCHAR(255),
|
|
617 |
"userDefined8" VARCHAR(255),
|
|
618 |
"userDefined9" VARCHAR(255),
|
|
619 |
"userDefined10" VARCHAR(255),
|
|
620 |
"userDefined11" VARCHAR(255),
|
|
621 |
"userDefined12" VARCHAR(255),
|
|
622 |
"userDefined13" VARCHAR(255),
|
|
623 |
"userDefined14" VARCHAR(255),
|
|
624 |
"userDefined15" VARCHAR(255),
|
|
625 |
"userDefined16" VARCHAR(255),
|
|
626 |
"record_src" VARCHAR(50),
|
|
627 |
"log_createDate" TIMESTAMP DEFAULT E'Now()',
|
|
628 |
"log_createUser" VARCHAR(50),
|
|
629 |
"log_modifiedDate" TIMESTAMP DEFAULT E'Now()',
|
|
630 |
"log_modifiedUser" VARCHAR(50),
|
|
631 |
"vmdMapSequence" INTEGER,
|
|
632 |
"vmd_recoverySortOrder" TIMESTAMP,
|
|
633 |
PRIMARY KEY ("TreeLineID")
|
|
634 |
);
|
|
635 |
|
|
636 |
--
|
|
637 |
-- Table structure for table 'fieldList'
|
|
638 |
--
|
|
639 |
|
|
640 |
DROP TABLE IF EXISTS "fieldList";
|
|
641 |
|
|
642 |
CREATE TABLE "fieldList" (
|
|
643 |
"fieldList_ID" SERIAL NOT NULL,
|
|
644 |
"tableName" VARCHAR(50),
|
|
645 |
"fieldName" VARCHAR(50),
|
|
646 |
"listValue" VARCHAR(255),
|
|
647 |
"valueDesc" TEXT,
|
|
648 |
"sortOrd" DOUBLE PRECISION NULL,
|
|
649 |
"entry_displayValue" VARCHAR(255),
|
|
650 |
"entry_description" TEXT,
|
|
651 |
"entry_hideValue" INTEGER,
|
|
652 |
"entry_sortingOrder" DOUBLE PRECISION NULL,
|
|
653 |
"entry_newRecord" BOOLEAN DEFAULT E'0',
|
|
654 |
"entry_obsoleteValue" BOOLEAN DEFAULT E'0',
|
|
655 |
"entry_obsoleteUseInstead" VARCHAR(255),
|
|
656 |
PRIMARY KEY ("fieldList_ID")
|
|
657 |
);
|
|
658 |
|
|
659 |
--
|
|
660 |
-- Table structure for table 'graphic'
|
|
661 |
--
|
|
662 |
|
|
663 |
DROP TABLE IF EXISTS "graphic";
|
|
664 |
|
|
665 |
CREATE TABLE "graphic" (
|
|
666 |
"GRAPHIC_ID" SERIAL NOT NULL,
|
|
667 |
"OBSERVATION_ID" INTEGER NOT NULL,
|
|
668 |
"graphicName" VARCHAR(30),
|
|
669 |
"graphicLocation" TEXT,
|
|
670 |
"graphicDescription" TEXT,
|
|
671 |
"graphicType" VARCHAR(20),
|
|
672 |
"graphicDate" TIMESTAMP,
|
|
673 |
"graphicData" TEXT,
|
|
674 |
"dba_src_ID" INTEGER,
|
|
675 |
"accessionCode" VARCHAR(100),
|
|
676 |
PRIMARY KEY ("GRAPHIC_ID")
|
|
677 |
);
|
|
678 |
|
|
679 |
--
|
|
680 |
-- Table structure for table 'migrationEntity'
|
|
681 |
--
|
|
682 |
|
|
683 |
DROP TABLE IF EXISTS "migrationEntity";
|
|
684 |
|
|
685 |
CREATE TABLE "migrationEntity" (
|
|
686 |
"migrationEntity_ID" SERIAL NOT NULL,
|
|
687 |
"migrationPkg_ID" INTEGER,
|
|
688 |
"tableName" VARCHAR(100),
|
|
689 |
"record_ID" INTEGER,
|
|
690 |
"sourceRecord_ID" INTEGER,
|
|
691 |
"entryDBPath" TEXT,
|
|
692 |
"migrationDBPath" TEXT,
|
|
693 |
PRIMARY KEY ("migrationEntity_ID")
|
|
694 |
);
|
|
695 |
|
|
696 |
--
|
|
697 |
-- Table structure for table 'migrationPackage'
|
|
698 |
--
|
|
699 |
|
|
700 |
DROP TABLE IF EXISTS "migrationPackage";
|
|
701 |
|
|
702 |
CREATE TABLE "migrationPackage" (
|
|
703 |
"migrationPkg_ID" SERIAL NOT NULL,
|
|
704 |
"migrationGUID" VARCHAR(38),
|
|
705 |
"migrationName" VARCHAR(100),
|
|
706 |
"migrationDescription" TEXT,
|
|
707 |
"userName" VARCHAR(50),
|
|
708 |
"archiveFullPath" TEXT,
|
|
709 |
"entryFullPath" TEXT,
|
|
710 |
"migrationDBFullPath" TEXT,
|
|
711 |
"migrationDateStart" TIMESTAMP,
|
|
712 |
"migrationDateEnd" VARCHAR(50),
|
|
713 |
"totalRecordsAdded" INTEGER,
|
|
714 |
"plotsAdded" INTEGER,
|
|
715 |
"observationsAdded" INTEGER,
|
|
716 |
PRIMARY KEY ("migrationPkg_ID")
|
|
717 |
);
|
|
718 |
|
|
719 |
--
|
|
720 |
-- Table structure for table 'namedPlace'
|
|
721 |
--
|
|
722 |
|
|
723 |
DROP TABLE IF EXISTS "namedPlace";
|
|
724 |
|
|
725 |
CREATE TABLE "namedPlace" (
|
|
726 |
"NAMEDPLACE_ID" SERIAL NOT NULL,
|
|
727 |
"placeSystem" VARCHAR(50),
|
|
728 |
"placeName" VARCHAR(100) NOT NULL,
|
|
729 |
"placeDescription" TEXT,
|
|
730 |
"placeCode" VARCHAR(15),
|
|
731 |
"owner" VARCHAR(100),
|
|
732 |
"reference_ID" INTEGER,
|
|
733 |
"accessionCode" VARCHAR(100),
|
|
734 |
"dba_src_ID" INTEGER,
|
|
735 |
PRIMARY KEY ("NAMEDPLACE_ID")
|
|
736 |
);
|
|
737 |
|
|
738 |
--
|
|
739 |
-- Table structure for table 'namedPlaceCorrelation'
|
|
740 |
--
|
|
741 |
|
|
742 |
DROP TABLE IF EXISTS "namedPlaceCorrelation";
|
|
743 |
|
|
744 |
CREATE TABLE "namedPlaceCorrelation" (
|
|
745 |
"NAMEDPLACECORRELATION_ID" SERIAL NOT NULL,
|
|
746 |
"PARENTPLACE_ID" INTEGER NOT NULL,
|
|
747 |
"CHILDPLACE_ID" INTEGER NOT NULL,
|
|
748 |
"placeConvergence" VARCHAR(20) NOT NULL,
|
|
749 |
PRIMARY KEY ("NAMEDPLACECORRELATION_ID")
|
|
750 |
);
|
|
751 |
|
|
752 |
--
|
|
753 |
-- Table structure for table 'note'
|
|
754 |
--
|
|
755 |
|
|
756 |
DROP TABLE IF EXISTS "note";
|
|
757 |
|
|
758 |
CREATE TABLE "note" (
|
|
759 |
"NOTE_ID" SERIAL NOT NULL,
|
|
760 |
"NOTELINK_ID" INTEGER NOT NULL,
|
|
761 |
"PARTY_ID" INTEGER,
|
|
762 |
"ROLE_ID" INTEGER,
|
|
763 |
"noteDate" TIMESTAMP,
|
|
764 |
"noteType" VARCHAR(20) NOT NULL,
|
|
765 |
"noteText" TEXT NOT NULL,
|
|
766 |
"dba_src_ID" INTEGER,
|
|
767 |
"accessionCode" VARCHAR(100),
|
|
768 |
PRIMARY KEY ("NOTE_ID")
|
|
769 |
);
|
|
770 |
|
|
771 |
--
|
|
772 |
-- Table structure for table 'noteLink'
|
|
773 |
--
|
|
774 |
|
|
775 |
DROP TABLE IF EXISTS "noteLink";
|
|
776 |
|
|
777 |
CREATE TABLE "noteLink" (
|
|
778 |
"NOTELINK_ID" SERIAL NOT NULL,
|
|
779 |
"tableName" VARCHAR(50) NOT NULL,
|
|
780 |
"attributeName" VARCHAR(50),
|
|
781 |
"tableRecord" INTEGER NOT NULL,
|
|
782 |
"dba_src_ID" INTEGER,
|
|
783 |
PRIMARY KEY ("NOTELINK_ID")
|
|
784 |
);
|
|
785 |
|
|
786 |
--
|
|
787 |
-- Table structure for table 'observation'
|
|
788 |
--
|
|
789 |
|
|
790 |
DROP TABLE IF EXISTS "observation";
|
|
791 |
|
|
792 |
CREATE TABLE "observation" (
|
|
793 |
"OBSERVATION_ID" SERIAL NOT NULL,
|
|
794 |
"PREVIOUSOBS_ID" INTEGER,
|
|
795 |
"PLOT_ID" INTEGER NOT NULL,
|
|
796 |
"PROJECT_ID" INTEGER,
|
|
797 |
"authorObsCode" VARCHAR(255),
|
|
798 |
"obsStartDate" TIMESTAMP,
|
|
799 |
"obsEndDate" TIMESTAMP,
|
|
800 |
"dateAccuracy" VARCHAR(30),
|
|
801 |
"dateEntered" TIMESTAMP DEFAULT E'=Now()',
|
|
802 |
"COVERMETHOD_ID" INTEGER,
|
|
803 |
"coverDispersion" VARCHAR(30),
|
|
804 |
"autoTaxonCover" BOOLEAN DEFAULT E'0',
|
|
805 |
"STRATUMMETHOD_ID" INTEGER,
|
|
806 |
"methodNarrative" TEXT,
|
|
807 |
"taxonObservationArea" DOUBLE PRECISION NULL,
|
|
808 |
"stemSizeLimit" DOUBLE PRECISION NULL,
|
|
809 |
"stemObservationArea" DOUBLE PRECISION NULL,
|
|
810 |
"stemSampleMethod" VARCHAR(30),
|
|
811 |
"originalData" TEXT,
|
|
812 |
"effortLevel" VARCHAR(30),
|
|
813 |
"plotValidationLevel" INTEGER,
|
|
814 |
"floristicQuality" VARCHAR(30),
|
|
815 |
"bryophyteQuality" VARCHAR(30),
|
|
816 |
"lichenQuality" VARCHAR(30),
|
|
817 |
"observationNarrative" TEXT,
|
|
818 |
"landscapeNarrative" TEXT,
|
|
819 |
"homogeneity" VARCHAR(255),
|
|
820 |
"phenologicAspect" VARCHAR(255),
|
|
821 |
"representativeness" VARCHAR(255),
|
|
822 |
"standMaturity" VARCHAR(255),
|
|
823 |
"successionalStatus" TEXT,
|
|
824 |
"basalArea" DOUBLE PRECISION NULL,
|
|
825 |
"hydrologicRegime" VARCHAR(255),
|
|
826 |
"soilMoistureRegime" VARCHAR(255),
|
|
827 |
"soilDrainage" VARCHAR(255),
|
|
828 |
"waterSalinity" VARCHAR(255),
|
|
829 |
"waterDepth" DOUBLE PRECISION NULL,
|
|
830 |
"shoreDistance" DOUBLE PRECISION NULL,
|
|
831 |
"soilDepth" DOUBLE PRECISION NULL,
|
|
832 |
"organicDepth" DOUBLE PRECISION NULL,
|
|
833 |
"SOILTAXON_ID" INTEGER,
|
|
834 |
"soilTaxonSrc" VARCHAR(200),
|
|
835 |
"soilTaxonComplex" VARCHAR(255),
|
|
836 |
"soilMapUnit" VARCHAR(255),
|
|
837 |
"percentBedRock" DOUBLE PRECISION NULL,
|
|
838 |
"percentRockGravel" DOUBLE PRECISION NULL,
|
|
839 |
"percentWood" DOUBLE PRECISION NULL,
|
|
840 |
"percentLitter" DOUBLE PRECISION NULL,
|
|
841 |
"percentBareSoil" DOUBLE PRECISION NULL,
|
|
842 |
"percentWater" DOUBLE PRECISION NULL,
|
|
843 |
"percentOther" DOUBLE PRECISION NULL,
|
|
844 |
"nameOther" VARCHAR(30),
|
|
845 |
"treeHt" DOUBLE PRECISION NULL,
|
|
846 |
"shrubHt" DOUBLE PRECISION NULL,
|
|
847 |
"fieldHt" DOUBLE PRECISION NULL,
|
|
848 |
"nonvascularHt" DOUBLE PRECISION NULL,
|
|
849 |
"submergedHt" DOUBLE PRECISION NULL,
|
|
850 |
"treeCover" DOUBLE PRECISION NULL,
|
|
851 |
"shrubCover" DOUBLE PRECISION NULL,
|
|
852 |
"fieldCover" DOUBLE PRECISION NULL,
|
|
853 |
"nonvascularCover" DOUBLE PRECISION NULL,
|
|
854 |
"floatingCover" DOUBLE PRECISION NULL,
|
|
855 |
"submergedCover" DOUBLE PRECISION NULL,
|
|
856 |
"dominantStratum" VARCHAR(40),
|
|
857 |
"growthform1Type" VARCHAR(40),
|
|
858 |
"growthform2Type" VARCHAR(40),
|
|
859 |
"growthform3Type" VARCHAR(40),
|
|
860 |
"growthform1Cover" DOUBLE PRECISION NULL,
|
|
861 |
"growthform2Cover" DOUBLE PRECISION NULL,
|
|
862 |
"growthform3Cover" DOUBLE PRECISION NULL,
|
|
863 |
"totalCover" DOUBLE PRECISION NULL,
|
|
864 |
"accessionCode" VARCHAR(100),
|
|
865 |
"notesPublic" BOOLEAN DEFAULT E'0',
|
|
866 |
"notesMgt" BOOLEAN DEFAULT E'0',
|
|
867 |
"revisions" BOOLEAN DEFAULT E'0',
|
|
868 |
"cust_cvs_CowardinSystem" VARCHAR(100),
|
|
869 |
"cust_cvs_mcnab_LFI_asp" DOUBLE PRECISION NULL,
|
|
870 |
"cust_cvs_mcnab_LFI_45" DOUBLE PRECISION NULL,
|
|
871 |
"cust_cvs_mcnab_LFI_90" DOUBLE PRECISION NULL,
|
|
872 |
"cust_cvs_mcnab_LFI_135" DOUBLE PRECISION NULL,
|
|
873 |
"cust_cvs_mcnab_LFI_180" DOUBLE PRECISION NULL,
|
|
874 |
"cust_cvs_mcnab_LFI_225" DOUBLE PRECISION NULL,
|
|
875 |
"cust_cvs_mcnab_LFI_270" DOUBLE PRECISION NULL,
|
|
876 |
"cust_cvs_mcnab_LFI_315" DOUBLE PRECISION NULL,
|
|
877 |
"cust_cvs_mcnab_TSI_asp" DOUBLE PRECISION NULL,
|
|
878 |
"cust_cvs_mcnab_TSI_45" DOUBLE PRECISION NULL,
|
|
879 |
"cust_cvs_mcnab_TSI_90" DOUBLE PRECISION NULL,
|
|
880 |
"cust_cvs_mcnab_TSI_135" DOUBLE PRECISION NULL,
|
|
881 |
"cust_cvs_mcnab_TSI_180" DOUBLE PRECISION NULL,
|
|
882 |
"cust_cvs_mcnab_TSI_225" DOUBLE PRECISION NULL,
|
|
883 |
"cust_cvs_mcnab_TSI_270" DOUBLE PRECISION NULL,
|
input.Makefile: SVN: add: Add a Source table to store datasource metadata. This adds a Source table to all herbaria which are listed in .herbaria, and therefore didn't previously need a Source table to indicate their referenceType and sampleType.