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 |