Re: Primary and Foreign Keys

[Ronald Bourret <rpbourret@rpbourret.com>]

"Bullard, Claude L (Len)" wrote:

> Another wrinkle:  going into the relational db and finding out
> that some fields and tables have the same name (noted as duplicate
> declarations in the XML Schema validation) and finding one that is
> different only the by the spelling of a single character but is
> now so deep in the code, getting rid of it would be expensive.
> For now, I will annotate and rename.  I realize I could push
> all the fields into attributes but I really don't want to.

I strongly suggest that your software be able to use different names in
XML and the database -- such as through some sort of mapping
configuration files. Users are likely to want this and it makes the
software more flexible in the long run.

-- Ron