数据库设计

• 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
  • 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, string
  • 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
  • pricemax, integer
  • type, integer
  • user_id, integer
  • counts, integer
  • good_tag, text
  • checked, integer
  • stared, integer
• tags
  • id, increments
  • tag_name, string
• 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, string
  • 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
• announcements
  • id, increments
  • title, text
  • content, text