My favorites | Sign in
Project Home Wiki Issues
READ-ONLY: This project has been archived. For more information see this post.
Search
for
db  
One-sentence summary of this page.
Updated Mar 11, 2011 by zhuxuezh...@gmail.com

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)
)

Powered by Google Project Hosting