MySQL数据库表结构(MySQL database table structuring)

 我正在研究基于用户的社交网络。 我使用PHP构建网站，我想使用MySQL数据库来存储用户数据。 我可以创建数据库/表没有问题（我使用phpMyAdmin）我不知道有多少表是必要的，什么会对我的Web应用程序更实用。 有很多桌子会很聪明吗？ 例如，一个USERS表。 列名分别为USER_ID，EMAIL，PASSWORD，LAST_LOGIN，然后是一个名为USER_SETTINGS的表，它将保存每个用户的帐户设置，另一个名为POSTS的表名称和值归于“状态更新”。 或者聪明地把所有东西放在一张桌子上？ 最佳做法是什么？ 

I am working on a user based social network. I am building the site in PHP and I want to use a MySQL database to store user data. I can create databases/tables no problem (I use phpMyAdmin) I am not sure how many tables are necessary and what would be more practical for my web application. Would it be smart to have many tables? For example, a USERS table. With column names USER_ID, EMAIL, PASSWORD, LAST_LOGIN and then a table named USER_SETTINGS that would hold the account settings for each user, and another table named POSTS with the names and values attributed to a "status update". Or is smart to have everything in one table? What is the best practice?

原文：https://stackoverflow.com/questions/9728166