contact_overview

Jump to bottom Edit New page

hertsch edited this page Jun 15, 2014 · 2 revisions

The table contact_overview is used to generate contact lists and enable a quick search over the main contact information.

contact_overview will be updated automatically by Contact processes.

The table contains the following fields:

id - used internal
contact_id - the regular Contact ID
contact_login - the login name for the contact
contact_name
contact_type - can be PERSON or COMPANY
contact_status - can be ACTIVE, LOCKED, PENDING or DELETED
person_id - the ID of the PERSON record
person_gender
person_title
person_first_name
person_last_name
person_nick_name
person_birthday
company_id - the ID of the COMPANY record
company_name
company_department
communication_email
communication_phone
address_id - the ID of the primary address record
address_street
address_zip
address_city
address_area
address_state
address_country_code - ISO, 2 characters, i.e. de for Germany
category_id - the ID of the category
category_name
category_access - can be ADMIN or PUBLIC
tags - array of the tags assigned to the contact
order_name - the name to order the list by default
timestamp - last change of the table

Contribution to the Wiki

If you spot a typo or want to contribute an article, a how-to or a tip, feel free to edit the Wiki directly
If you you have any questions, please visit the phpManufaktur Support Forum

This Documentation is part of the kitFramework Project

© 2010, 2014 by phpManufaktur, kitFramework and Contact are published under MIT license.