coupon_redeem_track

  • Redeemed coupon log

    Struktur

    Feldname Datentyp Beschreibung
    unique_id int(11) NOT NULL auto_increment DATENSATZ ID
    coupon_id int(11) NOT NULL default '0' Kupon ID (ref. coupons)
    customer_id int(11) NOT NULL default '0' Kunden ID (ref. customers)
    redeem_date datetime NOT NULL default '0000-00-00 00:00:00' Eingelöst am
    redeem_ip varchar(32) NOT NULL default IP-Adresse
    order_id int(11) NOT NULL default '0' Bestell ID (ref. orders)


    Indize

    Indextyp Indexname Indexspalten
    PRIMARY KEY unique_id

Share