1There are three tables in the database at present: 2 3(1) mandb: 4 This is the main FTS table which contains all the content from 5 man pages 6 7 COLUMN NAME DESCRIPTION 8 1. section Section number of the page 9 2. name The name of the page 10 3. name_desc The one line description from the NAME section 11 4. desc Contains the content from DESCRIPTION 12 section and any other section which 13 is not indexed in a separate column. 14 5. lib The LIBRARY section 15 6. return_vals RETURN VALUES section 16 7. env ENVIRONMENT section 17 8. files FILES section 18 9. exit_status EXIT STATUS section 19 10. diagnostics DIAGNOSTICS section 20 11. errors ERRORS section 21 12. md5_hash md5 hash of the man page (UNIQUE) 22 13. machine The machine architecture (if any) for which this page is 23 relevant. 24 25(2) mandb_meta: 26 This table contains md5 hashes of all the indexed man 27 pages. This is there to make sure we do not index 28 the same man page twice, i.e. to prevent indexing 29 hardlinks. 30 31 COLUMN NAME DESCRIPTION 32 1. device (dev_t)Logical device number from stat(2) 33 2. inode (ino_t)Inode number from stat(2) 34 3. mtime Last modification time from stat(2) 35 4. file Absolute path name (UNIQUE constraint) 36 5. md5_hash MD5 Hash of the man page (UNIQUE) 37 6. id A unique integer ID for the page, which 38 refers to the docid column in mandb (Implicit foreign 39 key?) PRIMARY KEY 40 {device, inode} form a UNIQUE index 41 42(3) mandb_links: 43 This is an index of all the hard/soft links of the man 44 pages. The list of the linked pages is usually obtained 45 from the multiple .Nm entries in the page. 46 47 COLUMN NAME DESCRIPTION 48 1. link The name of the hard/soft link (index) 49 2. target Name of the target page to which it points 50 3. section The section number 51 4. machine The machine architecture (if any) for which 52 the page is relevant 53 5. md5_hash MD5 Hash of the target man page. 54