数据库设计

• users
  • id, increments
  • privilege, integer
  • username, string
  • password, string
  • stuid, string
  • SSO, string
  • nickname, string
  • email, string
  • havecheckedemail, boolean
  • role_id, integer
  • baned, integer
  • username[unique]; email[unique];
• user_info
  • id, increments
  • gender, string
  • realname, string
  • tel_num, string
  • QQ, string
  • wechat, string
  • address, string
  • last_login_ip, string
  • register_ip, string
• check_email
  • id, increments
  • user_id, integer
  • token, string
• auth_log
  • id, increments
  • ip, string
  • username, stringuser_id, integer
  • event, integer
• good_cat
  • id, increments
  • cat_name, string
  • cat_index, integer
• good_info
  • id, increments
  • good_name, string
  • cat_id, integer
  • description, text
  • pricemin, integer //int是不是太小了只能卖24亿呢都不能卖98亿
  • pricemax, integer
  • type, integer
  • user_id, integer
  • counts, integer //这个实在太难受了
  • good_tag, text加good_tag表
  • checkedbaned, integer
  • stared, integer
• tags
  • id, increments
  • tag_name, string
• good_tags
  • id, increments
  • good_id, integer
  • tag_id, integer
• messages全表删掉

  - id, increments
  - cat_id, integer
  - user_id, integer
  - good_id, integer
  - shop_id, integer
  - content, string

• transactions
  • id, increments
  • trans_id, integer
  • buyer_id, integer
  • seller_id, integer
  • good_id, integer
  • number, integer
  • status, integer
• transaction_log
  • id, increments
  • ip, string
  • username, stringuser_id, integer
  • trans_id, integer
  • good_id, integer
  • event, integer
• favlist
  • id, increments
  • user_id, integer
  • good_id, integer
• message
  • id, increments
  • title, text
  • sender_id, integer
  • receiver_id, integer
  • content, text
• announcementsnotices //和路由一块改了吧
  • id, increments
  • title, text
  • content, text