dev:address
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 | - | pobox.ID | ||
| GEOLOCATION | INTEGER | - | geolocation.ID |
You could leave a comment if you were logged in.
dev/address.txt · Last modified: 2019/04/09 07:11 by jan