mftworkorderslavemoney_tmp.md
1.51 KB
mftworkorderslavemoney_tmp
工单计算从表分摊
- Rows (estimated): 8102
- Data size: 2.5 MB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:54:39
- Updated: 2026-04-27 18:54:40
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | sId |
varchar(100) |
NO | PRI | |||
| 2 | sSlaveId |
varchar(100) |
NO | MUL | |||
| 3 | sSlaveProcessTbId |
varchar(100) |
NO | MUL | |||
| 4 | sSlaveProcessId |
varchar(100) |
NO | MUL | |||
| 5 | sSlaveProcessType |
varchar(100) |
NO | ||||
| 6 | sSlaveProcessName |
varchar(100) |
NO | ||||
| 7 | dMoney |
decimal(18,6) |
NO | ||||
| 8 | sStatus |
varchar(10) |
NO | ||||
| 9 | sParentId |
varchar(100) |
NO | ||||
| 10 | sMakePerson |
varchar(100) |
NO | ||||
| 11 | sBrandsId |
varchar(100) |
NO | MUL | |||
| 12 | sSubsidiaryId |
varchar(100) |
NO |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
IndexN_1 |
BTREE | sSlaveProcessTbId |
|
IndexN_2 |
BTREE | sSlaveProcessId |
|
IndexN_3 |
BTREE |
sBrandsId, sSubsidiaryId, sParentId, sSlaveId
|
|
IndexN_mftworkorderslavemoney_tmp |
BTREE | sSlaveId |
|
IndexU_1 |
✓ | BTREE | sId |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.