elesupplycontacts

供应商列表

• Rows (estimated): 6
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb3_general_ci
• Created: 2026-04-27 18:52:40
• Updated: 2026-04-27 18:52:40

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)	YES				父级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	bDefault	bit(1)	NO		b'0'		默认

Indexes

Name	Unique	Type	Columns
IndexN_elesupplycontacts		BTREE	sId, sBrandsId, sSubsidiaryId, sContacts
IndexU_elesupplycontacts	✓	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.