Ecshop Common promotional Activity table structure

Promotional activities

SQL code

----Table structure for table ' ecs_favourable_activity '--CREATETABLEIF not EXISTS ' ecs_favourable_activity ' (' act_id 'smallint(5) unsigned not NULL auto_increment,---self-increasing ID ' act_name 'varchar(255) Not NULL,--activity name ' start_time 'int(a) unsigned not NULL,--start time ' end_time 'int(a) unsigned not NULL,--end time ' User_rank 'varchar(255) NOT NULL,--participating member rank ' act_range ' tinyint (3) unsigned NOT null,--preferential range; 0, all goods; 1, by category; 2 by Brand; 3, by Product ' Act_range_ext `varchar(255) Not NULL,--varies according to the scope of the offer, but is bound by the scope of the concession; if it is a commodity, it is the ID of the product, and if it is the brand, it is the brand ID ' min_amount 'decimal(10,2) unsigned not NULL,--the order reaches the lower limit of the amount to participate in the activity ' max_amount 'decimal(10,2) unsigned NOT NULL,--order reaches the upper limit of the amount, 0 table does not have ' act_type ' tinyint (3) unsigned NOT NULL,--the preferential way to participate in the activity; 0, gift or preferential purchase; 1, cash remission; price discount ' Act_type_ext 'decimal(10,2) unsigned NOT null,--if it is a gift, the place is the maximum number allowed, 0, no quantity limit; today's relief is the amount of relief, Unit yuan, discount, is the discount value, 100, 80 percent is the ' gift ' text not NULL,--If there is a special Product, here is the id,name,price information of the ex-gratia product, the value is Ecs_goods goods_id,goods_name, the price is the ' sort_order ' tinyint (3) that is filled in when the activity is added. Nulldefault',--the order of events on the promotional activity page, the larger the number, the morePRIMARYKEY(' act_id '),KEY' Act_name ' (' act_name ') Engine=myisamDEFAULTCharset=utf8 auto_increment=2;