From xt:Commerce 技術文件

資料結構   搜尋   語言 : 正體中文

	Contents 1 版本 2 說明 2.1 orders 資料表 2.2 版本異動說明 [edit] 版本 xt:Commerce 3.04 sp2.2 [edit] 說明 [edit] orders 資料表 orders_id int NOT NULL auto_increment customers_id int NOT NULL customers_cid varchar(32) customers_vat_id varchar (20) customers_status int(11) customers_status_name varchar(32) NOT NULL customers_status_image varchar (64) customers_status_discount decimal (4,2) customers_name varchar(64) NOT NULL customers_firstname varchar(64) NOT NULL customers_lastname varchar(64) NOT NULL customers_company varchar(32) customers_street_address varchar(64) NOT NULL customers_suburb varchar(32) customers_city varchar(32) NOT NULL customers_postcode varchar(10) NOT NULL customers_state varchar(32) customers_country varchar(32) NOT NULL customers_telephone varchar(32) NOT NULL customers_email_address varchar(96) NOT NULL customers_address_format_id int(5) NOT NULL delivery_name varchar(64) NOT NULL delivery_firstname varchar(64) NOT NULL delivery_lastname varchar(64) NOT NULL delivery_company varchar(32) delivery_street_address varchar(64) NOT NULL delivery_suburb varchar(32) delivery_city varchar(32) NOT NULL delivery_postcode varchar(10) NOT NULL delivery_state varchar(32) delivery_country varchar(32) NOT NULL delivery_country_iso_code_2 char(2) NOT NULL delivery_address_format_id int(5) NOT NULL billing_name varchar(64) NOT NULL billing_firstname varchar(64) NOT NULL billing_lastname varchar(64) NOT NULL billing_company varchar(32) billing_street_address varchar(64) NOT NULL billing_suburb varchar(32) billing_city varchar(32) NOT NULL billing_postcode varchar(10) NOT NULL billing_state varchar(32) billing_country varchar(32) NOT NULL billing_country_iso_code_2 char(2) NOT NULL billing_address_format_id int(5) NOT NULL payment_method varchar(32) NOT NULL cc_type varchar(20) cc_owner varchar(64) cc_number varchar(64) cc_expires varchar(4) cc_start varchar(4) default NULL cc_issue varchar(3) default NULL cc_cvv varchar(4) default NULL comments varchar (255) last_modified datetime date_purchased datetime orders_status int(5) NOT NULL orders_date_finished datetime currency char(3) currency_value decimal(14,6) account_type int(1) DEFAULT '0' NOT NULL payment_class VARCHAR(32) NOT NULL shipping_method VARCHAR(32) NOT NULL shipping_class VARCHAR(32) NOT NULL customers_ip VARCHAR(32) NOT NULL language VARCHAR(32) NOT NULL afterbuy_success INT(1) DEFAULT'0' NOT NULL afterbuy_id INT(32) DEFAULT '0' NOT NULL refferers_id VARCHAR(32) NOT NULL conversion_type INT(1) DEFAULT '0' NOT NULL orders_ident_key varchar(128) [edit] 版本異動說明 stocks_traffic orders_products