Field	Description	Type	Null	Key	Default	Extra
id	generated index	int(10) unsigned	NO	PRI	NULL	auto_increment
aid	account_id of owner	int(10) unsigned	NO	MUL	0
uid	channel_id of owner	int(10) unsigned	NO	MUL	0
hash	hash for cross-site identification	char(64)	NO	MUL
creator	xchan_hash of author/creator	char(128)	NO	MUL
filename	filename of original	char(255)	NO	MUL
filetype	mimetype	char(64)	NO	MUL
filesize	size in bytes	int(10) unsigned	NO	MUL	0
revision	for version control (partially implemented)	int(10) unsigned	NO	MUL	0
folder	attach.hash of parent folder	char(64)	NO	MUL
flags	no longer used	int(10) unsigned	NO	MUL	0
is_dir	0 (file) or 1 to indicate a directory	tinyint	NO	MUL	0
is_photo	if 1, a photo is linked to this resource	tinyint	NO	MUL	0
os_storage	if 0, data contains content; if 1 data contains path to content (always 1 in hubzilla)	tinyint	NO	MUL	0
os_path	under construction, store the system path	mediumtext	NO	MUL	0
display_path	under construction, store the human readable path	mediumtext	NO	MUL	0
content	file data or pathname to stored data if ATTACH_FLAG_OS	longblob	NO		NULL
created	creation time	datetime	NO	MUL	0000-00-00 00:00:00
edited	last edit time	datetime	NO	MUL	0000-00-00 00:00:00
allow_cid	permissions	mediumtext	NO		NULL
allow_gid	permissions	mediumtext	NO		NULL
deny_cid	permissions	mediumtext	NO		NULL
deny_gid	permissions	mediumtext	NO		NULL

permissions are xchan_hash or group_hash surrounded by angle chars. e.g. '<abc123><xyz789>'

Return to database documentation