Revision 13654
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4194 | 4194 |
|
| 4195 | 4195 |
|
| 4196 | 4196 |
-- |
| 4197 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: - |
|
| 4198 |
-- |
|
| 4199 |
|
|
| 4200 |
|
|
| 4201 |
|
|
| 4202 |
|
|
| 4203 |
-- |
|
| 4204 |
-- Name: COLUMN analytical_stem_view.country; Type: COMMENT; Schema: public; Owner: - |
|
| 4205 |
-- |
|
| 4206 |
|
|
| 4207 |
|
|
| 4208 |
|
|
| 4209 |
|
|
| 4210 |
-- |
|
| 4211 |
-- Name: COLUMN analytical_stem_view.`stateProvince`; Type: COMMENT; Schema: public; Owner: - |
|
| 4212 |
-- |
|
| 4213 |
|
|
| 4214 |
|
|
| 4215 |
|
|
| 4216 |
|
|
| 4217 |
-- |
|
| 4218 |
-- Name: COLUMN analytical_stem_view.county; Type: COMMENT; Schema: public; Owner: - |
|
| 4219 |
-- |
|
| 4220 |
|
|
| 4221 |
|
|
| 4222 |
|
|
| 4223 |
|
|
| 4224 |
-- |
|
| 4225 |
-- Name: COLUMN analytical_stem_view.locality; Type: COMMENT; Schema: public; Owner: - |
|
| 4226 |
-- |
|
| 4227 |
|
|
| 4228 |
|
|
| 4229 |
|
|
| 4230 |
|
|
| 4231 |
-- |
|
| 4232 |
-- Name: COLUMN analytical_stem_view.`decimalLatitude`; Type: COMMENT; Schema: public; Owner: - |
|
| 4233 |
-- |
|
| 4234 |
|
|
| 4235 |
|
|
| 4236 |
|
|
| 4237 |
|
|
| 4238 |
-- |
|
| 4239 |
-- Name: COLUMN analytical_stem_view.`decimalLongitude`; Type: COMMENT; Schema: public; Owner: - |
|
| 4240 |
-- |
|
| 4241 |
|
|
| 4242 |
|
|
| 4243 |
|
|
| 4244 |
|
|
| 4245 |
-- |
|
| 4246 |
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters`; Type: COMMENT; Schema: public; Owner: - |
|
| 4247 |
-- |
|
| 4248 |
|
|
| 4249 |
|
|
| 4250 |
|
|
| 4251 |
|
|
| 4252 |
-- |
|
| 4253 |
-- Name: COLUMN analytical_stem_view.`locationID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4254 |
-- |
|
| 4255 |
|
|
| 4256 |
|
|
| 4257 |
|
|
| 4258 |
|
|
| 4259 |
-- |
|
| 4260 |
-- Name: COLUMN analytical_stem_view.`locationName`; Type: COMMENT; Schema: public; Owner: - |
|
| 4261 |
-- |
|
| 4262 |
|
|
| 4263 |
|
|
| 4264 |
|
|
| 4265 |
|
|
| 4266 |
-- |
|
| 4267 |
-- Name: COLUMN analytical_stem_view.`eventDate`; Type: COMMENT; Schema: public; Owner: - |
|
| 4268 |
-- |
|
| 4269 |
|
|
| 4270 |
|
|
| 4271 |
|
|
| 4272 |
|
|
| 4273 |
-- |
|
| 4274 |
-- Name: COLUMN analytical_stem_view.`elevationInMeters`; Type: COMMENT; Schema: public; Owner: - |
|
| 4275 |
-- |
|
| 4276 |
|
|
| 4277 |
|
|
| 4278 |
|
|
| 4279 |
|
|
| 4280 |
-- |
|
| 4281 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol`; Type: COMMENT; Schema: public; Owner: - |
|
| 4282 |
-- |
|
| 4283 |
|
|
| 4284 |
|
|
| 4285 |
|
|
| 4286 |
|
|
| 4287 |
-- |
|
| 4288 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: - |
|
| 4289 |
-- |
|
| 4290 |
|
|
| 4291 |
|
|
| 4292 |
|
|
| 4293 |
|
|
| 4294 |
-- |
|
| 4295 |
-- Name: COLUMN analytical_stem_view.`occurrenceID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4296 |
-- |
|
| 4297 |
|
|
| 4298 |
|
|
| 4299 |
|
|
| 4300 |
|
|
| 4301 |
-- |
|
| 4302 |
-- Name: COLUMN analytical_stem_view.`recordedBy`; Type: COMMENT; Schema: public; Owner: - |
|
| 4303 |
-- |
|
| 4304 |
|
|
| 4305 |
|
|
| 4306 |
|
|
| 4307 |
|
|
| 4308 |
-- |
|
| 4309 |
-- Name: COLUMN analytical_stem_view.`recordNumber`; Type: COMMENT; Schema: public; Owner: - |
|
| 4310 |
-- |
|
| 4311 |
|
|
| 4312 |
|
|
| 4313 |
|
|
| 4314 |
|
|
| 4315 |
-- |
|
| 4316 |
-- Name: COLUMN analytical_stem_view.`dateCollected`; Type: COMMENT; Schema: public; Owner: - |
|
| 4317 |
-- |
|
| 4318 |
|
|
| 4319 |
|
|
| 4320 |
|
|
| 4321 |
|
|
| 4322 |
-- |
|
| 4323 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: - |
|
| 4324 |
-- |
|
| 4325 |
|
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
|
|
| 4329 |
-- |
|
| 4330 |
-- Name: COLUMN analytical_stem_view.`scientificName_verbatim`; Type: COMMENT; Schema: public; Owner: - |
|
| 4331 |
-- |
|
| 4332 |
|
|
| 4333 |
|
|
| 4334 |
|
|
| 4335 |
|
|
| 4336 |
-- |
|
| 4337 |
-- Name: COLUMN analytical_stem_view.`identifiedBy`; Type: COMMENT; Schema: public; Owner: - |
|
| 4338 |
-- |
|
| 4339 |
|
|
| 4340 |
|
|
| 4341 |
|
|
| 4342 |
|
|
| 4343 |
-- |
|
| 4344 |
-- Name: COLUMN analytical_stem_view.`dateIdentified`; Type: COMMENT; Schema: public; Owner: - |
|
| 4345 |
-- |
|
| 4346 |
|
|
| 4347 |
|
|
| 4348 |
|
|
| 4349 |
|
|
| 4350 |
-- |
|
| 4351 |
-- Name: COLUMN analytical_stem_view.`identificationRemarks`; Type: COMMENT; Schema: public; Owner: - |
|
| 4352 |
-- |
|
| 4353 |
|
|
| 4354 |
|
|
| 4355 |
|
|
| 4356 |
|
|
| 4357 |
-- |
|
| 4358 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
|
| 4359 |
-- |
|
| 4360 |
|
|
| 4361 |
|
|
| 4362 |
|
|
| 4363 |
|
|
| 4364 |
-- |
|
| 4365 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition`; Type: COMMENT; Schema: public; Owner: - |
|
| 4366 |
-- |
|
| 4367 |
|
|
| 4368 |
|
|
| 4369 |
|
|
| 4370 |
|
|
| 4371 |
-- |
|
| 4372 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks`; Type: COMMENT; Schema: public; Owner: - |
|
| 4373 |
-- |
|
| 4374 |
|
|
| 4375 |
|
|
| 4376 |
|
|
| 4377 |
|
|
| 4378 |
-- |
|
| 4197 | 4379 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 4198 | 4380 |
-- |
| 4199 | 4381 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: flagged the DwC terms