joint_venture 字段统计B 端联营合约
精确行数与字段画像 · 估算行数 0 · 主键 id
类型分布
字段可空与键位
| 字段 | 类型 | 键 | 可空 | 注释 |
| id | bigint | PRI | NO | |
| org_id | bigint | MUL | YES | 所属社区/联盟 |
| party_a_type | varchar | MUL | NO | store/merchant/service_provider |
| party_a_id | bigint | — | NO | |
| party_b_type | varchar | — | NO | |
| party_b_id | bigint | — | NO | |
| title | varchar | — | NO | |
| coop_type | varchar | — | YES | profit 分润 / stock 共享库存 / promo 联合活动 / serve 联合服务 |
| profit_ratio_a | decimal | — | YES | |
| profit_ratio_b | decimal | — | YES | |
| share_stock | tinyint | — | YES | |
| start_date | date | — | YES | |
| end_date | date | — | YES | |
| status | varchar | MUL | YES | DRAFT/SIGNED/ACTIVE/EXPIRE/STOP |
| contract_no | varchar | — | YES | |
| remark | varchar | — | YES | |
| created_at | datetime | — | YES | |
相关
返回全景目录