products
<h4>products</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>product_no</td>
<td>varchar(20)</td>
<td>NO</td>
<td>'--'</td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>commerce_name</td>
<td>varchar(100)</td>
<td>NO</td>
<td>''</td>
<td></td>
</tr>
<tr>
<td>name_en</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td></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>status</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>0</td>
<td>0: Draft</td>
</tr>
</tbody>
</table>
<p>1:申请中
2:無効
3: 承認中</p>
<p>4: 販売中
5:販売終了 |
| price | decimal(15,0) | NO | | JPY円 |
| price_CNY | decimal(15,0) | NO | | 元 |
| price_USD | decimal(15,0) | NO | | $ |
| price_GBP | decimal(15,0) | NO | | £ |
| price_EUR | decimal(15,0) | NO | | € |
| price_SGD | decimal(15,2) | NO | | SGD |
| price_editable | tinyint(4) | NO | 0 | |
| type | tinyint(4) | NO | 0 | -1:main product 0:product1:support2:subscription 3:others 4: Time License |
| ismainoption | tinyint(4) | NO | 0 | 0 unset, 1 main, 2 option |
| warplicense_type | varchar(20) | NO | | |
| option_code | varchar(20) | NO | | |
| new_option_code | varchar(20) | NO | '' | |
| option_string | varchar(20) | NO | | |
| isonlyone | int(11) | NO | 0 | set count 1 |
| billcycle | int(11) | NO | -1 | init:-1, month:0,yearly:1 |
| active | tinyint(4) | NO | 1 | |
| isdiscount | tinyint(4) | NO | 0 | 0:product 1:discount |
| isinput | tinyint(4) | NO | 0 | |
| sort_no | int(11) | NO | 0 | |
| shortname | varchar(100) | NO | '' | 製品コードcode |
| isAllowInput | tinyint(1) | NO | 1 | |
| cat_1 | varchar(100) | NO | '' | |
| cat_2 | varchar(100) | NO | '' | |
| cat_3 | varchar(100) | NO | '' | |
| cat_4 | varchar(100) | NO | '' | |
| main_category_for_total | varchar(100) | NO | '' | |
| small_category_for_total | varchar(100) | NO | '' | |
| creator | varchar(30) | NO | '' | |
| infoteria_seller_no | varchar(20) | NO | '' | |
| user_number | int(11) | NO | 0 | |
| disksize | int(11) | NO | 0 | unit is GB |
| is_oem | tinyint(4) | NO | 0 | |
| is_warp_optional | tinyint(4) | NO | 0 | |
| type_soft | tinyint(4) | NO | 0 | init:0, soft:1, other:2 |
| other_type_soft | tinyint(4) | NO | 0 | init:0, soft:1, other:2 |
| comment | text | NO | | |
| updated_records | text | NO | | |
| release_date | timestamp | NO | '0000-00-00 00:00:00' | |
| approve_date_manager | timestamp | NO | '0000-00-00 00:00:00' | |
| approve_date_supervisor | timestamp | NO | '0000-00-00 00:00:00' | |
| created_at | timestamp | NO | '0000-00-00 00:00:00' | |
| updated_at | timestamp | NO | '0000-00-00 00:00:00' | |</p>