kb_attachment Table (284)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table connects FAQ entries to attachments.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| entry_id | The id of the corresponding kb_entry. | FK kb_entry | |
| attachment_id | The id of the corresponding kb_category. | FK attachment |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| entry_id | FK | Index |
| attachment_id | FK | Index |
Relationships
| 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. |
Replication Flags
- None
Security Flags
- No access control via user's Role.