Joomla
joomla 3.7 erd
Tables (72)
joomla_assets
- id — int(10) — Primary key — NOT NULL — Primary Key
- parent_id — int(10) — Foreign key → joomla_assets.id — NOT NULL — Nested set parent.
- lft — int(11) — NOT NULL — Nested set lft.
- rgt — int(11) — NOT NULL — Nested set rgt.
- level — int(10) — NOT NULL — The cached level in the nested tree.
- name — varchar(50) — NOT NULL — The unique name for the asset.\n
- title — varchar(100) — NOT NULL — The descriptive title for the asset.
- rules — varchar(5120) — NOT NULL — JSON encoded access control.
joomla_associations
- context — varchar(50) — Primary key — NOT NULL — The context of the associated item.
- id — int(11) — Primary key — NOT NULL — A reference to the associated item.
- key — char(32) — NOT NULL — The key for the association computed from an md5 on associated ids.
joomla_banner_clients
- id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- contact — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- extrainfo — text — NOT NULL
- state — tinyint(3) — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- metakey — text — NOT NULL
- own_prefix — tinyint(4) — NOT NULL
- metakey_prefix — varchar(400) — NOT NULL
- purchase_type — tinyint(4) — NOT NULL
- track_clicks — tinyint(4) — NOT NULL
- track_impressions — tinyint(4) — NOT NULL
joomla_banner_tracks
- track_date — datetime — Primary key — NOT NULL
- track_type — int(10) — Primary key — NOT NULL
- banner_id — int(10) — Foreign key → joomla_banners.id — NOT NULL
- count — int(10) — NOT NULL
joomla_banners
- id — int(11) — Primary key — NOT NULL
- cid — int(11) — Foreign key → joomla_banner_clients.id — NOT NULL
- type — int(11) — NOT NULL
- name — varchar(255) — NOT NULL
- alias — varchar(400) — NOT NULL
- imptotal — int(11) — NOT NULL
- impmade — int(11) — NOT NULL
- clicks — int(11) — NOT NULL
- clickurl — varchar(200) — NOT NULL
- state — tinyint(3) — NOT NULL
- catid — int(10) — Foreign key → joomla_categories.id — NOT NULL
- description — text — NOT NULL
- custombannercode — varchar(2048) — NOT NULL
- sticky — tinyint(1) — NOT NULL
- ordering — int(11) — NOT NULL
- metakey — text — NOT NULL
- params — text — NOT NULL
- own_prefix — tinyint(1) — NOT NULL
- metakey_prefix — varchar(400) — NOT NULL
- purchase_type — tinyint(4) — NOT NULL
- track_clicks — tinyint(4) — NOT NULL
- track_impressions — tinyint(4) — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- publish_up — datetime — NOT NULL
- publish_down — datetime — NOT NULL
- reset — datetime — NOT NULL
- created — datetime — NOT NULL
- language — char(7) — NOT NULL
- created_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- created_by_alias — varchar(255) — NOT NULL
- modified — datetime — NOT NULL
- modified_by — int(10) — NOT NULL
- version — int(10) — NOT NULL
joomla_categories
- id — int(11) — Primary key — NOT NULL
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL — FK to the #__assets table.
- parent_id — int(10) — Foreign key → joomla_categories.id — NOT NULL
- lft — int(11) — NOT NULL
- rgt — int(11) — NOT NULL
- level — int(10) — NOT NULL
- path — varchar(400) — NOT NULL
- extension — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL
- alias — varchar(400) — NOT NULL
- note — varchar(255) — NOT NULL
- description — mediumtext — NOT NULL
- published — tinyint(1) — NOT NULL
- checked_out — int(11) — NOT NULL
- checked_out_time — datetime — NOT NULL
- access — int(10) — NOT NULL
- params — text — 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) — Foreign key → joomla_users.id — NOT NULL
- created_time — datetime — NOT NULL
- modified_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- modified_time — datetime — NOT NULL
- hits — int(10) — NOT NULL
- language — char(7) — NOT NULL
- version — int(10) — NOT NULL
joomla_contact_details
- id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- alias — varchar(400) — NOT NULL
- con_position — varchar(255)
- address — text
- suburb — varchar(100)
- state — varchar(100)
- country — varchar(100)
- postcode — varchar(100)
- telephone — varchar(255)
- fax — varchar(255)
- misc — mediumtext
- image — varchar(255)
- email_to — varchar(255)
- default_con — tinyint(1) — NOT NULL
- published — tinyint(1) — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- ordering — int(11) — NOT NULL
- params — text — NOT NULL
- user_id — int(11) — Foreign key → joomla_users.id — NOT NULL
- catid — int(11) — Foreign key → joomla_categories.id — NOT NULL
- access — int(10) — NOT NULL
- mobile — varchar(255) — NOT NULL
- webpage — varchar(255) — NOT NULL
- sortname1 — varchar(255) — NOT NULL
- sortname2 — varchar(255) — NOT NULL
- sortname3 — varchar(255) — NOT NULL
- language — varchar(7) — NOT NULL
- created — datetime — NOT NULL
- created_by — int(10) — NOT NULL
- created_by_alias — varchar(255) — NOT NULL
- modified — datetime — NOT NULL
- modified_by — int(10) — NOT NULL
- metakey — text — NOT NULL
- metadesc — text — NOT NULL
- metadata — text — NOT NULL
- featured — tinyint(3) — NOT NULL — Set if contact is featured.
- xreference — varchar(50) — NOT NULL — A reference to enable linkages to external data sets.
- publish_up — datetime — NOT NULL
- publish_down — datetime — NOT NULL
- version — int(10) — NOT NULL
- hits — int(10) — NOT NULL
joomla_content
- id — int(10) — Primary key — NOT NULL
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL — FK to the #__assets table.
- title — varchar(255) — NOT NULL
- alias — varchar(400) — NOT NULL
- introtext — mediumtext — NOT NULL
- fulltext — mediumtext — NOT NULL
- state — tinyint(3) — NOT NULL
- catid — int(10) — Foreign key → joomla_categories.id — NOT NULL
- created — datetime — NOT NULL
- created_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- created_by_alias — varchar(255) — NOT NULL
- modified — datetime — NOT NULL
- modified_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- publish_up — datetime — NOT NULL
- publish_down — datetime — NOT NULL
- images — text — NOT NULL
- urls — text — NOT NULL
- attribs — varchar(5120) — NOT NULL
- version — int(10) — NOT NULL
- ordering — int(11) — NOT NULL
- metakey — text — NOT NULL
- metadesc — text — NOT NULL
- access — int(10) — NOT NULL
- hits — int(10) — NOT NULL
- metadata — text — NOT NULL
- featured — tinyint(3) — NOT NULL — Set if article is featured.
- language — char(7) — NOT NULL — The language code for the article.
- xreference — varchar(50) — NOT NULL — A reference to enable linkages to external data sets.
joomla_content_frontpage
- content_id — int(11) — Foreign key → joomla_content.id — NOT NULL
- ordering — int(11) — NOT NULL
joomla_content_rating
- content_id — int(11) — Foreign key → joomla_content.id — NOT NULL
- rating_sum — int(10) — NOT NULL
- rating_count — int(10) — NOT NULL
- lastip — varchar(50) — NOT NULL
joomla_content_types
- type_id — int(10) — Primary key — NOT NULL
- type_title — varchar(255) — NOT NULL
- type_alias — varchar(400) — NOT NULL
- table — varchar(255) — NOT NULL
- rules — text — NOT NULL
- field_mappings — text — NOT NULL
- router — varchar(255) — NOT NULL
- content_history_options — varchar(5120) — JSON string for com_contenthistory options
joomla_contentitem_tag_map
- type_alias — varchar(255) — NOT NULL
- core_content_id — int(10) — Foreign key → joomla_ucm_content.core_content_id — NOT NULL — PK from the core content table
- content_item_id — int(11) — Foreign key → joomla_content_types.type_id — NOT NULL — PK from the content type table
- tag_id — int(10) — Foreign key → joomla_tags.id — NOT NULL — PK from the tag table
- tag_date — timestamp — NOT NULL — Date of most recent save for this tag-item
- type_id — mediumint(8) — Foreign key → joomla_content_types.type_id — NOT NULL — PK from the content_type table
joomla_core_log_searches
- search_term — varchar(128) — NOT NULL
- hits — int(10) — NOT NULL
joomla_extensions
- extension_id — int(11) — Primary key — NOT NULL
- package_id — int(11) — Foreign key → joomla_extensions.extension_id — NOT NULL — Parent package ID for extensions installed as a package.
- name — varchar(100) — NOT NULL
- type — varchar(20) — NOT NULL
- element — varchar(100) — NOT NULL
- folder — varchar(100) — NOT NULL
- client_id — tinyint(3) — NOT NULL
- enabled — tinyint(3) — NOT NULL
- access — int(10) — NOT NULL
- protected — tinyint(3) — NOT NULL
- manifest_cache — text — NOT NULL
- params — text — NOT NULL
- custom_data — text — NOT NULL
- system_data — text — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- ordering — int(11)
- state — int(11)
joomla_fields
- id — int(10) — Primary key — NOT NULL
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL
- context — varchar(255) — NOT NULL
- group_id — int(10) — Foreign key → joomla_fields_groups.id — NOT NULL
- title — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- label — varchar(255) — NOT NULL
- default_value — text — NOT NULL
- type — varchar(255) — NOT NULL
- note — varchar(255) — NOT NULL
- description — text — NOT NULL
- state — tinyint(1) — NOT NULL
- required — tinyint(1) — NOT NULL
- checked_out — int(11) — NOT NULL
- checked_out_time — datetime — NOT NULL
- ordering — int(11) — NOT NULL
- params — text — NOT NULL
- fieldparams — text — NOT NULL
- language — char(7) — NOT NULL
- created_time — datetime — NOT NULL
- created_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- modified_time — datetime — NOT NULL
- modified_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- access — int(11) — NOT NULL
joomla_fields_categories
- field_id — int(10) — Foreign key → joomla_fields.id — NOT NULL
- category_id — int(11) — Foreign key → joomla_categories.id — NOT NULL
joomla_fields_groups
- id — int(10) — Primary key — NOT NULL
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL
- context — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- note — varchar(255) — NOT NULL
- description — text — NOT NULL
- state — tinyint(1) — NOT NULL
- checked_out — int(11) — NOT NULL
- checked_out_time — datetime — NOT NULL
- ordering — int(11) — NOT NULL
- language — char(7) — NOT NULL
- created — datetime — NOT NULL
- created_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- modified — datetime — NOT NULL
- modified_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- access — int(11) — NOT NULL
joomla_fields_values
- field_id — int(10) — Foreign key → joomla_fields.id — NOT NULL
- item_id — varchar(255) — NOT NULL — Allow references to items which have strings as ids, eg. none db systems.
- value — text — NOT NULL
joomla_finder_filters
- filter_id — int(10) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- alias — varchar(255) — NOT NULL
- state — tinyint(1) — NOT NULL
- created — datetime — NOT NULL
- created_by — int(10) — NOT NULL
- created_by_alias — varchar(255) — NOT NULL
- modified — datetime — NOT NULL
- modified_by — int(10) — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- map_count — int(10) — NOT NULL
- data — text — NOT NULL
- params — mediumtext
joomla_finder_links
- link_id — int(10) — Primary key — NOT NULL
- url — varchar(255) — NOT NULL
- route — varchar(255) — NOT NULL
- title — varchar(400)
- description — text
- indexdate — datetime — NOT NULL
- md5sum — varchar(32)
- published — tinyint(1) — NOT NULL
- state — int(5)
- access — int(5)
- language — varchar(8) — NOT NULL
- publish_start_date — datetime — NOT NULL
- publish_end_date — datetime — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- list_price — double — NOT NULL
- sale_price — double — NOT NULL
- type_id — int(11) — Foreign key → joomla_finder_types.id — NOT NULL
- object — mediumblob — NOT NULL
joomla_finder_links_terms0
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms1
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms2
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms3
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms4
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms5
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms6
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms7
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms8
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_terms9
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_termsa
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_termsb
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_termsc
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_termsd
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_termse
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_links_termsf
- link_id — int(10) — Primary key — NOT NULL
- term_id — int(10) — Primary key — NOT NULL
- weight — float — NOT NULL
joomla_finder_taxonomy
- id — int(10) — Primary key — NOT NULL
- parent_id — int(10) — Foreign key → joomla_finder_taxonomy.id — NOT NULL
- title — varchar(255) — NOT NULL
- state — tinyint(1) — NOT NULL
- access — tinyint(1) — NOT NULL
- ordering — tinyint(1) — NOT NULL
joomla_finder_taxonomy_map
- node_id — int(10) — Primary key — NOT NULL
- link_id — int(10) — Foreign key → joomla_finder_links.link_id — NOT NULL
joomla_finder_terms
- term_id — int(10) — Primary key — NOT NULL
- term — varchar(75) — NOT NULL
- stem — varchar(75) — NOT NULL
- common — tinyint(1) — NOT NULL
- phrase — tinyint(1) — NOT NULL
- weight — float — NOT NULL
- soundex — varchar(75) — NOT NULL
- links — int(10) — NOT NULL
- language — char(3) — NOT NULL
joomla_finder_terms_common
- term — varchar(75) — NOT NULL
- language — varchar(3) — NOT NULL
joomla_finder_tokens
- term — varchar(75) — NOT NULL
- stem — varchar(75) — NOT NULL
- common — tinyint(1) — NOT NULL
- phrase — tinyint(1) — NOT NULL
- weight — float — NOT NULL
- context — tinyint(1) — NOT NULL
- language — char(3) — NOT NULL
joomla_finder_tokens_aggregate
- term_id — int(10) — Foreign key → joomla_finder_terms.term_id — NOT NULL
- map_suffix — char(1) — NOT NULL
- term — varchar(75) — NOT NULL
- stem — varchar(75) — NOT NULL
- common — tinyint(1) — NOT NULL
- phrase — tinyint(1) — NOT NULL
- term_weight — float — NOT NULL
- context — tinyint(1) — NOT NULL
- context_weight — float — NOT NULL
- total_weight — float — NOT NULL
- language — char(3) — NOT NULL
joomla_finder_types
- id — int(10) — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- mime — varchar(100) — NOT NULL
joomla_languages
- lang_id — int(11) — Primary key — NOT NULL
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL
- lang_code — char(7) — NOT NULL
- title — varchar(50) — NOT NULL
- title_native — varchar(50) — NOT NULL
- sef — varchar(50) — NOT NULL
- image — varchar(50) — NOT NULL
- description — varchar(512) — NOT NULL
- metakey — text — NOT NULL
- metadesc — text — NOT NULL
- sitename — varchar(1024) — NOT NULL
- published — int(11) — NOT NULL
- access — int(10) — NOT NULL
- ordering — int(11) — NOT NULL
joomla_menu
- id — int(11) — Primary key — NOT NULL
- menutype — varchar(24) — NOT NULL — The type of menu this item belongs to. FK to #__menu_types.menutype
- title — varchar(255) — NOT NULL — The display title of the menu item.
- alias — varchar(400) — NOT NULL — The SEF alias of the menu item.
- note — varchar(255) — NOT NULL
- path — varchar(1024) — NOT NULL — The computed path of the menu item based on the alias field.
- link — varchar(1024) — NOT NULL — The actually link the menu item refers to.
- type — varchar(16) — NOT NULL — The type of link: Component, URL, Alias, Separator
- published — tinyint(4) — NOT NULL — The published state of the menu link.
- parent_id — int(10) — Foreign key → joomla_menu.id — NOT NULL — The parent menu item in the menu tree.
- level — int(10) — NOT NULL — The relative level in the tree.
- component_id — int(10) — Foreign key → joomla_extensions.extension_id — NOT NULL — FK to #__extensions.id
- checked_out — int(10) — Foreign key → joomla_users.id — NOT NULL — FK to #__users.id
- checked_out_time — timestamp — NOT NULL — The time the menu item was checked out.
- browserNav — tinyint(4) — NOT NULL — The click behaviour of the link.
- access — int(10) — NOT NULL — The access level required to view the menu item.
- img — varchar(255) — NOT NULL — The image of the menu item.
- template_style_id — int(10) — Foreign key → joomla_template_styles.id — NOT NULL
- params — text — NOT NULL — JSON encoded data for the menu item.
- lft — int(11) — NOT NULL — Nested set lft.
- rgt — int(11) — NOT NULL — Nested set rgt.
- home — tinyint(3) — NOT NULL — Indicates if this menu item is the home or default page.
- language — char(7) — NOT NULL
- client_id — tinyint(4) — NOT NULL
joomla_menu_types
- id — int(10) — Primary key — NOT NULL
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL
- menutype — varchar(24) — NOT NULL
- title — varchar(48) — NOT NULL
- description — varchar(255) — NOT NULL
- client_id — int(11) — NOT NULL
joomla_messages
- message_id — int(10) — Primary key — NOT NULL
- user_id_from — int(10) — Foreign key → joomla_users.id — NOT NULL
- user_id_to — int(10) — Foreign key → joomla_users.id — NOT NULL
- folder_id — tinyint(3) — NOT NULL
- date_time — datetime — NOT NULL
- state — tinyint(1) — NOT NULL
- priority — tinyint(1) — NOT NULL
- subject — varchar(255) — NOT NULL
- message — text — NOT NULL
joomla_messages_cfg
- user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- cfg_name — varchar(100) — NOT NULL
- cfg_value — varchar(255) — NOT NULL
joomla_modules
- id — int(11) — Primary key — NOT NULL
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL — FK to the #__assets table.
- title — varchar(100) — NOT NULL
- note — varchar(255) — NOT NULL
- content — text — NOT NULL
- ordering — int(11) — NOT NULL
- position — varchar(50) — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- publish_up — datetime — NOT NULL
- publish_down — datetime — NOT NULL
- published — tinyint(1) — NOT NULL
- module — varchar(50)
- access — int(10) — NOT NULL
- showtitle — tinyint(3) — NOT NULL
- params — text — NOT NULL
- client_id — tinyint(4) — NOT NULL
- language — char(7) — NOT NULL
joomla_modules_menu
- menuid — int(11) — Primary key — NOT NULL
- moduleid — int(11) — Foreign key → joomla_modules.id — NOT NULL
joomla_newsfeeds
- id — int(10) — Primary key — NOT NULL
- catid — int(11) — Foreign key → joomla_categories.id — NOT NULL
- name — varchar(100) — NOT NULL
- alias — varchar(400) — NOT NULL
- link — varchar(2048) — NOT NULL
- published — tinyint(1) — NOT NULL
- numarticles — int(10) — NOT NULL
- cache_time — int(10) — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- ordering — int(11) — NOT NULL
- rtl — tinyint(4) — NOT NULL
- access — int(10) — NOT NULL
- language — char(7) — NOT NULL
- params — text — NOT NULL
- created — datetime — NOT NULL
- created_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- created_by_alias — varchar(255) — NOT NULL
- modified — datetime — NOT NULL
- modified_by — int(10) — Foreign key → joomla_users.id — NOT NULL
- metakey — text — NOT NULL
- metadesc — text — NOT NULL
- metadata — text — NOT NULL
- xreference — varchar(50) — NOT NULL — A reference to enable linkages to external data sets.
- publish_up — datetime — NOT NULL
- publish_down — datetime — NOT NULL
- description — text — NOT NULL
- version — int(10) — NOT NULL
- hits — int(10) — NOT NULL
- images — text — NOT NULL
joomla_overrider
- id — int(10) — Primary key — NOT NULL — Primary Key
- constant — varchar(255) — NOT NULL
- string — text — NOT NULL
- file — varchar(255) — NOT NULL
joomla_postinstall_messages
- postinstall_message_id — bigint(20) — Primary key — NOT NULL
- extension_id — bigint(20) — Foreign key → joomla_extensions.extension_id — NOT NULL — FK to #__extensions
- title_key — varchar(255) — NOT NULL — Lang key for the title
- description_key — varchar(255) — NOT NULL — Lang key for description
- action_key — varchar(255) — NOT NULL
- language_extension — varchar(255) — NOT NULL — Extension holding lang keys
- language_client_id — tinyint(3) — NOT NULL
- type — varchar(10) — NOT NULL — Message type - message, link, action
- action_file — varchar(255) — RAD URI to the PHP file containing action method
- action — varchar(255) — Action method name or URL
- condition_file — varchar(255) — RAD URI to file holding display condition method
- condition_method — varchar(255) — Display condition method, must return boolean
- version_introduced — varchar(50) — NOT NULL — Version when this message was introduced
- enabled — tinyint(3) — NOT NULL
joomla_redirect_links
- id — int(10) — Primary key — NOT NULL
- old_url — varchar(2048) — NOT NULL
- new_url — varchar(2048)
- referer — varchar(2048) — NOT NULL
- comment — varchar(255) — NOT NULL
- hits — int(10) — NOT NULL
- published — tinyint(4) — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
- header — smallint(3) — NOT NULL
joomla_schemas
- version_id — varchar(20) — Primary key — NOT NULL
- extension_id — int(11) — Foreign key → joomla_extensions.extension_id — NOT NULL
joomla_session
- session_id — varchar(191) — Primary key — NOT NULL
- client_id — tinyint(3)
- guest — tinyint(4)
- time — varchar(14)
- data — mediumtext
- userid — int(11) — Foreign key → joomla_users.id
- username — varchar(150)
joomla_tags
- id — int(10) — Primary key — NOT NULL
- parent_id — int(10) — Foreign key → joomla_tags.id — NOT NULL
- lft — int(11) — NOT NULL
- rgt — int(11) — NOT NULL
- level — int(10) — NOT NULL
- path — varchar(400) — NOT NULL
- title — varchar(255) — NOT NULL
- alias — varchar(400) — NOT NULL
- note — varchar(255) — NOT NULL
- description — mediumtext — NOT NULL
- published — tinyint(1) — NOT NULL
- checked_out — int(11) — NOT NULL
- checked_out_time — datetime — NOT NULL
- access — int(10) — NOT NULL
- params — text — 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) — Foreign key → joomla_users.id — NOT NULL
- created_time — datetime — NOT NULL
- created_by_alias — varchar(255) — NOT NULL
- modified_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- modified_time — datetime — NOT NULL
- images — text — NOT NULL
- urls — text — NOT NULL
- hits — int(10) — NOT NULL
- language — char(7) — NOT NULL
- version — int(10) — NOT NULL
- publish_up — datetime — NOT NULL
- publish_down — datetime — NOT NULL
joomla_template_styles
- id — int(10) — Primary key — NOT NULL
- template — varchar(50) — NOT NULL
- client_id — tinyint(1) — NOT NULL
- home — char(7) — NOT NULL
- title — varchar(255) — NOT NULL
- params — text — NOT NULL
joomla_ucm_base
- ucm_id — int(10) — Primary key — NOT NULL
- ucm_item_id — int(10) — Foreign key → joomla_content_types.type_id — NOT NULL
- ucm_type_id — int(11) — Foreign key → joomla_content_types.type_id — NOT NULL
- ucm_language_id — int(11) — Foreign key → joomla_languages.lang_id — NOT NULL
joomla_ucm_content
- core_content_id — int(10) — Primary key — NOT NULL
- core_type_alias — varchar(400) — NOT NULL — FK to the content types table
- core_title — varchar(400) — NOT NULL
- core_alias — varchar(400) — NOT NULL
- core_body — mediumtext — NOT NULL
- core_state — tinyint(1) — NOT NULL
- core_checked_out_time — varchar(255) — NOT NULL
- core_checked_out_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- core_access — int(10) — NOT NULL
- core_params — text — NOT NULL
- core_featured — tinyint(4) — NOT NULL
- core_metadata — varchar(2048) — NOT NULL — JSON encoded metadata properties.
- core_created_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- core_created_by_alias — varchar(255) — NOT NULL
- core_created_time — datetime — NOT NULL
- core_modified_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL — Most recent user that modified
- core_modified_time — datetime — NOT NULL
- core_language — char(7) — NOT NULL
- core_publish_up — datetime — NOT NULL
- core_publish_down — datetime — NOT NULL
- core_content_item_id — int(10) — Foreign key → joomla_content_types.type_id — NOT NULL — ID from the individual type table
- asset_id — int(10) — Foreign key → joomla_assets.id — NOT NULL — FK to the #__assets table.
- core_images — text — NOT NULL
- core_urls — text — NOT NULL
- core_hits — int(10) — NOT NULL
- core_version — int(10) — NOT NULL
- core_ordering — int(11) — NOT NULL
- core_metakey — text — NOT NULL
- core_metadesc — text — NOT NULL
- core_catid — int(10) — Foreign key → joomla_categories.id — NOT NULL
- core_xreference — varchar(50) — NOT NULL — A reference to enable linkages to external data sets.
- core_type_id — int(10) — Foreign key → joomla_content_types.type_id — NOT NULL
joomla_ucm_history
- version_id — int(10) — Primary key — NOT NULL
- ucm_item_id — int(10) — Foreign key → joomla_content_types.type_id — NOT NULL
- ucm_type_id — int(10) — Foreign key → joomla_content_types.type_id — NOT NULL
- version_note — varchar(255) — NOT NULL — Optional version name
- save_date — datetime — NOT NULL
- editor_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- character_count — int(10) — NOT NULL — Number of characters in this version.
- sha1_hash — varchar(50) — NOT NULL — SHA1 hash of the version_data column.
- version_data — mediumtext — NOT NULL — json-encoded string of version data
- keep_forever — tinyint(4
joomla_update_sites
- update_site_id — int(11) — Primary key — NOT NULL
- name — varchar(100)
- type — varchar(20)
- location — text — NOT NULL
- enabled — int(11)
- last_check_timestamp — bigint(20)
- extra_query — varchar(1000)
joomla_update_sites_extensions
- extension_id — int(11) — Foreign key → joomla_extensions.extension_id — NOT NULL
- update_site_id — int(11) — Foreign key → joomla_update_sites.update_site_id — NOT NULL
joomla_updates
- update_id — int(11) — Primary key — NOT NULL
- update_site_id — int(11) — Foreign key → joomla_update_sites.update_site_id
- extension_id — int(11) — Foreign key → joomla_extensions.extension_id
- name — varchar(100)
- description — text — NOT NULL
- element — varchar(100)
- type — varchar(20)
- folder — varchar(20)
- client_id — tinyint(3)
- version — varchar(32)
- data — text — NOT NULL
- detailsurl — text — NOT NULL
- infourl — text — NOT NULL
- extra_query — varchar(1000)
joomla_user_keys
- id — int(10) — Primary key — NOT NULL
- user_id — varchar(150) — NOT NULL
- token — varchar(255) — NOT NULL
- series — varchar(191) — NOT NULL
- invalid — tinyint(4) — NOT NULL
- time — varchar(200) — NOT NULL
- uastring — varchar(255) — NOT NULL
joomla_user_notes
- id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- catid — int(10) — NOT NULL
- subject — varchar(100) — NOT NULL
- body — text — NOT NULL
- state — tinyint(3) — NOT NULL
- checked_out — int(10) — NOT NULL
- checked_out_time — datetime — NOT NULL
- created_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- created_time — datetime — NOT NULL
- modified_user_id — int(10) — Foreign key → joomla_users.id — NOT NULL
- modified_time — datetime — NOT NULL
- review_time — datetime — NOT NULL
- publish_up — datetime — NOT NULL
- publish_down — datetime — NOT NULL
joomla_user_profiles
- user_id — int(11) — Foreign key → joomla_users.id — NOT NULL
- profile_key — varchar(100) — NOT NULL
- profile_value — text — NOT NULL
- ordering — int(11) — NOT NULL
joomla_user_usergroup_map
- user_id — int(10) — Foreign key → joomla_users.id — NOT NULL — Foreign Key to #__users.id
- group_id — int(10) — Foreign key → joomla_usergroups.id — NOT NULL — Foreign Key to #__usergroups.id
joomla_usergroups
- id — int(10) — Primary key — NOT NULL — Primary Key
- parent_id — int(10) — Foreign key → joomla_usergroups.id — NOT NULL — Adjacency List Reference Id
- lft — int(11) — NOT NULL — Nested set lft.
- rgt — int(11) — NOT NULL — Nested set rgt.
- title — varchar(100) — NOT NULL
joomla_users
- id — int(11) — Primary key — NOT NULL
- name — varchar(400) — NOT NULL
- username — varchar(150) — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
- block — tinyint(4) — NOT NULL
- sendEmail — tinyint(4)
- registerDate — datetime — NOT NULL
- lastvisitDate — datetime — NOT NULL
- activation — varchar(100) — NOT NULL
- params — text — NOT NULL
- lastResetTime — datetime — NOT NULL — Date of last password reset
- resetCount — int(11) — NOT NULL — Count of password resets since lastResetTime
- otpKey — varchar(1000) — NOT NULL — Two factor authentication encrypted keys
- otep — varchar(1000) — NOT NULL — One time emergency passwords
- requireReset — tinyint(4) — NOT NULL — Require user to reset password on next login
joomla_utf8_conversion
- converted — tinyint(4) — NOT NULL
joomla_viewlevels
- id — int(10) — Primary key — NOT NULL — Primary Key
- title — varchar(100) — NOT NULL
- ordering — int(11) — NOT NULL
- rules — varchar(5120) — NOT NULL — JSON encoded access control.