Home Backend Development PHP Tutorial [PHP] B2B2C product module database design, forum database design, system database design oracle database design

[PHP] B2B2C product module database design, forum database design, system database design oracle database design

Jul 29, 2016 am 08:52 AM
Database Design

goods_common (public goods table)

The difference between specifications and attributes is that specifications affect the price, attributes do not affect the price. On the product classification page, there is attribute filtering

Specification name field

Serialize the specification name array and store it in this Field

For example: Array ([1] => color),

key corresponds to the id of the specification table, and value corresponds to the name of the specification table

Specification value field

serializes the value array corresponding to the specification name Store this field

For example: Array ( [1] => Array ( [222] => Blue [224] => Green [225] => Plum Red [226] => Black) ) ,

The key of the first dimension corresponds to the specification table id, the key of the two-dimensional array corresponds to the id of the specification value table, and the value corresponds to the name of the specification value table

Commodity attributes

For example: Array ( [206] => Array ( [name] => Style [3050] => Sweater) [207] => Array ( [name] => Material [3059] => Cotton))

The key of the one-dimensional array corresponds to the attribute The id of the table, the name of the two-dimensional array corresponds to the name of the attribute table, the second element key of the two-dimensional array corresponds to the attribute value table id, and the value corresponds to the name of the attribute value table

Commodity public id

Product name

Product promotion Word

Product category id

Product category name ————Moderate redundancy, reduce the association table

Store id

Store name ————More redundancy, reduce the association table

Brand id

Brand name

Type id    ———Associate the type table and associate the attributes under the type

Product main image     ———Only save the file name of the uploaded image, the full path is spliced ​​through the program, more flexible

Product content

Product Status    ———0 Removed, 1 Normal

Reason for violation

Product review

Reason for review failure

Product lock

Product addition time

Product shelf time

Product price

Market price

Cost price

Discount

Merchant custom number

Freight rate template

Freight rate template name

Is it recommended?

Is free shipping?

Is a VAT invoice issued?

First-level region id

Second-level region id

Store classification The first and last id are separated by,

Top related layout

Bottom related layout

goods (product master table)

Add products of different specifications and generate multiple product information, sku is different,

product SKUid

product Public id

Product name (+ specification name)

Product promotion words

Store id

Store name

Product category id

Product brand ID

Product price

Market price

Merchant custom number

Click quantity

Sales quantity

Collection quantity

Product specification serialization, for example: Array ([222] => blue)

Product inventory

Product main image

Product status

Product review status

Product addition time

Product editing time

First-level region ID

Second-level region ID

Color specification ID

Shipping template ID

Is it recommended?

Is free shipping

Is a VAT invoice issued?

Store classification Use id first and last, separated

good reviews

number of reviews

spec (product specification table)

specification id

specification name

specification sorting

category id

category name

spec_value (product specification value Table)

Specification value id

Specification value name

Specification id

Classification id

Store id

Specification color

Sort

attribute (product attribute table)

Attribute id

Attribute name

Type Id

attribute value column

whether to display

sort

attribute_value (product attribute value table)

attribute value id

attribute value name

attribute id

type id

attribute value sort

category (product Category table)

category id

category name

type id

type name

parent id

sort

title

keyword

description

type (product type table)

type id

Type name

Sort

Category id

Category name

The above introduces the [PHP] B2B2C product module database design, including database design and b2b2c content. I hope it will be helpful to friends who are interested in PHP tutorials.

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Redundant Field Issues in Database Design: Best Practices in PHP Programming Redundant Field Issues in Database Design: Best Practices in PHP Programming Jun 22, 2023 am 11:02 AM

With the popularity of the Internet and the increasing number of application scenarios, database design has become an extremely important issue. In database design, redundant fields are a very important issue. Redundant fields refer to duplicate or unnecessary fields that appear when designing the database. Although redundant fields can improve query efficiency and speed to a certain extent, they also waste storage space, increase maintenance difficulty, and even affect data consistency and security. Therefore, in PHP programming, certain best practices should be followed to solve the problems caused by redundant fields.

