Artifacts Analysis and Utilization of Decentralized Web Service ZeroNet for Digital Forensics

Table 3

Main table structures of “content.db.”

Table Name	Description	Column name	Data type
content	Information of content.json	content_id	INTEGER
		site_id	INTEGER
		inner_path	TEXT
		size	INTEGER
		size_files	INTEGER
		size_files_optional	INTEGER
		modified	INTEGER
File_optional	Information of downloaded files	file_id	INTEGER
		site_id	INTEGER
		inner_path	TEXT
		hash_id	INTEGER
		size	INTEGER
		peer	INTEGER
		uploaded	INTEGER
		is_downloaded	INTEGER
		is_pinned	INTEGER
		time_added	INTEGER
		time_downloaded	INTEGER
		time_accessed	INTEGER
Peer	Information of peers	site_id	INTEGER
		address	TEXT
		port	INTEGER
		hashfield	BLOB
		reputation	INTERGER
		time_added	INTERGER
		time_found	INTERGER
site	Information of sites	site_id	INTEGER
		address	TEXT