bMember 会员表
<p>bMember 会员表</p>
<pre><code class="language-sql">CREATE TABLE IF NOT EXISTS bMember (
Id TEXT PRIMARY KEY COMMENT '会员ID',
CreateDate TEXT DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
UpdateDate TEXT COMMENT '数据更新时间',
ShopId TEXT COMMENT '所属店铺ID',
SortOrder INTEGER COMMENT '排序号，数值越大越靠前',
MemberNumber TEXT COMMENT '会员号',
Name TEXT COMMENT '姓名',
Phone TEXT COMMENT '电话',
MemberTypeId TEXT COMMENT '所属会员类型ID',
IsDisabled INTEGER COMMENT '是否禁用，1表示是，0表示否',
Gender TEXT COMMENT '性别',
Birthday TEXT COMMENT '生日',
ConsumptionCount INTEGER COMMENT '消费次数',
ConsumptionAmount REAL COMMENT '消费金额',
RechargeCount INTEGER COMMENT '充值次数',
RechargeAmount REAL COMMENT '充值金额',
GiftAmount REAL COMMENT '赠送金额',
Note TEXT COMMENT '备注'
);
</code></pre>