Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 258 about 13 years Aaron Marcuse-Kubitza Moved pre-BIEN 3 files into _archive folder
  bin 564 almost 13 years Aaron Marcuse-Kubitza repl: When matching words, treat _ as word boun...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 594 almost 13 years Aaron Marcuse-Kubitza VegX-VegBIEN mappings: Took advantage of severa...
  lib 577 almost 13 years Aaron Marcuse-Kubitza PostgreSQL-MySQL.csv: Deal with MySQL assuming ...
  mappings 594 almost 13 years Aaron Marcuse-Kubitza VegX-VegBIEN mappings: Took advantage of severa...
  schemas 593 almost 13 years Aaron Marcuse-Kubitza Regenerated vegbien.ERD exports
  test 594 almost 13 years Aaron Marcuse-Kubitza VegX-VegBIEN mappings: Took advantage of severa...
Makefile 5.83 KB 418 about 13 years Aaron Marcuse-Kubitza Makefiles: Added empty rules for targets withou...
README.TXT 392 Bytes 554 almost 13 years Aaron Marcuse-Kubitza README.TXT: Added make empty_db
map 723 Bytes 274 about 13 years Aaron Marcuse-Kubitza Renamed util to bin

Latest revisions

# Date Author Comment
594 01/23/2012 03:43 PM Aaron Marcuse-Kubitza

VegX-VegBIEN mappings: Took advantage of several fields becoming optional

593 01/23/2012 03:36 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

592 01/23/2012 03:36 PM Aaron Marcuse-Kubitza

vegbien.sql: taxonbinmethod points to stratumtype instead of stratum because stratumtype is a method table, but stratum is a measurements table. stratum does not point directly to stratummethod because it points to it via stratumtype.

591 01/23/2012 03:04 PM Aaron Marcuse-Kubitza

vegbien.sql: Made taxondetermination.determinationdate optional because some determinations might not have a date

590 01/23/2012 02:47 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

589 01/23/2012 02:46 PM Aaron Marcuse-Kubitza

vegbien.sql: Added specimen.authorspecimencode

588 01/23/2012 02:36 PM Aaron Marcuse-Kubitza

Adjusted vegbien.ERD.mwb

587 01/23/2012 02:34 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

586 01/23/2012 02:33 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed sourceaccessionnumber to sourceaccessioncode to show that they are the data source's analog of accessioncode. Added sourceaccessioncode to all applicable tables because this is the database pkey, which is distinct from any author*code applied by the collector.

585 01/23/2012 01:56 PM Aaron Marcuse-Kubitza

vegbien.sql: Changed taxonbinmethod_keys to UNIQUE INDEX to take advantage of COALESCE for dealing with NULL values

View all revisions | View revisions

Also available in: Atom