WEBDEV Concepts

Part 5: Databases 175 HFSQL: files physically created The data model editor allows you to define the structure of the data files. Different files are physically created depending on the information typed in the data model editor. Characteristics of the file (Analysis) HFSQL Classic or Client/Server file One or more search keys (unique or with duplicates) One or more full-text indexes One or more "Memo" items Files physically created ".fic" file Data file ".ndx" file Index file ".ftx" file Full-text index file ".mmo" file Memo file Note : This diagram only presents the main created files. Other specific files can be created if the data file uses replication, logs or transactions.