One additional group of tables, the temporary search result tables, will appear in the FmLib SQL Server database after the application is up and running and borrowers are making searches for library materials.
For each search made by a CML borrower a temporary table is created in the database. The tables have names like srch11189825610PM8, where the name is a concatenation of the four letters srch, the date and time, and a random number between 1 and 100. This naming scheme ensures unique table names. These tables are discussed in the topic:
When the borrower ends the session or the session times out after 20 minutes of inactivity, the temporary search result tables created by the session are deleted.