Tables/categories
From Joomla! Documentation
Usage:
Description:
categories Table (#__categories)
| Field |
Type |
Nullable |
Default |
Key |
Extra |
Comments
|
| id int |
(11) |
NOT NULL |
|
PK |
auto_increment |
Category identifier.
|
| asset_id |
INTEGER UNSIGNED |
NOT NULL |
0 |
|
|
FK to the #__assets table
|
| parent_id |
int(10) unsigned |
NOT NULL |
0 |
|
|
|
| lft |
int(11) |
NOT NULL |
0 |
|
|
|
| rgt |
int(11) |
NOT NULL |
0 |
|
|
|
| level |
int(10) unsigned |
NOT NULL |
0 |
|
|
|
| path |
varchar(255) |
NOT NULL |
|
|
|
|
| extension |
varchar(50) |
NOT NULL |
|
|
|
|
| title |
varchar(255) |
NOT NULL |
|
|
|
|
| alias |
varchar(255) |
NOT NULL |
|
|
|
|
| note |
varchar(255) |
NOT NULL |
|
|
|
|
| description |
varchar(5120) |
NOT NULL |
|
|
|
|
| published |
tinyint(1) |
NOT NULL |
0 |
|
|
|
| checked_out |
int(11) unsigned |
NOT NULL |
0 |
|
|
|
| checked_out_time |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
| access |
tinyint(3) unsigned |
NOT NULL |
0 |
|
|
|
| params |
varchar(2048) |
NOT NULL |
|
|
|
|
| metadesc |
varchar(1024) |
NOT NULL |
|
|
|
The meta description for the page.
|
| metakey |
varchar(1024) |
NOT NULL |
|
|
|
The meta keywords for the page.
|
| metadata |
varchar(2048) |
NOT NULL |
|
|
|
JSON-encoded metadata properties.
|
| created_user_id |
int(10) unsigned |
NOT NULL |
0 |
|
|
|
| created_time |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
| modified_user_id |
int(10) unsigned |
NOT NULL |
0 |
|
|
|
| modified_time |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
| hits |
int(10) unsigned |
NOT NULL |
0 |
|
|
|
| language |
char(7) |
NOT NULL |
|
|
|
|
Notes
Indices
| Index Name |
Column(s) |
Unique?
|
- Default character set: utf8
