# address

## Type: table

## Columns

| Column                   | Type      | Attributes                   | Description |
| ------------------------ | --------- | ---------------------------- | ----------- |
| accountrowid             | int       |                              |             |
| addressid                | varchar   |                              |             |
| addresstypelistitemrowid | int       |                              |             |
| attention                | varchar   |                              |             |
| city                     | varchar   |                              |             |
| companyrowid             | int       |                              |             |
| contactrowid             | int       |                              |             |
| countrylistitemrowid     | int       |                              |             |
| description              | varchar   |                              |             |
| isactive                 | tinyint   |                              |             |
| isdefault                | smallint  |                              |             |
| jobrowid                 | int       |                              |             |
| noterowid                | int       |                              |             |
| phonenbr                 | varchar   |                              |             |
| relationshiprowid        | int       |                              |             |
| rowid                    | int       | auto\_increment              |             |
| state                    | varchar   |                              |             |
| streetaddress            | varchar   |                              |             |
| taskrowid                | int       |                              |             |
| transactionrowid         | int       |                              |             |
| updatetimestamp          | timestamp | on update CURRENT\_TIMESTAMP |             |
| userrowid                | int       |                              |             |
| zipcode                  | varchar   |                              |             |

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