MySQL Database Design Review notes and project combat _mysql

Author: Yang Xinchi

Recently, 3 projects have been started on hand, the other 2 are starting from the bottom, one has been started for some time, in small cities under the conditions of small team development, there is no dedicated DBA to do the design and maintenance of the database, is often the top of the developers, but looked at a lot of database design, Feel a lot of design is not very perfect, including DZ Ucenter and Ucenterhome database, so this time words for nearly 5 hours of time to properly collate the basic content of the database, with the existing framework to achieve a fast database design, to meet the needs of the current project

Reference database documents mainly include: The current domestic common PHP system database

DZ6.0 database ecshop SUPESITE7 uchome ucenter database structure and DEDECMS database structure, these are from the Phpchina forum, the need for friends can contact me or leave a message I sent the past, today in reading these paradigms, Design considerations in the article, I think of the University of the database course, remember freshman year, Tao Tao will pull me to listen to the 03 session of the database course, feel that time to listen to also more fascinated, feel the teacher also speak good, and then to our own database course, the teacher will be able to speak PPT, Just graduated graduate students who have no design experience to teach us, Gaga, at that time do not want to go to class, a little study of the impulse is not, the teacher himself to teach tired, we learn also tired, now think of college time really did not put the Foundation dozen good, now want to evil to fill up. Despise under their own college life and mentality, did not well learn good professional courses, hehe, the book used when the side hate less ...

Entry question:

Database design, I mainly divided into the following:

First, design tools

Because now only to do Lnmp (Linux + Nginx +php +mysql) Aspects of the development, so the database design I chose the database design tool, now using the MySQL own development tools: MySQL Workbench 5.2.16 OOS Beta The development version of the design, this aspect is mainly for MySQL database development, from 5.2 of each version has been used, found that a lot of bugs but for the present design is still very useful, the bug is still a lot, to be perfected, the main characteristics finally a, only do MySQL comparison professional B, you can reverse the database C , you can manage and monitor MySQL D, the interface is similar to SQL Server Manager, or to use more comfortable, well, the previous picture

Second, the realization of database design and basic knowledge review

These are directly above the diagram

We can download the next look, too big