elecustomercontacts.md 2.11 KB

Edit Raw Blame History



elecustomercontacts


客户-联系人


Rows (estimated): 27

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

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


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


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
sMakePerson
varchar(255)
NO


制单人


6
iOrder
int
NO

0

排序号


7
sParentId
varchar(100)
NO
MUL


父级ID


8
sContacts
varchar(255)
YES


联系人


9
sPhone1
varchar(255)
YES


电话1


10
sPhone2
varchar(255)
YES


电话2


11
sMobile
varchar(255)
YES


手机


12
sEmail
varchar(255)
YES


email


13
sFax
varchar(255)
YES


传真


14
sDepart
varchar(255)
YES


部门


15
sPosition
varchar(255)
YES


职位


16
sMsnQQ
varchar(255)
YES


QQ


17
sMemo
text
YES


备注


18
sWxUserName
varchar(255)
YES


企业微信账号


19
sDingTalk
varchar(255)
YES


钉钉账号


20
tBirthday
datetime
YES

CURRENT_TIMESTAMP
DEFAULT_GENERATED
生日


21
bDefault
bit(1)
NO

b'0'

是否默认


22
sAddress
varchar(255)
YES


地址


Indexes


Name
Unique
Type
Columns


IndexN_elecustomercontactsId

BTREE

sParentId, sContacts


IndexU_elecustomercontacts
✓
BTREE

sId, sBrandsId, sSubsidiaryId


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.