-
Notifications
You must be signed in to change notification settings - Fork 0
34 v1 database field dictionary
技术老胡 edited this page Jul 30, 2026
·
1 revision
本文档冻结 SmartFarm V1 新增表和 CRMEB 必要兼容变更的物理字段基线。它不是可执行 SQL，不写数据库；开发时应按本字典生成版本化 migration，并执行 up → verify → rollback boundary。
| 缩写/类型 | 含义 |
|---|---|
PK |
bigint unsigned AUTO_INCREMENT 主键 |
RID |
新农业表逻辑外键，bigint unsigned
|
CID |
CRMEB 既有主键，实际 migration 必须与来源列的 unsigned/长度完全一致，当前基线按 int unsigned
|
NO |
业务编号 varchar(40)，ASCII、非空、唯一 |
CODE |
稳定代码 varchar(32)，ASCII、非空 |
STATE |
状态码 varchar(32)，ASCII、非空；API 原样返回，不在数据库另存中文状态 |
MONEY |
decimal(14,2)，非空默认 0.00
|
CALC |
decimal(20,8)，计算中间值 |
QTY |
decimal(14,3)，非空默认 0.000
|
EQTY |
decimal(20,6)，用户经济等价数量；不得作为实体库存扣减数量 |
RATE |
smallint unsigned 基点，0..10000
|
DT |
datetime(3)；发生时间无默认值，明确由业务服务写入 |
JSON |
MySQL json；业务服务必须写合法对象/数组，不依赖数据库隐式字符串转换 |
HASH |
char(64)，小写 SHA-256 |
VER |
int unsigned NOT NULL DEFAULT 1 |
本字典用 NN 表示 NOT NULL，NULL 表示可空。未写默认值的 NN JSON/DT/varchar 必须由创建命令显式赋值。
| 模板 | 列 |
|---|---|
CORE |
<table>_id PK、status STATE、version VER、create_time DT、update_time DT NULL
|
MASTER |
CORE + is_del tinyint unsigned NN default 0、delete_time DT NULL、create_admin_id CID NULL、update_admin_id CID NULL
|
IMMUTABLE |
<table>_id PK、create_time DT；无 is_del、无业务更新入口 |
SNAPSHOT |
snapshot_schema_version smallint unsigned NN default 1、snapshot_hash HASH NN、source_version int unsigned NN、snapshot_created_at DT
|
交易、库存、账本、状态迁移、审计、Outbox 和证据引用不设物理删除入口。主数据只允许软删除且有关联历史时仍不得删除。
- 新表统一
InnoDB、utf8mb4；业务号、状态码、幂等键、事件名等 ASCII 列使用区分大小写的 ASCII collation。 - V1 不建立数据库级级联删除。逻辑外键由 Repository 校验，所有历史引用永久保留。
- 金额、数量均加应用层非负/方程校验；MySQL 8 migration 可补
CHECK，但代码不得仅依赖CHECK。 - JSON 只存快照、步骤参数、展示材料和第三方摘要；可筛选、可排序、参与金额/数量计算的字段必须独立成列。
- 每个唯一业务结果都先有唯一键，再写幂等代码；只加普通索引不能替代并发唯一约束。
- 大表索引只按已冻结查询建立；开发环境用代表数据执行
EXPLAIN后再签 G3 数据门。
| 表 | 变更 | 上线前验证 | 回退边界 |
|---|---|---|---|
eb_user |
now_money decimal(14,2) NN default 0.00 |
无负溢出、余额与账单尾值一致 | 产生超旧字段容量的金额后不可缩回 |
eb_user_bill |
number/balance decimal(14,2) NN default 0.00 |
抽样复算方向、金额、余额 | 同上 |
eb_merchant |
mer_money decimal(14,2) NN default 0.00 |
商户余额与财务流水一致 | 同上 |
eb_financial_record |
number decimal(14,2) NN default 0.00 |
抽样结单入账精度 | 同上 |
eb_store_service |
增加 uk_service_account(account)
|
空字符串先规范为 NULL；任一非空重复账号阻断升级 |
未发新 Token 前可删索引；产生冲突依赖后不可盲回 |
空账号规范化仅对真正空白值执行；非空重复账号不得自动改名或合并，必须在迁移前停止并报告。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_product_agriculture_profile |
MASTER |
product_id CID NN；source_type CODE NN；farm_id RID NULL；supplier_name varchar(120) NULL；origin_province/city/district varchar(64) NULL；origin_address varchar(255) NULL；public_summary text NULL；supply_eligible tinyint unsigned NN default 0；trace_archive_id RID NULL；material_status CODE NN default 'missing'；submitted_by/submitted_at CID/DT NULL；audit_by/audit_at CID/DT NULL；audit_remark varchar(1000) NULL
|
uk_product(product_id)；idx_source_status(source_type,status,product_id)；idx_farm(farm_id,status)；idx_review(status,submitted_at,product_agriculture_profile_id)
|
eb_farm_product_material |
CORE |
product_id CID NN；material_type CODE NN；material_no varchar(80) NULL；attachment_id CID NN（逻辑引用 eb_system_attachment.attachment_id）；issuer varchar(160) NULL；effective_at DT NULL；expire_at DT NULL；audit_status STATE NN；audit_by CID NULL；audit_at DT NULL；source_material_id RID NULL
|
idx_product_type_status(product_id,material_type,status,expire_at)；idx_expiry(status,expire_at,product_material_id)
|
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_cloud_activity |
MASTER |
activity_no NO；name varchar(120) NN；preview_at DT NULL；start_at/end_at DT NN；payment_timeout_minutes smallint unsigned NN；choice_days_default smallint unsigned NN；publish_at/closed_at DT NULL；rule_snapshot JSON NULL + SNAPSHOT（发布后必填） |
uk_activity_no(activity_no)；idx_status_time(status,start_at,end_at,cloud_activity_id)
|
eb_farm_cloud_activity_product |
CORE |
activity_id RID NN；product_id CID NN；display_title varchar(160) NN；cover_image varchar(255) NULL；supports_shipping/supports_pickup/supports_consign tinyint unsigned NN default 0；choice_days/pickup_days smallint unsigned NULL；rule_version int unsigned NN；publish_snapshot JSON NULL + SNAPSHOT（发布后必填） |
uk_activity_product(activity_id,product_id)；idx_activity_status(activity_id,status,cloud_activity_product_id)
|
eb_farm_cloud_activity_sku |
CORE |
activity_product_id/supply_id RID NN；source_product_id/source_value_id CID NN；source_unique varchar(128) NN；source_sku_text varchar(255) NN；source_snapshot JSON NN；source_snapshot_hash HASH NN；source_sync_status STATE NN；source_checked_at DT NULL；activity_unit_price/supply_unit_price MONEY；activity_qty/per_user_limit QTY；expected_sale_days smallint unsigned NN；maturity_resolution_days smallint unsigned NN default 30；settlement_mode CODE NN；user_profit_rate/platform_profit_rate/buyback_rate RATE NN；platform_cost_policy_snapshot JSON NN；primary_after_sale_days/secondary_after_sale_days smallint unsigned NN；resale_product_id/resale_sku_value_id CID NULL；rule_version int unsigned NN；publish_snapshot JSON NULL + SNAPSHOT（发布后必填） |
uk_activity_source(activity_product_id,source_snapshot_hash)；idx_supply_status(supply_id,status)；idx_source_check(source_sync_status,source_checked_at,cloud_activity_sku_id)；idx_resale_map(resale_product_id,resale_sku_value_id)
|
eb_farm_cloud_user_quota |
CORE |
activity_sku_id RID NN；user_id CID NN；limit_qty/locked_unpaid_qty/paid_qty/refunded_qty QTY
|
uk_sku_user(activity_sku_id,user_id)；idx_user(user_id,status,cloud_user_quota_id)
|
约束：start_at < end_at；发布活动 supports_consign=1；利润分成合计 10000；buyback_rate 为 1..10000；所有数量非负。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_cloud_supply |
CORE |
supply_no NO；source_type CODE NN；merchant_id CID NULL；product_id/source_sku_value_id CID NN；source_sku_unique_snapshot varchar(128) NN；source_sku_snapshot JSON NN；supply_price MONEY；proposed_qty/approved_qty/source_reserved_qty/delivered_qty/accepted_qty/pending_inspection_qty/rejected_qty/shortage_qty/allocated_activity_qty/cloud_available_qty/cancelled_qty/return_pending_qty/returned_qty/platform_acquired_qty QTY；fulfillment_type CODE NN；shipping_responsible_party/quality_responsible_party/after_sale_responsible_party CODE NN；responsibility_snapshot JSON NULL；after_sale_days smallint unsigned NN；audit_by CID NULL；audit_at/accepted_at DT NULL；audit_remark varchar(500) NULL
|
uk_supply_no(supply_no)；idx_merchant_status(merchant_id,status,cloud_supply_id)；idx_source(product_id,source_sku_value_id,status)；idx_eligibility(status,accepted_at,merchant_id,cloud_supply_id)
|
eb_farm_cloud_supply_delivery |
CORE |
delivery_no NO；supply_id RID NN；dispatch_qty/received_qty/shortage_qty QTY；carrier_code varchar(32) NULL；tracking_no varchar(80) NULL；handover_method CODE NN；dispatch_at/received_at DT NULL；dispatch_evidence JSON NULL；receive_evidence JSON NULL；created_merchant_user_id CID NULL；received_admin_id CID NULL
|
uk_delivery_no(delivery_no)；uk_carrier_tracking(carrier_code,tracking_no)（允许 NULL）; idx_supply_status(supply_id,status,cloud_supply_delivery_id)
|
eb_farm_cloud_supply_inspection |
CORE |
inspection_no NO；supply_id/delivery_id RID NN；received_qty/accepted_qty/pending_inspection_qty/rejected_qty QTY；unit_code varchar(16) NN；warehouse_id/location_id RID NULL；quality_result CODE NN；evidence_snapshot JSON NN；review_by CID NN；review_at DT NN
|
uk_inspection_no(inspection_no)；idx_delivery(delivery_id,status)；idx_warehouse(warehouse_id,location_id,status)
|
eb_farm_cloud_supply_material |
CORE |
supply_id RID NN；material_type CODE NN；source_material_id RID NULL；attachment_id CID NN（逻辑引用 eb_system_attachment.attachment_id）；material_no varchar(80) NULL；issuer varchar(160) NULL；effective_at/expire_at DT NULL；audit_status STATE NN；snapshot_version int unsigned NN；material_snapshot JSON NN
|
idx_supply_type(supply_id,material_type,status)；idx_expiry(status,expire_at,cloud_supply_material_id)
|
eb_farm_cloud_supply_return |
CORE |
return_no NO；supply_id RID NN；merchant_id CID NN；reason_code CODE NN；return_qty/dispatched_qty/received_qty/difference_qty/restored_source_qty QTY；handover_method CODE NN；carrier_code varchar(32) NULL；tracking_no varchar(80) NULL；dispatch_evidence/receive_evidence/difference_snapshot JSON NULL；created_by/audited_by/acknowledged_by CID NULL；dispatch_at/received_at/acknowledged_at/completed_at DT NULL；ack_result CODE NULL；result_key varchar(160) NN
|
uk_return_no(return_no)；uk_result_key(result_key)；idx_supply_status(supply_id,status,cloud_supply_return_id)；idx_merchant_status(merchant_id,status,cloud_supply_return_id)；idx_carrier_tracking(carrier_code,tracking_no)（NULL 可重复） |
eb_farm_cloud_supply_acquisition |
CORE |
acquisition_no NO；supply_id RID NN；merchant_id CID NULL；acquisition_qty QTY；acquisition_unit_price/acquisition_amount MONEY；target_product_id/target_sku_value_id CID NN；calculation_snapshot/evidence_snapshot JSON NN；prepared_by/reviewed_by/executed_by CID NULL；prepared_at/reviewed_at/executed_at/completed_at DT NULL；review_remark varchar(500) NULL；platform_inventory_flow_id RID NULL；result_key varchar(160) NN
|
uk_acquisition_no(acquisition_no)；uk_result_key(result_key)；idx_supply_status(supply_id,status,cloud_supply_acquisition_id)；idx_target_sku(target_product_id,target_sku_value_id,status)
|
source_type='merchant' 时 merchant_id 必填；交付、验收、退回、平台承接和供货汇总的数量方程由同事务校验。returned_qty 只累计完成退回的 restored_source_qty，platform_acquired_qty 只累计完成承接的 acquisition_qty。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_cloud_batch |
CORE |
batch_no NO；activity_id/activity_product_id/activity_sku_id/supply_id RID NN；source_product_id/source_value_id CID NN；source_unique varchar(128) NN；source_snapshot JSON NN；merchant_id CID NULL；resale_stock_id RID NULL；purchase_unit_price/supply_unit_price MONEY；activity_qty/locked_unpaid_qty/gross_paid_qty/primary_refunded_qty/net_paid_qty/shipping_qty/pickup_qty/consign_qty/secondary_locked_qty/gross_effective_sold_qty/secondary_reversed_qty/net_effective_sold_qty/buyback_qty/remaining_qty/platform_assumed_inflight_qty QTY；confirmed_sales_amount/distributable_profit/platform_operating_cost_amount MONEY；platform_cost_snapshot JSON NULL；choice_deadline_at/consign_start_at/maturity_at/maturity_grace_deadline_at/ownership_cutover_at/closed_at DT NULL；current_milestone tinyint unsigned NN default 0；settlement_mode CODE NN；user_profit_rate/buyback_rate RATE NN；suspended_from STATE NULL
|
uk_batch_no(batch_no)；uk_activity_sku(activity_sku_id)；idx_resale_fefo(resale_stock_id,status,maturity_at,cloud_batch_id)；idx_activity(activity_id,activity_product_id,status)；idx_maturity(status,maturity_grace_deadline_at,cloud_batch_id)
|
eb_farm_cloud_batch_pool_balance |
CORE |
batch_id RID NN；pool_code CODE NN；qty QTY；last_flow_id RID NULL
|
uk_batch_pool(batch_id,pool_code)；idx_pool_status(pool_code,status,batch_id)
|
eb_farm_cloud_inventory_flow |
IMMUTABLE |
flow_no NO；supply_id/activity_sku_id/batch_id RID NULL；warehouse_id/location_id RID NULL；pool_from/pool_to CODE NULL；unit_code varchar(16) NN；change_qty QTY；before_qty/after_qty QTY；business_type CODE NN；business_id RID NN；idempotency_key varchar(160) NN；occurred_at DT；operator_type CODE NN；operator_id bigint unsigned NULL
|
uk_flow_no(flow_no)；uk_idempotency(idempotency_key)；idx_batch_time(batch_id,occurred_at,cloud_inventory_flow_id)；idx_supply_time(supply_id,occurred_at,cloud_inventory_flow_id)；idx_business(business_type,business_id)
|
库存流水要求 change_qty > 0，且 supply_id/activity_sku_id/batch_id 至少一个非空。池余额表只保存当前值，任何变化都必须先创建唯一业务流水。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_cloud_order_item |
CORE |
group_order_id/order_id/order_product_id CID NN；user_id CID NN；activity_id/activity_product_id/activity_sku_id/batch_id RID NN；product_id/source_sku_value_id CID NN；sku_snapshot JSON NN；purchase_unit_price MONEY；purchase_qty QTY；gross_goods_amount/discount_amount/principal_amount/goods_paid_amount MONEY；disposition CODE NN default 'unselected'；choice_status STATE NN；choice_version VER；choice_deadline_at/choice_at DT NULL；choice_operator_type CODE NULL；current_freight_order_id/shipping_fulfillment_id/pickup_id/holding_id RID NULL；freight_status STATE NULL；freight_amount MONEY；pickup_deadline_at/primary_completed_at/primary_settlement_eligible_at DT NULL；primary_refund_status STATE NN default 'none'；primary_refund_qty QTY；rule_snapshot JSON NN + SNAPSHOT
|
uk_order_product(order_product_id)；idx_user_status(user_id,status,cloud_order_item_id)；idx_choice(status,choice_deadline_at,cloud_order_item_id)；idx_pickup(status,pickup_deadline_at,cloud_order_item_id)；idx_batch(batch_id,status)
|
eb_farm_cloud_freight_order |
CORE |
freight_order_no NO；cloud_order_item_id RID NN；user_id CID NN；choice_version/quote_version int unsigned NN；address_snapshot/freight_rule_snapshot/charge_basis_snapshot JSON NN；freight_template_id CID NULL；quote_hash HASH NN；freight_amount/paid_amount/callback_amount/refund_amount MONEY；business_status/pay_status/close_status/refund_status STATE NN；pay_type/pay_driver CODE NULL；provider_transaction_id varchar(96) NULL；pay_time/callback_at/expired_at/cancelled_at DT NULL；error_code varchar(64) NULL；error_message varchar(500) NULL
|
uk_freight_no(freight_order_no)；uk_provider_tx(provider_transaction_id)（NULL 可重复）；idx_item_status(cloud_order_item_id,status)；idx_pay_repair(pay_status,update_time,cloud_freight_order_id)；idx_expiry(pay_status,expired_at,cloud_freight_order_id)；expired_at 必须等于活动支付超时点和去向截止点的较早值 |
eb_farm_cloud_freight_refund |
CORE |
freight_refund_no NO；freight_order_id RID NN；user_id CID NN；reason_type CODE NN；reason_snapshot JSON NN；refund_amount MONEY；pay_type/pay_driver CODE NN；provider_refund_id varchar(96) NULL；attempt_count smallint unsigned NN default 0；next_retry_at/requested_at/completed_at DT NULL；operator_type CODE NN；operator_id bigint unsigned NULL；error_code varchar(64) NULL；error_message varchar(500) NULL
|
uk_refund_no(freight_refund_no)；uk_freight(freight_order_id)；uk_provider_refund(provider_refund_id)（NULL 可重复）；idx_retry(status,next_retry_at,cloud_freight_refund_id)
|
eb_farm_cloud_pickup |
CORE |
pickup_no NO；cloud_order_item_id RID NN；user_id CID NN；pickup_point_id RID NN；pickup_point_snapshot JSON NN；pickup_qty/verified_qty/remaining_qty/refunded_qty/converted_shipping_qty/exception_buyback_qty QTY；voucher_code_hash HASH NN；voucher_version int unsigned NN；valid_from/expires_at/last_verified_at/overdue_at DT NULL；last_verified_by_type CODE NULL；last_verified_by_id bigint unsigned NULL；exception_event_id RID NULL
|
uk_pickup_no(pickup_no)；uk_item_active(cloud_order_item_id,status)；uk_voucher(voucher_code_hash,voucher_version)；idx_point_status(pickup_point_id,status,expires_at)
|
eb_farm_cloud_pickup_verification |
IMMUTABLE |
verification_no NO；pickup_id RID NN；verified_qty/before_verified_qty/after_verified_qty QTY；voucher_version int unsigned NN；service_id CID NN；pickup_point_id RID NN；operation_type CODE NN default 'verify'；reversal_of_id RID NULL；evidence_hash HASH NULL；idempotency_key varchar(160) NN；occurred_at DT
|
uk_verification_no(verification_no)；uk_idempotency(idempotency_key)；idx_pickup_time(pickup_id,occurred_at,cloud_pickup_verification_id)；idx_reversal(reversal_of_id)
|
eb_farm_cloud_holding |
CORE |
holding_no NO；user_id CID NN；batch_id/cloud_order_item_id RID NN；initial_qty/active_qty QTY；sold_equivalent_qty/unsold_equivalent_qty/buyback_equivalent_qty EQTY；unit_principal/total_principal/returned_principal/recognized_profit/settled_profit/buyback_amount/normal_refund_offset_amount/platform_risk_absorbed_amount MONEY；settlement_mode CODE NN；user_profit_rate/buyback_rate RATE NN；rule_snapshot JSON NN + SNAPSHOT
|
uk_holding_no(holding_no)；uk_order_item(cloud_order_item_id)；idx_user_status(user_id,status,cloud_holding_id)；idx_batch_status(batch_id,status,cloud_holding_id)
|
eb_farm_cloud_primary_refund_impact |
IMMUTABLE |
refund_order_id CID NN；cloud_order_item_id RID NN；refund_qty QTY；refund_principal_amount MONEY；activity_return_qty/source_return_qty QTY；merchant_ledger_adjustment_id RID NULL；disposition_snapshot/inventory_snapshot JSON NN；idempotency_key varchar(160) NN；status STATE NN；occurred_at DT；reversal_of_id RID NULL
|
uk_refund_item(refund_order_id,cloud_order_item_id)；uk_idempotency(idempotency_key)；idx_item(cloud_order_item_id,occurred_at)
|
discount_amount 在 V1 云仓首次订单强制为 0.00；principal_amount=gross_goods_amount=goods_paid_amount。disposition 只允许 unselected/shipping/pickup/consign，且最终关联 shipping_fulfillment_id/pickup_id/holding_id 至多一个非空。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_cloud_resale_stock |
CORE |
resale_stock_no NO；resale_product_id/resale_sku_value_id CID NN；resale_sku_unique_snapshot varchar(128) NN；stock_source CODE NN default 'cloud_only'；published_qty/available_qty/locked_qty/effective_sold_qty/returned_qty QTY；is_visible/is_saleable tinyint unsigned NN default 0；last_reconciled_at DT NULL
|
uk_resale_no(resale_stock_no)；uk_product_sku(resale_product_id,resale_sku_value_id)；idx_saleable(status,is_saleable,resale_stock_id)
|
eb_farm_cloud_resale_allocation |
CORE |
secondary_group_order_id/secondary_order_id/secondary_order_product_id CID NN；resale_stock_id/batch_id RID NN；allocated_qty QTY；goods_paid_amount/platform_subsidy_amount/recognized_sales_amount MONEY；gross_effective_qty/reversed_qty/net_effective_qty QTY；effective_at/observation_end_at DT NULL；allocation_version int unsigned NN
|
uk_order_product_batch(secondary_order_product_id,batch_id)；idx_stock_status(resale_stock_id,status,cloud_resale_allocation_id)；idx_batch_status(batch_id,status,observation_end_at,cloud_resale_allocation_id)
|
eb_farm_cloud_resale_refund_allocation |
IMMUTABLE |
secondary_refund_order_id/secondary_order_product_id CID NN；resale_allocation_id/batch_id RID NN；refund_qty QTY；refund_goods_amount/platform_subsidy_reversal/recognized_sales_reversal MONEY；status STATE NN；effective_at DT NULL；idempotency_key varchar(160) NN
|
uk_refund_allocation(secondary_refund_order_id,resale_allocation_id)；uk_idempotency(idempotency_key)；idx_batch(batch_id,create_time)
|
eb_farm_cloud_batch_progress |
IMMUTABLE |
batch_id RID NN；trigger_type CODE NN；trigger_id RID NN；effective_sold_qty/consign_qty QTY；progress_rate decimal(9,4) NN；confirmed_sales_amount/sold_principal_amount/distributable_profit MONEY；previous_milestone/reached_milestone tinyint unsigned NN；crossed_milestones JSON NN；is_settlement_trigger tinyint unsigned NN default 0；calculation_version int unsigned NN；idempotency_key varchar(160) NN
|
uk_idempotency(idempotency_key)；idx_batch_version(batch_id,calculation_version,cloud_batch_progress_id)；idx_trigger(trigger_type,trigger_id)
|
一个 group_order_id 的所有子订单和明细必须指向同一 finance_policy。resale_stock.stock_source 固定为 cloud_only，不得与普通商品库存混算。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_cloud_user_ledger |
CORE |
ledger_no NO；user_id CID NN；holding_id/batch_id RID NN；ledger_type/direction CODE NN；milestone varchar(16) NN；amount MONEY；cumulative_effective_qty EQTY；cumulative_due_amount/historical_ledger_amount/pending_posting_amount/rounding_adjustment_amount/normal_refund_offset_amount/platform_risk_absorbed_amount MONEY；calculation_version int unsigned NN；calculation_snapshot/platform_cost_policy_snapshot JSON NN；ledger_status/posting_status STATE NN；posting_id RID NULL；balance_bill_id CID NULL；idempotency_key varchar(160) NN；settled_at DT NULL
|
uk_ledger_no(ledger_no)；uk_idempotency(idempotency_key)；idx_user_status(user_id,ledger_status,cloud_user_ledger_id)；idx_posting(posting_status,status,cloud_user_ledger_id)；idx_batch(batch_id,holding_id,cloud_user_ledger_id)
|
eb_farm_cloud_buyback |
CORE |
buyback_no NO；batch_id/holding_id RID NN；user_id CID NN；remaining_equivalent_qty EQTY；unit_principal/buyback_amount MONEY；buyback_rate RATE NN；calculation_snapshot JSON NN；calculation_version int unsigned NN；target_platform_product_id/target_platform_sku_id CID NN；platform_stock_flow_id/ledger_id RID NULL；prepared_by/reviewed_by/executed_by CID NULL；prepared_at/reviewed_at/executed_at/completed_at DT NULL；review_remark varchar(500) NULL；failure_step CODE NULL；last_error varchar(1000) NULL
|
uk_buyback_no(buyback_no)；uk_holding(holding_id)；idx_batch_status(batch_id,status,cloud_buyback_id)；idx_execute(status,update_time,cloud_buyback_id)
|
eb_farm_merchant_supply_ledger |
CORE |
ledger_no NO；merchant_id CID NN；supply_id/batch_id/cloud_order_item_id RID NN；effective_qty QTY；supply_unit_price/gross_supply_amount/refund_deduction/merchant_charge_amount/settle_amount MONEY；warehouse_accepted_at/primary_completed_at/after_sale_end_at/eligible_at/settled_at DT NULL；eligible_reason CODE NULL；freeze_reason varchar(500) NULL；dispute_status STATE NN default 'none'；calculation_snapshot JSON NN；ledger_version int unsigned NN；ledger_status STATE NN；statement_item_id/posting_id RID NULL；financial_record_id CID NULL；idempotency_key varchar(160) NN
|
uk_ledger_no(ledger_no)；uk_idempotency(idempotency_key)；idx_eligible(ledger_status,eligible_at,merchant_id,merchant_supply_ledger_id)；idx_merchant_status(merchant_id,ledger_status,merchant_supply_ledger_id)
|
eb_farm_merchant_supply_statement |
CORE |
statement_no NO；merchant_id CID NN；period_start/period_end DT NN；currency char(3) NN default 'CNY'；ledger_count int unsigned NN default 0；gross_amount/deduction_amount/settle_amount MONEY；posting_id RID NULL；financial_record_id CID NULL；generated_at/reviewed_at/posted_at DT NULL；reviewed_by CID NULL；review_remark varchar(500) NULL
|
uk_statement_no(statement_no)；uk_merchant_period(merchant_id,period_start,period_end,currency)；idx_status(status,period_end,merchant_supply_statement_id)
|
eb_farm_merchant_supply_statement_item |
IMMUTABLE |
statement_id/merchant_supply_ledger_id RID NN；effective_qty QTY；supply_unit_price/gross_amount/deduction_amount/settle_amount MONEY；ledger_snapshot JSON NN
|
uk_ledger(merchant_supply_ledger_id)；idx_statement(statement_id,merchant_supply_statement_item_id)
|
eb_farm_financial_posting |
CORE |
posting_no NO；posting_key varchar(160) NN；source_type CODE NN；source_id RID NN；source_version int unsigned NN；target_account_type CODE NN；target_id CID NN；direction CODE NN；amount/balance_before/balance_after MONEY；reversal_of_posting_id RID NULL；crm_bill_type CODE NULL；crm_bill_id CID NULL；attempt_count smallint unsigned NN default 0；last_error_code varchar(64) NULL；last_error_message varchar(1000) NULL；next_retry_at/lease_until/requested_at/processing_at/posted_at DT NULL；lease_owner varchar(96) NULL；operator_type CODE NN；operator_id bigint unsigned NULL
|
uk_posting_no(posting_no)；uk_posting_key(posting_key)；idx_retry(status,next_retry_at,financial_posting_id)；idx_lease(status,lease_until,financial_posting_id)；idx_source(source_type,source_id)；idx_target(target_account_type,target_id,posted_at)
|
eb_farm_cloud_ledger_adjustment |
CORE |
adjustment_no NO；target_type CODE NN；target_id RID NN；adjustment_type CODE NN；reason_code CODE NN；reason varchar(1000) NN；evidence JSON NN；preview_snapshot JSON NN；requested_by/audited_by CID NULL；requested_at/audited_at/executed_at DT NULL；audit_remark varchar(500) NULL；executed_ledger_id RID NULL
|
uk_adjustment_no(adjustment_no)；idx_target(target_type,target_id,status)；idx_review(status,requested_at,cloud_ledger_adjustment_id)
|
正式入账表只存正数 amount，方向由 direction 表示。成功 posting 的金额、目标账户、CRMEB 流水和前后余额不可修改；更正必须新增 reversal_of_posting_id 指向原记录。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_farm |
MASTER |
farm_no NO；name varchar(120) NN；province_code/city_code/district_code varchar(16) NN；public_address varchar(255) NN；detail_address varchar(255) NULL；introduction longtext NULL；cover_image varchar(255) NULL；manager_admin_id CID NULL；longitude/latitude decimal(10,7) NULL；coordinate_system varchar(8) NULL；public_enabled tinyint unsigned NN default 0
|
uk_farm_no(farm_no)；idx_status(status,farm_id)；idx_manager(manager_admin_id,status)
|
eb_farm_zone |
MASTER |
farm_id RID NN；zone_no varchar(40) NN；name varchar(120) NN；purpose_code CODE NN；area decimal(14,3) NN default 0.000；area_unit varchar(16) NN；schematic_image varchar(255) NULL；longitude/latitude decimal(10,7) NULL；coordinate_system varchar(8) NULL
|
uk_farm_zone(farm_id,zone_no)；idx_farm_status(farm_id,status,zone_id)
|
eb_farm_plot |
MASTER |
farm_id/zone_id RID NN；plot_no varchar(40) NN；name varchar(120) NN；total_area/rentable_area decimal(14,3) NN；area_unit varchar(16) NN；soil_code/purpose_code CODE NULL；location_description varchar(500) NULL；schematic_image varchar(255) NULL；longitude/latitude decimal(10,7) NULL；coordinate_system varchar(8) NULL；maintenance_reason varchar(500) NULL
|
uk_farm_plot(farm_id,plot_no)；idx_zone_status(zone_id,status,plot_id)；idx_farm_status(farm_id,status,plot_id)
|
eb_farm_warehouse |
MASTER |
warehouse_no NO；farm_id RID NN；name varchar(120) NN；warehouse_type CODE NN；manager_admin_id CID NULL；internal_address varchar(255) NULL；longitude/latitude decimal(10,7) NULL；coordinate_system varchar(8) NULL；temperature_rule varchar(255) NULL；purpose_description varchar(500) NULL
|
uk_warehouse_no(warehouse_no)；idx_farm_status(farm_id,status,warehouse_id)
|
eb_farm_warehouse_location |
MASTER |
warehouse_id RID NN；location_no varchar(40) NN；name varchar(120) NN；zone_label/shelf_label/level_label varchar(64) NULL；allowed_category_codes JSON NN；capacity_description varchar(255) NULL
|
uk_warehouse_location(warehouse_id,location_no)；idx_warehouse_status(warehouse_id,status,warehouse_location_id)
|
eb_farm_pickup_point |
MASTER |
pickup_point_no varchar(32) NN；owner_type CODE NN default 'platform'；owner_id bigint unsigned NN default 0；business_types JSON NN（V1 仅 ['cloud']）；name varchar(120) NN；province_code/city_code/district_code varchar(16) NN；public_address/detail_address varchar(255) NN；business_hours JSON NN；contact_name varchar(80) NN；contact_phone varchar(32) NN；longitude/latitude decimal(10,7) NULL；coordinate_system varchar(8) NULL；capacity_description varchar(255) NULL
|
uk_pickup_no(pickup_point_no)；idx_owner_status(status,owner_type,owner_id,pickup_point_id)
|
坐标字段必须同时为空或同时非空；启用且公开的农场、自提点必须为合法 GCJ02。仓库和库位只在 ADM-AG-003 标签中维护。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_plot_occupancy |
CORE |
occupancy_no NO；plot_id/land_order_id RID NN；planting_batch_id RID NULL；allocation_type CODE NN；occupied_area decimal(14,3) NN；area_unit varchar(16) NN；start_at/end_at DT NN；reservation_token_hash HASH NULL；reserved_by_type CODE NULL；reserved_by bigint unsigned NULL；locked_at/lock_expires_at/actual_end_at DT NULL
|
uk_occupancy_no(occupancy_no)；uk_reservation_token(reservation_token_hash)（NULL 可重复）；idx_plot_overlap(plot_id,status,start_at,end_at,plot_occupancy_id)；idx_expiry(status,lock_expires_at,plot_occupancy_id)；idx_order(land_order_id,status)
|
eb_farm_crop |
MASTER |
crop_no NO；name varchar(120) NN；variety varchar(120) NULL；expected_cycle_days smallint unsigned NN；unit_code varchar(16) NN；cover_image varchar(255) NULL；default_task_template JSON NULL
|
uk_crop_no(crop_no)；uk_name_variety(name,variety)；idx_status(status,crop_id)
|
eb_farm_land_plan |
MASTER |
plan_no NO；name varchar(160) NN；farm_id RID NN；zone_id RID NULL；allocation_mode CODE NN；area decimal(14,3) NN；area_unit varchar(16) NN；cycle_days smallint unsigned NN；price/service_value_amount/delivery_value_amount MONEY；promised_qty/min_promised_qty QTY；promised_unit varchar(16) NN；capacity_qty QTY；delay_tolerance_days smallint unsigned NN default 7；exception_confirmation_days smallint unsigned NN default 3；shipping_rule/exception_rule/service_snapshot/agreement_snapshot JSON NN；publish_version int unsigned NN default 0；published_at DT NULL
|
uk_plan_no(plan_no)；idx_farm_status(farm_id,status,land_plan_id)；idx_publish(status,published_at,land_plan_id)
|
eb_farm_land_plan_crop |
CORE |
land_plan_id/crop_id RID NN；is_default tinyint unsigned NN default 0；service_price_delta MONEY；sort int NN default 0
|
uk_plan_crop(land_plan_id,crop_id)；idx_crop(crop_id,status)
|
eb_farm_land_order |
CORE |
land_order_no NO；group_order_id/order_id/order_product_id CID NN；user_id CID NN；plan_id/crop_id RID NN；current_occupancy_id RID NULL；promised_qty/delivered_qty/refunded_unfulfilled_qty QTY；promised_unit varchar(16) NN；service_refund_base_amount/delivery_refund_base_amount/refunded_unfulfilled_amount MONEY；delay_tolerance_days smallint unsigned NN；exception_confirmation_days smallint unsigned NN default 3；allocated_at/production_started_at/expected_harvest_at/completed_at DT NULL；rule_snapshot JSON NN + SNAPSHOT
|
uk_land_no(land_order_no)；uk_order_product(order_product_id)；idx_user_status(user_id,status,land_order_id)；idx_plan_status(plan_id,status,land_order_id)；idx_allocation(status,land_order_id)
|
start_at < end_at，occupied_area > 0 且不超地块可租面积。V1 不用单纯唯一索引代替时间重叠检查；确认事务锁地块主行后重查。
租地与认养套餐均满足 price = service_value_amount + delivery_value_amount。delay_tolerance_days 只允许 0/3/7/15/30；订单退款基数按订单明细商品实付同比例计算，且 service_refund_base_amount + delivery_refund_base_amount = goods_paid_amount。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_adoption_category |
MASTER |
category_no NO；name varchar(120) NN；default_allocation_mode CODE NN；sort int NN default 0
|
uk_category_no(category_no)；uk_name(name)
|
eb_farm_breed |
MASTER |
breed_no NO；category_id RID NN；species_name/breed_name varchar(120) NN；expected_cycle_days smallint unsigned NN；expected_output_snapshot JSON NN；cover_image varchar(255) NULL
|
uk_breed_no(breed_no)；uk_category_breed(category_id,breed_name)；idx_status(status,breed_id)
|
eb_farm_enclosure |
MASTER |
enclosure_no NO；farm_id/zone_id RID NN；name varchar(120) NN；enclosure_type CODE NN；capacity_qty QTY；unit_code varchar(16) NN；current_qty QTY；health_status STATE NN；maintenance_reason varchar(500) NULL
|
uk_enclosure_no(enclosure_no)；idx_farm_status(farm_id,status,enclosure_id)；idx_zone(zone_id,status)
|
eb_farm_animal_asset |
MASTER |
asset_no NO；breed_id/enclosure_id RID NN；ear_tag_no/chip_no varchar(80) NULL；birth_date/entry_date date NULL；sex_code CODE NULL；health_status STATE NN；allocation_status STATE NN；photo_snapshot JSON NULL；current_breeding_batch_id RID NULL
|
uk_asset_no(asset_no)；uk_ear_tag(ear_tag_no)（NULL 可重复）；uk_chip(chip_no)（NULL 可重复）；idx_enclosure_status(enclosure_id,status,animal_asset_id)；idx_allocation(allocation_status,health_status,animal_asset_id)
|
eb_farm_breeding_batch |
MASTER |
batch_no NO；breed_id/enclosure_id RID NN；total_qty/allocatable_share_qty/reserved_share_qty/allocated_share_qty QTY；unit_code varchar(16) NN；start_at/expected_end_at/actual_end_at DT NULL；health_status STATE NN
|
uk_batch_no(batch_no)；idx_enclosure_status(enclosure_id,status,breeding_batch_id)；idx_capacity(status,health_status,breeding_batch_id)
|
eb_farm_adoption_plan |
MASTER |
plan_no NO；name varchar(160) NN；breed_id/farm_id RID NN；enclosure_id/breeding_batch_id RID NULL；allocation_mode CODE NN；cycle_days smallint unsigned NN；price/service_value_amount/delivery_value_amount MONEY；capacity_qty QTY；promised_qty/min_promised_qty QTY；promised_unit varchar(16) NN；delay_tolerance_days smallint unsigned NN default 7；exception_confirmation_days smallint unsigned NN default 3；shipping_rule/exception_rule/replacement_rule/service_snapshot/agreement_snapshot JSON NN；publish_version int unsigned NN default 0；published_at DT NULL
|
uk_plan_no(plan_no)；idx_farm_status(farm_id,status,adoption_plan_id)；idx_breed_mode(breed_id,allocation_mode,status)
|
eb_farm_adoption_order |
CORE |
adoption_order_no NO；group_order_id/order_id/order_product_id CID NN；user_id CID NN；plan_id RID NN；allocation_mode CODE NN；current_allocation_id RID NULL；promised_qty/delivered_qty/refunded_unfulfilled_qty QTY；promised_unit varchar(16) NN；service_refund_base_amount/delivery_refund_base_amount/refunded_unfulfilled_amount MONEY；delay_tolerance_days smallint unsigned NN；exception_confirmation_days smallint unsigned NN default 3；allocated_at/production_started_at/expected_output_at/completed_at DT NULL；rule_snapshot JSON NN + SNAPSHOT
|
uk_adoption_no(adoption_order_no)；uk_order_product(order_product_id)；idx_user_status(user_id,status,adoption_order_id)；idx_plan_status(plan_id,status,adoption_order_id)
|
eb_farm_adoption_allocation |
CORE |
allocation_no NO；adoption_order_id RID NN；allocation_mode CODE NN；animal_asset_id/breeding_batch_id RID NULL；share_qty QTY；reservation_token_hash HASH NULL；reserved_by_type CODE NULL；reserved_by bigint unsigned NULL；locked_at/lock_expires_at/effective_from/effective_to DT NULL；replaces_allocation_id RID NULL；replacement_reason varchar(500) NULL
|
uk_allocation_no(allocation_no)；uk_reservation_token(reservation_token_hash)（NULL 可重复）；idx_asset_active(animal_asset_id,status,effective_to)；idx_batch_active(breeding_batch_id,status,effective_to)；idx_order(adoption_order_id,status)；idx_expiry(status,lock_expires_at,adoption_allocation_id)
|
eb_farm_asset_replacement |
IMMUTABLE |
exception_id RID NN；adoption_order_id RID NN；old_allocation_id/new_allocation_id RID NN；old_asset_id/new_asset_id RID NULL；reason_code CODE NN；reason_snapshot JSON NN；effective_at DT；idempotency_key varchar(160) NN
|
uk_idempotency(idempotency_key)；uk_new_allocation(new_allocation_id)；idx_order(adoption_order_id,create_time)
|
单体模式必须仅 animal_asset_id 非空且 share_qty=1.000；份额模式必须仅 breeding_batch_id 非空且 share_qty>0。有效+预留份额不得超过 allocatable_share_qty。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_production_batch |
CORE |
batch_no NO；production_type CODE NN；farm_id RID NN；zone_id RID NULL；plan_start_at/plan_end_at DT NN；actual_start_at/actual_end_at DT NULL；expected_output_qty/actual_output_qty QTY；output_unit varchar(16) NN；manager_id CID NULL；current_stage_code CODE NULL；has_open_exception tinyint unsigned NN default 0；suspended_from STATE NULL
|
uk_batch_no(batch_no)；idx_farm_status(farm_id,status,production_batch_id)；idx_manager(manager_id,status,plan_end_at)
|
eb_farm_production_plant_detail |
CORE |
production_batch_id/plot_occupancy_id/crop_id RID NN；planting_area decimal(14,3) NN；area_unit varchar(16) NN；planting_method CODE NULL；growth_stage_code CODE NULL；seed_batch_no varchar(80) NULL
|
uk_production(production_batch_id)；idx_occupancy(plot_occupancy_id)
|
eb_farm_production_livestock_detail |
CORE |
production_batch_id/enclosure_id/breed_id RID NN；breeding_batch_id RID NULL；livestock_mode CODE NN；current_qty QTY；unit_code varchar(16) NN；growth_stage_code CODE NULL
|
uk_production(production_batch_id)；idx_enclosure(enclosure_id,status)；idx_breeding_batch(breeding_batch_id,status)
|
eb_farm_production_right_link |
CORE |
production_batch_id RID NN；business_type CODE NN；business_id RID NN；plot_occupancy_id/adoption_allocation_id RID NULL；right_rate RATE NN default 10000；promised_qty QTY；promised_unit varchar(16) NN
|
uk_production_right(production_batch_id,business_type,business_id)；idx_business(business_type,business_id,status)
|
eb_farm_task |
CORE |
task_no NO；task_type CODE NN；farm_id RID NN；zone_id RID NULL；target_type CODE NN；target_id RID NN；production_batch_id/output_batch_id/fulfillment_id RID NULL；planned_at/due_at/completed_at DT NULL；requirement_snapshot JSON NN；assignee_service_id CID NULL；priority tinyint unsigned NN default 3；scope_version int unsigned NULL
|
uk_task_no(task_no)；idx_assignee(assignee_service_id,status,due_at,task_id)；idx_target(target_type,target_id,status)；idx_farm(farm_id,status,due_at)
|
eb_farm_task_assignment |
IMMUTABLE |
task_id RID NN；from_service_id/to_service_id CID NULL；duty_code CODE NN；scope_snapshot JSON NN；reason_code CODE NN；reason varchar(500) NULL；assigned_by_type CODE NN；assigned_by bigint unsigned NN；started_at DT；ended_at DT NULL；assignment_version int unsigned NN
|
uk_task_version(task_id,assignment_version)；idx_service(to_service_id,ended_at,task_id)
|
eb_farm_production_event |
CORE |
event_no NO；production_batch_id RID NN；task_id/animal_asset_id RID NULL；event_type CODE NN；current_version_id RID NULL；review_status/publish_status STATE NN；occurred_at DT NN
|
uk_event_no(event_no)；idx_batch_time(production_batch_id,occurred_at,production_event_id)；idx_review(review_status,status,production_event_id)
|
eb_farm_production_event_version |
IMMUTABLE |
production_event_id RID NN；version_no int unsigned NN；occurred_at DT NN；operator_service_id CID NULL；content longtext NN；material_snapshot JSON NULL；visibility CODE NN；submitted_by/reviewed_by CID NULL；submitted_at/reviewed_at DT NULL；review_remark varchar(500) NULL；content_hash HASH NN；status STATE NN
|
uk_event_version(production_event_id,version_no)；uk_content_hash(production_event_id,content_hash)；idx_review(status,submitted_at,production_event_version_id)
|
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_output_batch |
CORE |
output_no NO；production_batch_id RID NN；output_type CODE NN；product_name varchar(160) NN；spec varchar(160) NULL；unit_code varchar(16) NN；total_qty/pending_inspection_qty/qualified_qty/rejected_qty/loss_qty/available_qty/allocated_qty/shipped_qty/cancelled_qty/frozen_qty/disposed_qty QTY；produced_at/expire_at DT NULL；quality_status STATE NN；warehouse_id/warehouse_location_id RID NULL；quality_snapshot JSON NULL
|
uk_output_no(output_no)；idx_production(production_batch_id,status,output_batch_id)；idx_available(status,available_qty,output_batch_id)；idx_expiry(status,expire_at,output_batch_id)
|
eb_farm_output_inventory_flow |
IMMUTABLE |
output_batch_id RID NN；unit_code varchar(16) NN；pool_from/pool_to CODE NULL；change_qty/before_qty/after_qty QTY；business_type CODE NN；business_id RID NN；idempotency_key varchar(160) NN；occurred_at DT；operator_type CODE NN；operator_id bigint unsigned NULL
|
uk_idempotency(idempotency_key)；idx_output_time(output_batch_id,occurred_at,output_inventory_flow_id)；idx_business(business_type,business_id)
|
eb_farm_output_allocation |
CORE |
output_batch_id RID NN；business_type CODE NN；business_id RID NN；allocated_qty QTY；unit_code varchar(16) NN；fulfillment_id RID NULL；allocation_sequence int unsigned NN；calculation_version int unsigned NN；idempotency_key varchar(160) NN
|
uk_idempotency(idempotency_key)；uk_business_sequence(business_type,business_id,allocation_sequence)；idx_output_status(output_batch_id,status,output_allocation_id)；idx_business(business_type,business_id,status)
|
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_fulfillment |
CORE |
fulfillment_no NO；business_type CODE NN；business_id RID NN；user_id CID NN；sequence_no int unsigned NN；planned_qty/shipped_qty/completed_qty/refunded_qty QTY；unit_code varchar(16) NN；address_status STATE NN；address_version int unsigned NN default 0；address_snapshot JSON NULL；freight_rule_snapshot JSON NN；split_reason CODE NN default 'normal'；freight_payer CODE NN；delivery_type CODE NN default 'express'；current_freight_order_id RID NULL；address_due_at/receive_due_at/next_reminder_at/completed_at DT NULL
|
uk_fulfillment_no(fulfillment_no)；uk_business_sequence(business_type,business_id,sequence_no)；idx_user_status(user_id,status,fulfillment_id)；idx_reminder(status,next_reminder_at,fulfillment_id)；idx_address_due(status,address_due_at,fulfillment_id)；idx_receive_due(status,receive_due_at,fulfillment_id)
|
eb_farm_fulfillment_item |
CORE |
fulfillment_id/output_allocation_id/output_batch_id RID NN；unit_code varchar(16) NN；planned_qty/outbound_qty/returned_qty/refunded_qty QTY
|
uk_fulfillment_allocation(fulfillment_id,output_allocation_id)；idx_output(output_batch_id,status)
|
eb_farm_fulfillment_package |
CORE |
package_no NO；fulfillment_id RID NN；carrier_code varchar(32) NULL；tracking_no varchar(80) NULL；package_qty QTY；weight decimal(14,3) NULL；weight_unit varchar(16) NULL；shipped_at/received_at DT NULL；shipping_evidence JSON NULL
|
uk_package_no(package_no)；uk_carrier_tracking(carrier_code,tracking_no)（NULL 可重复）；idx_fulfillment(fulfillment_id,status,fulfillment_package_id)
|
eb_farm_fulfillment_package_item |
IMMUTABLE |
package_id/fulfillment_item_id RID NN；qty QTY；unit_code varchar(16) NN
|
uk_package_item(package_id,fulfillment_item_id)；idx_item(fulfillment_item_id)
|
eb_farm_fulfillment_freight_order |
CORE |
freight_order_no NO；fulfillment_id RID NN；user_id CID NN；address_version/quote_version int unsigned NN；address_snapshot/freight_rule_snapshot/charge_basis_snapshot JSON NN；quote_hash HASH NN；freight_amount/paid_amount/refund_amount MONEY；business_status/pay_status/refund_status STATE NN；pay_type/pay_driver CODE NULL；provider_transaction_id/provider_refund_id varchar(96) NULL；expired_at/paid_at/refunded_at DT NULL；error_code varchar(64) NULL；error_message varchar(500) NULL
|
uk_freight_no(freight_order_no)；uk_provider_tx(provider_transaction_id)（NULL 可重复）；idx_fulfillment(fulfillment_id,status)；idx_repair(pay_status,refund_status,update_time,fulfillment_freight_order_id)
|
农业运费支付 attach 固定为 farm_output_freight。农业产出只使用快递履约，不写 eb_farm_cloud_pickup。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_trace_archive |
CORE |
trace_no NO；public_code varchar(48) NN；archive_type CODE NN；farm_id/production_batch_id/output_batch_id RID NULL；current_draft_version_id/current_published_version_id RID NULL；public_summary varchar(500) NULL
|
uk_trace_no(trace_no)；uk_public_code(public_code)；uk_source(archive_type,production_batch_id,output_batch_id)；idx_status(status,trace_archive_id)
|
eb_farm_trace_version |
IMMUTABLE |
archive_id RID NN；version_no int unsigned NN；title varchar(160) NN；public_snapshot JSON NN；content_hash HASH NN；submitted_by/reviewed_by/published_by/withdrawn_by CID NULL；submitted_at/reviewed_at/published_at/withdrawn_at DT NULL；review_remark/withdraw_reason varchar(500) NULL；status STATE NN
|
uk_archive_version(archive_id,version_no)；uk_archive_hash(archive_id,content_hash)；idx_review(status,submitted_at,trace_version_id)
|
eb_farm_trace_material |
CORE |
archive_id/version_id RID NN；material_type CODE NN；material_no varchar(80) NULL；attachment_id CID NN（逻辑引用 eb_system_attachment.attachment_id）；issuer varchar(160) NULL；effective_at/expire_at DT NULL；content_hash HASH NN；display_name varchar(160) NN
|
idx_archive_version(archive_id,version_id,status)；idx_expiry(status,expire_at,trace_material_id)；idx_attachment(attachment_id)
|
eb_farm_trace_link |
CORE |
archive_id/version_id RID NN；target_type CODE NN；target_id bigint unsigned NN；relation_type CODE NN；valid_from/valid_to DT NULL；source_type CODE NN
|
uk_relation(archive_id,version_id,target_type,target_id,relation_type)；idx_target(target_type,target_id,status)
|
public_code 使用不可枚举随机值，不编码内部 ID。撤回不删除档案、版本、材料或二维码入口。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_exception_event |
CORE |
event_no NO；business_domain CODE NN；event_type CODE NN；farm_id/production_batch_id RID NULL；severity tinyint unsigned NN；sla_due_at DT NN；owner_type CODE NULL；owner_id bigint unsigned NULL；reason longtext NN；fact_snapshot JSON NN；freeze_flags JSON NN；current_impact_version int unsigned NN default 0；current_plan_version_id RID NULL；resolved_at/closed_at DT NULL
|
uk_event_no(event_no)；idx_sla(status,sla_due_at,exception_event_id)；idx_owner(owner_type,owner_id,status)；idx_farm(farm_id,status,exception_event_id)
|
eb_farm_exception_impact |
CORE |
exception_id RID NN；impact_version int unsigned NN；target_type CODE NN；target_id bigint unsigned NN；impact_type CODE NN；impact_qty QTY；impact_amount MONEY；unit_code varchar(16) NULL；before_snapshot/expected_snapshot JSON NN；calculated_at DT NN
|
uk_impact(exception_id,impact_version,target_type,target_id,impact_type)；idx_target(target_type,target_id,status)
|
eb_farm_exception_plan_version |
IMMUTABLE |
exception_id RID NN；version_no int unsigned NN；impact_version int unsigned NN；plan_type CODE NN；plan_snapshot/expected_result_snapshot/equivalence_snapshot/allocation_snapshot JSON NN；affected_qty/refund_qty QTY；service_refund_base_amount/delivery_refund_base_amount/cumulative_refund_due/current_refund_amount MONEY；requires_user_confirm tinyint unsigned NN default 0；confirmation_deadline_at/confirmed_at DT NULL；confirmation_result/timeout_policy CODE NULL；submitted_by/reviewed_by/confirmed_by CID NULL；submitted_at/reviewed_at DT NULL；review_remark varchar(500) NULL；precheck_hash HASH NULL；precheck_expire_at DT NULL；status STATE NN
|
uk_exception_version(exception_id,version_no)；idx_review(status,submitted_at,exception_plan_version_id)；idx_confirm(status,confirmation_deadline_at,exception_plan_version_id)
|
eb_farm_exception_execution_step |
CORE |
exception_id/plan_version_id RID NN；step_order smallint unsigned NN；step_code CODE NN；is_required tinyint unsigned NN default 1；input_snapshot/before_snapshot/after_snapshot/compensation_snapshot JSON NULL；result_key varchar(160) NN；attempt_count smallint unsigned NN default 0；next_retry_at/started_at/completed_at DT NULL；error_code varchar(64) NULL；error_message varchar(1000) NULL
|
uk_plan_step(exception_id,plan_version_id,step_code)；uk_result_key(result_key)；idx_execute(status,next_retry_at,exception_execution_step_id)；idx_plan_order(plan_version_id,step_order)
|
异常影响和方案必须版本化。执行步骤只能使用 33 中允许的 step_code，不得把任意 SQL、类名、URL 或脚本保存为可执行参数。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_order_binding |
CORE |
group_order_id/order_id/order_product_id CID NN；user_id CID NN；merchant_id CID NULL；business_type/aggregate_type CODE NN；aggregate_id RID NN；finance_policy/stock_policy/fulfillment_policy CODE NN；payment_status/refund_status STATE NN
|
uk_order_product(order_product_id)；idx_group(group_order_id,finance_policy,status)；idx_order(order_id,status)；idx_aggregate(business_type,aggregate_type,aggregate_id)；idx_payment(payment_status,status,binding_id)
|
eb_farm_idempotency_record |
CORE |
operation_code CODE NN；actor_type CODE NN；actor_id bigint unsigned NN；request_id char(36) NN；request_hash HASH NN；response_status varchar(16) NULL；response_snapshot JSON NULL；target_type/result_type CODE NULL；target_id/result_id bigint unsigned NULL；locked_until/expired_at DT NULL
|
uk_http_idempotency(operation_code,actor_type,actor_id,request_id)；idx_lease(status,locked_until,idempotency_record_id)；idx_expire(status,expired_at,idempotency_record_id)
|
eb_farm_domain_outbox |
CORE |
event_id char(26) NN；event_type varchar(96) NN；event_version smallint unsigned NN；aggregate_type CODE NN；aggregate_id bigint unsigned NN；aggregate_version int unsigned NN；trace_id char(26) NN；source CODE NN；payload JSON NN；occurred_at/published_at/next_retry_at/lease_until DT NULL；retry_count smallint unsigned NN default 0；lease_owner varchar(96) NULL；last_error varchar(1000) NULL
|
uk_event_id(event_id)；idx_dispatch(status,next_retry_at,event_id)；idx_lease(status,lease_until,event_id)；idx_aggregate(aggregate_type,aggregate_id,occurred_at)
|
eb_farm_event_consume_log |
CORE |
event_id char(26) NN；consumer_name varchar(96) NN；event_type varchar(96) NN；event_version smallint unsigned NN；started_at/finished_at/next_retry_at DT NULL；duration_ms int unsigned NULL；retry_count smallint unsigned NN default 0；result_business_key varchar(160) NULL；last_error varchar(1000) NULL
|
uk_event_consumer(event_id,consumer_name)；idx_retry(status,next_retry_at,event_consume_log_id)；idx_result(result_business_key)
|
eb_farm_job_run |
CORE |
job_name varchar(96) NN；run_key varchar(160) NN；scheduled_for DT NN；timezone varchar(40) NN default 'Asia/Shanghai'；shard_key varchar(80) NULL；selector_snapshot JSON NN；cursor_value varchar(255) NULL；lease_owner varchar(96) NULL；lease_until/timeout_at/next_retry_at/started_at/finished_at DT NULL；retry_count smallint unsigned NN default 0；scanned_count/success_count/failed_count int unsigned NN default 0；last_error varchar(1000) NULL
|
uk_job_run(job_name,run_key)；idx_lease(status,lease_until,job_run_id)；idx_retry(status,next_retry_at,job_run_id)；idx_job_time(job_name,scheduled_for,job_run_id)
|
eb_farm_notification_log |
CORE |
template_code varchar(64) NN；channel CODE NN；receiver_type CODE NN；receiver_id bigint unsigned NN；business_type CODE NN；business_id bigint unsigned NN；business_key varchar(160) NN；content_snapshot JSON NN；provider_message_id varchar(128) NULL；scheduled_at/sent_at/next_retry_at DT NULL；retry_count smallint unsigned NN default 0；last_error varchar(1000) NULL
|
uk_notification(template_code,channel,receiver_type,receiver_id,business_key)；idx_send(status,scheduled_at,notification_log_id)；idx_business(business_type,business_id)
|
eb_farm_audit_log |
IMMUTABLE |
operator_type CODE NN；operator_id bigint unsigned NULL；action_code CODE NN；target_type CODE NN；target_id bigint unsigned NN；before_snapshot/after_snapshot JSON NULL；reason_code CODE NULL；reason varchar(1000) NULL；request_id char(36) NULL；trace_id char(26) NN；ip varchar(45) NULL；user_agent varchar(500) NULL；occurred_at DT
|
idx_target(target_type,target_id,occurred_at,audit_log_id)；idx_operator(operator_type,operator_id,occurred_at,audit_log_id)；idx_trace(trace_id)
|
eb_farm_state_transition |
IMMUTABLE |
aggregate_type CODE NN；aggregate_id bigint unsigned NN；from_status/to_status STATE NULL；event_code varchar(96) NULL；operation_code CODE NN；aggregate_version int unsigned NN；idempotency_key varchar(160) NN；operator_type CODE NN；operator_id bigint unsigned NULL；reason_code CODE NULL；reason_snapshot JSON NULL；occurred_at DT
|
uk_transition(aggregate_type,aggregate_id,idempotency_key)；idx_aggregate_time(aggregate_type,aggregate_id,occurred_at,state_transition_id)；idx_event(event_code,occurred_at)
|
eb_farm_async_operation |
CORE |
operation_no NO；operation_type CODE NN；target_type CODE NN；target_id bigint unsigned NULL；requested_by_type CODE NN；requested_by_id bigint unsigned NN；request_key varchar(160) NN；progress_total/progress_done/success_count/failure_count int unsigned NN default 0；current_step CODE NULL；result_summary JSON NULL；result_file_id CID NULL（逻辑引用 eb_system_attachment.attachment_id）；error_code varchar(64) NULL；error_message varchar(1000) NULL；lease_owner varchar(96) NULL；lease_until/next_retry_at/started_at/finished_at DT NULL
|
uk_operation_no(operation_no)；uk_request_key(request_key)；idx_owner(requested_by_type,requested_by_id,status,async_operation_id)；idx_lease(status,lease_until,async_operation_id)
|
CORE 模板中的业务 status 不替代该表自身列出的细分状态；实现时只保留一列 status，不得重复创建 ledger_status/status 等含义冲突列。对于账本等确需业务状态与 posting 状态并存的表，分别保留明确命名。
| 表 | 模板 | 业务列（类型、空值、默认） | 唯一键/索引 |
|---|---|---|---|
eb_farm_service_profile |
自定义 |
profile_id PK；service_id CID NN；farm_enabled/mobile_enabled tinyint unsigned NN default 0；default_workspace varchar(20) NN default 'chat'；scope_version int unsigned NN default 1；last_scope_change_at DT NULL；create_time DT；update_time DT NULL
|
uk_service(service_id) |
eb_farm_service_scope |
自定义 |
scope_id PK；service_id CID NN；merchant_id CID NN default 0；duty_code varchar(40) NN；scope_type CODE NN；scope_object_id bigint unsigned NN default 0；valid_from DT NN；valid_to DT NULL；status tinyint unsigned NN default 1；created_by_type CODE NN；created_by_id bigint unsigned NN；revoke_reason varchar(255) NULL；create_time DT；update_time DT NULL
|
uk_service_duty_scope(service_id,duty_code,scope_type,scope_object_id)；idx_service_valid(service_id,status,valid_from,valid_to)；idx_scope_object(scope_type,scope_object_id,status)
|
eb_farm_admin_scope |
自定义 |
scope_id PK；admin_id CID NN；domain_code CODE NN；scope_type CODE NN；scope_object_id bigint unsigned NN default 0；valid_from DT NN；valid_to DT NULL；status tinyint unsigned NN default 1；scope_set_version int unsigned NN；version VER；created_by/updated_by CID NN；create_time DT；update_time DT NULL
|
uk_admin_domain_scope(admin_id,domain_code,scope_type,scope_object_id)；idx_admin_scope_valid(admin_id,domain_code,status,valid_from,valid_to)；idx_scope_object(scope_type,scope_object_id,status)；idx_admin_set_version(admin_id,scope_set_version)
|
eb_farm_evidence_attachment |
自定义 |
attachment_id PK；attachment_no varchar(32) NN；service_id CID NN；merchant_id CID NN default 0；task_id RID NULL；scope_object_type CODE NN；scope_object_id bigint unsigned NN；storage_type tinyint unsigned NN；storage_path varchar(512) NN；original_name varchar(255) NN；mime_type varchar(100) NN；file_ext varchar(20) NN；file_size bigint unsigned NN；content_hash HASH NN；business_type CODE NULL；business_id bigint unsigned NULL；status STATE NN；expires_at/bound_at DT NULL；create_time DT；update_time DT NULL
|
uk_attachment_no(attachment_no)；idx_owner(service_id,status,create_time)；idx_expire(status,expires_at,attachment_id)；idx_business(business_type,business_id)；idx_hash(content_hash)
|
eb_system_attachment.attachment_id 与 eb_farm_evidence_attachment.attachment_id 是两个独立 ID 域：平台/商户商品材料、供货材料、溯源材料和异步结果文件使用前者；服务/现场端离线草稿与证据绑定使用后者。所有 DTO 和 Repository 必须按字段语义分别校验归属，禁止只凭同名数值互换。
权限菜单决定“能否调用”，scope 表决定“能操作哪条数据”。对象越界时详情和写命令统一按不存在处理；内部审计记录真实拒绝原因。
管理员范围唯一键表示一个范围对象始终复用同一行。重新授权已停用范围时更新该行的 status/valid_from/valid_to/updated_by/version/scope_set_version；不得插入第二行。一次全量保存的新增、保留、停用和重新启用行统一写相同的新 scope_set_version，完整前后历史进入 eb_farm_audit_log。
| 顺序 | migration 组 | 表/变更 | 验证 |
|---|---|---|---|
M01 |
兼容预检 | CRMEB 金额列容量、服务账号空值/重复 | 全部通过才继续 |
M02 |
核心支撑 | idempotency、outbox、consume log、job run、audit、transition、async operation | 唯一键和租约扫描 EXPLAIN
|
M03 |
权限附件 | service/admin scope、service profile、evidence attachment | 越权/空范围/过期范围 |
M04 |
农场主数据 | farm、zone、plot、warehouse、location、pickup、crop、认养基础表 | 编号唯一、坐标、停用引用 |
M05 |
商品/供货 | product profile/material、supply/delivery/inspection/material/return/acquisition | 数量方程、来源 SKU、退回/承接结果键 |
M06 |
云仓活动库存 | activity/product/sku/quota/batch/pool/flow/resale stock | 活动发布和库存守恒 |
M07 |
订单与交易 | binding、首次明细、运费/退款、自提、持仓、二次分配/退款/进度 | 创建/支付/取消/退款回归 |
M08 |
财务 | 用户/商户账本、结单/明细、posting、adjustment、buyback | 入账唯一键和精度算例 |
M09 |
权益生产 | land/adoption order、occupancy/allocation、production/task/event | 并发预留、替换历史 |
M10 |
产出履约 | output/flow/allocation、fulfillment/item/package/freight | 数量方程、多包裹、运费 |
M11 |
异常溯源 | exception/impact/plan/step/replacement、trace 四表 | 版本、步骤结果键、稳定二维码 |
M12 |
菜单配置 |
system_menu、权限码、配置项；不写业务交易数据 |
四端菜单与权限矩阵 |
-
M02~M12尚无业务事实时可按逆序移除新表；有任一业务事实后只允许应用版本前滚，禁止删表回滚。 - 可空适配列可在确认无引用后删除；扩大后的 CRMEB 金额列和已经依赖的唯一账号约束不自动缩回。
- 菜单可停用，权限和业务历史不可通过删菜单清除。
- 每个
15中出现的eb_farm_*表在本文件恰好有一条物理定义。 - 每个 Model/DAO/Repository 都能在
21、35找到对应表；不得出现无表模型或无模型核心表。 - 每个写操作的事务写集都能定位到具体列、唯一键和索引。
- 每个 Job 选择器和游标都有本文件冻结的组合索引。
- 所有金额、数量、比例、状态、时间、快照和操作者列均有明确类型与空值规则。
- migration 注释必须列出状态常量来源，不在 DDL 中复制一套可能漂移的中文状态。
- 开发前执行表名、列名和索引名静态核对；开发完成后在全新库和升级副本各跑一次 migration/verify。
- 首页
- 项目总览
- 项目立项
- 端与角色
- 供应链经营闭环
- 模块地图
- V1 范围 PRD
- 任务拆解
- 结算与账本
- V1 结算口径
- 云仓秒杀
- CRMEB 底座能力映射
- 当前菜单页面审计
- V1 决策与术语
- 云仓流程与状态机
- 租地认养与溯源 PRD
- V1 数据模型草案
- 开发前设计计划
- V1 信息架构
- 页面与原型规格
- V1 API 契约草案
- 事件任务权限通知
- 五项目代码改造蓝图
- 测试验收发布与手册计划
- CRMEB 视觉基线审计
- G3/G4 决策登记表
- 用户端 uni-app 复用审计
- 开发前主清单
- 自主设计工作指引
- V1 需求追踪矩阵
- G3 技术专项验证报告
- V1 P0 页面矩阵
- 写操作契约注册表
- 事件任务操作注册表
- 状态异常事务矩阵
- 数据库字段字典
- 页面 API 文件追踪
- V1 ER 图
- API 字段契约注册表
- 平台管理员手册
- 商户手册
- 用户帮助
- 服务与现场手册
- 开发任务包
- 测试目录与 Fixtures
- 发布与运维手册
- 设计交付与研发交接