简体中文(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-13 12:16:56
Original
890 people have browsed it

问一个数据库表命名的问题。
比如两张表性质一样，你们觉得设置名称为
table1
table2

还是
table_first
table_second

或者
tableFirst
tableSecond

或者
table1st
table2nd

哪种写法好，和专业不专业有关系吗？
------解决思路----------------------
只要你分的清就行
一般应能从表名感知表的用途
如果使用元数据（或数据字典）技术，那么表名应能通过计算得到

------解决思路----------------------
表名不要用camel case，特别是在pgsql那个奇葩下
如果名称要由程序读取识别，建议用阿拉伯数字
------解决思路----------------------
分表會習慣用
table_001
table_002
------解决思路----------------------
阿拉伯数字！

Related labels：
table
source：php.cn
Previous article：PHP菜鸟请问大神 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
How to retrieve values ​​of unselected rows in HTML data table using jquery I'm trying to get the value of all rows where the button was not clicked. For example, whe...
From 2024-04-05 09:26:49
0
1
1418
Retrieve nested related values ​​in mysql I'm trying to retrieve related values ​​based on multiple entries in a database. I'm very ...
From 2024-04-04 17:29:06
0
2
365
How to listen for specific click events but suppress others? My web application contains an HTML table where each row links to a specific URL: <tabl...
From 2024-04-04 16:55:27
0
1
317
Vertically rotated table title, centered + bottom aligned, cross-browser I have a table with rotated headers that looks as expected in Chrome, but not in Firefox. ...
From 2024-04-04 16:45:25
0
1
330
Table with fixed header and rotated column headers I have a table with a fixed header and a fixed first column. I also want to rotate the col...
From 2024-04-03 08:50:32
0
1
362
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！