calcproductcontralsphase.md
8.4 KB
calcproductcontralsphase
- Rows (estimated): 79
- Data size: 224.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:51:55
- Updated: 2026-04-27 18:51:55
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | sId |
varchar(100) |
NO | MUL | |||
| 2 | sSlaveId |
varchar(100) |
NO | ||||
| 3 | sWorkOrderId |
varchar(100) |
NO | ||||
| 4 | sWorkSlaveId |
varchar(100) |
NO | ||||
| 5 | sPartsName |
varchar(255) |
YES | ||||
| 6 | tCreateDate |
datetime |
YES | ||||
| 7 | sBillNo |
varchar(255) |
YES | MUL | |||
| 8 | sOrderNo |
text |
YES | ||||
| 9 | tDeliverDate |
datetime |
YES | ||||
| 10 | sCustomerId |
varchar(100) |
NO | ||||
| 11 | sCustomerName |
varchar(255) |
YES | ||||
| 12 | sProductId |
varchar(100) |
NO | ||||
| 13 | sProductName |
varchar(255) |
YES | ||||
| 14 | sProductStyle |
varchar(255) |
YES | ||||
| 15 | dProductQty |
decimal(18,6) |
YES | ||||
| 16 | dProductInStoreQty |
decimal(18,6) |
YES | ||||
| 17 | sCustomerMaterialNo |
varchar(255) |
YES | ||||
| 18 | iOrder |
int |
YES | ||||
| 19 | sControlId |
varchar(100) |
NO | ||||
| 20 | sPartNameStatus |
text |
YES | ||||
| 21 | sMakePerson |
varchar(255) |
YES | ||||
| 22 | sProcessId |
varchar(255) |
YES | ||||
| 23 | sProcessName |
varchar(255) |
YES | ||||
| 24 | dProcessReportQty |
decimal(18,6) |
YES | ||||
| 25 | sReportMachineId |
varchar(255) |
YES | ||||
| 26 | sReportMachineName |
varchar(255) |
YES | ||||
| 27 | sCReserve1 |
varchar(255) |
YES | ||||
| 28 | sMReserve1 |
varchar(255) |
YES | ||||
| 29 | sPlannerMemo |
varchar(255) |
YES | ||||
| 30 | tPlannerSet |
datetime |
YES | ||||
| 31 | iListOrder |
int |
YES | 0 | |||
| 32 | sChangeMemo |
varchar(255) |
YES | ||||
| 33 | sPublish |
varchar(255) |
YES | ||||
| 34 | dProductPQty |
decimal(18,6) |
YES | ||||
| 35 | dSumMachineQty |
decimal(18,6) |
YES | ||||
| 36 | sProcessNameS |
varchar(255) |
YES | ||||
| 37 | tCalcDate |
datetime |
YES | ||||
| 38 | tOrderDate |
datetime |
YES | ||||
| 39 | sDeliveryMode |
varchar(255) |
YES | ||||
| 40 | sProductState |
varchar(255) |
YES | 未完成 | |||
| 41 | dGiveQty |
decimal(18,6) |
YES | ||||
| 42 | sManualNo |
varchar(255) |
YES | ||||
| 43 | sParentName |
varchar(255) |
YES | ||||
| 44 | dDeliverQty |
decimal(18,6) |
YES | ||||
| 45 | bBillComplete |
bit(1) |
YES | ||||
| 46 | bPlanB |
bit(1) |
YES | ||||
| 47 | sProductClassifyId |
varchar(100) |
YES | ||||
| 48 | sProductClassifyName |
varchar(100) |
YES | ||||
| 49 | sMaterialsStatus |
longtext |
YES | 材料状态 | |||
| 50 | s_文件制作-锁定_21 |
varchar(100) |
YES | ||||
| 51 | s_文件制作-计划_22_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 52 | s_文件制作-实际_23_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 53 | s_蓝纸确认-锁定_24 |
varchar(100) |
YES | ||||
| 54 | s_蓝纸确认-计划_25_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 55 | s_蓝纸确认-实际_26_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 56 | s_印刷阶段-锁定_27 |
varchar(100) |
YES | ||||
| 57 | s_印刷阶段-计划_28_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 58 | s_印刷阶段-实际_29_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 59 | s_打码-锁定_30 |
varchar(100) |
YES | ||||
| 60 | s_打码-计划_31_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 61 | s_打码-实际_32_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 62 | s_过胶-锁定_33 |
varchar(100) |
YES | ||||
| 63 | s_过胶-计划_34_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 64 | s_过胶-实际_35_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 65 | s_表面处理-锁定_36 |
varchar(100) |
YES | ||||
| 66 | s_表面处理-计划_37_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 67 | s_表面处理-实际_38_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 68 | s_UV-锁定_39 |
varchar(100) |
YES | ||||
| 69 | s_UV-计划_40_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 70 | s_UV-实际_41_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 71 | s_模具准备-锁定_42 |
varchar(100) |
YES | ||||
| 72 | s_模具准备-计划_43_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 73 | s_模具准备-实际_44_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 74 | s_模烫阶段-锁定_45 |
varchar(100) |
YES | ||||
| 75 | s_模烫阶段-计划_46_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 76 | s_模烫阶段-实际_47_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 77 | s_品检阶段-锁定_48 |
varchar(100) |
YES | ||||
| 78 | s_品检阶段-计划_49_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 79 | s_品检阶段-实际_50_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 80 | s_糊盒包装-锁定_51 |
varchar(100) |
YES | ||||
| 81 | s_糊盒包装-计划_52_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 82 | s_糊盒包装-实际_53_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 83 | s_装订阶段-锁定_54 |
varchar(100) |
YES | ||||
| 84 | s_装订阶段-计划_55_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 85 | s_装订阶段-实际_56_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 86 | s_制版-锁定_57 |
varchar(100) |
YES | ||||
| 87 | s_制版-计划_58_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 88 | s_制版-实际_59_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 89 | s_蓝纸-锁定_60 |
varchar(100) |
YES | ||||
| 90 | s_蓝纸-计划_61_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 91 | s_蓝纸-实际_62_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 92 | s_白样-锁定_63 |
varchar(100) |
YES | ||||
| 93 | s_白样-计划_64_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 94 | s_白样-实际_65_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 95 | s_测试-锁定_66 |
varchar(100) |
YES | ||||
| 96 | s_测试-计划_67_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 97 | s_测试-实际_68_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 98 | s_数码-锁定_69 |
varchar(100) |
YES | ||||
| 99 | s_数码-计划_70_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 100 | s_数码-实际_71_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 101 | s_设计-锁定_72 |
varchar(100) |
YES | ||||
| 102 | s_设计-计划_73_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] | |||
| 103 | s_设计-实际_74_json |
varchar(100) |
YES | [{"dSchedulHours":"","sState":"0"}] |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
IndexU_CalcProductContralsPhase |
BTREE | sId |
|
IndexU_CalcProductContralsPhaseBillNo |
BTREE | sBillNo |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.