The table that holds details of each acronym (or glossary) item.
Table 7.4. Acronyms table description
Column Name |
Type |
Size |
Not Null? |
Constraints |
Description |
|---|---|---|---|---|---|
id |
Number |
11 |
Yes |
Primary key |
A unique numeric identification for each acronym. Populated by an auto-sequence. |
asset_id |
Int |
10 |
No |
None |
FK to the #__assets table. |
short |
Varchar |
255 |
Yes |
- |
This field contains the specific acronym, abbreviation, or Initialism to be described. |
long |
Varchar |
255 |
Yes |
- |
The expanded term for the acronym, abbreviation or Initialism item. |
alias |
Varchar |
255 |
Yes |
None |
AcronymAlias. |
description |
MediumText |
1024t |
No |
None |
The description or meaning of the acronym, Initialism or Abbreviation term. Not mandatory, but suspected will always be populated with details. |
hits |
Int |
10 |
Yes |
None |
The number of times the acronym has been viewed (individually not as part of the list). |
type |
Int |
11 |
Yes |
1 |
The type of glossary item. i.e. Acronym (1), Abbreviation (2) or Initialism (3) |
ordering |
Int |
11 |
No |
None |
The column used for ordering records. |
state |
TinyInt |
1 |
No |
None |
State of the specific record. i.e. Published, archived, trashed etc. |
language |
Character |
7 |
No |
None |
Language code. |
access |
TinyInt |
3 |
Yes |
None |
Access levels required to view the acronym [ACL] |
checked_out |
Integer |
11 |
Yes |
None |
The id of the Joomla user editing the record. |
checked_out_time |
Datetime |
na |
Yes |
None |
The date/time the record was checked out for editing. |
created_by |
Int |
11 |
Yes |
None |
The id of the Joomla user who created the article. |
created_at |
Timestamp |
- |
No |
None |
The date and time the record was created. Default NULL. |
modified_by |
Int |
11 |
Yes |
None |
The id of the Joomla user who last modified the article. |
modified_on |
Timestamp |
- |
No |
None |
If populated the date and time the record was last modified. |
created_by_alias |
Varchar |
255 |
No |
None |
The name of the user who created the item. Not yet fully implemented. |
![[Note]](/media/com_docimport/admonition/note.png) | Note |
|---|---|
|
Acronym (or Glossary) items are effectively a separate and isolated part of the component. It used the same styling and is included since a Glossary or acronym list is a stable part of Knowledgebase components. |