Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | INT | 10 | 0 |
|
|
||||||
| ACCOUNTID | INT | 10 | null |
|
|
||||||
| TYPEID | INT | 10 | null |
|
|
||||||
| NAME | VARCHAR | 60 | null |
|
|
||||||
| ADDRESS1 | VARCHAR | 90 | √ | null |
|
|
|||||
| ADDRESS2 | VARCHAR | 90 | √ | null |
|
|
|||||
| ADDRESS3 | VARCHAR | 90 | √ | null |
|
|
|||||
| CITY | VARCHAR | 30 | √ | null |
|
|
|||||
| STATEID | INT | 10 | √ | null |
|
|
|||||
| ZIP | VARCHAR | 10 | √ | null |
|
|
|||||
| COUNTRYID | INT | 10 | √ | null |
|
|
|||||
| DEFAULTFLAG | BIT | 1 | null |
|
|
||||||
| RESIDENTIALFLAG | BIT | 1 | null |
|
|