数据库设计

• users
  • id, increments
  • privilege, integertinyInteger
  • username, string
  • password, string
  • stuid, string
  • SSO, string
  • nickname, string
  • email, string
  • havecheckedemail, boolean
  • role~~_id~~, integertinyInteger
  • baned, integerboolean
  • username[unique]; email[unique];
• user_info
  • id, increments
  • gender, stringboolean, nullable
  • 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, integerstring
• good_cat
  • id, increments
  • cat_name, string
  • cat_index, integer
• good_info
  • id, increments
  • good_name, string
  • cat_id, integer
  • description, text
  • pricemin, double //int是不是太小了只能卖24亿呢都不能卖98亿int什么的是有毒吧
  • pricemax, integer
  • type, integertinyInteger
  • user_id, integer
  • counts, integer
  • good_tag, text加good_tag表
  • checkedbaned, integerboolean
  • stared, integerboolean
  • fav_num, 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, integersmallInteger
• transaction_log
  • id, increments
  • ip, string
  • username, stringuser_id, integer
  • trans_id, integer
  • good_id, integer
  • event, integerstring
• favlist
  • id, increments
  • user_id, integer
  • good_id, integer
• message
  • id, increments
  • title, textstring
  • sender_id, integer
  • receiver_id, integer
  • content, text
  • is_read, boolean
• announcementsnotices //和路由一块改了吧
  • id, increments
  • title, textstring
  • content, text

新表

• tickets //评价和举报都是ticket
  • id, increments
  • sender_id, integer
  • transaction_id, integer
  • receiver_id, integer
  • type, smallInteger
  • message, string
  • assignee, integer
  • state, integer
• admin_events
  • id, increments
  • admin_id, integer
  • target_user, integer
  • event, string
  • ticket_id, integer, nullable
  • message, text