Trader addresses with invoice/delivery/main-address flags.
| # | Name | Type | Key | Nullable | Default | Comment |
|---|---|---|---|---|---|---|
| 1 | traderid | varchar(20) | PRI | NO | - | - |
| 2 | addressid | varchar(30) | PRI | NO | - | - |
| 3 | street | varchar(255) | - | YES | - | - |
| 4 | city | varchar(80) | - | YES | - | - |
| 5 | county | varchar(80) | - | YES | - | - |
| 6 | postcode | varchar(15) | MUL | YES | - | - |
| 7 | countryid | varchar(3) | - | NO | - | - |
| 8 | areaid | varchar(30) | - | YES | - | - |
| 9 | currencyid | varchar(3) | - | YES | - | - |
| 10 | vatcatid | varchar(1) | - | YES | - | - |
| 11 | nlcatid | varchar(4) | - | YES | - | - |
| 12 | isexportaddress | tinyint(1) | - | NO | 0 | - |
| 13 | isforeigndomcurrency | tinyint(1) | - | NO | 0 | - |
| 14 | isexchfixedatorder | tinyint(1) | - | NO | 0 | - |
| 15 | discountband | varchar(4) | - | YES | - | - |
| 16 | pricelistid | varchar(20) | - | YES | - | - |
| 17 | vatreg | varchar(15) | - | YES | - | - |
| 18 | eudeliveryid | varchar(3) | - | YES | - | - |
| 19 | eutransportid | smallint | - | YES | - | - |
| 20 | languageid | varchar(8) | - | NO | - | - |
| 21 | ourcontact | varchar(36) | - | YES | - | - |
| 22 | isackaddress | tinyint(1) | - | NO | 0 | - |
| 23 | isdeladdress | tinyint(1) | - | NO | 0 | - |
| 24 | isinvaddress | tinyint(1) | - | NO | 0 | - |
| 25 | ismainaddress | tinyint(1) | - | NO | 0 | - |
| 26 | isstataddress | tinyint(1) | - | NO | 0 | - |
| 27 | tradertype | varchar(2) | PRI | NO | - | - |
| 28 | createdby | varchar(36) | - | YES | - | - |
| 29 | createddate | timestamp | - | YES | CURRENT_TIMESTAMP | - |
| 30 | modifiedby | varchar(36) | - | YES | - | - |
| 31 | modifieddate | datetime(6) | - | YES | - | - |
| 32 | auditoperation | varchar(8) | - | YES | - | - |
| 33 | modifiedtimestamp | binary(8) | - | NO | - | - |
| 34 | traderaddressreference | varchar(30) | - | YES | - | - |
| 35 | companyid | varchar(30) | - | YES | - | - |
| 36 | ean | varchar(13) | - | YES | - | - |
| 37 | olversionnumber | int | - | NO | 0 | - |
| 38 | preferredengineerid | varchar(36) | - | YES | - | - |
| 39 | excludedengineerid | varchar(36) | - | YES | - | - |
| 40 | uuid | varchar(36) | UNI | NO | - | - |
| 41 | latitude | decimal(15,12) | - | YES | - | - |
| 42 | longitude | decimal(15,12) | - | YES | - | - |
| 43 | isavailableoffline | tinyint(1) | - | YES | - | - |
| 44 | eorinumber | varchar(17) | - | YES | - | - |
| 45 | xieorinumber | varchar(17) | - | YES | - | - |
| Name | Unique | Columns |
|---|---|---|
| ck_tauuid | Yes | uuid |
| PRIMARY | Yes | traderid, tradertype, addressid |
| i_ta_postcode | No | postcode |
| ix_tradad_clust | No | traderid, addressid, tradertype |
| ix_tradadd_address | No | traderid, addressid, tradertype, postcode, street, city, countryid |
| ix_traders_ismain | No | traderid, ismainaddress |
| Column | References |
|---|---|
| No enforced foreign keys found for this table. | |