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[edit]
- Since:
Description[edit]
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[edit]
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