Tusho currently uses two main tables:
scan_runsEach crawl creates one row in scan_runs. That row records:
file_system_entriesEach discovered entry becomes one row in file_system_entries.
Important columns:
absolute_pathparent_directory_pathentry_nameentry_typesymbolic_link_target_pathpermissions_octal_textfile_size_bytesowner_user_identifierowner_group_identifierinode_numberdevice_numberhard_link_countlast_write_time_utc_textlast_status_change_time_utc_textwas_accessiblescan_run_identifierStoring paths as text makes search and web rendering simple. It also lets administrators inspect the catalog directly with ordinary SQLite queries.