kpimoduleuser.md 1.19 KB

kpimoduleuser

KPI工作量个人统计表

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO PRI auto_increment 自增列
2 sId varchar(100) NO 唯一ID
3 sBrandsId varchar(100) NO MUL 加工商ID
4 sSubsidiaryId varchar(100) NO 子公司ID
5 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 制单日期
6 sModelId varchar(100) NO 模块Id
7 sUserId varchar(100) NO 用户ID
8 sTobeDone varchar(10) YES 总数
9 sToDayNum varchar(10) YES 今日
10 sErroMsg text YES

Indexes

Name Unique Type Columns
IndexU_sModelId BTREE sBrandsId, sSubsidiaryId, sModelId
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.