salsalesprintplanslave.md 2.23 KB

salsalesprintplanslave

印前开发计划从表

  • 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) NO 父级ID
8 sFollowUpPhase varchar(255) NO 跟进阶段
9 sEmployeeId varchar(100) NO 人员
10 sMemo text NO 备注
11 sSReserve1 varchar(255) YES 预留字符1
12 sSReserve2 varchar(255) YES 预留字符2
13 sSReserve3 varchar(255) YES 预留字符3
14 sSReserve4 varchar(255) YES 预留字符4
15 sSReserve5 varchar(255) YES 预留字符5
16 sSReserve6 varchar(255) YES 预留字符6
17 dSReserve1 decimal(18,6) YES 预留数字1
18 dSReserve2 decimal(18,6) YES 预留数字2
19 dSReserve3 decimal(18,6) YES 预留数字3
20 iSReserve1 int YES 预留整型1
21 iSReserve2 int YES 预留整型2
22 iSReserve3 int YES 预留整型3
23 tSReserve1 datetime YES 预留日期1
24 tSReserve2 datetime YES 预留日期2
25 tStartDate datetime YES 开始时间
26 tEndDate datetime YES 结束时间

Indexes

Name Unique Type Columns
IndexU_salsalesprintplanslave 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.