# contact

## Type: table

## Columns

| Column                       | Type      | Attributes                   | Description |
| ---------------------------- | --------- | ---------------------------- | ----------- |
| accountrowid                 | int       |                              |             |
| addressrowid                 | int       |                              |             |
| alternatephonenbr            | varchar   |                              |             |
| attention                    | varchar   |                              |             |
| companyname                  | varchar   |                              |             |
| companyrowid                 | int       |                              |             |
| contactid                    | varchar   |                              |             |
| contacttypelistitemrowid     | int       |                              |             |
| description                  | varchar   |                              |             |
| emailaddress                 | varchar   |                              |             |
| faxnbr                       | varchar   |                              |             |
| firstactivitydate            | datetime  |                              |             |
| firstname                    | varchar   |                              |             |
| isactive                     | tinyint   |                              |             |
| jobrowid                     | int       |                              |             |
| languagelistitemrowid        | varchar   |                              |             |
| lastname                     | varchar   |                              |             |
| mailtoname                   | varchar   |                              |             |
| middlename                   | varchar   |                              |             |
| mobilenbr                    | varchar   |                              |             |
| noterowid                    | int       |                              |             |
| phonenbr                     | varchar   |                              |             |
| relationshiprowid            | int       |                              |             |
| rowid                        | int       | auto\_increment              |             |
| salespersonrelationshiprowid | int       |                              |             |
| suffix                       | varchar   |                              |             |
| taskrowid                    | int       |                              |             |
| title                        | varchar   |                              |             |
| transactionrowid             | int       |                              |             |
| updatetimestamp              | timestamp | on update CURRENT\_TIMESTAMP |             |
| userrowid                    | int       |                              |             |

v.ismain -- Wed, Feb 28, 2018 2:58 PM
