elesupplyaddress.md 1.48 KB

elesupplyaddress

供应商地址

  • 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 sProvince varchar(255) NO
9 sCity varchar(255) YES
10 sArea varchar(255) YES
11 sDetailAddress varchar(255) YES 详细地址
12 bDefault bit(1) YES b'0' 是否默认
13 sContact varchar(100) YES 联系人
14 sMobile varchar(100) YES 手机号码

Indexes

Name Unique Type Columns
IndexN_elesupplyaddress BTREE sId, sBrandsId, sSubsidiaryId
IndexU_elesupplyaddress 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.