11.1SjoergThere are three tables in the database at present: 21.1Sjoerg 31.1Sjoerg(1) mandb: 41.1Sjoerg This is the main FTS table which contains all the content from 51.1Sjoerg man pages 61.1Sjoerg 71.1Sjoerg COLUMN NAME DESCRIPTION 81.1Sjoerg 1. section Section number of the page 91.1Sjoerg 2. name The name of the page 101.1Sjoerg 3. name_desc The one line description from the NAME section 111.1Sjoerg 4. desc Contains the content from DESCRIPTION 121.1Sjoerg section and any other section which 131.1Sjoerg is not indexed in a separate column. 141.1Sjoerg 5. lib The LIBRARY section 151.1Sjoerg 6. return_vals RETURN VALUES section 161.1Sjoerg 7. env ENVIRONMENT section 171.1Sjoerg 8. files FILES section 181.1Sjoerg 9. exit_status EXIT STATUS section 191.1Sjoerg 10. diagnostics DIAGNOSTICS section 201.1Sjoerg 11. errors ERRORS section 211.1Sjoerg 12. md5_hash md5 hash of the man page (UNIQUE) 221.1Sjoerg 13. machine The machine architecture (if any) for which this page is 231.1Sjoerg relevant. 241.1Sjoerg 251.1Sjoerg(2) mandb_meta: 261.1Sjoerg This table contains md5 hashes of all the indexed man 271.1Sjoerg pages. This is there to make sure we do not index 281.1Sjoerg the same man page twice, i.e. to prevent indexing 291.1Sjoerg hardlinks. 301.1Sjoerg 311.1Sjoerg COLUMN NAME DESCRIPTION 321.1Sjoerg 1. device (dev_t)Logical device number from stat(2) 331.1Sjoerg 2. inode (ino_t)Inode number from stat(2) 341.1Sjoerg 3. mtime Last modification time from stat(2) 351.1Sjoerg 4. file Absolute path name (UNIQUE constraint) 361.1Sjoerg 5. md5_hash MD5 Hash of the man page (UNIQUE) 371.1Sjoerg 6. id A unique integer ID for the page, which 381.1Sjoerg refers to the docid column in mandb (Implicit foreign 391.1Sjoerg key?) PRIMARY KEY 401.1Sjoerg {device, inode} form a UNIQUE index 411.1Sjoerg 421.1Sjoerg(3) mandb_links: 431.1Sjoerg This is an index of all the hard/soft links of the man 441.1Sjoerg pages. The list of the linked pages is usually obtained 451.1Sjoerg from the multiple .Nm entries in the page. 461.1Sjoerg 471.1Sjoerg COLUMN NAME DESCRIPTION 481.1Sjoerg 1. link The name of the hard/soft link (index) 491.1Sjoerg 2. target Name of the target page to which it points 501.1Sjoerg 3. section The section number 511.1Sjoerg 4. machine The machine architecture (if any) for which 521.1Sjoerg the page is relevant 531.2Swiz 5. md5_hash MD5 Hash of the target man page. 541.3Sleot 6. name_desc The one line description from the NAME section 55