Unlimited database Rating (classification table)

In the database we often do one thing: Create a classification table, and then create a sub-classification, how many levels we are accustomed to create how many tables.

This is not only a lot of time, but also in the operation of the table when the chaos, here I introduce a way: unlimited classification.

In this way, we just need to create a table to put all levels of classification into all.

First we sort out the idea, in this table we have a number (ID), and a parent number (ParentID)

We can use ParentID to distinguish this ID belongs to that grade when we put the data, and through this parentid, we can achieve infinite classification, that is, use this ID constantly as parentid.

Complete.

Unlimited database Rating (classification table)