Joomla Database Table: contentitem_tag_map

This table maps Joomla tags with content item. Each tag on any content item will have one unique row in this table.

Structure of Table

1. type_alias
2. core_content_id
3. content_item_id
4. tag_id
5. tag_date
6. type_id

type_alias

Name of the component tag uses. Examples: com_content.article, com_content.category

core_content_id

It is the primary key from the core content table. The same item has the same core_content_id, regardless of how many tags you use.

content_item_id

It is primary key from the content type table.

tag_id

It is primary key taken from the tag table.

tag_date

Date and time of the most recent save for the tag item.

type_id

It is primary key from the content_types table.