database table design best practices

MySQL database design review notes and project practices bitsCN.com Author: Yang Xinqi Recently, three projects were started on hand, and the other two started from the bottom layer. one was started for a while and developed by a small team in a small city, there are no dedicated DBAs for database

Database Table design. It is not best to have only the most suitable (adjacent table, Path Enumeration, nested set, closure table), enumeration packet tableWhen designing a database, do we break through the general rules and find

design. There are still many bugs that need to be improved. The main features are finally, only professional MySQL B can be used, reverse database C can be used, and MySQL D can be managed and monitored. The interface is similar to sqlserver manager, so it is easy to use. II. Implementation of database design and

Tags: tinyint1 mysql bool mysql boolean mysql integer storage mysql unsignedMySQL various INTEGER types occupy storage space, value range listBest practices UNSIGNED can only store non-negative integers Signed can store positive integers, 0, negative integers The best practice for storing always positive integers, such as primary keys, is UNSIGNED, because it takes up as much storage space as signed, but with a value range of more than one

Use clear and uniform labels and column names, such as school, schoolcourse, and courceid. The data table name uses a singular number instead of a plural number, for example, studentcourse, instead of studentcourses. Do not use spaces for data table names. Do not use unnecessary prefixes or suffixes for data table names, such as using school instead of tblscho

duplicates Product image ID, primary key Wares_id Int Cannot be blank Product ID, associated with wares_info.wares_id Length Char (20) Cannot be blank Product length description Not long after the change, the boss planned to add a new batch of products. This time, all the products of this type need to be added with the "width" attribute. You have bitten your teeth, caught your teeth, and added the commodity width

Tags: margin png ica timing color assignment weight for varchar The source of this article: http://www.cnblogs.com/wy123/p/6677073.html When doing data statistics database design, when considering the data storage, often encounter logically the same businessid corresponding to multiple data points of the situation,For example, the employee ID in the payroll and the payroll information, the individual repor

ultimately address performance issues.Once a research and development colleague to help it optimize SQL, found that its business needs are tens of millions of of data to sort the page and then take the top, a few 10 seconds can not return the results, it is recommended to remove the sorting, is told that some of the data needs to be prioritized, and this part of the need to prioritize processing of very few, The final solution is to split the priority data out of a separate program for processi

Database Table Design for Mysql optimization and database table Optimization for mysql Separation of Fixed Length and Variable Length Separation of common and uncommon Columns For example: This table is not good enough and

http://q.cnblogs.com/q/39658/ On the design of the table structure of the infinite Classification database, traversing the efficiency of all products under a certain classification The database table structure is like this: [Category] Category