address_book

  • Customer addresses

    Struktur

    Feldname Datentyp Beschreibung
    address_book_id int(11) NOT NULL auto_increment Datensatz ID
    customers_id int(11) NOT NULL default '0' Kunden ID (Referenz Tabelle customers)
    entry_gender char(1) NOT NULL default Geschlecht, "m" oder "f"
    entry_company varchar(32) default NULL Firma
    entry_firstname varchar(32) NOT NULL default Vorname
    entry_lastname varchar(32) NOT NULL default Nachname
    entry_street_address varchar(64) NOT NULL default Strasse
    entry_suburb varchar(32) default NULL Vorort
    entry_postcode varchar(10) NOT NULL default Postleitzahl
    entry_city varchar(32) NOT NULL default Stadt
    entry_state varchar(32) default NULL Staat oder Bundesland
    entry_country_id int(11) NOT NULL default '0' Land ID, (Ref. Tab. countries)
    entry_zone_id int(11) NOT NULL default '0' Land ID, (Ref. Tab. zones)
    address_date_added datetime default '0000-00-00 00:00:00' Datensatz Anlage
    address_last_modified datetime default '0000-00-00 00:00:00' Datensatz letzte Änderung



    Indize

    Indextyp Indexname Indexspalten
    PRIMARY KEY address_book_id
    KEY idx_address_book_customers_id customers_id

Share