Primary Keys

[Garth Keesler]

Can the PK as specified in the DBEntity be different than the PK 
actually specified in the schema? I ask because I use DB-generated 
integer sequences as the primary keys which are never used in the 
software. The software uses an abbreviated form of the vendor name that 
is forced to be unique within the table. Would it make more sense to 
specify that the shortened name is the "real" PK in the definition of 
the DBEntity (which is hand-created, not extracted from the schema)? 
FYI, this column is also used in may foreign keys. Speaking of FKs, if I 
specify a relation in the DBEntity, should it share the name of the FK 
specified in the schema or are they unrelated?

Thanx,
Garth