Struktur
Feldname | Datentyp | Beschreibung |
countries_id | int(11) NOT NULL auto_increment | DATENSATZ ID |
countries_name | varchar(64) NOT NULL | Länder Name |
countries_iso_code_2 | varchar(2) NOT NULL | ISO Code 2-stellig |
countries_iso_code_3 | varchar(3) NOT NULL | ISO Code 3-stellig |
address_format_id | int(11) NOT NULL | Adressformat ID (ref. address_format) |
status | int(1) default '1' | Status (0/1) |
Indize
Indextyp | Indexname | Indexspalten |
PRIMARY KEY | countries_id | |
KEY | IDX_COUNTRIES_NAME | countries_name |