应帆Yinfluencer达分销数据管理平台

基于关系型数据库（InnoDB引擎）构建，用于存储多维度的订单明细数据。表结构采用行式存储，单条记录对应一个订单明细，通过列定义各项属性，并利用索引与约束保障查询性能及数据完整性。
核心表为 yinfluencer.order_item，使用 id 字段作为自增主键，唯一标识每条订单记录。数据表字符集为 utf8mb4，支持存储 emoji 及特殊字符。核心字段分为以下几类：1）标识类：如 order_platform_id、product_id，用于关联平台及商品；2）基础信息类：包括 platform、product_name 等；3）金额类：如 payment_amout、settled_kickback；4）时间类：如 order_time、payment_time 等时间戳信息；5）状态类：如order_status、deleted 标记订单与删除状态。
为提升查询效率，表结构设计了普通索引（如 order_platform_idx）及联合索引 kol_page_idx，以支持高频条件与分页筛选。同时通过主键约束、非空约束及默认值设置，确保数据一致性与业务规则执行。

Built on a relational database (InnoDB engine), this dataset is designed to store multi-dimensional order detail data. The table structure adopts row-based storage, with each record corresponding to one order detail. Various attributes are defined via table columns, and indexes and constraints are leveraged to ensure query performance and data integrity.

The core table is `yinfluencer.order_item`, which takes the `id` field as its auto-incrementing primary key to uniquely identify every order record. The data table uses the utf8mb4 character set, which supports the storage of emojis and special characters. The core fields are categorized into the following types:
1) Identification Fields: such as "order_platform_id" and "product_id", which are used to associate with external platforms and products;
2) Basic Information Fields: including "platform", "product_name", and other similar attributes;
3) Amount Fields: such as "payment_amout" and "settled_kickback";
4) Time Fields: timestamp-related information including "order_time", "payment_time", and other similar timestamp fields;
5) Status Fields: such as "order_status" and "deleted", which mark the order state and deletion state respectively.

To enhance query efficiency, the table structure is configured with regular indexes (e.g., "order_platform_idx") and composite indexes ("kol_page_idx") to support high-frequency query conditions and paging filtering. Additionally, primary key constraints, non-null constraints and default value configurations are applied to guarantee data consistency and enforce business rules.

搜集汇总

背景与挑战

背景概述

该数据集是上海应帆数字科技有限公司申请的数据加工集合，名称为'应帆Yinfluencer达分销数据管理平台'，于2025年12月11日公示。它属于数据产品知识产权登记的一部分，主要用于分销数据管理。