mftproductionreportemployee.md 5.5 KB

Edit Raw Blame History



mftproductionreportemployee


送货通知单从表


Rows (estimated): 443

Data size: 288.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:53:34

Updated: 2026-04-27 18:53:34


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(100)
NO
MUL


唯一ID


3
sBrandsId
varchar(100)
NO


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
sMakePerson
varchar(255)
NO


制单人


6
iOrder
int
NO

0

排序号


7
sParentId
varchar(100)
NO


父级ID


8
sSlaveId
varchar(100)
NO


从表Id


9
sEmployeeId
varchar(255)
YES


员工Id


10
dProportion
decimal(18,6)
NO

0.000000

比例


11
dWageMoney
decimal(18,6)
NO

0.000000

计件工资


12
dTimeMoney
decimal(18,6)
NO

0.000000

工时工资


13
dLossMoney
decimal(18,6)
NO

0.000000

损失金额


14
dOtherMoney
decimal(18,6)
NO

0.000000

其他金额


15
dJobMoney
decimal(18,6)
NO

0.000000

岗位工资


16
sEReserve1
varchar(255)
YES


预留字符1


17
sEReserve2
varchar(255)
YES


预留字符2


18
sEReserve3
varchar(255)
YES


预留字符3


19
sEReserve4
varchar(255)
YES


预留字符4


20
sEReserve5
varchar(255)
YES


预留字符5


21
sEReserve6
varchar(255)
YES


预留字符6


22
dEReserve1
decimal(18,6)
YES


预留数字1


23
dEReserve2
decimal(18,6)
YES


预留数字2


24
dEReserve3
decimal(18,6)
YES


预留数字3


25
iEReserve1
int
YES


预留整型1


26
iEReserve2
int
YES


预留整型2


27
iEReserve3
int
YES


预留整型3


28
tEReserve1
datetime
YES


预留日期1


29
tEReserve2
datetime
YES


预留日期2


30
dHour
decimal(18,6)
NO

0.000000

工时


31
dHourWage
decimal(18,6)
NO

0.000000

准备时间


32
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED


33
bCalcWage
bit(1)
YES

b'0'

是否计算工资


34
dConversionCalQty
decimal(18,6)
YES

0.000000

分摊折算上报数


35
dEmpNum
decimal(18,2)
YES

1.00

人数


36
dMakeReadyMoney
decimal(18,6)
NO

0.000000

调机费用


37
dOriginalProportion
decimal(18,6)
NO

0.000000

原始比例


38
dOriginalWageMoney
decimal(18,6)
NO

0.000000

原始计件工资


39
dProcessCalQty
decimal(18,6)
YES

0.000000

上报数量


40
dWageMoney1
decimal(18,6)
NO

0.000000

奖项1金额


41
dWageMoney10
decimal(18,6)
NO

0.000000

奖项10金额


42
dWageMoney11
decimal(18,6)
NO

0.000000

奖项11金额


43
dWageMoney12
decimal(18,6)
NO

0.000000

奖项12金额


44
dWageMoney13
decimal(18,6)
NO

0.000000

奖项13金额


45
dWageMoney14
decimal(18,6)
NO

0.000000

奖项14金额


46
dWageMoney15
decimal(18,6)
NO

0.000000

奖项15金额


47
dWageMoney16
decimal(18,6)
NO

0.000000

奖项16金额


48
dWageMoney17
decimal(18,6)
NO

0.000000

奖项17金额


49
dWageMoney18
decimal(18,6)
NO

0.000000

奖项18金额


50
dWageMoney19
decimal(18,6)
NO

0.000000

奖项19金额


51
dWageMoney2
decimal(18,6)
NO

0.000000

奖项2金额


52
dWageMoney20
decimal(18,6)
NO

0.000000

奖项20金额


53
dWageMoney21
decimal(18,6)
NO

0.000000

奖项21金额


54
dWageMoney22
decimal(18,6)
NO

0.000000

奖项22金额


55
dWageMoney23
decimal(18,6)
NO

0.000000

奖项23金额


56
dWageMoney24
decimal(18,6)
NO

0.000000

奖项24金额


57
dWageMoney25
decimal(18,6)
NO

0.000000

奖项25金额


58
dWageMoney3
decimal(18,6)
NO

0.000000

奖项3金额


59
dWageMoney4
decimal(18,6)
NO

0.000000

奖项5金额


60
dWageMoney6
decimal(18,6)
NO

0.000000

奖项6金额


61
dWageMoney7
decimal(18,6)
NO

0.000000

奖项7金额


62
dWageMoney8
decimal(18,6)
NO

0.000000

奖项8金额


63
dWageMoney9
decimal(18,6)
NO

0.000000

奖项9金额


64
sDaySumReportId
varchar(50)
NO


日统计Id


65
sEmpMemo
text
YES


Indexes


Name
Unique
Type
Columns


IndexN_mftproductionreportemployee

BTREE

sId, sBrandsId, sSubsidiaryId, sParentId


IndexU_mftproductionreportemployee
✓
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.