Actions

Difference between revisions of "Tables/contact details"

From Joomla! Documentation

< Tables
(New page: == Usage: == * Since: == Description: == {| border="1" |+ '''contact_details Table (#__contact_details)''' |- bgcolor="lightgrey" || Field || Type || Nullable || Default || Key || Extra ...)
 
m (categorisation)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Usage: ==
+
== Usage ==
 
* Since:
 
* Since:
  
== Description: ==
+
== Description ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''contact_details Table (#__contact_details)'''
 
|+ '''contact_details Table (#__contact_details)'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
|| Field || Type || Nullable || Default || Key || Extra || Comments
 
|| 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 ==
 
== Notes ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''Indices'''
 
|+ '''Indices'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
|| Index Name || Column(s) || Unique?
 
|| 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'''
 
* Default character set: '''utf8'''
 +
 +
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 10:37, 16 March 2013

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