biz_preorder

<h4>biz_preorder</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>ID</td> <td>bigint(20)</td> <td>NO</td> <td></td> <td>主键</td> </tr> <tr> <td>Type</td> <td>int(11)</td> <td>YES</td> <td></td> <td>业务类型, 对应订单类型, 目前只有快吧</td> </tr> <tr> <td>MemberShipID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>会员ID</td> </tr> <tr> <td>SLocation</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>出发地</td> </tr> <tr> <td>SLongitude</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>出发地经度</td> </tr> <tr> <td>SLatitude</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>出发地纬度</td> </tr> <tr> <td>ELocation</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>目的地</td> </tr> <tr> <td>ELongitude</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>目的地经度</td> </tr> <tr> <td>Distance</td> <td>double</td> <td>YES</td> <td></td> <td>距离</td> </tr> <tr> <td>ELatitude</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>目的地纬度</td> </tr> <tr> <td>CreateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>创建日期</td> </tr> <tr> <td>DriverID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>接单的司机ID</td> </tr> <tr> <td>CarID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>接单的车</td> </tr> <tr> <td>OrderID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>产生后的OrderID, 可能暂且无关联</td> </tr> <tr> <td>Description</td> <td>varchar(250)</td> <td>YES</td> <td></td> <td>备注</td> </tr> <tr> <td>OrderPerson</td> <td>int(11)</td> <td>YES</td> <td></td> <td>上车人数</td> </tr> <tr> <td>State</td> <td>int(11)</td> <td>YES</td> <td></td> <td>状态</td> </tr> <tr> <td>Attribute1</td> <td>varchar(200)</td> <td>YES</td> <td></td> <td>备用字段</td> </tr> <tr> <td>Attribute2</td> <td>varchar(200)</td> <td>YES</td> <td></td> <td>备用字段</td> </tr> <tr> <td>Attribute3</td> <td>varchar(200)</td> <td>YES</td> <td></td> <td>备用字段</td> </tr> <tr> <td>CancelReason</td> <td>varbinary(200)</td> <td>YES</td> <td></td> <td>取消原因</td> </tr> <tr> <td>CancelDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>取消日期</td> </tr> </tbody> </table>