forked from havochvatten/MSP-Symphony
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathImportTables.txt
230 lines (170 loc) · 8.91 KB
/
ImportTables.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
CREATE SCHEMA IF NOT EXISTS import
AUTHORIZATION postgres;
COMMENT ON SCHEMA import
IS 'Schema for import of data to be used in Symphony';
-- Table: import.sensitivityimport
-- DROP TABLE IF EXISTS import.sensitivityimport;
CREATE TABLE IF NOT EXISTS import.sensitivityimport
(
senimp_c0 text COLLATE pg_catalog."default" NOT NULL,
senimp_c1 text COLLATE pg_catalog."default",
senimp_c2 text COLLATE pg_catalog."default",
senimp_c3 text COLLATE pg_catalog."default",
senimp_c4 text COLLATE pg_catalog."default",
senimp_c5 text COLLATE pg_catalog."default",
senimp_c6 text COLLATE pg_catalog."default",
senimp_c7 text COLLATE pg_catalog."default",
senimp_c8 text COLLATE pg_catalog."default",
senimp_c9 text COLLATE pg_catalog."default",
senimp_c10 text COLLATE pg_catalog."default",
senimp_c11 text COLLATE pg_catalog."default",
senimp_c12 text COLLATE pg_catalog."default",
senimp_c13 text COLLATE pg_catalog."default",
senimp_c14 text COLLATE pg_catalog."default",
senimp_c15 text COLLATE pg_catalog."default",
senimp_c16 text COLLATE pg_catalog."default",
senimp_c17 text COLLATE pg_catalog."default",
senimp_c18 text COLLATE pg_catalog."default",
senimp_c19 text COLLATE pg_catalog."default",
senimp_c20 text COLLATE pg_catalog."default",
senimp_c21 text COLLATE pg_catalog."default",
senimp_c22 text COLLATE pg_catalog."default",
senimp_c23 text COLLATE pg_catalog."default",
senimp_c24 text COLLATE pg_catalog."default",
senimp_c25 text COLLATE pg_catalog."default",
senimp_c26 text COLLATE pg_catalog."default",
senimp_c27 text COLLATE pg_catalog."default",
senimp_c28 text COLLATE pg_catalog."default",
senimp_c29 text COLLATE pg_catalog."default",
senimp_c30 text COLLATE pg_catalog."default",
senimp_c31 text COLLATE pg_catalog."default",
senimp_c32 text COLLATE pg_catalog."default",
senimp_c33 text COLLATE pg_catalog."default",
senimp_c34 text COLLATE pg_catalog."default",
senimp_c35 text COLLATE pg_catalog."default",
senimp_c36 text COLLATE pg_catalog."default",
senimp_c37 text COLLATE pg_catalog."default",
senimp_c38 text COLLATE pg_catalog."default",
senimp_c39 text COLLATE pg_catalog."default",
senimp_c40 text COLLATE pg_catalog."default",
senimp_c41 text COLLATE pg_catalog."default",
senimp_c42 text COLLATE pg_catalog."default",
senimp_c43 text COLLATE pg_catalog."default",
senimp_c44 text COLLATE pg_catalog."default",
senimp_c45 text COLLATE pg_catalog."default",
senimp_c46 text COLLATE pg_catalog."default",
senimp_c47 text COLLATE pg_catalog."default",
senimp_c48 text COLLATE pg_catalog."default",
senimp_c49 text COLLATE pg_catalog."default",
senimp_c50 text COLLATE pg_catalog."default"
)
WITH (
OIDS = FALSE
)
TABLESPACE symphony;
ALTER TABLE IF EXISTS import.sensitivityimport
OWNER to postgres;
COMMENT ON TABLE import.sensitivityimport
IS 'Import of sensitivity matrix for the combination of ecocomponent and pressure,';
COMMENT ON COLUMN import.sensitivityimport.senimp_c0
IS 'Column with pressures,';
COMMENT ON COLUMN import.sensitivityimport.senimp_c1
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c2
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c3
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c4
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c5
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c6
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c7
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c8
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c9
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c10
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c11
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c12
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c13
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c14
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c15
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c16
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c17
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c18
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c19
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c20
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c21
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c22
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c23
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c24
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c25
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c26
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c27
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c28
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c29
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c30
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c31
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c32
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c33
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c34
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c35
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c36
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c37
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c38
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c39
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c40
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c41
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c42
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c43
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c44
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c45
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c46
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c47
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c48
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c49
IS 'Sensitivity value (but first row eco component name).';
COMMENT ON COLUMN import.sensitivityimport.senimp_c50
IS 'Sensitivity value (but first row eco component name).';