elematerialsprice.md 1.29 KB

elematerialsprice

物料价格唯一表

  • 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 加工商ID
4 sSubsidiaryId varchar(50) NO 子公司ID
5 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 记账日期
6 sMaterialsId varchar(50) NO 材料id
7 sTaxId varchar(50) YES 税率id
8 sRoughRstimatePrice varchar(10) YES 价格类型
9 dMaterialsPrice decimal(18,6) YES 0.000000 价格
10 dTaxRate decimal(18,6) NO 税率
11 sTaxName varchar(100) NO 税率名称

Indexes

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