| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int4 | 10 | √ | null |
|
|
Contact ID |
|||||||||||||||||||
| owneruser | int4 | 10 | √ | null |
|
|
Owner user ID (PUBLIC if |
|||||||||||||||||||
| ownergroup | int4 | 10 | √ | null |
|
|
Owner group ID (PUBLIC if |
|||||||||||||||||||
| creator | int4 | 10 | √ | null |
|
|
Creator user ID (defaults to authenticated user on creation) |
|||||||||||||||||||
| assigneduser | int4 | 10 | √ | null |
|
|
Assigned user ID |
|||||||||||||||||||
| creationdate | int8 | 19 | date_part('epoch'::text, now()) |
|
|
Creation date and time as a Unix time stamp (defaults to current date and time on creation) |
||||||||||||||||||||
| lastmodified | int8 | 19 | date_part('epoch'::text, now()) |
|
|
Last modification date and time as a Unix time stamp (auto-reset on modification) |
||||||||||||||||||||
| picbinfile | int4 | 10 | √ | null |
|
|
||||||||||||||||||||
| visibility | int2 | 5 | 0 |
|
|
Visibility ( |
||||||||||||||||||||
| lastname | text | 2147483647 | ''::text |
|
|
Last name (surname or company name); is required if |
||||||||||||||||||||
| firstname | text | 2147483647 | ''::text |
|
|
First name (given name); is required if |
||||||||||||||||||||
| type | int2 | 5 | 0 |
|
|
Contact type ( |
||||||||||||||||||||
| title | text | 2147483647 | ''::text |
|
|
Title or salutation (only for PERSON) |
||||||||||||||||||||
| company | text | 2147483647 | ''::text |
|
|
Company name (only for PERSON) |
||||||||||||||||||||
| position | text | 2147483647 | ''::text |
|
|
Position or job title (only for PERSON) |
||||||||||||||||||||
| department | text | 2147483647 | ''::text |
|
|
Department (only for PERSON) |
||||||||||||||||||||
| address | text | 2147483647 | ''::text |
|
|
Address (street and building/suite number) |
||||||||||||||||||||
| postalcode | text | 2147483647 | ''::text |
|
|
Postal or ZIP code |
||||||||||||||||||||
| city | text | 2147483647 | ''::text |
|
|
City or municipality |
||||||||||||||||||||
| region | text | 2147483647 | ''::text |
|
|
Region or state |
||||||||||||||||||||
| country | varchar | 2 | ''::character varying |
|
|
Country code (ISO 3166-1 alpha-2) (Pattern: |
||||||||||||||||||||
| phone | text | 2147483647 | ''::text |
|
|
Primary phone number |
||||||||||||||||||||
| phone2 | text | 2147483647 | ''::text |
|
|
Secondary phone number |
||||||||||||||||||||
| cell | text | 2147483647 | ''::text |
|
|
Cell phone number |
||||||||||||||||||||
| fax | text | 2147483647 | ''::text |
|
|
Fax number |
||||||||||||||||||||
| text | 2147483647 | ''::text |
|
|
Primary e-mail address |
|||||||||||||||||||||
| email2 | text | 2147483647 | ''::text |
|
|
Secondary e-mail address |
||||||||||||||||||||
| website | text | 2147483647 | ''::text |
|
|
Website URL |
||||||||||||||||||||
| birthdate | int8 | 19 | √ | null |
|
|
Birth date as a Unix time stamp (only for PERSON) |
|||||||||||||||||||
| description | text | 2147483647 | ''::text |
|
|
Detailed general description |
Table contained 0 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_contacts | Primary key | Asc | ID |
| i_contacts_lastname_firstname_ID | Performance | Asc/Asc/Asc | lastname + firstname + ID |
| i_contacts_noowner | Performance | Asc | ownergroup |
| i_contacts_owner | Performance | Asc/Asc/Asc | owneruser + ownergroup + assigneduser |
| s_contacts | Performance | Asc/Asc/Asc/Asc/Asc | lastname + firstname + company + email + email2 |
