eleteamemployee.md 1.3 KB

eleteamemployee

班组-员工

  • 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 iOrder int NO 0 排序号
6 sParentId varchar(100) NO 父级ID
7 sEmployeeId varchar(100) NO 员工ID
8 dProportion decimal(18,6) YES 比例
9 sPositionId varchar(100) YES 职位ID
10 sMakePerson varchar(255) NO 制单人
11 sMemo text YES

Indexes

Name Unique Type Columns
IndexN_eleteamemployee BTREE sId, sBrandsId, sSubsidiaryId, sParentId
IndexU_eleteamemployee 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.