t_finishdata.md 5.42 KB

t_finishdata

  • Rows (estimated): 0
  • Data size: 16.0 KB
  • Engine: InnoDB
  • Collation: utf8mb3_general_ci
  • Created: 2026-04-27 19:10:04
  • Updated:

Columns

# Name Type Null Key Default Extra Comment
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

Indexes

Name Unique Type Columns
PRIMARY BTREE LineID

Narrative

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