lxfmac.md 1.49 KB

Edit Raw Blame History



lxfmac


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
sId
varchar(100)
NO


标准ID


2
ORDER_NO
varchar(255)
NO


3
MAC_NO
varchar(255)
NO


4
CUST_NO
varchar(255)
NO


5
CUST_SHORT
varchar(255)
NO


6
CZ_NO
varchar(255)
NO


7
CZ_NO_P
varchar(255)
YES


8
PAPER_NO1
varchar(255)
YES


9
PAPER_NO2
varchar(255)
YES


10
PAPER_NO3
varchar(255)
YES


11
PAPER_NO4
varchar(255)
YES


12
PAPER_NO5
varchar(255)
YES


13
KB
varchar(255)
YES


14
PROD_WMM
decimal(18,6)
YES


15
PROD_HMM
decimal(18,6)
YES


16
PROD_YA1
decimal(18,6)
YES


17
PROD_YA2
decimal(18,6)
YES


18
PROD_YA3
decimal(18,6)
YES


19
OR_OQTY
decimal(18,6)
YES


20
PL_OQTY
decimal(18,6)
YES


21
INS_TYPE
varchar(255)
YES


22
iStatus
bit(1)
YES


Narrative

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