key columns in tecdb

Of course we need to look at mapping column names in “tecdb” (the user interface database) as well as “infdb”. This is slightly different. The only suffix used is “#” which in this is used to indicate a column that is a primary/foreign key (or part of). So we will just map “wibble#” to “wibble” for this database. Any resultant name conflicts will be mapped with a leading “ing_”.

Mappings in “tecdb” will have to be replicated into the user interface build data structures so that the boot strap cache refers to the correct new names, this in itself is not difficult but it will necessitate starting a branch’ed version of the interface to do this. However this will need to be done for PostgreSQL support anyway, and putting the whole thing under version control is part of the Phase 1 work.