When I look at the tables created in the NORMA relational view tab, I notice that some table elements are bold and some are not, and that some are prefixed by PK, FK, U# or nothing at all. Where can I find information on how to decode the meaning of all this? Thanks.
Richard
PK indicates 'primary key'.
FK indicates 'foreign key'.
U indicates a non-primary uniqueness constraint.
Numbers after the letters help you associate other columns in the same constraint.
Bold means that the column is not null.
-Matt
Matt,
Just getting back to this. Thanks for the information. This explained a lot.
I also noticed that there are also entries in the relational view tables with no indicators (PK, FK, U) They seem to correlate with objects for which there are no uniqueness constraints on their role box. I think that I probably need to take another look at section 8.5 of the Big Brown Book to understand the mapping rules/process.