plat_offer.md
3.54 KB
plat_offer
平台报价表
- Rows (estimated): 0
- Data size: 16.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:54:50
- Updated:
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | iIncreaseId |
int |
NO | PRI | auto_increment | 主键(自增序列) | |
| 2 | tCreateTime |
datetime |
NO | MUL | 创建时间 | ||
| 3 | tModifyTime |
datetime |
NO | 修改时间 | |||
| 4 | sShopUserId |
varchar(35) |
NO | MUL | 店铺用户编号 | ||
| 5 | sOfferId |
varchar(35) |
NO | UNI | 报价编号(P_OFR开头) | ||
| 6 | sOfferUserId |
varchar(35) |
NO | MUL | 报价人用户编号 | ||
| 7 | iOfferSource |
tinyint |
NO | 0 | 报价来源(0:平台,1:印果,2:微信) | ||
| 8 | sCustomerUserId |
varchar(35) |
NO | MUL | 报价客户编号 | ||
| 9 | sProductId |
varchar(35) |
NO | 产品编号(定制产品才有) | |||
| 10 | iOfferUserType |
tinyint |
NO | 报价人类型(0:用户,1:员工,2:游客) | |||
| 11 | sLevel2ClassifyId |
varchar(35) |
NO | MUL | 2级分类编号 | ||
| 12 | sLevel3ClassifyId |
varchar(35) |
NO | MUL | 3级分类编号 | ||
| 13 | iType |
tinyint |
NO | 0 | 类型(0:报价,1:定制产品) | ||
| 14 | dOriginalMoney |
decimal(18,2) |
NO | 0.00 | 原价 | ||
| 15 | dPreDiscountMoney |
decimal(18,2) |
NO | 0.00 | 折前价 | ||
| 16 | dPostDiscountMoney |
decimal(18,2) |
NO | 0.00 | 折后价 | ||
| 17 | dMaterialMoney |
decimal(18,2) |
NO | 0.00 | 材料费 | ||
| 18 | dPrintMoney |
decimal(18,2) |
NO | 0.00 | 印刷费 | ||
| 19 | dPostPrintMoney |
decimal(18,2) |
NO | 0.00 | 印后费 | ||
| 20 | dFinishedProductMoney |
decimal(18,2) |
NO | 0.00 | 成品费 | ||
| 21 | dAlternativeMoney |
decimal(18,2) |
NO | 0.00 | 备选费 | ||
| 22 | dPromotionMoney |
decimal(18,2) |
NO | 0.00 | 促销价 | ||
| 23 | iQuantity |
int |
NO | 0 | 数量 | ||
| 24 | sCommonSpecificationId |
varchar(35) |
NO | 常用规格编号 | |||
| 25 | dFinishedProductLength |
decimal(10,2) |
YES | 成品长 | |||
| 26 | dFinishedProductWidth |
decimal(10,2) |
YES | 成品宽 | |||
| 27 | dFinishedProductHigh |
decimal(10,2) |
YES | 成品高 | |||
| 28 | iTotalPNumber |
int |
NO | 0 | 总p数 | ||
| 29 | dPacketBottomWidth |
decimal(10,2) |
NO | 0.00 | 封套兜底宽 | ||
| 30 | iPaginations |
int |
NO | 0 | 每本页数 | ||
| 31 | iContactNumbers |
int |
NO | 0 | 联单联数 | ||
| 32 | iModelses |
int |
NO | 0 | 名片款数 | ||
| 33 | iBoxes |
int |
NO | 0 | 盒数 | ||
| 34 | iSpecieses |
int |
NO | 0 | 种数 | ||
| 35 | iModelPosition |
int |
NO | 0 | 模位 | ||
| 36 | sAlternativeIds |
varchar(255) |
NO | 备选方案编号串(逗号分割) |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
PLAT_OFFER_IDX1 |
BTREE | sShopUserId |
|
PLAT_OFFER_IDX2 |
BTREE | tCreateTime |
|
PLAT_OFFER_IDX3 |
BTREE | sOfferUserId |
|
PLAT_OFFER_IDX4 |
BTREE | sCustomerUserId |
|
PLAT_OFFER_IDX5 |
BTREE | sLevel2ClassifyId |
|
PLAT_OFFER_IDX6 |
BTREE | sLevel3ClassifyId |
|
PLAT_OFFER_UNQ1 |
✓ | BTREE | sOfferId |
PRIMARY |
✓ | BTREE | iIncreaseId |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.