README

Lists data on fonts installed on the system.

Due to limitations with how the script is ran, it does not list details about user installed fonts (~/Library/Fonts). Only those in /Library/Fonts/ are listed.

Table Schema

• name - varchar(255) - name of the font file
• enabled - int - 0/1 is the font file enabled
• type_name - varchar(255) - typeface name
• fullname - varchar(255) - full name of font
• type_enabled - int - 0/1 typeface enabled
• valid - int - 0/1 font is valid
• duplicate - int - 0/1 duplicate font
• path - text - full path to font file
• type - varchar(255) - font file type
• family - varchar(255) - family group
• style - vharchar(255) - style of typeface
• version - varchar(255) - version of font
• embeddable - int - 0/1 is font embeddable
• outline - int 0/1
• unique_id - varchar(255) - unique ID of font
• copyright - text - copyright information about the font
• copy_protected - int - 0/1 copy protected
• description - text - short description about font
• vendor - text - font vendor
• designer - text - designer of the font
• trademark - text - font trademark