[[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'''||
||''type''|| ||
||''id''|| ||
||''filename''|| ||
||''size''||`int`||
||''time''||`int64`||
||''description''|| ||
||''author''|| ||
||''ipnr''|| ||

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]