This topic (more or less) has come up before<//www.freelists.org/post/oracle-l/Ora-Apps-ERDs>; see also my blog posting from 2007.<http://preferisco.blogspot.com/2007/02/schema-models-fk-constraints-and-oracle.html>which I quoted at the time. Regards Nigel On 4 March 2010 15:40, Bahrami, Mary <Mary.Bahrami@xxxxxxxxxxxxxx> wrote: > It’s been a version or two since I dba’d a financials database, but you > can tell that different (non-communicating?) development teams handled the > different modules. Very frustrating to guess which of _nbr, _number, and > _num various keys used. > >