customers_requestlist_donors

  • Customers requestlist donors

    Struktur

    Feldname Datentyp Beschreibung
    customers_requestlist_donors_id int(11) unsigned NOT NULL auto_increment DATENSATZ ID
    customers_requestlist_id varchar(32) NOT NULL Kunden Wunschlisten ID (ref.customers_requestlist)
    donors_name varchar(255) NOT NULL Erfüller Name
    donors_email varchar(255) NOT NULL Erfüller E-Mail Adresse
    mail_received enum('0','1') NOT NULL default '0' E-Mail erhalten (0/1)
    mail_code varchar(32) NOT NULL E-Mail Code
    donors_customer_id int(11) NOT NULL default '0' Erfüller Kunden ID (ref. customers)


    Indize

    Indextyp Indexname Indexspalten
    PRIMARY KEY customers_requestlist_donors_id, customers_requestlist_id

Share