        information about this node is not (yet) present.
 
      base-deleted: the underlying BASE node has been marked for deletion due
-       to a delete or a move-away (see the moved_to column to determine).  */
+       to a delete or a move-away (see the moved_to column to determine
+       which), and has not been replaced.  */
   presence  TEXT NOT NULL,
 
   /* the kind of the new node. may be "unknown" if the node is not present. */

  copyfrom_repos_path  TEXT,
  copyfrom_revnum  INTEGER,

  /* Boolean value, specifying if this node was moved here (rather than just
     copied). The source of the move is specified in copyfrom_*.  */
  moved_here  INTEGER,

  /* If the underlying node was moved (rather than just deleted), this
     specifies the local_relpath of where the BASE node was moved to.
     This is set only on the root of a move, and implied for all children.
     The whole moved subtree is marked with presence=base-deleted

     Note that moved_to never refers to *this* node. It always refers
     to the "underlying" node, whether that is BASE or a child node

  /* for kind==symlink, this specifies the target. */
  symlink_target  TEXT,

  /* Where this node was copied/moved from. All copyfrom_* fields are set
     only on the root of the operation, and are NULL for all children. */
  copyfrom_repos_id  INTEGER REFERENCES REPOSITORY (id),
  /* ### BH: Should we call this copyfrom_repos_relpath and skip the initial '/'
     ### to match the other repository paths used in sqlite and to make it easier
