Edgewall Software

Version 2 (modified by Peter Suter, 10 years ago) ( diff )

Add some clarifying notes

Trac Database Schema: Attachments

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

Table attachment

attachmenttype, id, filename
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
sizeint Attachment file site in bytes
timeint64 Time attachment was uploaded
author User name of uploader
ipnr IP address of the uploader

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

Note: See TracWiki for help on using the wiki.