1 package fr.ifremer.quadrige2.synchro.meta;
2
3 /*-
4 * #%L
5 * Quadrige2 Core :: Quadrige2 Synchro Core
6 * $Id:$
7 * $HeadURL:$
8 * %%
9 * Copyright (C) 2017 Ifremer
10 * %%
11 * This program is free software: you can redistribute it and/or modify
12 * it under the terms of the GNU Affero General Public License as published by
13 * the Free Software Foundation, either version 3 of the License, or
14 * (at your option) any later version.
15 *
16 * This program is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
20 *
21 * You should have received a copy of the GNU Affero General Public License
22 * along with this program. If not, see <http://www.gnu.org/licenses/>.
23 * #L%
24 */
25
26 /**
27 * Enumeration to get some columns names from Quadrige2 database
28 */
29 public enum DatabaseColumns {
30
31 UPDATE_DT,
32 SYNCHRONIZATION_STATUS,
33 REMOTE_ID,
34 STATUS_CD,
35 /* QUSER */
36 QUSER_ID,
37 QUSER_INTRANET_LG,
38 QUSER_CRYPT_PASSWORD,
39 /* DEPARTMENT */
40 DEP_CD,
41 /* SURVEY table */
42 SURVEY_ID,
43 SURVEY_DT,
44 SURVEY_TIME,
45 SURVEY_CONTROL_DT,
46 SURVEY_VALID_DT,
47 SURVEY_BOTTOM_DEPTH,
48 /* SAMPLING_OPERATION table */
49 SAMPLING_OPER_ID,
50 /* SAMPLE table */
51 SAMPLE_ID,
52 /* EVENT */
53 EVENT_ID,
54 /* MONITORING_LOCATION */
55 MON_LOC_ID,
56 MON_LOC_NM,
57 /* DELETED_ITEM_HISTORY */
58 DEL_ITEM_HIST_ID,
59 OBJECT_ID,
60 OBJECT_CD,
61 /* OBJECT_TYPE */
62 OBJECT_TYPE_CD,
63 /* MEASUREMENT */
64 MEAS_NUMER_VALUE,
65 MEAS_DIGIT_NUMBER,
66 TAXON_MEAS_NUMER_VALUE,
67 TAXON_MEAS_DIGIT_NUMBER,
68
69 /* QUALIFICATION_HISTORY */
70 QUAL_HIST_ELEMENT_ID,
71
72 /* VALIDATION_HISTORY */
73 VALID_HIST_ELEMENT_ID,
74
75 /* PMFM */
76 PMFM_ID,
77 PAR_CD,
78 MATRIX_ID,
79 FRACTION_ID,
80 METHOD_ID,
81 UNIT_ID,
82 MATRIX_NM,
83 FRACTION_NM,
84 METHOD_NM,
85 UNIT_NM,
86 UNIT_SYMBOL,
87 QUAL_VALUE_NM,
88
89 /* ANALYSIS_INSTRUMENT */
90 ANAL_INST_NM,
91
92 /* SAMPLING_EQUIPMENT */
93 SAMPLING_EQUIPMENT_NM,
94
95 /* TAXON_NAME */
96 TAXON_NAME_COMPLETE_NM,
97 REF_TAXON_ID,
98
99 /* TAXON_GROUP */
100 TAXON_GROUP_NM,
101
102 /* CITATION */
103 CIT_ID,
104
105 /* RULE */
106 RULE_LIST_CD,
107 RULE_CD,
108
109 /* CONTEXT */
110 CONTEXT_NM,
111
112 /* FILTER */
113 FILTER_NM,
114 FILTER_TYPE_ID,
115
116 /* PROGRAMME */
117 PROG_CD,
118 STRAT_NM,
119 STRAT_ID,
120 PMFM_STRAT_ID,
121 APPLIED_STRAT_ID,
122
123 /* SYSTEM_VERSION */
124 SYSTEM_VERSION_LB,
125
126 /* TRANSCRIBING_ITEM */
127 TRANSC_ITEM_TYPE_ID,
128 TRANSC_ITEM_TYPE_LB
129
130 }