简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Backend Development> PHP Tutorial> body text

问一个数据库表命名的问题。

WBOY
Release： 2016-06-23 13:37:55
Original
983 people have browsed it

比如两张表性质一样，你们觉得设置名称为
table1
table2

还是
table_first
table_second

或者
tableFirst
tableSecond

或者
table1st
table2nd

哪种写法好，和专业不专业有关系吗？


回复讨论(解决方案)

只要你分的清就行
一般应能从表名感知表的用途
如果使用元数据（或数据字典）技术，那么表名应能通过计算得到

表名不要用camel case，特别是在pgsql那个奇葩下
如果名称要由程序读取识别，建议用阿拉伯数字

分表???用
table_001
table_002

阿拉伯数字！

Related labels：
问一个数据库表命名的问题。
source：php.cn
Previous article：php数组array_filter()函数和array_slice()函数 Next article：生成随机验证吗
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
Latest Articles by Author
Latest Issues
Implement filters and pagination using Laravel Eloquent I'm trying to create an API that will return all customer records from a database. But thi...
From 2023-11-12 18:42:35
0
1
310
Stream data from OpenAI's API using AJAX, PHP, and server-sent events How can I use Server Sent Events (SSE) to stream data from the above API to a browser clie...
From 2023-11-11 12:03:23
0
1
497
Vue, vite: GET http://localhost:3000/@vite/client The title of net::ERR_ABORTED 404 (Not Found) is rewritten to: Vue, vite: on http://localhost:3000/@vite/client A net::ERR_ABORTED 404 (not found) error occurred in the initiated GET request. I'm using Vue and vite to practice the workflow of a web application that uses an API to g...
From 2023-11-06 11:49:11
0
2
255
The title is rewritten as: "Flutter mysql1 received out-of-order packets" I'm having some issues setting up a connection to my VPS using flutter's mysql1 library. W...
From 2023-11-05 22:34:25
0
1
217
Vue 3 Composition API: Render Props and v-if even if value is False I'm running into a problem here that I feel like I don't really understand. I include a ch...
From 2023-11-05 14:48:16
0
2
280
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！