Trac Database Schema: Attachments

Trac's attachment module uses just a single database table.

Table attachment

Table	Key
attachment	type, id, filename

Columns	Type	Notes
type		Realm (e.g. wiki for wiki page attachments, ticket for ticket attachments)
id		Resource id (ticket id or wiki page name)
filename		Attachment file name
size	int	Attachment file size in bytes
time	int64	Time attachment was uploaded
description
author		User name of uploader
ipnr		IP address of the uploader Removed in Trac 1.3.1 (see #9612)

Stores metadata describing the attachments of e.g. Wiki pages or tickets. The actual file contents are stored on disk, not in the DB.

Use the trac.attachment.Attachment model class to access this table.

See trac.attachment.Attachment​