contracts
<h4>contracts</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>contract_no</td>
<td>varchar(20)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>super_contract_id</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>super_or_sub</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>0: none,1:super,2:sub</td>
</tr>
<tr>
<td>category</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>0: init 1 Platio 2 Gravio 3 Core 4 期間限定 5 Other 6 WARP</td>
</tr>
<tr>
<td>isEdgePack</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>haveEdgePlatio</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>status</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>0:init, 1:support effective, 2:support expired, 3:disabled</td>
</tr>
<tr>
<td>istest</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>servicetype</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0:standard 1:enterprise 2/3 core 4 other 5 GC 6 Platio 7 Platio Connect 8 Platio One 9 Gravio Basic Trial</td>
</tr>
<tr>
<td>user_order_date</td>
<td>timestamp</td>
<td>NO</td>
<td>'0000-00-00 00:00:00'</td>
<td></td>
</tr>
<tr>
<td>ep_id</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>the ep generate this contract</td>
</tr>
<tr>
<td>invoice_id</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>the invoice generate this contract (for old data)</td>
</tr>
<tr>
<td>isautosendinvoice</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>only for core</td>
</tr>
<tr>
<td>buy_company</td>
<td>varchar(100)</td>
<td>NO</td>
<td>''</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>maintenance_company</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>company_id</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>partner_id</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>infoteria_seller_no</td>
<td>varchar(20)</td>
<td>NO</td>
<td>''</td>
<td></td>
</tr>
<tr>
<td>has_support_flag</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>0:none, 1:have</td>
</tr>
<tr>
<td>support_way</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0:init 1:direct 2:partner</td>
</tr>
<tr>
<td>support_start_date</td>
<td>timestamp</td>
<td>NO</td>
<td>'0000-00-00 00:00:00'</td>
<td></td>
</tr>
<tr>
<td>support_end_date</td>
<td>timestamp</td>
<td>NO</td>
<td>'0000-00-00 00:00:00'</td>
<td></td>
</tr>
<tr>
<td>support_years</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>comment</td>
<td>text</td>
<td>YES</td>
<td>NULL</td>
<td></td>
</tr>
<tr>
<td>GCOrgID</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>GravioVersion</td>
<td>varchar(20)</td>
<td>NO</td>
<td>'4.5'</td>
<td>4.4, 4.5</td>
</tr>
<tr>
<td>GCPaymentType</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0"none", 1"InAppPurchaseWindows", 2"InAppPurchaseiOS", 3"InAppPurchaseMac", 4"CreditCard", 5"BankTransfer"</td>
</tr>
<tr>
<td>GCPaymentCycle</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0 “monthly” 1 “yearly”</td>
</tr>
<tr>
<td>GCServiceType</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0"free" 1"basic" 2"standard" 3"premium" 4"enterprise" 5 "basic pack" 6 "CO2 pack" 7 "timelicense" 8 " Business" 9 " Business Pro"</td>
</tr>
<tr>
<td>GCRemoved</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>HBOrgID</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>HBPaymentType</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0 none 1 InAppPurchaseWindows 2 InAppPurchaseiOS 3 InAppPurchaseMac 4 CreditCard 5 BankTransfer 6 InAppPurchaseAndroid</td>
</tr>
<tr>
<td>HBPaymentCycle</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>HBServiceType</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0 free, 1 p-bronze, 2 p-silver, 3 p-gold, 4 x-bronze, 5 x-silver, 6 x-gold, 7 x-platinum, 8 x-diamond</td>
</tr>
<tr>
<td>subdomain</td>
<td>varchar(100)</td>
<td>NO</td>
<td>''</td>
<td></td>
</tr>
<tr>
<td>subdomainStatus</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td>0 未设定, 1 サーバ準備中, 2 運用中</td>
</tr>
<tr>
<td>serverInfo</td>
<td>text</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>firstPurchaseDate</td>
<td>timestamp</td>
<td>NO</td>
<td>'0000-00-00 00:00:00'</td>
<td></td>
</tr>
<tr>
<td>PLOrgID</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>PLOrgName</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>PLUserLimit</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>PLAppLimit</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>PLType</td>
<td>varchar(10)</td>
<td>NO</td>
<td>'pws'</td>
<td>pws / pwp / pwe</td>
</tr>
<tr>
<td>PLDisabled</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>PlatioOneStorageCapacity</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>PLRemoved</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>allowDownloadApk</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>updated_records</td>
<td>text</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>termination_date</td>
<td>timestamp</td>
<td>NO</td>
<td>'0000-00-00 00:00:00'</td>
<td></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>