coupon_gv_queue

  • Coupon Queue

    Struktur

    Feldname Datentyp Beschreibung
    unique_id int(5) NOT NULL auto_increment DATENSATZ ID
    customer_id int(5) NOT NULL default '0' Kunden ID (ref. customers)
    order_id int(5) NOT NULL default '0' Bestell ID (ref. orders)
    amount decimal(8,4) NOT NULL default '0.0000' Betrag
    date_created datetime NOT NULL default '0000-00-00 00:00:00' Erstellt am
    ipaddr varchar(32) NOT NULL default IP-Adresse
    release_flag char(1) NOT NULL default 'N' Eingelöst (N/Y)


    Indize

    Indextyp Indexname Indexspalten
    PRIMARY KEY unique_id
    KEY uid unique_id, customer_id, order_id

Share