Atitti Curing database table structure scheme

Atitti Curing database table structure scheme

1. the importance of curing database tables 1

2. How to cure the table structure 1

2.1. an upward layer of abstraction, with a verb having a target, with a noun as the storage object. 1

2.2. data type datatype field: This is used to indicate which function the data belongs to. Easy to filter 1

3. Special case 20%:: For very frequent functions, you can also specialize in a separate build table 2

1. The important meaning of curing database table knot

a project, consisting essentially of three parts, interface UI , business logic, database

Curing the database table, the basic can be achieved immediately improve the degree of great efficiency ...

2. How to cure table structure2.1. abstract a layer upward, with the verb has the goal, takes the noun as the storage object.

such as the collection of XXXX function. You can create a collection table fav, which contains the favorite object ID and favorite title.

This is more general-purpose, the future can be generally used to collect AAA,BBB,CCCD features are available modules.

2.2. data type datatype field: This is used to indicate which function the data belongs to. Easy to filter

3. Special case 20%:: For very frequent functions, you can also specialize in building tables individually

author :: nickname : old Wow's paw Claw of Eagle idol iconoclast image-smasher

Bird King "Bird Catcher Kok devout pious religious defender Defender of The Faith. Caracalla Red cloak Caracalla red cloak king of Beasts

abbreviation:: Emir attilax Akbar Emile Atiraca

Full Name:: Emir Attilax Akbar bin Mahmud bin Attila bin Solomon bin Adam Al Rapanui Emile Atilax Akbaben Maham Solomon Ben Adam Arrapano Iraq

Common name: Etila (Ayron), Email:[email protected]

title:Head of Uke headquarters , founder of global Grid project,

president of Uke Friendship Association Uke Hunting Association President Emir chief chieftain of the Uke tribe,

Uke , Minister of Religious and Cultural Integration Affairs, Vice-Chairman of the Uke Reformation Commission

Uke System and chairman of the major conference committee,uke Security Department Chief Brigade , uke System Inspection Committee vice president,

Uke chief CTO Software Division Director of Technical department deputy Director of Research and Development department Director of Product department deputy Manager Project department deputy manager uke Science and Technology Research Institute Dean Uke Software Training Master

uke, head of regional chain of Polynesia District, Tonga Kingdom uke, head of chain, Line Is. Districtchain Head,uke Bouvet and South Georgia and South Sandwich Is. region chain Head

Uke, chairman of the Association of Software Standardization , Vice president of Uke Database and storage Standardization Association

Uke , founder of Uke Hospital and medical School, vice president of lifelong education school

UEC , President of Uecip , director of uke Document retrieval Department, head of Department of Image processing machine Vision

Uke, chief Dean of the School of image processing and machine vision

Uke Outdoor Sports Association chairman of the resort chief Mayor Uke Press editor

reprint Please indicate source:Attilax 's column ? http://www.cnblogs.com/attilax/

--atiend V8

Atitti Curing database table structure scheme