eleknifemouldproduct.md 1.56 KB

Edit Raw Blame History



eleknifemouldproduct


刀模印件表


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(100)
NO
MUL


唯一ID


3
sBrandsId
varchar(100)
NO
MUL


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
sMakePerson
varchar(100)
NO


制单人


6
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


7
iOrder
int
NO

0

排序号


8
sParentId
varchar(100)
NO


父级ID


9
sProductId
varchar(100)
NO


产品Id


10
sCustomerId
varchar(100)
NO


客户ID


11
sProductTechnologyVer
varchar(100)
NO


工艺版本


12
sMReserve5
varchar(255)
YES


预留字符5


13
sSrcId
varchar(100)
NO


14
sSrcSlaveId
varchar(100)
NO


Indexes


Name
Unique
Type
Columns


IndexU_eleknifemouldproduct
✓
BTREE

sId, sBrandsId, sSubsidiaryId


IndexU_eleknifemouldproductParent

BTREE

sBrandsId, sSubsidiaryId, sParentId


PRIMARY
✓
BTREE
iIncrement


Narrative

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