Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| contactid | int4 | 10 | √ | null |
|
|
||
| aliasid | int4 | 10 | √ | null |
|
|
||
| contactname | varchar | 80 | √ | null |
|
|
||
| contactstatus | varchar | 16 | √ | null |
|
|
||
| familyname | varchar | 80 | √ | null |
|
|
||
| leadinginitials | varchar | 16 | √ | null |
|
|
||
| givennames | varchar | 80 | √ | null |
|
|
||
| suffix | varchar | 16 | √ | null |
|
|
||
| title | varchar | 16 | √ | null |
|
|
||
| phone | varchar | 64 | √ | null |
|
|
||
| fax | varchar | 64 | √ | null |
|
|
||
| varchar | 64 | √ | null |
|
|
|||
| url | varchar | 255 | √ | null |
|
|
||
| address | text | 2147483647 | √ | null |
|
|
||
| notes | text | 2147483647 | √ | null |
|
|