Project

General

Profile

Actions
Copy link

Task #562

open

flatten the mappings

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

Status:
New
Priority:
Normal
Assignee:
Aaron Marcuse-Kubitza
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
Copy link

Also available in: Atom PDF