kpimaster.md 1.74 KB

kpimaster

班组

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO PRI auto_increment 自增列
2 sId varchar(255) NO MUL 标准ID
3 sBrandsId varchar(255) NO MUL 加工商ID
4 sSubsidiaryId varchar(255) NO 子公司ID
5 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 统计日期
6 sMakePerson varchar(255) NO 操作人员
7 iOrder int NO 排序
8 sUnTaskFromId varchar(255) NO MUL 未清模块Id
9 iTodayTotal int YES 0 今天总数
10 iTotal varchar(255) YES 当前模块未清总数
11 iTodayNo int YES 0 今天未完成
12 iTodayOk int YES 0 今日已完成
13 iTodayStandard int YES 0 今日达标
14 dCompRate decimal(18,6) NO 0.000000 达标率
15 drewardMoney decimal(18,6) NO 0.000000 奖励
16 dpunishmentMoney decimal(18,6) NO 0.000000 惩罚

Indexes

Name Unique Type Columns
IndexN_kpimaster BTREE sBrandsId, sSubsidiaryId, sUnTaskFromId
IndexN_kpimaster1 BTREE sUnTaskFromId
IndexU_eleteam BTREE sId, sBrandsId, sSubsidiaryId
PRIMARY BTREE iIncrement

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.