sisformulaparam.md 1.72 KB

Edit Raw Blame History Permalink



sisformulaparam


自定义计算参数


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(50)
NO
MUL


标准ID


3
sBrandsId
varchar(50)
NO
MUL


加工商ID


4
sSubsidiaryId
varchar(50)
NO


子公司ID


5
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
记账日期


6
sMakePerson
varchar(50)
NO


制单人


7
iOrder
int
NO

0

排序号


8
sName
varchar(100)
NO


名称


9
sFieldName
varchar(100)
NO


字段名


10
sType
varchar(50)
NO


类型 （单据主表、单据从表、单据控制表、单据材料表、单据工序表、基础产品表、基础材料表、基础工序表）


11
bInvalid
bit(1)
NO

b'0'

是否作废


12
tMakeDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


13
sEnglishName
varchar(100)
YES


名称


Indexes


Name
Unique
Type
Columns


IndexN_sisformulaparam

BTREE

sId, sBrandsId, sSubsidiaryId, sName


IndexU_sisformulaparam
✓
BTREE

sId, sBrandsId, sSubsidiaryId


IndexU_sisformulaparamName
✓
BTREE

sBrandsId, sSubsidiaryId, sName


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.