Revision 13654
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/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 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 6842 | 6842 |
|
| 6843 | 6843 |
|
| 6844 | 6844 |
-- |
| 6845 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: - |
|
| 6846 |
-- |
|
| 6847 |
|
|
| 6848 |
COMMENT ON COLUMN analytical_stem_view.datasource IS 'where this database got the data; the proximate data provider'; |
|
| 6849 |
|
|
| 6850 |
|
|
| 6851 |
-- |
|
| 6852 |
-- Name: COLUMN analytical_stem_view.country; Type: COMMENT; Schema: public; Owner: - |
|
| 6853 |
-- |
|
| 6854 |
|
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view.country IS 'from DwC'; |
|
| 6856 |
|
|
| 6857 |
|
|
| 6858 |
-- |
|
| 6859 |
-- Name: COLUMN analytical_stem_view."stateProvince"; Type: COMMENT; Schema: public; Owner: - |
|
| 6860 |
-- |
|
| 6861 |
|
|
| 6862 |
COMMENT ON COLUMN analytical_stem_view."stateProvince" IS 'from DwC'; |
|
| 6863 |
|
|
| 6864 |
|
|
| 6865 |
-- |
|
| 6866 |
-- Name: COLUMN analytical_stem_view.county; Type: COMMENT; Schema: public; Owner: - |
|
| 6867 |
-- |
|
| 6868 |
|
|
| 6869 |
COMMENT ON COLUMN analytical_stem_view.county IS 'from DwC'; |
|
| 6870 |
|
|
| 6871 |
|
|
| 6872 |
-- |
|
| 6873 |
-- Name: COLUMN analytical_stem_view.locality; Type: COMMENT; Schema: public; Owner: - |
|
| 6874 |
-- |
|
| 6875 |
|
|
| 6876 |
COMMENT ON COLUMN analytical_stem_view.locality IS 'from DwC'; |
|
| 6877 |
|
|
| 6878 |
|
|
| 6879 |
-- |
|
| 6880 |
-- Name: COLUMN analytical_stem_view."decimalLatitude"; Type: COMMENT; Schema: public; Owner: - |
|
| 6881 |
-- |
|
| 6882 |
|
|
| 6883 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude" IS 'from DwC'; |
|
| 6884 |
|
|
| 6885 |
|
|
| 6886 |
-- |
|
| 6887 |
-- Name: COLUMN analytical_stem_view."decimalLongitude"; Type: COMMENT; Schema: public; Owner: - |
|
| 6888 |
-- |
|
| 6889 |
|
|
| 6890 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude" IS 'from DwC'; |
|
| 6891 |
|
|
| 6892 |
|
|
| 6893 |
-- |
|
| 6894 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters"; Type: COMMENT; Schema: public; Owner: - |
|
| 6895 |
-- |
|
| 6896 |
|
|
| 6897 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters" IS 'from DwC'; |
|
| 6898 |
|
|
| 6899 |
|
|
| 6900 |
-- |
|
| 6901 |
-- Name: COLUMN analytical_stem_view."locationID"; Type: COMMENT; Schema: public; Owner: - |
|
| 6902 |
-- |
|
| 6903 |
|
|
| 6904 |
COMMENT ON COLUMN analytical_stem_view."locationID" IS 'from DwC'; |
|
| 6905 |
|
|
| 6906 |
|
|
| 6907 |
-- |
|
| 6908 |
-- Name: COLUMN analytical_stem_view."locationName"; Type: COMMENT; Schema: public; Owner: - |
|
| 6909 |
-- |
|
| 6910 |
|
|
| 6911 |
COMMENT ON COLUMN analytical_stem_view."locationName" IS 'from DwC'; |
|
| 6912 |
|
|
| 6913 |
|
|
| 6914 |
-- |
|
| 6915 |
-- Name: COLUMN analytical_stem_view."eventDate"; Type: COMMENT; Schema: public; Owner: - |
|
| 6916 |
-- |
|
| 6917 |
|
|
| 6918 |
COMMENT ON COLUMN analytical_stem_view."eventDate" IS 'from DwC'; |
|
| 6919 |
|
|
| 6920 |
|
|
| 6921 |
-- |
|
| 6922 |
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: - |
|
| 6923 |
-- |
|
| 6924 |
|
|
| 6925 |
COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term'; |
|
| 6926 |
|
|
| 6927 |
|
|
| 6928 |
-- |
|
| 6929 |
-- Name: COLUMN analytical_stem_view."samplingProtocol"; Type: COMMENT; Schema: public; Owner: - |
|
| 6930 |
-- |
|
| 6931 |
|
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol" IS 'from DwC'; |
|
| 6933 |
|
|
| 6934 |
|
|
| 6935 |
-- |
|
| 6936 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: - |
|
| 6937 |
-- |
|
| 6938 |
|
|
| 6939 |
COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed'; |
|
| 6940 |
|
|
| 6941 |
|
|
| 6942 |
-- |
|
| 6943 |
-- Name: COLUMN analytical_stem_view."occurrenceID"; Type: COMMENT; Schema: public; Owner: - |
|
| 6944 |
-- |
|
| 6945 |
|
|
| 6946 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID" IS 'from DwC'; |
|
| 6947 |
|
|
| 6948 |
|
|
| 6949 |
-- |
|
| 6950 |
-- Name: COLUMN analytical_stem_view."recordedBy"; Type: COMMENT; Schema: public; Owner: - |
|
| 6951 |
-- |
|
| 6952 |
|
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."recordedBy" IS 'from DwC'; |
|
| 6954 |
|
|
| 6955 |
|
|
| 6956 |
-- |
|
| 6957 |
-- Name: COLUMN analytical_stem_view."recordNumber"; Type: COMMENT; Schema: public; Owner: - |
|
| 6958 |
-- |
|
| 6959 |
|
|
| 6960 |
COMMENT ON COLUMN analytical_stem_view."recordNumber" IS 'from DwC'; |
|
| 6961 |
|
|
| 6962 |
|
|
| 6963 |
-- |
|
| 6964 |
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: - |
|
| 6965 |
-- |
|
| 6966 |
|
|
| 6967 |
COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term'; |
|
| 6968 |
|
|
| 6969 |
|
|
| 6970 |
-- |
|
| 6971 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: - |
|
| 6972 |
-- |
|
| 6973 |
|
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term'; |
|
| 6975 |
|
|
| 6976 |
|
|
| 6977 |
-- |
|
| 6978 |
-- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: - |
|
| 6979 |
-- |
|
| 6980 |
|
|
| 6981 |
COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term'; |
|
| 6982 |
|
|
| 6983 |
|
|
| 6984 |
-- |
|
| 6985 |
-- Name: COLUMN analytical_stem_view."identifiedBy"; Type: COMMENT; Schema: public; Owner: - |
|
| 6986 |
-- |
|
| 6987 |
|
|
| 6988 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy" IS 'from DwC'; |
|
| 6989 |
|
|
| 6990 |
|
|
| 6991 |
-- |
|
| 6992 |
-- Name: COLUMN analytical_stem_view."dateIdentified"; Type: COMMENT; Schema: public; Owner: - |
|
| 6993 |
-- |
|
| 6994 |
|
|
| 6995 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified" IS 'from DwC'; |
|
| 6996 |
|
|
| 6997 |
|
|
| 6998 |
-- |
|
| 6999 |
-- Name: COLUMN analytical_stem_view."identificationRemarks"; Type: COMMENT; Schema: public; Owner: - |
|
| 7000 |
-- |
|
| 7001 |
|
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks" IS 'from DwC'; |
|
| 7003 |
|
|
| 7004 |
|
|
| 7005 |
-- |
|
| 7006 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
|
| 7007 |
-- |
|
| 7008 |
|
|
| 7009 |
COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed'; |
|
| 7010 |
|
|
| 7011 |
|
|
| 7012 |
-- |
|
| 7013 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition"; Type: COMMENT; Schema: public; Owner: - |
|
| 7014 |
-- |
|
| 7015 |
|
|
| 7016 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition" IS 'from DwC'; |
|
| 7017 |
|
|
| 7018 |
|
|
| 7019 |
-- |
|
| 7020 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks"; Type: COMMENT; Schema: public; Owner: - |
|
| 7021 |
-- |
|
| 7022 |
|
|
| 7023 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks" IS 'from DwC'; |
|
| 7024 |
|
|
| 7025 |
|
|
| 7026 |
-- |
|
| 6845 | 7027 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 6846 | 7028 |
-- |
| 6847 | 7029 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6842 | 6842 |
|
| 6843 | 6843 |
|
| 6844 | 6844 |
-- |
| 6845 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: - |
|
| 6846 |
-- |
|
| 6847 |
|
|
| 6848 |
COMMENT ON COLUMN analytical_stem_view.datasource IS 'where this database got the data; the proximate data provider'; |
|
| 6849 |
|
|
| 6850 |
|
|
| 6851 |
-- |
|
| 6852 |
-- Name: COLUMN analytical_stem_view.country; Type: COMMENT; Schema: public; Owner: - |
|
| 6853 |
-- |
|
| 6854 |
|
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view.country IS 'from DwC'; |
|
| 6856 |
|
|
| 6857 |
|
|
| 6858 |
-- |
|
| 6859 |
-- Name: COLUMN analytical_stem_view."stateProvince"; Type: COMMENT; Schema: public; Owner: - |
|
| 6860 |
-- |
|
| 6861 |
|
|
| 6862 |
COMMENT ON COLUMN analytical_stem_view."stateProvince" IS 'from DwC'; |
|
| 6863 |
|
|
| 6864 |
|
|
| 6865 |
-- |
|
| 6866 |
-- Name: COLUMN analytical_stem_view.county; Type: COMMENT; Schema: public; Owner: - |
|
| 6867 |
-- |
|
| 6868 |
|
|
| 6869 |
COMMENT ON COLUMN analytical_stem_view.county IS 'from DwC'; |
|
| 6870 |
|
|
| 6871 |
|
|
| 6872 |
-- |
|
| 6873 |
-- Name: COLUMN analytical_stem_view.locality; Type: COMMENT; Schema: public; Owner: - |
|
| 6874 |
-- |
|
| 6875 |
|
|
| 6876 |
COMMENT ON COLUMN analytical_stem_view.locality IS 'from DwC'; |
|
| 6877 |
|
|
| 6878 |
|
|
| 6879 |
-- |
|
| 6880 |
-- Name: COLUMN analytical_stem_view."decimalLatitude"; Type: COMMENT; Schema: public; Owner: - |
|
| 6881 |
-- |
|
| 6882 |
|
|
| 6883 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude" IS 'from DwC'; |
|
| 6884 |
|
|
| 6885 |
|
|
| 6886 |
-- |
|
| 6887 |
-- Name: COLUMN analytical_stem_view."decimalLongitude"; Type: COMMENT; Schema: public; Owner: - |
|
| 6888 |
-- |
|
| 6889 |
|
|
| 6890 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude" IS 'from DwC'; |
|
| 6891 |
|
|
| 6892 |
|
|
| 6893 |
-- |
|
| 6894 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters"; Type: COMMENT; Schema: public; Owner: - |
|
| 6895 |
-- |
|
| 6896 |
|
|
| 6897 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters" IS 'from DwC'; |
|
| 6898 |
|
|
| 6899 |
|
|
| 6900 |
-- |
|
| 6901 |
-- Name: COLUMN analytical_stem_view."locationID"; Type: COMMENT; Schema: public; Owner: - |
|
| 6902 |
-- |
|
| 6903 |
|
|
| 6904 |
COMMENT ON COLUMN analytical_stem_view."locationID" IS 'from DwC'; |
|
| 6905 |
|
|
| 6906 |
|
|
| 6907 |
-- |
|
| 6908 |
-- Name: COLUMN analytical_stem_view."locationName"; Type: COMMENT; Schema: public; Owner: - |
|
| 6909 |
-- |
|
| 6910 |
|
|
| 6911 |
COMMENT ON COLUMN analytical_stem_view."locationName" IS 'from DwC'; |
|
| 6912 |
|
|
| 6913 |
|
|
| 6914 |
-- |
|
| 6915 |
-- Name: COLUMN analytical_stem_view."eventDate"; Type: COMMENT; Schema: public; Owner: - |
|
| 6916 |
-- |
|
| 6917 |
|
|
| 6918 |
COMMENT ON COLUMN analytical_stem_view."eventDate" IS 'from DwC'; |
|
| 6919 |
|
|
| 6920 |
|
|
| 6921 |
-- |
|
| 6922 |
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: - |
|
| 6923 |
-- |
|
| 6924 |
|
|
| 6925 |
COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term'; |
|
| 6926 |
|
|
| 6927 |
|
|
| 6928 |
-- |
|
| 6929 |
-- Name: COLUMN analytical_stem_view."samplingProtocol"; Type: COMMENT; Schema: public; Owner: - |
|
| 6930 |
-- |
|
| 6931 |
|
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol" IS 'from DwC'; |
|
| 6933 |
|
|
| 6934 |
|
|
| 6935 |
-- |
|
| 6936 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: - |
|
| 6937 |
-- |
|
| 6938 |
|
|
| 6939 |
COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed'; |
|
| 6940 |
|
|
| 6941 |
|
|
| 6942 |
-- |
|
| 6943 |
-- Name: COLUMN analytical_stem_view."occurrenceID"; Type: COMMENT; Schema: public; Owner: - |
|
| 6944 |
-- |
|
| 6945 |
|
|
| 6946 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID" IS 'from DwC'; |
|
| 6947 |
|
|
| 6948 |
|
|
| 6949 |
-- |
|
| 6950 |
-- Name: COLUMN analytical_stem_view."recordedBy"; Type: COMMENT; Schema: public; Owner: - |
|
| 6951 |
-- |
|
| 6952 |
|
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."recordedBy" IS 'from DwC'; |
|
| 6954 |
|
|
| 6955 |
|
|
| 6956 |
-- |
|
| 6957 |
-- Name: COLUMN analytical_stem_view."recordNumber"; Type: COMMENT; Schema: public; Owner: - |
|
| 6958 |
-- |
|
| 6959 |
|
|
| 6960 |
COMMENT ON COLUMN analytical_stem_view."recordNumber" IS 'from DwC'; |
|
| 6961 |
|
|
| 6962 |
|
|
| 6963 |
-- |
|
| 6964 |
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: - |
|
| 6965 |
-- |
|
| 6966 |
|
|
| 6967 |
COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term'; |
|
| 6968 |
|
|
| 6969 |
|
|
| 6970 |
-- |
|
| 6971 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: - |
|
| 6972 |
-- |
|
| 6973 |
|
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term'; |
|
| 6975 |
|
|
| 6976 |
|
|
| 6977 |
-- |
|
| 6978 |
-- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: - |
|
| 6979 |
-- |
|
| 6980 |
|
|
| 6981 |
COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term'; |
|
| 6982 |
|
|
| 6983 |
|
|
| 6984 |
-- |
|
| 6985 |
-- Name: COLUMN analytical_stem_view."identifiedBy"; Type: COMMENT; Schema: public; Owner: - |
|
| 6986 |
-- |
|
| 6987 |
|
|
| 6988 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy" IS 'from DwC'; |
|
| 6989 |
|
|
| 6990 |
|
|
| 6991 |
-- |
|
| 6992 |
-- Name: COLUMN analytical_stem_view."dateIdentified"; Type: COMMENT; Schema: public; Owner: - |
|
| 6993 |
-- |
|
| 6994 |
|
|
| 6995 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified" IS 'from DwC'; |
|
| 6996 |
|
|
| 6997 |
|
|
| 6998 |
-- |
|
| 6999 |
-- Name: COLUMN analytical_stem_view."identificationRemarks"; Type: COMMENT; Schema: public; Owner: - |
|
| 7000 |
-- |
|
| 7001 |
|
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks" IS 'from DwC'; |
|
| 7003 |
|
|
| 7004 |
|
|
| 7005 |
-- |
|
| 7006 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
|
| 7007 |
-- |
|
| 7008 |
|
|
| 7009 |
COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed'; |
|
| 7010 |
|
|
| 7011 |
|
|
| 7012 |
-- |
|
| 7013 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition"; Type: COMMENT; Schema: public; Owner: - |
|
| 7014 |
-- |
|
| 7015 |
|
|
| 7016 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition" IS 'from DwC'; |
|
| 7017 |
|
|
| 7018 |
|
|
| 7019 |
-- |
|
| 7020 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks"; Type: COMMENT; Schema: public; Owner: - |
|
| 7021 |
-- |
|
| 7022 |
|
|
| 7023 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks" IS 'from DwC'; |
|
| 7024 |
|
|
| 7025 |
|
|
| 7026 |
-- |
|
| 6845 | 7027 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 6846 | 7028 |
-- |
| 6847 | 7029 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: flagged the DwC terms