10 recommended articles about database design

This article mainly introduces the relevant information on the implementation of the PC-side WeChat code scanning registration and login functions developed by .NET WeChat. It is very good and has reference value. Friends in need can refer to the next one. Let me state in the preface that this article The focus is on implementing ideas. The code and database design are mainly to show the ideas. Do not copy it if there are projects that have strict requirements on code efficiency. I believe that anyone who has done WeChat development has done a lot of authorization, but generally speaking we do more authorization for mobile websites. To be precise, we do authorization under WeChat. One problem I encountered today is that the project supports WeChat and PC, and registration is open. It is required that after registering on the PC side or on the WeChat side, you can log in on the other side. In other words, whether it is PC or WeChat, "you are you" (relevant in some way). 2. Looking for solutions Thinking in the traditional way, WeChat can completely register through authorization, but on the PC side, the traditional method is nothing more than filling in a mobile phone number, or email, etc. If you use this method to register, the following problems will occur: 1. I first log in to WeChat

1. About WeChat user registration and login example code summary

Introduction: This article mainly introduces the relevant information on the implementation of the PC-side WeChat code scanning registration and login functions developed by .NET WeChat. It is very Yes, it has reference value. Friends who need it can refer to the next one. Let me declare in the preface that the focus of this article is the implementation idea. The code and database design are mainly to show the idea. If the project has strict requirements on code efficiency, do not copy it. I believe that anyone who has done WeChat development has done a lot of authorization, but generally speaking we do more authorization for mobile websites. To be precise, we do authorization under WeChat. A problem I encountered today is that project support...

2. 5 Common Database Design Mistakes

# Introduction: Everyone makes mistakes, but as database administrators, we should try to avoid them to reduce costs for the company and ensure data quality. The following five database design mistakes must arouse our vigilance. 1. Choose appropriate data types to avoid excessive expansion of the database. Please pay attention to the selection of data types. For example, if you know that the value of a column ranges from 0 to 100,000, you don't need to use the BIGINT data type because the INT type will suffice. Choosing the former means that every time you insert a piece of data, you waste 4 bytes than the latter. This may sound trivial, but as data volumes grow, the problem becomes apparent.

3. Summary of the principles of database design

##Introduction: The relationship between the original document and the entity can be one-to-one, one-to-many, or many-to-many. In general, they are a one-to-one relationship: that is, one original document corresponds to and only one entity. In special cases, they may be a one-to-many or many-to-one relationship, that is, one original document corresponds to multiple entities, or multiple original documents correspond to one entity. , (fine) database design principles

4. Detailed graphic explanation of RBAC user rights management database design in thinkphp

Introduction: RBAC (Role-Based Access Control, role-based access control) is the association of users with permissions through roles. Simply put, a user has several roles, and each role has several permissions. In this way, a "user-role-permission" authorization model is constructed. In this model, there is generally a many-to-many relationship between users and roles, and between roles and permissions. (As shown below)

5. Introduction to joins and relationship tables in mysql

Introduction: Join One of the most powerful features of SQL is the ability to join tables during the execution of a data retrieval query. Joins are the most important operation you can perform using SQL's SELECT, and a good understanding of joins and their syntax is an extremely important part of learning SQL. Before you can use joins effectively, you must understand relational tables and some basic knowledge of relational database design. The following introduction is not all the knowledge on this content, but it is enough as an introduction

6. Analysis of mysql database design skills

#Introduction: Use clear and unified labels and column names, such as Person, StudentID. Use the singular rather than the plural for table names, such as SchoolName, not SchoolNames. Do not use spaces in table names. Do not use unnecessary prefixes or suffixes in table names, such as School instead of TblSchool, or SchoolTable, etc. The password in the database must be encrypted and then decrypted in the application. (In fact, it is hash storage

7. Understand the three major paradigms of database design

##Introduction: Database design has a great relationship with data storage performance and developers' operation of data. Therefore, establishing a scientific and standardized database requires meeting some#.

##8.

About MySQL database design summary

##Introduction: This article introduces in detail what needs to be paid attention to when designing mysql database, and what kind of rules are reasonable for design.

##9. A large collection of MySQL sql basic statements.

Introduction: Every time I am accustomed to using SQL Sever to directly design the database without correcting the SQL statement Attract enough attention, take the opportunity of this reconstruction of the computer room cooperation version, use SQL statements to design the database, and at the same time sort out the basic usage of SQL statements.

##10. MySQL Database Design Preliminary Specification V1.0

## Introduction: Original link: http://linux .chinaitlab.com/administb) Naming should use meaningful English words or abbreviations, consisting of multiple words, all in capital letters, separated by "_". Only English letters, numbers and underscores can be used, without leaving spaces. For example, USER_DETALL does not allow the use of keywords TYPE or STATUS as field names.

[Related Q&A recommendations]:

nosql - how to design schema for mongodb

Database design - MySQL database primary key issues

Some problems in mysql database design?

php - How to design a simple and efficient database

mysql - Multiple school management system database design

The above is the detailed content of 10 recommended articles about database design. For more information, please follow other related articles on the PHP Chinese website!