表单安装 安装后可存放1000万+条数据
表字段预览 除系统字段外，okayapi_box_client_order数据库表 共有 29 个表字段
Displaying 1-29 of 29 results.
| 字段名称 | 字段类型 | 字段默认值 | 是否允许为空 | 字段描述 | 索引 | 字段数据示例 |
|---|---|---|---|---|---|---|
| client_id | bigint(20) | 是 | Normal Index | |||
| product_id | bigint(20) | 是 | Normal Index | |||
| form_id | bigint(20) | 是 | Normal Index | |||
| promo_id | bigint(20) | 是 | Normal Index | |||
| promo_recurring | tinyint(1) | 是 | ||||
| promo_used | bigint(20) | 是 | ||||
| group_id | varchar(255) | 是 | ||||
| group_master | tinyint(1) | 0 | 是 | 0 | ||
| invoice_option | varchar(255) | 是 | ||||
| title | varchar(255) | 是 | ||||
| currency | varchar(20) | 是 | ||||
| unpaid_invoice_id | bigint(20) | 是 | ||||
| service_id | bigint(20) | 是 | ||||
| service_type | varchar(100) | 是 | ||||
| period | varchar(20) | 是 | ||||
| quantity | bigint(20) | 1 | 是 | 1 | ||
| unit | varchar(100) | 是 | ||||
| price | double(18,2) | 是 | ||||
| discount | double(18,2) | 是 | first invoice discount | |||
| status | varchar(50) | 是 | ||||
| reason | varchar(255) | 是 | suspend/cancel reason | |||
| notes | text | 是 | ||||
| config | text | 是 | ||||
| referred_by | varchar(255) | 是 | ||||
| expires_at | datetime | 是 | ||||
| activated_at | datetime | 是 | ||||
| suspended_at | datetime | 是 | ||||
| unsuspended_at | datetime | 是 | ||||
| canceled_at | datetime | 是 |
