customers_status

  • Customers status

    Struktur

    Feldname Datentyp Beschreibung
    customers_status_id int(11) NOT NULL default '0' DATENSATZ ID
    owner int(11) NOT NULL default '0' Eigentümer Store ID (ref. ms_store)
    language_id int(11) NOT NULL default '1' Sprach ID (ref. languages)
    customers_status_name varchar(32) NOT NULL default Kundengruppen Name
    customers_status_min_order int(7) default NULL Mindestbestellmenge
    customers_status_max_order int(7) default NULL Maximalbestellmenge
    customers_status_image varchar(64) default NULL Kundengruppen Bild
    customers_status_discount decimal(4,2) default '0.00' Rabatt
    customers_status_ot_discount_flag char(1) NOT NULL default '0' Bestellrabatt Status (0/1)
    customers_status_ot_discount decimal(4,2) default '0.00' Bestellrabatt
    customers_status_graduated_prices char(1) NOT NULL default '0' Staffelpreise (0/1)
    customers_status_show_price int(1) NOT NULL default '1' Preise sichtbar (0/1)
    customers_status_show_price_tax int(1) NOT NULL default '1' MwSt. ausweisen (0/1)
    customers_status_add_tax_ot int(1) NOT NULL default '0' MwSt. berechnen (0/1)
    customers_status_payment_unallowed varchar(255) NOT NULL default Unerlaubte Zahlweisen
    customers_status_shipping_unallowed varchar(255) NOT NULL default Unerlaubte Versandarten
    customers_status_discount_attributes int(1) NOT NULL default '0' Rabatt auf Attribute
    customers_fsk18 int(1) NOT NULL default '1' FSK18 Produkte aktivieren (0/1)
    customers_fsk18_display int(1) NOT NULL default '1' FSK18 Produkte zeigen (0/1)
    customers_status_write_reviews int(1) NOT NULL default '1' Bewertungen schreiben (0/1)
    customers_status_read_reviews int(1) NOT NULL default '1' Bewertungen lesen (0/1)
    system_default tinyint(1) unsigned default '0' Standard (0/1)


    Indize

    Indextyp Indexname Indexspalten
    PRIMARY KEY customers_status_id, language_id
    KEY idx_orders_status_name customers_status_name

Share