Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| tpid | int8 | 19 | √ | null |
|
|
|||||
| mgid | int8 | 19 | √ | null |
|
|
|||||
| networkcode | varchar | 10 | √ | null |
|
|
|||||
| tpname | varchar | 100 | √ | null |
|
|
|||||
| tpmainadrstreet1 | varchar | 250 | √ | null |
|
|
|||||
| tpmainadrstreet2 | varchar | 250 | √ | null |
|
|
|||||
| tpmainadrcity | varchar | 50 | √ | null |
|
|
|||||
| tpmainadrzipcode | varchar | 10 | √ | null |
|
|
|||||
| tpmainadrregion | varchar | 100 | √ | null |
|
|
|||||
| tptel1 | varchar | 15 | √ | null |
|
|
|||||
| tptel2 | varchar | 15 | √ | null |
|
|
|||||
| tpemail1 | varchar | 100 | √ | null |
|
|