Tables/contact details

From Joomla! Documentation

< Tables


  • Since:


contact_details Table (#__contact_details)
Field Type Nullable Default Key Extra Comments
id integer NOT NULL PK auto_increment
name varchar(255) NOT NULL
alias varchar(255) NOT NULL
con_position varchar(255) NULL
address text
suburb varchar(100) NULL
state varchar(100) NULL
country varchar(100) NULL
postcode varchar(100) NULL
telephone varchar(255) NULL
fax varchar(255) NULL
misc mediumtext
image varchar(255) NULL
imagepos varchar(20) NULL
email_to varchar(255) NULL
default_con tinyint(1) unsigned NOT NULL 0
published tinyint(1) NOT NULL 0
checked_out integer unsigned NOT NULL 0
checked_out_time datetime NOT NULL '0000-00-00 00:00:00'
ordering integer NOT NULL 0
params text NOT NULL
user_id integer NOT NULL 0
catid integer NOT NULL 0
access tinyint(3) unsigned NOT NULL 0
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 char(7) NOT NULL
created datetime NOT NULL '0000-00-00 00:00:00'
created_by int(10) unsigned NOT NULL 0
created_by_alias varchar(255) NOT NULL
modified datetime NOT NULL '0000-00-00 00:00:00'
modified_by int(10) unsigned NOT NULL 0
metakey text NOT NULL
metadesc text NOT NULL
metadata text NOT NULL
featured tinyint(3) unsigned NOT NULL 0 Flag indicating if article is featured.
xreference varchar(50) NOT NULL A reference to enable linkages to external data sets.
publish_up datetime NOT NULL '0000-00-00 00:00:00'
publish_down datetime NOT NULL '0000-00-00 00:00:00'


Index Name Column(s) Unique?
idx_access access No
idx_checkout checked_out No
idx_state published No
idx_catid catid No
idx_createdby created_by No
idx_featured_catid featured,catid No
idx_language language No
idx_xreference xreference No
  • Default character set: utf8