kb_attachment table

kb_attachment Table (284)

This table connects FAQ entries to attachments.

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
entry_id	The id of the corresponding kb_entry.	FK kb_entry	No
attachment_id	The id of the corresponding kb_category.	FK attachment	No

Fields	Types	Description
entry_id	FK	Index
attachment_id	FK	Index

Table	Description
attachment	This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table.
kb_entry	This table contains FAQ entries.