Table: contact_address

KB43 Last reviewed 27 November 2013
A description of the contact_address table within the Camino CMS database schema.

Generic store holding contact information (address, telephone, email etc) for a variety of owners including user accounts, and organisations.

Field Type Null Key Default Description
address_id int(10) No Primary, Multiple
creator_uid int(10) No 0 The ID of the user who created the record
owner_name varchar(50) Yes Multiple The identity of the object who 'owns' the record
owner_id int(20) No Multiple 0 The ID of the object who 'owns' the record
address_description varchar(100) Yes A short description or title
address_line1 varchar(100) Yes Address Line 1 (typically building number)
address_line2 varchar(100) Yes Address Line 2 (e.g. road name)
address_towncity varchar(100) Yes Address Town
address_county varchar(100) Yes County, state or region
address_postcode varchar(10) Yes Post or zip code
address_telephone varchar(20) Yes Telephone number
address_fax varchar(20) Yes Fax Number
address_mobile varchar(2) Yes Mobile or cellphone number
address_email varchar(20) Yes Email address
address_isprimary tinyint(2) No address_primary 1 or 0 - used to indicate whether this is the primary record for the owner
address_created datetime No 0000-00-00 00:00:00 The timestamp when the record was created
address_lastmodified datetime No 0000-00-00 00:00:00 The timestamp when the record was last modified

Indexes

Keyname Type Cardinality Field(s)
PRIMARY PRIMARY 0 address_id
owner_name INDEX None owner_name
owner_id INDEX None owner_id
owner_details INDEX None owner_name,owner_id
address_primary INDEX None address_id,address_isprimary
3
Please wait, loading ...
Copyright © 2011 - 2017 Calzada Media Limited. All Rights Reserved.