elematerialsworkcenter.md 1.32 KB

Edit Raw Blame History



elematerialsworkcenter


Rows (estimated): 1992

Data size: 1.5 MB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:52:19

Updated: 2026-04-27 18:52:19


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO

0

自增列


2
sId
varchar(100)
NO


标准ID


3
sBrandsId
varchar(100)
NO


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


6
sMakePerson
varchar(255)
NO


制单人


7
iOrder
int
NO

0

排序号


8
sMaterialsId
varchar(100)
NO


材料ID


9
sMaterialsStyle
varchar(100)
NO


材料规格


10
sWorkCenterId
varchar(100)
NO


工作中心ID


11
sWorkCenterName
varchar(100)
NO


工作中心


12
sDepartId
varchar(100)
NO


部门ID


13
sDepartName
varchar(100)
NO


部门


Narrative

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