sissalarystructureplan.md 1.32 KB

sissalarystructureplan

  • Engine: InnoDB
  • Collation: utf8mb4_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO 0 自增列
2 sId varchar(100) NO 标准ID
3 sBrandsId varchar(100) NO 加工商ID
4 sSubsidiaryId varchar(100) NO 子公司ID
5 sMakePerson varchar(255) NO 制单人
6 iOrder int NO 0 排序号
7 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
8 sSalaryItem varchar(255) YES 工资项目
9 sFormulaId varchar(50) YES 计算方案Id
10 sCycle varchar(50) YES 周期("1":"日统计","2":"月统计")
11 sAward varchar(50) YES 奖项("1":"超产桨")
12 sType varchar(50) YES 常量("1":"内置")
13 sTeamType varchar(50) YES 1 班次("1":"白班","2":"夜班","0":"不区分")
14 bCalcType bit(1) NO b'0' 是否分摊

Narrative

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