This diagram illustrates logical columns in an Accounts
table
before and after best practices have been applied. The list on the left shows all 11
logical columns (used and unused) in an Accounts
table, with ambiguous
names such as ACCNT_REGION
, ACTIVE_FLG
,
ACCNT_HIN_NUM
, and ROW_WID
. The list on the right
shows a clean list of logical columns, that is, only used columns appear in the list
with more readable presentation names (Region
, Active
Flag
, Account Name
, Account Number
).