订单表与订单商品表金额说明
<h2>一、订单表 order</h2>
<table>
<thead>
<tr>
<th>ORDER_UUID</th>
<th>ORDER_NO</th>
<th>PRODUCT_COST_AMOUNT</th>
<th>PRODUCT_AMOUNT</th>
<th>DEDUCT_AMOUNT</th>
<th>FREIGHT_AMOUNT</th>
<th>ACTUAL_AMOUNT</th>
<th>USER_COUPON_UUID</th>
<th>P_ACTUAL_AMOUNT</th>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>20220302001</td>
<td>22=2*1+1*4+8*2</td>
<td>30=3+8+19</td>
<td>7=2+5</td>
<td>3</td>
<td>33=30+3</td>
<td>k</td>
</tr>
</tbody>
</table>
<h3>说明</h3>
<table>
<thead>
<tr>
<th>字段</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>ORDER_UUID</td>
<td>订单id</td>
</tr>
<tr>
<td>ORDER_NO</td>
<td>订单号</td>
</tr>
<tr>
<td>PRODUCT_COST_AMOUNT</td>
<td>成本总价:<code>∑(规格i成本价 * 规格i数量)</code></td>
</tr>
<tr>
<td>PRODUCT_AMOUNT</td>
<td>所有商品的实付金额之和,即<code>∑(order_product.ACTUAL_AMOUNT)</code></td>
</tr>
<tr>
<td>DEDUCT_AMOUNT</td>
<td>优惠金额,不包含秒杀优惠的金额,即:<code>优惠券优惠金额 + 满减专区优惠金额</code></td>
</tr>
<tr>
<td>FREIGHT_AMOUNT</td>
<td>运费</td>
</tr>
<tr>
<td>ACTUAL_AMOUNT</td>
<td>实付金额,即<code>PRODUCT_AMOUNT + FREIGHT_AMOUNT</code></td>
</tr>
<tr>
<td>USER_COUPON_UUID</td>
<td>使用的用户优惠券id</td>
</tr>
<tr>
<td>P_ACTUAL_AMOUNT</td>
<td>合单支付时的总金额<br/>如果下单时多笔订单一起支付则为多个订单的 <code>ACTUAL_AMOUNT</code> 之和;<br/>如果未一起支付,则为空</td>
</tr>
</tbody>
</table>
<h2>二、订单商品表 order_product</h2>
<table>
<thead>
<tr>
<th>ORDER_PRODUCT_UUID</th>
<th>ORDER_UUID</th>
<th>PRODUCT_UUID</th>
<th>PRODUCTSKU_UUID</th>
<th>ACTUAL_AMOUNT</th>
<th>PRODUCT_AMOUNT</th>
<th>PRODUCT_UNIT</th>
<th>PRODUCT_UNIT_PRICE</th>
<th>SEC_KILL_PRODUCT_UUID</th>
</tr>
</thead>
<tbody>
<tr>
<td>2</td>
<td>1</td>
<td>m</td>
<td>n</td>
<td>3</td>
<td>6</td>
<td>1</td>
<td>6</td>
<td>qq</td>
</tr>
<tr>
<td>3</td>
<td>1</td>
<td>x</td>
<td>y</td>
<td>8</td>
<td>10</td>
<td>4</td>
<td>2.5</td>
</tr>
<tr>
<td>4</td>
<td>1</td>
<td>a</td>
<td>b</td>
<td>19</td>
<td>24</td>
<td>2</td>
<td>12</td>
</tr>
</tbody>
</table>
<blockquote>
<p>假设:
第一个商品为秒杀商品,秒杀价3,规格m成本价2
第二个商品在满10减2专区,规格y成本价1
第三个商品使用了一张满20减5优惠券k,规格b成本价8
满减专区和优惠券都可以多个商品一起使用,此处只是举例,只对应了一个商品</p>
</blockquote>
<h3>说明</h3>
<table>
<thead>
<tr>
<th>字段</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>ORDER_PRODUCT_UUID</td>
<td>主键</td>
</tr>
<tr>
<td>ORDER_UUID</td>
<td>订单表id</td>
</tr>
<tr>
<td>PRODUCT_UUID</td>
<td>商品Id</td>
</tr>
<tr>
<td>PRODUCTSKU_UUID</td>
<td>规格id</td>
</tr>
<tr>
<td>ACTUAL_AMOUNT</td>
<td>实付金额:<br/>对非秒杀商品为:<code>PRODUCT_AMOUNT - 优惠金额</code><br/>对秒杀商品为: <code>秒杀价 * PRODUCT_UNIT</code></td>
</tr>
<tr>
<td>PRODUCT_AMOUNT</td>
<td>总价,单价乘数量,即:<br/> <code>PRODUCT_UNIT_PRICE * PRODUCT_UNIT</code></td>
</tr>
<tr>
<td>PRODUCT_UNIT</td>
<td>购买数量</td>
</tr>
<tr>
<td>PRODUCT_UNIT_PRICE</td>
<td>商品规格的单价,如果是秒杀商品也为规格的原单价,非秒杀价</td>
</tr>
<tr>
<td>SEC_KILL_PRODUCT_UUID</td>
<td>秒杀商品Id,只在购买秒杀商品时有值</td>
</tr>
</tbody>
</table>