elesupplycontacts.md 1.7 KB

elesupplycontacts

供应商列表

  • 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 加工商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.