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.