Project

General

Profile

Actions

Task #562

open

flatten the mappings

Added by Aaron Marcuse-Kubitza about 11 years ago. Updated about 10 years ago.

Status:
New
Priority:
Normal
Start date:
02/14/2013
Due date:
% Done:

0%

Estimated time:
Activity type:

Description

  • put the destination table at the beginning of the mapping, rather than nesting it within a hierarchy of tables it has fkeys to
  • requires #561 to be done because autogenerated pkeys require the nested normalization format to be propagated properly
  • note that normalized VegCore's traceable.id_by_source now provides an alternate pkey that can be used for duplicate-merging when the referenced table provides enough for a natural key (causing a natural key to be used for traceable.id), but the referencing table uses a source-specific numeric key (which is enough for a collision on traceable.id_by_source but not traceable.id)
Actions #1

Updated by Aaron Marcuse-Kubitza over 10 years ago

  • Status changed from New to Rejected

autopopulated natural pkeys actually do require the nested mappings, but these can be part of the schema instead

Actions #2

Updated by Aaron Marcuse-Kubitza about 10 years ago

  • Status changed from Rejected to New

normalized VegCore's traceable.id_by_source now provides an alternate pkey that can be used for duplicate-merging, so that the flattening can still work

Actions #3

Updated by Aaron Marcuse-Kubitza about 10 years ago

  • Description updated (diff)
Actions

Also available in: Atom PDF