t_finishdata.md
5.44 KB
t_finishdata
- 预估行数: 0
- 数据大小: 16.0 KB
- 引擎: InnoDB
- 排序规则: utf8mb3_general_ci
- 创建时间: 2026-04-27 19:10:04
- 更新时间:
字段
| # | 名称 | 类型 | 可空 | 键 | 默认值 | 额外属性 | 备注 |
|---|---|---|---|---|---|---|---|
| 1 | LineID |
varchar(1) |
NO | PRI | |||
| 2 | ClassID |
varchar(1) |
YES | ||||
| 3 | PrimaryKey |
varchar(40) |
YES | ||||
| 4 | OrderPosition |
varchar(1) |
YES | ||||
| 5 | OrderStatus |
varchar(20) |
YES | ||||
| 6 | OrderNo |
varchar(20) |
YES | ||||
| 7 | CustID |
varchar(12) |
YES | ||||
| 8 | CustName |
varchar(40) |
YES | ||||
| 9 | Co_Date |
datetime |
YES | ||||
| 10 | DispWidth |
varchar(12) |
YES | ||||
| 11 | TotalWidthmm |
int |
YES | ||||
| 12 | OrderWidthmm |
int |
YES | ||||
| 13 | OrderLengthmm |
int |
YES | ||||
| 14 | SWt |
decimal(24,6) |
YES | ||||
| 15 | BWt |
decimal(24,6) |
YES | ||||
| 16 | OrderQty |
int |
YES | ||||
| 17 | FinishQty |
int |
YES | ||||
| 18 | BadQty |
int |
YES | ||||
| 19 | StartTime |
datetime |
YES | ||||
| 20 | CostTime |
int |
YES | ||||
| 21 | StopTime |
int |
YES | ||||
| 22 | StopCount |
int |
YES | ||||
| 23 | ArtID |
varchar(40) |
YES | ||||
| 24 | ArtLB |
varchar(8) |
YES | ||||
| 25 | ArtD |
varchar(8) |
YES | ||||
| 26 | ArtBF |
varchar(8) |
YES | ||||
| 27 | ArtBB |
varchar(8) |
YES | ||||
| 28 | ArtCF |
varchar(8) |
YES | ||||
| 29 | ArtCB |
varchar(8) |
YES | ||||
| 30 | ArtAF |
varchar(8) |
YES | ||||
| 31 | ArtAB |
varchar(8) |
YES | ||||
| 32 | ArtEF |
varchar(8) |
YES | ||||
| 33 | ArtEB |
varchar(8) |
YES | ||||
| 34 | ArtX1 |
decimal(24,6) |
YES | ||||
| 35 | ArtX2 |
decimal(24,6) |
YES | ||||
| 36 | ArtX3 |
decimal(24,6) |
YES | ||||
| 37 | ArtX4 |
decimal(24,6) |
YES | ||||
| 38 | ArtDGram |
int |
YES | ||||
| 39 | ArtBFGram |
int |
YES | ||||
| 40 | ArtBBGram |
int |
YES | ||||
| 41 | ArtCFGram |
int |
YES | ||||
| 42 | ArtCBGram |
int |
YES | ||||
| 43 | ArtAFGram |
int |
YES | ||||
| 44 | ArtABGram |
int |
YES | ||||
| 45 | ArtEFGram |
int |
YES | ||||
| 46 | ArtEBGram |
int |
YES | ||||
| 47 | ArtDLen |
decimal(24,6) |
YES | ||||
| 48 | ArtBFLen |
decimal(24,6) |
YES | ||||
| 49 | ArtBBLen |
decimal(24,6) |
YES | ||||
| 50 | ArtCFLen |
decimal(24,6) |
YES | ||||
| 51 | ArtCBLen |
decimal(24,6) |
YES | ||||
| 52 | ArtAFLen |
decimal(24,6) |
YES | ||||
| 53 | ArtABLen |
decimal(24,6) |
YES | ||||
| 54 | ArtEFLen |
decimal(24,6) |
YES | ||||
| 55 | ArtEBLen |
decimal(24,6) |
YES | ||||
| 56 | Cut |
int |
YES | ||||
| 57 | Kun |
int |
YES | ||||
| 58 | AvgSpeed |
int |
YES | ||||
| 59 | CutBorder |
int |
YES | ||||
| 60 | PLineStyle |
varchar(12) |
YES | ||||
| 61 | remark |
varchar(60) |
YES | ||||
| 62 | DataSynchroned |
bit(1) |
YES | b'0' | |||
| 63 | ScoreStr |
varchar(128) |
YES | ||||
| 64 | ProdQty |
int |
YES | ||||
| 65 | ProductArea |
varchar(12) |
YES | ||||
| 66 | SaveTime |
datetime |
YES | ||||
| 67 | MainCutPos |
bit(1) |
YES | b'0' | |||
| 68 | SaveStatus |
varchar(1) |
YES | ||||
| 69 | Is_Rece |
bit(1) |
YES | b'0' | |||
| 70 | IndexNo |
decimal(18,0) |
YES | ||||
| 71 | OrderLen |
varchar(50) |
YES | ||||
| 72 | OrderArea |
varchar(50) |
YES | ||||
| 73 | FinishLen |
varchar(50) |
YES | ||||
| 74 | FinishArea |
varchar(50) |
YES | ||||
| 75 | BadLen |
varchar(50) |
YES | ||||
| 76 | BadArea |
varchar(50) |
YES | ||||
| 77 | rowguid |
varchar(50) |
YES | ||||
| 78 | MainCutFinishLen |
varchar(50) |
YES | ||||
| 79 | MainCutFinishQty |
varchar(50) |
YES | ||||
| 80 | MainCutFinishArea |
varchar(50) |
YES | ||||
| 81 | MainCutBadQty |
varchar(50) |
YES | ||||
| 82 | MainCutBadLen |
varchar(50) |
YES | ||||
| 83 | MainCutBadArea |
varchar(50) |
YES | ||||
| 84 | MainCutCostTime |
varchar(50) |
YES | ||||
| 85 | MainCutStopTime |
varchar(50) |
YES | ||||
| 86 | MainCutStopCount |
varchar(50) |
YES | ||||
| 87 | KbCoe |
varchar(50) |
YES | ||||
| 88 | ClassKey |
varchar(50) |
YES | ||||
| 89 | CutWasterLength |
varchar(50) |
YES | ||||
| 90 | CutWasterQty |
varchar(50) |
YES | ||||
| 91 | SlitCutSelection |
varchar(50) |
YES | ||||
| 92 | ManualScorStr |
varchar(50) |
YES | ||||
| 93 | IsUpdate |
varchar(50) |
YES | ||||
| 94 | BoaWidthmm |
varchar(50) |
YES | ||||
| 95 | bSend |
varchar(50) |
YES |
索引
| 名称 | 唯一 | 类型 | 字段 |
|---|---|---|---|
PRIMARY |
✓ | BTREE | LineID |
说明
暂无人工说明;当某个垂直切片使用这张表时,请从切片反向链接到本页。