订单表

<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                                                                                                       /*订单日期*/

);