invoice_items

<h4>invoice_items</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>serial_no</td> <td>varchar(20)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>invoice_id</td> <td>int(11)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>item_no</td> <td>varchar(100)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>name</td> <td>varchar(100)</td> <td>NO</td> <td>'Unknow'</td> <td></td> </tr> <tr> <td>unitprice</td> <td>varchar(20)</td> <td>NO</td> <td>'Unknow'</td> <td></td> </tr> <tr> <td>type</td> <td>int(11)</td> <td>NO</td> <td>-2</td> <td></td> </tr> <tr> <td>isdiscount</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>product_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>options</td> <td>text</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>mtcd</td> <td>varchar(100)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>pdtsd</td> <td>varchar(100)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>cpu_number</td> <td>int(11)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>month_count</td> <td>int(11)</td> <td>NO</td> <td>1</td> <td>only for subscription items</td> </tr> <tr> <td>firstStartDate</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>start_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td>only for subscription items</td> </tr> <tr> <td>end_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td>only for subscription items</td> </tr> <tr> <td>deactive_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>dprice</td> <td>varchar(100)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>damount</td> <td>varchar(100)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>price</td> <td>varchar(100)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>isstock</td> <td>int(11)</td> <td>NO</td> <td>-1</td> <td></td> </tr> <tr> <td>comment</td> <td>varchar(300)</td> <td>YES</td> <td>NULL</td> <td></td> </tr> <tr> <td>TVN</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td>Temporary Pseudo Version Number</td> </tr> <tr> <td>PVN</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td>Purchased Version Number</td> </tr> <tr> <td>CVN</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td>Current Version Number</td> </tr> <tr> <td>JDK</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td>JDK version</td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> </tbody> </table>