Ours Facebook Technology Research Report (2)-data table Design
--- Xu Zhaoyuan/FLxyzsby@163.com
[Opening]
Database Version selection.
Chapter 1 Requirements Analysis of ours Facebook Database
1.1 view Facebook's Data Structure
1.2 Basic Requirements of ours Facebook Data Structure
[Opening part]
Database Version selection.
At present, MySQL has been developed to version 5.0 or above. The table definition and creation of this table are subject to MySQL 5.0 or later versions.
Chapter 1 Requirements Analysis of ours Facebook Database
1.1View Facebook's Data Structure
For reference, we browsed Facebook's public documents and obtained the object structure diagram of its API, from which we can obtain some information.
1.2 ours FacebookBasic requirements of Data Structure
From the API structure of 1.1 and the business requirements I pointed out in the analysis report on the demand for ours Facebook research, we can conclude that our database should include these requirements.
● Manager Information
● User information (basic information, photo information, etc)
● School Information
● Group information
● Relationship information between users (relationship information, communication information, status information, etc)
● System parameter settings
Here, I will not analyze its structure in detail, and all the table definitions will be manifested in.