User Tools

Site Tools


rev:address

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

rev:address [2019/04/09 07:34] (current)
Line 1: Line 1:
 +=== address ===
 +^ name ^ type ^ comment ^ NOT NULL ^ primary key ^ foreign key ^
 +| ID| INTEGER | unique address ID| X | X |  |
 +| NAME1 | VARCHAR | first part of name |  |  |  |
 +| NAME2 | VARCHAR | second part of name |  |  |  |
 +| NAME3 | VARCHAR | third part of name |  |  |  |
 +| ISO_3166ID | VARCHAR | 2 Char country code | X |  |  |
 +| STREET | VARCHAR |  | X |  |  |
 +| HOUSE_NUMBER | VARCHAR |  |  |  |  |
 +| CITY | VARCHAR |  | X |  |  |
 +| ZIP | VARCHAR |  | X |  |  |
 +| STATE | VARCHAR |  | |  |  |
 +| COMMUNITY_ID | INTEGER | local community ID | |  |  |
 +| POBOX | INTEGER | - |  |  | [[rev:pobox | pobox.ID ]] |
 +| GEOLOCATION | INTEGER | - |  |  | [[rev:​geolocation | geolocation.ID ]] |
  
 + 
 +~~DISCUSSION:​closed~~
rev/address.txt ยท Last modified: 2019/04/09 07:34 (external edit)

Statement on Data Protection | Imprint