Name | Description | Type | Additional information |
---|---|---|---|
ProductId |
商品ID Int PK FK. |
integer |
Required |
Unit |
单位名称 Varchar(8) PK. |
string |
Required Max length: 8 |
RateOfBaseUnit |
相对于基本单位的商品数量倍数 Numeric(8,4) NN |
decimal number |
Required |
NormalRetailPrice |
一般零售价 Numeric(8,2) NN |
decimal number |
Required |
NormalLowestRetailPrice |
一般零售底价 Numeric(8,2) NN |
decimal number |
Required |
NormalPurchaePrice |
一般采购价 Numeric(8,2) NN |
decimal number |
Required |