MySQL 数据库设计复习笔记及项目实战_MySQL
bitsCN.com
作者：杨鑫奇
最近手头上有3个项目开动，其他2个都是从底层开始的，一个已经开始了一段时间的了，在小城市小团队开发的条件下，都没有专门的DBA来做数据库的设计和维护，往往都是开发人员顶上，可是看了很多的数据库的设计，感觉很多设计都不是很完美，包括DZ的Ucenter和UcenterHome的数据库，所以这段时间话了近5个小时的时间好好的整理了下数据库方面的基本内容，配合现有的框架来实现快捷的数据库设计，来满足目前项目的需求
参考的数据库文档主要有：目前国内的常见的PHP系统的数据库
DZ6.0的数据库 ECSHOP SUPESITE7 UCHOME UCENTER的数据库结构 还有DEDECMS的数据库结构，这些都是来自 PHPCHINA论坛，有需要的朋友可以联系我或者留下邮件我发送过去，今天在读这些范式，设计注意事项的文章中，就想到了大学时候的数据库课程，记得大一的时候，涛涛就拉我一起去听比听03届的数据库课程，感觉那个时候听的也比较入神，感觉老师也讲的好，后来就到了我们自己上数据库课程的时候，来的老师感觉就会讲PPT，根本没有设计经验的刚刚毕业的研究生来教我们的，嘎嘎，那个时候就不想去上课的了，一点学习的冲动都没有了，老师自己教的累，我们学的也累，现在想想大学时候真的没有把基础打好，现在要来恶补一下了。鄙视下自己的大学时候的生活和心态，没有好好的学好好专业课，呵呵，书动用时方恨少.......
入题：
数据库设计方面我主要分为如下：
一、设计工具
因为现在只做LNMP（Linux + Nginx +PHP +MySQL）方面的开发了,所以数据库设计上我就选了数据库的设计工具了，现在用的是MYSQL自己的 开发的工具：MySQL Workbench 5.2.16 OOS Beta 设计的开发版本，这个方面主要是针对MYSQL的数据库开发的，从5.2的各个版本一直在用，发现不少bug但是对于现在的设计还是很有用的，BUG还是很多，有待完善，主要的特点终于 a,只做MySQL比较专业 b,可以反向数据库 c,可以管理和监控MySQL d,界面上和SQLSERVER MANAGER差不多，还是用起来比较顺手的，好了上张图
二、数据库设计的注意实现及基础知识复习
这些直接上图了
大家可以下载下来看，太大了
bitsCN.com
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1391
52
Can AI conquer Fermat's last theorem? Mathematician gave up 5 years of his career to turn 100 pages of proof into code
Apr 09, 2024 pm 03:20 PM
Fermat's last theorem, about to be conquered by AI? And the most meaningful part of the whole thing is that Fermat’s Last Theorem, which AI is about to solve, is precisely to prove that AI is useless. Once upon a time, mathematics belonged to the realm of pure human intelligence; now, this territory is being deciphered and trampled by advanced algorithms. Image Fermat's Last Theorem is a "notorious" puzzle that has puzzled mathematicians for centuries. It was proven in 1993, and now mathematicians have a big plan: to recreate the proof using computers. They hope that any logical errors in this version of the proof can be checked by a computer. Project address: https://github.com/riccardobrasca/flt
Four recommended AI-assisted programming tools
Apr 22, 2024 pm 05:34 PM
This AI-assisted programming tool has unearthed a large number of useful AI-assisted programming tools in this stage of rapid AI development. AI-assisted programming tools can improve development efficiency, improve code quality, and reduce bug rates. They are important assistants in the modern software development process. Today Dayao will share with you 4 AI-assisted programming tools (and all support C# language). I hope it will be helpful to everyone. https://github.com/YSGStudyHards/DotNetGuide1.GitHubCopilotGitHubCopilot is an AI coding assistant that helps you write code faster and with less effort, so you can focus more on problem solving and collaboration. Git
A closer look at PyCharm: a quick way to delete projects
Feb 26, 2024 pm 04:21 PM
Title: Learn more about PyCharm: An efficient way to delete projects. In recent years, Python, as a powerful and flexible programming language, has been favored by more and more developers. In the development of Python projects, it is crucial to choose an efficient integrated development environment. As a powerful integrated development environment, PyCharm provides Python developers with many convenient functions and tools, including deleting project directories quickly and efficiently. The following will focus on how to use delete in PyCharm
Learn how to develop mobile applications using Go language
Mar 28, 2024 pm 10:00 PM
Go language development mobile application tutorial As the mobile application market continues to boom, more and more developers are beginning to explore how to use Go language to develop mobile applications. As a simple and efficient programming language, Go language has also shown strong potential in mobile application development. This article will introduce in detail how to use Go language to develop mobile applications, and attach specific code examples to help readers get started quickly and start developing their own mobile applications. 1. Preparation Before starting, we need to prepare the development environment and tools. head
Which AI programmer is the best? Explore the potential of Devin, Tongyi Lingma and SWE-agent
Apr 07, 2024 am 09:10 AM
On March 3, 2022, less than a month after the birth of the world's first AI programmer Devin, the NLP team of Princeton University developed an open source AI programmer SWE-agent. It leverages the GPT-4 model to automatically resolve issues in GitHub repositories. SWE-agent's performance on the SWE-bench test set is similar to Devin, taking an average of 93 seconds and solving 12.29% of the problems. By interacting with a dedicated terminal, SWE-agent can open and search file contents, use automatic syntax checking, edit specific lines, and write and execute tests. (Note: The above content is a slight adjustment of the original content, but the key information in the original text is retained and does not exceed the specified word limit.) SWE-A
Which Linux distribution is best for Android development?
Mar 14, 2024 pm 12:30 PM
Android development is a busy and exciting job, and choosing a suitable Linux distribution for development is particularly important. Among the many Linux distributions, which one is most suitable for Android development? This article will explore this issue from several aspects and give specific code examples. First, let’s take a look at several currently popular Linux distributions: Ubuntu, Fedora, Debian, CentOS, etc. They all have their own advantages and characteristics.
Exploring Go language front-end technology: a new vision for front-end development
Mar 28, 2024 pm 01:06 PM
As a fast and efficient programming language, Go language is widely popular in the field of back-end development. However, few people associate Go language with front-end development. In fact, using Go language for front-end development can not only improve efficiency, but also bring new horizons to developers. This article will explore the possibility of using the Go language for front-end development and provide specific code examples to help readers better understand this area. In traditional front-end development, JavaScript, HTML, and CSS are often used to build user interfaces
PyCharm Tutorial: How to remove items in PyCharm?
Feb 24, 2024 pm 05:54 PM
PyCharm is a powerful Python integrated development environment (IDE) that provides rich functions to help developers write and manage Python projects more efficiently. In the process of developing projects using PyCharm, sometimes we need to delete some projects that are no longer needed to free up space or clean up the project list. This article will detail how to delete projects in PyCharm and provide specific code examples. How to delete a project Open PyCharm and enter the project list interface. In the project list,
