bMemberType 会员类型表
<p>bMemberType 会员类型表</p>
<pre><code class="language-sql">CREATE TABLE IF NOT EXISTS bMemberType (
Id TEXT PRIMARY KEY COMMENT '会员类型ID',
CreateDate TEXT DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
UpdateDate TEXT COMMENT '数据更新时间',
ShopId TEXT COMMENT '所属店铺ID',
SortOrder INTEGER COMMENT '排序号，数值越大越靠前',
MemberType TEXT COMMENT '会员类型',
Discount REAL COMMENT '折扣',
Note TEXT COMMENT '备注'
);
</code></pre>