inventory database design

Database model (ID-PID): A father has many children, and a child has only one father, such a structure is a tree. In a database table, the ID and PID (parent_id) are designed. A tree is stored by ID and PID. From the object-oriented design point of view, in the tree node class is not suitable for PID, a node has 1 or 0 fathers, and 0 or children. So the

platform in the future. Now we have begun to design the product information table of the platform database. Each sold item has the same attributes, such as the product ID, product name, product category, related information, supplier, number of items included, inventory, purchase price, sales price, and discount price. You will soon

and serves as the data basis for decision-making support. 3.4 considerations for data table classification during data table naming . Business data table: t_d _ Or t_d_SH _ contract;. Basic Encoding table: t_ B _ [ User;Auxiliary encoding table: t_a _ [ Category;. System information table: t_s _ [. Accumulative data table: t_t _ Inventory;. Settlement data table: t_c _ T_c_SO _ monthly inventory close;.

improved a lot and learning is not as objective as it was before. Thank you! Stick to the tomato template to make your efficiency more and more efficient! Come On! Database optimization (ER Model Design) If you are the boss of your company, this design can quickly query the required information. However, if you manage it yourself, I think, combine the "Contact

features, but improper design will make these features partially or completely lost. Let's take a look at the following scenarios caused by poor Database Design: 1. Loss of Data Consistency An order management system maintains the order information of customers and customers. After a user who uses the system receives a call from the customer to modify the

attributes. Example 1: A simple management system for a mechanical manufacturing plant. First, design two partial E-R diagrams Based on the factory technical department and the factory supply department. The factory technical department is concerned with the product performance parameters, components, parts, materials, and consumption. The factory supply department is concerned with the product price, price and

MYSQL database design and database design example (I) preparations before bitsCN.com database design and database design

considerations for data table classification during data table naming . Business data table: T_d _ . Basic Encoding table: T_ B _ [Auxiliary encoding table: T_A _ [. System information table: t_s _ [. Accumulative data table: t_t _ Inventory;. Settlement data table: T_c _ . Decision data table: t_w _ Note: The content in [] is optional. For example, "t_s _ [ 4. database structure principles It d

Summary: For database design, we generally start from the conceptual model. In the conceptual model design phase, we focus on analyzing the logical structure of data to avoid getting into the specific storage details, all designs are irrelevant to specific database products to be used in the future. This article is sui

http://blog.csdn.net/zxq1138634642/article/details/9121363 0, the process of using E-R method to design the database concept is discussed. A : the use of E-R method for database conceptual design, can be divided into 3 steps: First, the design of local E-R mode, and then th

1. Test the existing environment When designing a new database, you should not only carefully study the business needs, but also examine the existing system. Most Databases Projects are not built from scratch. Normally, there will always be existing systems within the Organization to meet specific needs (there may be no real Automatically calculated ). Obviously, the existing system is not perfect, otherwise you do not have to create a new system. H

General permission management design (database structure design) and permission management structure designI. Preface The application of the permission management system should be used in three different ways, A. Permission B. Assign permissions. C. Grant Permissions This article only analyzes the application levels of "Use Permission" and "assign permission", an

: T_ B _ [ User;Auxiliary encoding table: T_A _ [ Category;. System information table: t_s _ [. Accumulative data table: t_t _ Inventory;. Settlement data table: T_c _ T_c_so _ monthly inventory close;. Decision data table: t_w _ T_w_sh _ monthly sales statistics;Note: The content in [] is optional. For example, "t_s _ [ T_s_user is compliant with the rules. 4. datab