訂單表

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#1">1</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#2">2</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#3">3</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#4">4</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#5">5</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#6">6</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#7">7</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#8">8</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#9">9</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#10">10</a>

<a href="http://code.google.com/p/dolphincommerce/source/browse/trunk/DolphinCommerce/trunk/document/database/mysql/db_table/03.%E5%88%9B%E5%BB%BA%E8%AE%A2%E5%8D%95%E8%A1%A8.sql?r=65#11">11</a>

/*訂單表*/

CREATETABLE tb_FormOrder

(

   id int notnull auto_increment primarykey,                                                                  /*主鍵*/

   orderId  int notnull,                                       /*訂單編号,:生成規則=年月日小時分鐘+001遞增*/

   userId  int  notnull,                                                               /*使用者ID  --關聯到使用者表 */

   orderState char(1),                                                                  /*訂單狀态 0:無效; 1:有效; 2:撤消*/

   orderPrice decimal(10,2),                                                            /*訂單總價*/

   orderTime DATE                                                                                                       /*訂單日期*/

);