Tables/contact details

Usage

• Since:

Description

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'

Notes

Indices

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