plat_customer_account.md 1.51 KB

plat_customer_account

平台客户账户表

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncreaseId int NO PRI auto_increment 主键(自增序列)
2 tCreateTime datetime NO 创建时间
3 tModifyTime datetime NO 修改时间
4 sShopUserId varchar(35) NO MUL 商铺用户编号
5 sCustomerUserId varchar(35) NO UNI 客户用户编号
6 dTotalMoney decimal(18,2) NO 0.00 用户余额
7 dAvailableMoney decimal(18,2) NO 0.00 可用余额
8 dFreezeMoney decimal(18,2) NO 0.00 冻结金额
9 dTotalIntegralMoney decimal(18,2) NO 0.00 用户积分
10 dAvailableIntegralMoney decimal(18,2) NO 0.00 可用积分
11 dFreezeIntegralMoney decimal(18,2) NO 0.00 冻结积分
12 iIsLock tinyint NO 0 是否锁定(0:未锁定,1:锁定)

Indexes

Name Unique Type Columns
PLAT_CUSTOMER_ACCOUNT_IDX1 BTREE sShopUserId
PLAT_CUSTOMER_ACCOUNT_UNQ1 BTREE sCustomerUserId
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.