Table of Contents
回复内容:
Home Backend Development PHP Tutorial 电子商务系统中 order表中的 order_id 和order_sn的区别

电子商务系统中 order表中的 order_id 和order_sn的区别

Jun 06, 2016 pm 08:10 PM
php

order_id 是ID主键
order_sn是订单编号
从我们代码实现上来说 有order_id 就够了 那order_sn存在的意义是啥?
为了前台展示订单信息的时候用? 不展示订单id安全点?
order_sn 的内容问题,有的是时间加自增长位 还有就是规定一串数字加自增长位
对了 我们现在系统的order给order_sn加了索引

回复内容:

order_id 是ID主键
order_sn是订单编号
从我们代码实现上来说 有order_id 就够了 那order_sn存在的意义是啥?
为了前台展示订单信息的时候用? 不展示订单id安全点?
order_sn 的内容问题,有的是时间加自增长位 还有就是规定一串数字加自增长位
对了 我们现在系统的order给order_sn加了索引

如LS所说,所以id是自增的话,这个是不适合暴露出来的
同时,后期扩展的话,可能会多台数据库,这个id可能都会出现重复的,

sn一般是自己的逻辑运算出来的,所以不会出现这个问题

你会对外暴露你们的自增的order_id吗?公司内部机密的东西

没什么区别,一种自认为安全的处理而已,就像user有id和username,两者除了外观不同外实际上是等价的。非要说区别的话就是一个是顺序的,另一个是无序的,所以有的人认为无序的更安全。

order_id是自增长;order_sn俗称订单号,订单表里唯一值;

一般作用:

  • 在暴露情况,订单号会比订单id更适合展示给用户,相比而言也会更直观好记

  • 安全考虑。订单号会比订单id相对更安全,毕竟id是自增长,有规律

  • 报表:一般财务,运营,在做统计的时候,订单号会更利于统计

  • 后期数据维护及转移,当牵涉多个表关联的时候,订单号毕竟唯一;订单id自增长,如后期转移数据,id可能会因此变化。但订单号不变化

订单id是给外部用的,有规律的id会暴漏一些机密信息。如一天的订单量,别人的订单号等。你总不想你的成交量被人直接看到吧?id是主键,自增长,是给数据库用的。

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

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Two Point Museum: All Exhibits And Where To Find Them
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

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)

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

In this chapter, we will understand the Environment Variables, General Configuration, Database Configuration and Email Configuration in CakePHP.

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

To work on file upload we are going to use the form helper. Here, is an example for file upload.

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

In this chapter, we are going to learn the following topics related to routing ?

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu

CakePHP Creating Validators CakePHP Creating Validators Sep 10, 2024 pm 05:26 PM

Validator can be created by adding the following two lines in the controller.

CakePHP Working with Database CakePHP Working with Database Sep 10, 2024 pm 05:25 PM

Working with database in CakePHP is very easy. We will understand the CRUD (Create, Read, Update, Delete) operations in this chapter.

See all articles