Research on solutions to database design problems encountered in development using MongoDB technology Research on solutions to database design problems encountered in development using MongoDB technology Oct 08, 2023 pm 05:53 PM

Exploring solutions to database design problems encountered in the development of MongoDB technology Abstract: With the rapid development of big data and cloud computing, database design is particularly important in software development. This article will discuss common database design issues encountered during development and introduce MongoDB solutions through specific code examples. Introduction: In the software development process, database design is a key link. Traditional relational databases have some performance and scalability issues when processing large-scale data. And MongoD

Golang learning database design practice for web applications Golang learning database design practice for web applications Jun 24, 2023 am 10:33 AM

Golang is a programming language developed by Google. Its simplicity of use, superior performance, and cross-platform features make it increasingly popular in modern web application development. In web application development, database design is a very important part. In this article, we will introduce how to practice database design when developing web applications using Golang. Choosing a database First, we need to choose a suitable database. Golang supports a variety of databases, such as MySQL, Po

How to implement database design for multi-specification SKU of products in PHP How to implement database design for multi-specification SKU of products in PHP Sep 06, 2023 am 09:03 AM

How to implement database design for product multi-specification SKU in PHP In e-commerce platforms, product specifications are a very important concept. Product specifications can be understood as the different attributes and characteristics of the product, such as size, color, weight, etc. In practical applications, for different specifications, we often need to set different prices, inventory, pictures and other information for each combination. This requires us to design a suitable database structure to store and manage product specifications and related information. This article will introduce how to implement multi-specification SKU of products in PHP

MySQL database design: ordering system menu table MySQL database design: ordering system menu table Nov 01, 2023 pm 12:40 PM

MySQL database design: ordering system menu list Introduction: In the catering industry, the design and implementation of the ordering system is crucial. One of the core data tables is the menu table. This article will introduce in detail how to design and create an effective menu table to support the functions of the ordering system. 1. Requirements analysis Before designing the menu list, we need to clarify the requirements and functions of the system. In the ordering system, the menu table needs to store relevant information about each dish, including dish name, price, classification, description, etc. In addition, you also need to consider the dishes

Use MySQL MVCC to optimize database design and improve application performance Use MySQL MVCC to optimize database design and improve application performance Sep 08, 2023 am 08:34 AM

Use MySQLMVCC to optimize database design and improve application performance Summary: In today's Internet applications, database performance is crucial to the stable operation and response time of the system. As one of the most commonly used relational database management systems, MySQL uses multi-version concurrency control (MVCC) to improve concurrency performance and data consistency when designing the database. This article will introduce the basic principles of MVCC and its implementation in MySQL, and give some examples of optimizing database design. Basic principles of MVCC multi-version concurrency

Design and application of PHP and MySQL databases Design and application of PHP and MySQL databases Jun 20, 2023 am 09:27 AM

PHP and MySQL are a powerful pair with a wide range of applications. In the Internet industry, PHP and MySQL have become the standard configuration of the technology stack, and a large number of websites, web applications, backend management systems and other applications have adopted this combination. This article will explore the design and application of PHP and MySQL databases and introduce some best practices. 1. Advantages of PHP and MySQL database PHP is an open source, cross-platform, server-side Web programming language with a wide range of application scenarios. MySQL is a

Detailed explanation of the application of MySQL composite primary key in database design Detailed explanation of the application of MySQL composite primary key in database design Mar 15, 2024 am 11:33 AM

Detailed explanation of the application of MySQL composite primary key in database design MySQL composite primary key refers to a primary key composed of multiple fields. A record is uniquely identified by combining the values ​​of these fields. In database design, composite primary keys are widely used, especially when an entity needs to be uniquely identified. This article will introduce in detail the concept, design principles and specific code examples of MySQL composite primary keys. 1. The concept of MySQL composite primary key. In MySQL, the primary key is a field used to uniquely identify each row of data in the table.

See all articles