Ecshop Two development Notes--order table structure Ecs_order_info description

--Table structure ' ecs_order_info '  create table IF not EXISTS ' ecs_order_info ' (  ' order_id ' mediumint (8) unsigned not NULL Auto_increment COMMENT ' Order Details self-increment id ',  ' order_sn ' varchar ' not NULL COMMENT ' order number, unique ',  ' user_id ' Mediumint (8 ) unsigned not null DEFAULT ' 0 ' COMMENT ' user ID with ecs_users user_id ',  ' order_status ' tinyint (1) unsigned NOT NULL Defaul T ' 0 ' COMMENT ' order status. 0, unconfirmed, 1, confirmed, 2, cancelled, 3, void; 4, return; ',  ' shipping_status ' tinyint (1) unsigned not NULL default ' 0 ' COMMENT ' goods distribution, 0, not shipped; 1 , shipped, 2, received, 3, in stock ',  ' pay_status ' tinyint (1) unsigned not NULL DEFAULT ' 0 ' COMMENT ' payment status; 0, unpaid; 1, payment; 2, paid ',  ' Consignee ' varchar ' not NULL COMMENT ' consignee's name, user page fill, default value in table User_address ',  ' Country ' smallint (5) unsigned not NULL default ' 0 ' COMMENT ' consignee country, user page filled, default value in table user_address, its ID corresponding value in ecs_region ',  ' Province ' smallint (5) unsigned Not NULL default ' 0 ' COMMENT ' consignee's province, user page filled, default value in table user_address, its ID corresponding value in ecs_region ',  ' City ' smallint (5) unsigned Not NULL DEFAULT ' 0 ' COMMENT ' closedThe city of the Goods, user page fill, default value in table user_address, its ID corresponding value in ecs_region ',  ' District ' smallint (5) unsigned not NULL default ' 0 ' COMMENT ' Consignee's area, user page fill, default value in table user_address, its ID corresponding value in ecs_region ',  ' address ' varchar (255) not NULL COMMENT ' The consignee's detailed address, the user page fills in, the default value in the table user_address ',  ' zipcode ' varchar (not NULL COMMENT ' consignee's zip code, the user page fills in, the default value is in the table user_address ' ,  ' tel ' varchar ' NOT null COMMENT ' consignee's phone, user page filled, default value in table User_address ',  ' mobile ' varchar ' NOT NULL COMMENT ' consignee's mobile phone, user page fill, default value in table user_address ',  ' email ' varchar ' not NULL COMMENT ' consignee's phone, user page fill, default value in table User_ Address ',  ' best_time ' varchar ' not NULL COMMENT ' consignee's best delivery time, user page filled, default value in table User_address ',  ' sign_ Building ' varchar ' not NULL COMMENT ' consignee's address of the iconic building, user page filled, default value in table User_address ',  ' PostScript ' varchar (255) not Null COMMENT ' order PostScript, submitted by the user before the order is filled ',  ' shipping_id ' tinyint (3) Not NULL default ' 0 ' COMMENT ' User selected shipping Method ID, Value table ecs_shipping ',  ' shipping_name ' varchar ' not NULL COMMENT ' user-selected shipping method name, Value table ecs_shipping ',  ' Pay_Id ' tinyint (3) NOT null default ' 0 ' COMMENT ' user-selected payment method ID, Value table ecs_payment ',  ' pay_name ' varchar (+) NOT null COMMENT ' The user chooses the name of the payment method, the Value table Ecs_payment ',  ' how_oos ' varchar ' not NULL COMMENT ' out of stock handling, waiting for all items to be ready for re-delivery, cancel the order; Negotiate with the shopkeeper ',  ' How_surplus ' varchar ' NOT null COMMENT ' based on the field guess should be the balance processing method, the program did not make this part of the implementation of ',  ' pack_name ' varchar (+) NOT null COMMENT ' Wrapper name, Value table Ecs_pack ',  ' card_name ' varchar ' not NULL COMMENT ' greeting card name, value Ecs_card ',  ' card_message ' varchar ( 255) NOT null COMMENT ' greeting card content, submitted by user ',  ' inv_payee ' varchar ' NOT null COMMENT ' invoice header, user page filled ',  ' inv_content ' varchar (+) not NULL COMMENT ' invoice content, user page selection, value ecs_shop_config the value of the Code field is Invoice_content ',  ' Goods_amount ' Decimal (10,2) NOT null default ' 0.00 ' COMMENT ' commodity total amount ',  ' Shipping_fee ' decimal (10,2) NOT null default ' 0.00 ' COMMENT ' Delivery fee ',  ' insure_fee ' decimal (10,2) NOT null DEFAULT ' 0.00 ' COMMENT ' insured cost ',  ' Pay_fee ' decimal (10,2) NOT null DEFA ULT ' 0.00 ' COMMENT ' pay fees, related to the configuration of payment methods, Value Table Ecs_payment ',   ' Pack_fee ' decimal (10,2) not NULL default ' 0.00 ' COMMENT ' Packing fee, table value table Ecs_pack ',  ' Card_fee ' decimal (10,2) not Null default ' 0.00 ' COMMENT ' card fee, value Ecs_card ',  ' money_paid ' decimal (10,2) not NULL default ' 0.00 ' COMMENT ' paid amount ', &N BSP; ' Surplus ' decimal (10,2) not NULL DEFAULT ' 0.00 ' COMMENT ' The amount of balance used in the order, take the user set balance, the user's available balance, the order amount of the smallest person ',  ' integral ' int ( Unsigned not NULL DEFAULT ' 0 ' COMMENT ' use of the number of points, take the user to use points, merchandise available points, the user has the smallest of points ',  ' Integral_money ' decimal (10,2) not Null default ' 0.00 ' COMMENT ' Use integral amount ',  ' bonus ' decimal (10,2) not NULL default ' 0.00 ' COMMENT ' use red envelope amount ',  ' order_am Ount ' Decimal (10,2) NOT null default ' 0.00 ' COMMENT ' payable amount ',  ' from_ad ' smallint (5) NOT null default ' 0 ' COMMENT ' ORDER by a Advertisement ID should be valued at Ecs_ad ',  ' referer ' varchar (255) Not NULL COMMENT ' order source page ',  ' add_time ' int (ten) unsigned not Null default ' 0 ' COMMENT ' order generation time ',  ' confirm_time ' int (ten) unsigned not NULL default ' 0 ' COMMENT ' Order confirmation time ',  ' pay_t IME ' int (ten) unsigned not NULL DEFAULT '0 ' COMMENT ' Order payment time ',  ' shipping_time ' int (ten) unsigned not NULL DEFAULT ' 0 ' COMMENT ' Order delivery time ',  ' pack_id ' tinyint ( 3) unsigned NOT NULL default ' 0 ' COMMENT ' wrapper ID, Value table ecs_pack ',  ' card_id ' tinyint (3) unsigned NOT NULL default ' 0 ' COM ment ' greeting Card ID, user in page selection, value ecs_card ',  ' bonus_id ' smallint (5) unsigned not NULL DEFAULT ' 0 ' COMMENT ' Red envelopes Id,ecs_user_ Bonus bonus_id ',  ' invoice_no ' varchar (s) not NULL COMMENT ' shipping number, when shipped, can be viewed in order inquiry ',  ' extension_code ' varchar (a) Not NULL COMMENT ' The code of the goods purchased through the activity; Group_buy is a group purchase; AUCTION, is an auction; snatch, seize Jones; normal General Products The place is empty ',  ' extension_id ' mediumint (8) unsigned not NULL default ' 0 ' COMMENT ' the ID of the item purchased through the activity, value ecs_goods_activity; if it is a normal ordinary commodity, it is 0 ',  ' to_buyer ' varchar ( 255) NOT null COMMENT ' merchant to the customer's message, when the field has a value can be seen in the order query ',  ' pay_note ' varchar (255) Not NULL COMMENT ' payment notes, edit in order management changes ',   ' agency_id ' smallint (5) unsigned not NULL COMMENT ' the ID of the office to which the order was assigned, according to the order content and the scope of the office is automatically determined, or can be modified by the administrator, value in the table ecs_agency ',  ' inv_type ' varchar ' not NULL COMMENT ' invoice type, user page selection, the value of the value of the Code field of Ecs_shop_config is Invoice_type ',  ', ' Tax ' decimal (10,2) ' is not NULL COMMENT ' invoice taxes ',  ' is_ Separate ' tinyint (1) Not NULL DEFAULT ' 0 ' COMMENT ' 0, is not divided into or waiting to be divided into; 1, has been divided into; 2, cancelled; ',  ' parent_id ' mediumint (8) unsigned not Null default ' 0 ' COMMENT ' can get the recommended split user Id,id value in table Ecs_users ',  ' Discount ' decimal (10,2) not NULL COMMENT ' discount amount ',  PRIMARY key (' order_id '),  unique key ' order_sn ' (' order_sn '),  key ' user_id ' (' user_id '),  key ' Order_ Status ' (' Order_status '),  key ' Shipping_status ' (' Shipping_status '),  key ' Pay_status ' (' Pay_status '),  key ' shipping_id ' (' shipping_id '),  key ' pay_id ' (' pay_id '),  key ' Extension_code ' (' Extension_code ', ' extension_id '),  key ' agency_id ' (' agency_id ')  ) Engine=myisam DEFAULT Charset=utf8 row_format=dynamic Comment= ' order delivery, greeting cards and more ' auto_increment=24; 

Ecshop Two development Notes-order table structure Ecs_order_info description