SQL INTERFACE Clause Samples

SQL INTERFACE. The SQL table structures along with the changes of field values will constitute the SQL interface. Any other program that needs to coordinate with the provisioning system will monitor these tables and use them. Aside from the common tables, which form the interface with other programs, some private tables will also be used. Their structures will not be discussed in this section. The tables will be designed and maintained with the following requirements in mind. - Any changes to a record should not merely overwrite old data, but the old data must get backed up before being overwritten. - There should be minimum possible data duplication. This means that one piece of information should be stored at one place only (This does not include data mirroring). - Full time stamp and user information should be maintained for all changes made to the configuration. User information may be redundant in some cases. - Auto-increment integers are to be used as keys. - The database will be mirrored and this might become an important factor in table design.