1
|
/**
|
2
|
* Copyright (C) 2017 EDIT
|
3
|
* European Distributed Institute of Taxonomy
|
4
|
* http://www.e-taxonomy.eu
|
5
|
*
|
6
|
* The contents of this file are subject to the Mozilla Public License Version 1.1
|
7
|
* See LICENSE.TXT at the top of this package for the full license terms.
|
8
|
*/
|
9
|
package eu.etaxonomy.cdm.io.cdmLight;
|
10
|
|
11
|
/**
|
12
|
* An enumeration with each instance representing a table type in the Output Model.
|
13
|
*
|
14
|
* @author a.mueller
|
15
|
* @since 15.03.2017
|
16
|
*/
|
17
|
public enum CdmLightExportTable {
|
18
|
METADATA("Metadata", metaDataColumns()),
|
19
|
SCIENTIFIC_NAME("ScientificName", nameColumns()),
|
20
|
NAME_RELATIONSHIP("NameRelationship",nameRelationColumns()),
|
21
|
HOMOTYPIC_GROUP("HomotypicGroup", homotypicGroupColumns()),
|
22
|
NOMENCLATURAL_AUTHOR("PersonOrTeam", nomenclaturalAuthorColumns()),
|
23
|
NOMENCLATURAL_AUTHOR_TEAM_RELATION("PersonTeamRelation", nomenclaturalAuthorTeamRelColumns()),
|
24
|
TYPE_DESIGNATION("SpecimenTypeDesignation", typeDesignationColumns()),
|
25
|
SPECIMEN("Specimen", specimenColumns()),
|
26
|
TAXON("Taxon", taxonColumns()),
|
27
|
SYNONYM("Synonym", synonymColumns()),
|
28
|
REFERENCE("Reference", referenceColumns()),
|
29
|
SIMPLE_FACT("SimpleFact", simpleFactsColumns()),
|
30
|
TAXON_INTERACTION_FACT("TaxonInteractionFact", taxonInteractionFactsColumns()),
|
31
|
SPECIMEN_FACT("SpecimenFact", specimenFactsColumns()),
|
32
|
GEOGRAPHIC_AREA_FACT("GeographicAreaFact", geographicAreaFactsColumns()),
|
33
|
COMMON_NAME_FACT("CommonNameFact", commonNameFactsColumns()),
|
34
|
FACT_SOURCES("FactSources", factSourcesColumns()),
|
35
|
IDENTIFIER("Identifier", identifierColumns()),
|
36
|
MEDIA("MediaFact", mediaColumns()),
|
37
|
// CONDENSED_DISTRIBUTION_FACT("CondensedDistributionFact", compressedDistributionFactColumns()),
|
38
|
NAME_FACT("NameFact", nameFactColumns()),
|
39
|
TYPE_SPECIMEN_NAME("NameSpecimenTypeRelation", typeDesignationNameColumns())
|
40
|
;
|
41
|
|
42
|
//Taxon/Synonym
|
43
|
protected static final String NAME_FK = "Name_Fk";
|
44
|
protected static final String TAXON_ID = "Taxon_ID";
|
45
|
protected static final String TAXON_FK = "Taxon_Fk";
|
46
|
protected static final String CLASSIFICATION_ID = "Classification_ID";
|
47
|
protected static final String CLASSIFICATION_TITLE = "ClassificationName";
|
48
|
protected static final String SYNONYM_ID = "Synonym_ID";
|
49
|
protected static final String PARENT_FK = "Parent_Fk";
|
50
|
protected static final String SEC_REFERENCE_FK = "SecReference_Fk";
|
51
|
protected static final String SEC_REFERENCE = "SecReference";
|
52
|
protected static final String SORT_INDEX = "SortIndex";
|
53
|
protected static final String UNPLACED = "Unplaced";
|
54
|
protected static final String EXCLUDED = "Excluded";
|
55
|
protected static final String DOUBTFUL = "PlacementDoubtful";
|
56
|
protected static final String PUBLISHED = "Published";
|
57
|
protected static final String STATUS_NOTES = "StatusNotes";
|
58
|
|
59
|
//pro parte / misapplied
|
60
|
protected static final String SYN_SEC_REFERENCE_FK = "SynSecReference_Fk";
|
61
|
protected static final String SYN_SEC_REFERENCE = "SynSecReference";
|
62
|
protected static final String IS_PRO_PARTE = "IsProParteSynonym";
|
63
|
protected static final String IS_PARTIAL = "IsPartial";
|
64
|
protected static final String IS_MISAPPLIED = "IsMisapplied";
|
65
|
|
66
|
//Reference
|
67
|
protected static final String REFERENCE_ID = "Reference_ID";
|
68
|
protected static final String BIBLIO_SHORT_CITATION = "BibliographicShortCitation";
|
69
|
protected static final String REF_TITLE = "Title";
|
70
|
protected static final String ABBREV_REF_TITLE = "AbbrevTitle";
|
71
|
protected static final String DATE_PUBLISHED = "DatePublished";
|
72
|
protected static final String EDITION = "Edition";
|
73
|
protected static final String EDITOR= "Editor";
|
74
|
protected static final String ISBN = "ISBN";
|
75
|
protected static final String ISSN = "ISSN";
|
76
|
protected static final String ORGANISATION = "Organisation";
|
77
|
protected static final String PAGES = "Pages";
|
78
|
protected static final String PLACE_PUBLISHED = "PlacePublished";
|
79
|
protected static final String PUBLISHER = "Publisher";
|
80
|
protected static final String REF_ABSTRACT = "ReferenceAbstract";
|
81
|
protected static final String SERIES_PART = "SeriesPart";
|
82
|
protected static final String VOLUME = "Volume";
|
83
|
protected static final String YEAR = "Year";
|
84
|
protected static final String AUTHORSHIP_TITLE = "FullAuthor";
|
85
|
|
86
|
|
87
|
protected static final String IN_REFERENCE = "InReference";
|
88
|
protected static final String INSTITUTION = "Institution";
|
89
|
// protected static final String LSID = "LSID";
|
90
|
protected static final String SCHOOL = "School";
|
91
|
protected static final String REF_TYPE = "ReferenceType";
|
92
|
protected static final String URI = "URI";
|
93
|
|
94
|
//Name
|
95
|
protected static final String NAME_ID = "Name_ID";
|
96
|
// protected static final String TROPICOS_ID = "Tropicos_ID";
|
97
|
// protected static final String IPNI_ID = "IPNI_ID";
|
98
|
// protected static final String WFO_ID = "WorldFloraOnline_ID";
|
99
|
protected static final String LSID = "LSID";
|
100
|
protected static final String RANK = "Rank";
|
101
|
protected static final String RANK_SEQUENCE = "RankSequence";
|
102
|
protected static final String FULL_NAME_WITH_AUTHORS = "FullNameWithAuthors";
|
103
|
protected static final String FULL_NAME_WITH_REF = "FullNameWithRef";
|
104
|
protected static final String FULL_NAME_NO_AUTHORS = "FullNameNoAuthors";
|
105
|
protected static final String GENUS_UNINOMIAL = "GenusOrUninomial";
|
106
|
protected static final String INFRAGENERIC_RANK = "InfragenericRank";
|
107
|
protected static final String INFRAGENERIC_EPITHET = "InfraGenericEpithet";
|
108
|
protected static final String SPECIFIC_EPITHET = "SpecificEpithet";
|
109
|
protected static final String INFRASPECIFIC_RANK = "InfraspecificRank";
|
110
|
protected static final String INFRASPECIFIC_EPITHET = "InfraSpecificEpithet ";
|
111
|
protected static final String APPENDED_PHRASE = "AppendedPhrase";
|
112
|
protected static final String BAS_EX_AUTHORTEAM_FK = "BasionymExAuthorTeam_Fk";
|
113
|
protected static final String BAS_AUTHORTEAM_FK = "BasionymAuthorTeam_Fk";
|
114
|
protected static final String COMB_EX_AUTHORTEAM_FK = "PublishingExAuthorTeam_Fk";
|
115
|
protected static final String COMB_AUTHORTEAM_FK = "PublishingAuthorTeam_Fk";
|
116
|
protected static final String AUTHOR_TEAM_STRING = "AuthorTeamString";
|
117
|
protected static final String NAME_USED_IN_SOURCE_FK = "NameUsedInSource_Fk";
|
118
|
// protected static final String REFERENCE_FK = "Reference_Fk"
|
119
|
protected static final String PUBLICATION_TYPE = "PublicationType";
|
120
|
protected static final String ABBREV_TITLE = "AbbreviatedTitle";
|
121
|
protected static final String FULL_TITLE = "FullTitle";
|
122
|
protected static final String ABBREV_REF_AUTHOR = "AbbreviatedInRefAuthor";
|
123
|
protected static final String FULL_REF_AUTHOR = "FullInRefAuthor";
|
124
|
protected static final String COLLATION = "Collation";
|
125
|
protected static final String VOLUME_ISSUE = "VolumeIssue";
|
126
|
protected static final String DETAIL = "Detail";
|
127
|
protected static final String YEAR_PUBLISHED = "YearPublished";
|
128
|
protected static final String VERBATIM_DATE = "VerbatimDate";
|
129
|
protected static final String PROTOLOGUE_URI = "ProtologueURI";
|
130
|
protected static final String NOM_STATUS = "NomenclaturalStatus";
|
131
|
protected static final String NOM_STATUS_ABBREV = "NomenclaturalStatusAbbreviation";
|
132
|
protected static final String HOMOTYPIC_GROUP_FK = "HomotypicGroup_Fk";
|
133
|
protected static final String HOMOTYPIC_GROUP_SEQ = "HomotypicGroupSequenceNumber";
|
134
|
protected static final String PROTOLOGUE_TYPE_STATEMENT = "ProtologueTypeStatement";
|
135
|
protected static final String TYPE_SPECIMEN = "TypeSpecimens";
|
136
|
protected static final String TYPE_STATEMENT = "TypeStatements";
|
137
|
|
138
|
|
139
|
|
140
|
//Name Relationship
|
141
|
protected static final String NAME1_FK = "Name1_Fk";
|
142
|
protected static final String NAME2_FK = "Name2_Fk";
|
143
|
protected static final String NAME_REL_TYPE = "NameRelationshipType";
|
144
|
|
145
|
//CDM MetaData
|
146
|
protected static final String INSTANCE_ID = "EditInstance_ID";
|
147
|
protected static final String INSTANCE_NAME = "EditInstanceName";
|
148
|
|
149
|
protected static final String DATASET_DESCRIPTION = "DatasetDescription";
|
150
|
protected static final String DATASET_CREATOR = "DatasetCreator";
|
151
|
protected static final String DATASET_CONTRIBUTOR = "DatasetContributor";
|
152
|
protected static final String DATASET_TITLE = "DatasetTitle";
|
153
|
protected static final String DATASET_LANGUAGE = "Language";
|
154
|
protected static final String DATASET_LANDINGPAGE = "DataSetLandingPage";
|
155
|
protected static final String DATASET_DOWNLOAD_LINK = "DatasetDownloadLink";
|
156
|
protected static final String DATASET_BASE_URL = "DatasetBaseUrl";
|
157
|
protected static final String DATASET_RECOMMENDED_CITATTION = "RecommendedCitation";
|
158
|
protected static final String DATASET_LOCATION = "DatasetLocation";
|
159
|
protected static final String DATASET_KEYWORDS = "DatasetKeywords";
|
160
|
protected static final String DATASET_LICENCE = "Licence";
|
161
|
|
162
|
|
163
|
//Homotypic Group
|
164
|
protected static final String HOMOTYPIC_GROUP_ID = "HomotypicGroup_ID";
|
165
|
protected static final String HOMOTYPIC_GROUP_STRING = "HomotypicGroupString";
|
166
|
protected static final String HOMOTYPIC_GROUP_WITH_SEC_STRING = "HomotypicGroupStringWithSec";
|
167
|
protected static final String HOMOTYPIC_GROUP_WITHOUT_ACCEPTED = "HomotypicGroupStringWithoutAccepted";
|
168
|
protected static final String HOMOTYPIC_GROUP_WITHOUT_ACCEPTEDWITHSEC = "HomotypicGroupStringWithoutAcceptedWithSec";
|
169
|
protected static final String HOMOTYPIC_GROUP_TYPE_STATEMENT_REFERENCE = "HomotypicGroupTypeStatementReference";
|
170
|
|
171
|
protected static final String TYPE_STRING = "TypeSpecimenString";
|
172
|
protected static final String TYPE_CACHE = "TypeStatementsString";
|
173
|
protected static final String TYPE_STRING_WITH_REF = "TypeSpecimenStringWithRef";
|
174
|
protected static final String TYPE_CACHE_WITH_REF = "TypeStatementsStringWithRef";
|
175
|
|
176
|
//NomenclaturalAuthor
|
177
|
protected static final String AUTHOR_ID = "PersonOrTeam_ID";
|
178
|
protected static final String ABBREV_AUTHOR = "AbbrevNames";
|
179
|
protected static final String AUTHOR_TITLE = "FullNames";
|
180
|
protected static final String AUTHOR_GIVEN_NAME = "PersonOtherNames";
|
181
|
protected static final String AUTHOR_FAMILY_NAME = "PersonFamiliyNames";
|
182
|
protected static final String AUTHOR_PREFIX = "PersonPrefix";
|
183
|
protected static final String AUTHOR_SUFFIX = "PersonSuffix";
|
184
|
|
185
|
//Nomenclatural Author AuthorTeam Relations
|
186
|
|
187
|
protected static final String AUTHOR_FK = "Author_Fk";
|
188
|
protected static final String AUTHOR_TEAM_FK = "AuthorTeam_Fk";
|
189
|
protected static final String AUTHOR_TEAM_SEQ_NUMBER = "SequenceNumber";
|
190
|
|
191
|
//TypeDesignations
|
192
|
protected static final String TYPE_ID="Type_ID";
|
193
|
protected static final String SPECIMEN_FK = "Specimen_Fk";
|
194
|
protected static final String TYPIFIED_NAME_FK = "TypifiedName_Fk";
|
195
|
protected static final String TYPE_VERBATIM_CITATION = "TypeVerbatimCitation";
|
196
|
protected static final String TYPE_STATUS = "TypeStatus";
|
197
|
protected static final String TYPE_INFORMATION_REF_STRING = "TypeInformationSource";
|
198
|
protected static final String TYPE_INFORMATION_REF_FK = "TypeInfoSourcePreferred_Fk";
|
199
|
protected static final String TYPE_DESIGNATED_BY_REF_FK = "TypeDesignatedBy_Fk";
|
200
|
|
201
|
//Type_Name_Rel
|
202
|
protected static final String TYPE_FK="Type_Fk";
|
203
|
|
204
|
|
205
|
//Specimen
|
206
|
protected static final String SPECIMEN_ID = "Specimen_ID";
|
207
|
protected static final String SPECIMEN_CITATION = "SpecimenCitation";
|
208
|
protected static final String FIELDUNIT_CITATION = "FieldUnitCitation";
|
209
|
protected static final String LOCALITY= "Locality";
|
210
|
protected static final String COUNTRY = "Country";
|
211
|
protected static final String AREA_CATEGORY1 = "AreaCategory1";
|
212
|
protected static final String AREA_NAME1 = "AreaName1";
|
213
|
protected static final String AREA_CATEGORY2 = "AreaCategory2";
|
214
|
protected static final String AREA_NAME2 = "AreaName2";
|
215
|
protected static final String AREA_CATEGORY3 = "AreaCategory3";
|
216
|
protected static final String AREA_NAME3 = "AreaName3";
|
217
|
protected static final String FURTHER_AREAS = "FurtherAreas";
|
218
|
protected static final String COLLECTOR_STRING = "CollectorString";
|
219
|
protected static final String COLLECTOR_NUMBER = "CollectorNumber";
|
220
|
protected static final String COLLECTION_DATE = "CollectionDate";
|
221
|
protected static final String SPECIMEN_IMAGE_URIS = "SpecimenImageURIs";
|
222
|
protected static final String HERBARIUM_ABBREV = "HerbariumAbbrev";
|
223
|
protected static final String MEDIA_SPECIMEN_URL = "MediaSpecimenURI";
|
224
|
protected static final String PREFERREDSTABLE_ID = "PreferredStableId";
|
225
|
protected static final String BARCODE = "Barcode";
|
226
|
protected static final String ACCESSION_NUMBER = "AccessionNumber";
|
227
|
protected static final String CATALOGUE_NUMBER = "CatalogueNumber ";
|
228
|
//other specimen attributes
|
229
|
|
230
|
//SimpleFacts
|
231
|
protected static final String FACT_ID = "Fact_ID";
|
232
|
protected static final String FACT_TEXT = "FactText";
|
233
|
protected static final String LANGUAGE = "Language";
|
234
|
protected static final String MEDIA_URI = "MediaURI";
|
235
|
protected static final String FACT_CATEGORY = "FactCategory";
|
236
|
|
237
|
// Specimen Facts
|
238
|
protected static final String SPECIMEN_NOTES = "SpecimenNotes";
|
239
|
protected static final String SPECIMEN_DESCRIPTION = "SpecimenDescription";
|
240
|
|
241
|
// TaxonInteraction Facts
|
242
|
protected static final String TAXON2_FK = "Taxon2_FK";
|
243
|
protected static final String DESCRIPTION = "Description";
|
244
|
|
245
|
//Geographic Area Facts
|
246
|
protected static final String AREA_LABEL = "AreaLabel";
|
247
|
protected static final String STATUS_LABEL = "StatusLabel";
|
248
|
|
249
|
//FactSources
|
250
|
protected static final String FACT_FK = "Fact_Fk";
|
251
|
protected static final String REFERENCE_FK = "Reference_Fk";
|
252
|
protected static final String NAME_IN_SOURCE_FK = "NameInSource_Fk";
|
253
|
protected static final String FACT_TYPE = "FactType";
|
254
|
|
255
|
//Annotations
|
256
|
|
257
|
|
258
|
//Identifiers
|
259
|
protected static final String EXTERNAL_NAME_IDENTIFIER = "ExternalIdentifier";
|
260
|
protected static final String IDENTIFIER_TYPE = "IdentifierType";
|
261
|
protected static final String FK = "ForeignKey";
|
262
|
protected static final String REF_TABLE = "ReferencedTable";
|
263
|
|
264
|
final static String[] homotypicGroupColumns(){
|
265
|
return new String[]{HOMOTYPIC_GROUP_ID, HOMOTYPIC_GROUP_STRING, TYPE_STRING, TYPE_CACHE, HOMOTYPIC_GROUP_WITH_SEC_STRING, HOMOTYPIC_GROUP_WITHOUT_ACCEPTED, HOMOTYPIC_GROUP_WITHOUT_ACCEPTEDWITHSEC, SORT_INDEX, HOMOTYPIC_GROUP_TYPE_STATEMENT_REFERENCE};
|
266
|
|
267
|
}
|
268
|
|
269
|
// private static String[] compressedDistributionFactColumns() {
|
270
|
// return new String[]{FACT_ID, TAXON_FK, FACT_TEXT};
|
271
|
// }
|
272
|
|
273
|
private Object usageFactColumns() {
|
274
|
return new String[]{FACT_ID, TAXON_FK, FACT_TEXT, LANGUAGE, MEDIA_URI, FACT_CATEGORY};
|
275
|
}
|
276
|
|
277
|
final static String[] nameFactColumns() {
|
278
|
return new String[]{FACT_ID, NAME_FK, FACT_TEXT, LANGUAGE, MEDIA_URI, FACT_CATEGORY};
|
279
|
}
|
280
|
final static String[] taxonInteractionFactsColumns(){
|
281
|
return new String[]{FACT_ID, TAXON_FK, TAXON2_FK, DESCRIPTION};
|
282
|
}
|
283
|
|
284
|
final static String[] identifierColumns() {
|
285
|
return new String[]{ FK, REF_TABLE, EXTERNAL_NAME_IDENTIFIER, IDENTIFIER_TYPE};
|
286
|
}
|
287
|
|
288
|
final static String[] mediaColumns() {
|
289
|
return new String[]{ FACT_ID, TAXON_FK, NAME_FK, MEDIA_URI};
|
290
|
}
|
291
|
|
292
|
final static String[] factSourcesColumns() {
|
293
|
return new String[]{FACT_FK, REFERENCE_FK, NAME_IN_SOURCE_FK, FACT_TYPE};
|
294
|
}
|
295
|
|
296
|
final static String[] specimenFactsColumns() {
|
297
|
return new String[]{FACT_ID, TAXON_FK, SPECIMEN_FK, SPECIMEN_DESCRIPTION, SPECIMEN_NOTES};
|
298
|
}
|
299
|
|
300
|
final static String[] commonNameFactsColumns() {
|
301
|
return new String[]{FACT_ID, TAXON_FK, FACT_TEXT, LANGUAGE, AREA_LABEL};
|
302
|
|
303
|
}
|
304
|
final static String[] geographicAreaFactsColumns() {
|
305
|
return new String[]{FACT_ID, TAXON_FK, AREA_LABEL, STATUS_LABEL};
|
306
|
}
|
307
|
|
308
|
final static String[] simpleFactsColumns() {
|
309
|
return new String[]{FACT_ID, TAXON_FK, FACT_TEXT, LANGUAGE, MEDIA_URI, FACT_CATEGORY};
|
310
|
}
|
311
|
|
312
|
final static String[] nomenclaturalAuthorColumns() {
|
313
|
return new String[]{AUTHOR_ID, ABBREV_AUTHOR, AUTHOR_TITLE, AUTHOR_GIVEN_NAME, AUTHOR_FAMILY_NAME, AUTHOR_PREFIX, AUTHOR_SUFFIX};
|
314
|
}
|
315
|
|
316
|
final static String[] nomenclaturalAuthorTeamRelColumns() {
|
317
|
return new String[]{AUTHOR_TEAM_FK, AUTHOR_FK, AUTHOR_TEAM_SEQ_NUMBER};
|
318
|
}
|
319
|
|
320
|
final static String[] metaDataColumns(){
|
321
|
return new String[]{INSTANCE_ID, INSTANCE_NAME, DATASET_TITLE, DATASET_CONTRIBUTOR, DATASET_CREATOR, DATASET_DESCRIPTION,
|
322
|
DATASET_DOWNLOAD_LINK, DATASET_BASE_URL, DATASET_KEYWORDS, DATASET_LANDINGPAGE, DATASET_LANGUAGE, DATASET_LICENCE,
|
323
|
DATASET_LOCATION, DATASET_RECOMMENDED_CITATTION};
|
324
|
}
|
325
|
|
326
|
final static String[] nameRelationColumns(){
|
327
|
return new String[]{NAME1_FK, NAME2_FK, NAME_REL_TYPE};
|
328
|
}
|
329
|
|
330
|
final static String[] nameColumns(){
|
331
|
return new String[]{NAME_ID, LSID, RANK, RANK_SEQUENCE,
|
332
|
FULL_NAME_WITH_AUTHORS, FULL_NAME_NO_AUTHORS, GENUS_UNINOMIAL,
|
333
|
INFRAGENERIC_RANK, INFRAGENERIC_EPITHET, SPECIFIC_EPITHET,
|
334
|
INFRASPECIFIC_RANK, INFRASPECIFIC_EPITHET,
|
335
|
BAS_EX_AUTHORTEAM_FK, BAS_AUTHORTEAM_FK, COMB_EX_AUTHORTEAM_FK, COMB_AUTHORTEAM_FK,
|
336
|
AUTHOR_TEAM_STRING, REFERENCE_FK, PUBLICATION_TYPE, ABBREV_TITLE, FULL_TITLE,
|
337
|
ABBREV_REF_AUTHOR, FULL_REF_AUTHOR, COLLATION, VOLUME_ISSUE,
|
338
|
DETAIL, DATE_PUBLISHED, YEAR_PUBLISHED, VERBATIM_DATE, PROTOLOGUE_URI,
|
339
|
NOM_STATUS, NOM_STATUS_ABBREV, HOMOTYPIC_GROUP_FK,
|
340
|
HOMOTYPIC_GROUP_SEQ, PROTOLOGUE_TYPE_STATEMENT, TYPE_SPECIMEN, TYPE_STATEMENT, FULL_NAME_WITH_REF, NAME_USED_IN_SOURCE_FK, APPENDED_PHRASE
|
341
|
};
|
342
|
}
|
343
|
|
344
|
final static String[] taxonColumns(){
|
345
|
return new String[]{TAXON_ID, CLASSIFICATION_ID, CLASSIFICATION_TITLE, NAME_FK, PARENT_FK, SEC_REFERENCE_FK, SEC_REFERENCE, SORT_INDEX, EXCLUDED, STATUS_NOTES, PUBLISHED, UNPLACED, DOUBTFUL, APPENDED_PHRASE};
|
346
|
}
|
347
|
|
348
|
final static String[] synonymColumns(){
|
349
|
return new String[]{SYNONYM_ID, TAXON_FK, NAME_FK, SYN_SEC_REFERENCE_FK, SYN_SEC_REFERENCE, SEC_REFERENCE_FK, SEC_REFERENCE,
|
350
|
IS_PRO_PARTE, IS_PARTIAL, IS_MISAPPLIED, PUBLISHED, SORT_INDEX, APPENDED_PHRASE};
|
351
|
}
|
352
|
|
353
|
final static String[] referenceColumns(){
|
354
|
return new String[]{REFERENCE_ID, BIBLIO_SHORT_CITATION, REF_TITLE,ABBREV_REF_TITLE, DATE_PUBLISHED, EDITION, EDITOR, ISBN,ISSN, ORGANISATION, PAGES, PLACE_PUBLISHED, PUBLISHER,
|
355
|
REF_ABSTRACT, SERIES_PART, VOLUME, YEAR, AUTHORSHIP_TITLE, AUTHOR_FK, IN_REFERENCE, INSTITUTION, LSID, SCHOOL, REF_TYPE, URI};
|
356
|
}
|
357
|
|
358
|
final static String[] typeDesignationColumns(){
|
359
|
return new String[]{TYPE_ID, TYPIFIED_NAME_FK, SPECIMEN_FK, //TYPE_VERBATIM_CITATION,
|
360
|
TYPE_STATUS, TYPE_DESIGNATED_BY_REF_FK, TYPE_INFORMATION_REF_STRING, TYPE_INFORMATION_REF_FK};
|
361
|
|
362
|
}
|
363
|
|
364
|
final static String[] typeDesignationNameColumns(){
|
365
|
return new String[]{TYPE_FK, NAME_FK};
|
366
|
}
|
367
|
|
368
|
|
369
|
final static String[] specimenColumns() {
|
370
|
return new String[]{SPECIMEN_ID, SPECIMEN_CITATION, FIELDUNIT_CITATION, LOCALITY, COUNTRY, AREA_CATEGORY1, AREA_NAME1, AREA_CATEGORY2, AREA_NAME2, AREA_CATEGORY3, AREA_NAME3,
|
371
|
FURTHER_AREAS, COLLECTOR_STRING, COLLECTOR_NUMBER, COLLECTION_DATE, SPECIMEN_IMAGE_URIS, HERBARIUM_ABBREV, MEDIA_SPECIMEN_URL, PREFERREDSTABLE_ID, BARCODE, CATALOGUE_NUMBER, ACCESSION_NUMBER};
|
372
|
}
|
373
|
|
374
|
private String tableName;
|
375
|
private String[] columnNames;
|
376
|
|
377
|
// ************** CONSTRUCTOR *******************/
|
378
|
|
379
|
private CdmLightExportTable(String tableName, String[] columnNames){
|
380
|
this.tableName = tableName;
|
381
|
this.columnNames = columnNames;
|
382
|
}
|
383
|
|
384
|
// ****************** GETTER / SETTER *************/
|
385
|
|
386
|
public String getTableName() {return tableName;}
|
387
|
|
388
|
public int getSize(){ return columnNames.length;}
|
389
|
|
390
|
public String[] getColumnNames(){return columnNames;}
|
391
|
|
392
|
public int getIndex(String columnName) {
|
393
|
int index= 0;
|
394
|
for(String column : getColumnNames()){
|
395
|
if (column.equals(columnName)){
|
396
|
return index;
|
397
|
}
|
398
|
index++;
|
399
|
}
|
400
|
return -1;
|
401
|
}
|
402
|
}
|