countries

  • Countries

    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

Share