Introduction
Add your content here.
Details
Add your content here. Format your content with:
- Text in bold or italic
- Headings, paragraphs, and lists
- Automatic links to other wiki pages
TB_SELLER_MEMBER
| id | int | 主键 |
| nick | varchar(32) not null | 用户 |
| user_id | int | 用户数字id |
| uid | varchar(32) | 用户id |
| gmt_created | date not null | 注册时间 |
TB_SELLER_SERVICE
| id | int | 主键 |
| nick | varchar(32) not null | 卖家 |
| gmt_register | date not null | 服务开通时间 |
| gmt_end | date not null | 服务到期时间 |
| type | varchar(16) | 服务类型 |
| fee | number not null default 0 | 费用 |
| note | varchar(128) | 备注 |
TB_BUYER_ATTENTION
| id | int | 主键 |
| nick | varchar(32) not null | 买家用户 |
| user_id | int | 用户数字id |
| uid | varchar(32) | 用户id |
| seller_nick | varchar(32) not null | 卖家 |
| num_iid | varchar(64) not null | 商品ID |
| price | number not null | 关注时原价 |
| exp_price | number not null | 期望价格 |
| gmt_created | date not null | 关注日期 |
| email | varchar(64) | 关注邮件 |
| note | varchar(128) | say somethine |
风险点: 1.发送邮件 2.判断登录 3.tb计费研究 4.隐私数据
建表语句
CREATE TABLE openzara.tb_seller_member (
ID int(11) NOT NULL AUTO_INCREMENT,
NICK varchar(64) NOT NULL,
USER_ID int(100) DEFAULT NULL,
UID varchar(100) DEFAULT NULL,
GMT_CREATED date NOT NULL,
PRIMARY KEY (ID)
)
CREATE TABLE openzara.tb_buyer_attention (
id int(11) NOT NULL AUTO_INCREMENT,
nick varchar(32) NOT NULL,
user_id int(11) NOT NULL,
uid varchar(32) NOT NULL,
seller_nick varchar(32) NOT NULL,
num_iid varchar(64) NOT NULL,
price int(11) NOT NULL,
exp_price int(11) NOT NULL,
gmt_created date NOT NULL,
email varchar(64) NOT NULL,
note varchar(128) DEFAULT NULL,
PRIMARY KEY (id)
)
CREATE TABLE openzara.tb_seller_service (
ID int(11) NOT NULL AUTO_INCREMENT,
FEE int(11) NOT NULL,
NICK varchar(32) NOT NULL,
TYPE varchar(16) NOT NULL,
gmt_register date NOT NULL,
gmt_end date NOT NULL,
note varchar(128) DEFAULT NULL,
PRIMARY KEY (ID)
)