表单安装 安装后可存放1000万+条数据
表字段预览 除系统字段外，okayapi_openant_order数据库表 共有 51 个表字段
Displaying 1-51 of 51 results.
| 字段名称 | 字段类型 | 字段默认值 | 是否允许为空 | 字段描述 | 索引 | 字段数据示例 |
|---|---|---|---|---|---|---|
| order_id | int(11) | 否 | ||||
| invoice_no | int(11) | 0 | 否 | 0 | ||
| invoice_prefix | varchar(26) | 否 | ||||
| store_id | int(11) | 0 | 否 | 0 | ||
| user_id | int(11) | 0 | 否 | 0 | ||
| user_class_id | int(11) | 0 | 否 | 0 | ||
| firstname | varchar(32) | 否 | ||||
| lastname | varchar(32) | 否 | ||||
| varchar(96) | 否 | |||||
| telephone | varchar(32) | 否 | ||||
| payment_firstname | varchar(32) | 否 | ||||
| payment_lastname | varchar(32) | 否 | ||||
| payment_address | varchar(128) | 否 | ||||
| payment_city | varchar(128) | 否 | ||||
| payment_postcode | varchar(10) | 否 | ||||
| payment_country | varchar(128) | 否 | ||||
| payment_country_id | int(11) | 否 | ||||
| payment_zone | varchar(128) | 否 | ||||
| payment_zone_id | int(11) | 否 | ||||
| payment_address_format | text | 否 | ||||
| payment_method | varchar(128) | 否 | ||||
| payment_code | varchar(128) | 否 | ||||
| shipping_firstname | varchar(32) | 否 | ||||
| shipping_lastname | varchar(32) | 否 | ||||
| shipping_address | varchar(128) | 否 | ||||
| shipping_city | varchar(128) | 否 | ||||
| shipping_postcode | varchar(10) | 否 | ||||
| shipping_country | varchar(128) | 否 | ||||
| shipping_country_id | int(11) | 否 | ||||
| shipping_zone | varchar(128) | 否 | ||||
| shipping_zone_id | int(11) | 否 | ||||
| shipping_address_format | text | 否 | ||||
| shipping_method | varchar(128) | 否 | ||||
| shipping_code | varchar(128) | 否 | ||||
| okayapi_openant_order_comment | text | 否 | ||||
| total | decimal(15,4) | 0.0000 | 否 | 0.0000 | ||
| order_status_id | int(11) | 0 | 否 | 0 | ||
| affiliate_id | int(11) | 否 | ||||
| commission | decimal(15,4) | 否 | ||||
| marketing_id | int(11) | 否 | ||||
| tracking | varchar(64) | 否 | ||||
| language_id | int(11) | 否 | ||||
| currency_id | int(11) | 否 | ||||
| currency_code | varchar(3) | 否 | ||||
| currency_value | decimal(15,8) | 1.00000000 | 否 | 1.00000000 | ||
| ip | varchar(40) | 否 | ||||
| forwarded_ip | varchar(40) | 否 | ||||
| user_agent | varchar(255) | 否 | ||||
| accept_language | varchar(255) | 否 | ||||
| logistic | varchar(28) | 否 | ||||
| date_added | datetime | 否 |
