Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5234 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: party: Made it datasource-...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5225 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Renamed taxonpath -> taxon...
  lib 5233 about 12 years Aaron Marcuse-Kubitza lib/PostgreSQL-MySQL.csv: Changed translation o...
  mappings 5225 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Renamed taxonpath -> taxon...
  schemas 5236 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: party: Fixed bug where nee...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 over 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.99 KB 4752 over 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: postgres-Linux: Adde...
README.TXT 13 KB 5227 about 12 years Aaron Marcuse-Kubitza README.TXT: Schema changes: Moved "update the f...
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
5236 10/04/2012 06:44 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: party: Fixed bug where needed separate unique index for roots (datasources), whose organizationnames must be globally unique rather than unique within a datasource

5235 10/04/2012 06:28 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonconcept: Renamed concept_reference_id to definer_id because this is a clearer name and because this will allow merging with datasource_id, which serves the same purpose

5234 10/04/2012 06:15 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: party: Made it datasource-scoped. Since this creates a recursive fkey, a datasource (a root party) should point to itself in this field, which will happen automatically by setting it to the special value 0.

5233 10/04/2012 05:51 PM Aaron Marcuse-Kubitza

lib/PostgreSQL-MySQL.csv: Changed translation of fulltext to quote the identifier instead of appending characters to make it not a reserved word

5232 10/04/2012 05:36 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonconcept: Moved concept_reference_id to the top of the table because it is now a key scoping field

5231 10/04/2012 05:30 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: concept_reference_id: Made it an fkey to party instead of taxonscope, because this is now the entity that defined the taxon concept, and is no longer specific to morphospecies. Removed no longer used table taxonscope.

5230 10/04/2012 05:13 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonconcept: Documented that it's equivalent to VegBank's plantConcept table

5229 10/04/2012 04:56 PM Aaron Marcuse-Kubitza

schemas/filter_ERD.csv: taxonconcept inward fkeys: Removed not applicable taxon filtered table, since the fkey points in the opposite direction and thus is not part of this filter

5228 10/04/2012 04:52 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonconcept: Renamed scope_id -> concept_reference_id as part of taxonomic schema refactoring at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/2012-10-03_conference_call#Taxonomic-schema-refactoring>

5227 10/04/2012 04:47 PM Aaron Marcuse-Kubitza

README.TXT: Schema changes: Moved "update the following files with any renamings" out of "Sync ERD with vegbien.sql schema" because this is needed for any schema changes, not just as part of syncing the ERD

View all revisions | View revisions

Also available in: Atom