[[PageOutline(2)]]

= 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 ||

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 [browser:trunk/trac/attachment.py trac.attachment.Attachment]