Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
225 views
in Technique[技术] by (71.8m points)

mysql - 如果我的表与其他表没有关系,这正常吗?(Is it normal if I have table with have no relationship with other tables?)

I have an existing application.

(我有一个现有的应用程序。)

Now my boss wants me to create a FAQ for apps usage documentation.

(现在我的老板希望我为应用程序使用情况文档创建一个常见问题解答。)

So I create tbl_faq.

(所以我创建了tbl_faq。)

But tbl_faq doesn't have any relationship with others table.

(但是tbl_faq与others表没有任何关系。)

tbl_faq
id int NOT NULL PRIMARY KEY AUTO_INCREMENT
title varchar(255) NOT NULL
content text NOT NULL
created DATETIME

But, I have some doubt in my mind when I see the final ERD diagram (using Workbench).

(但是,当我看到最终的ERD图(使用Workbench)时,我心中有些疑问。)

Because I have 1 weird table which doesn't have any relationship at all.

(因为我有1个完全没有任何关系的奇怪表。)

My question: is this normal or not?

(我的问题:这正常吗?)

  ask by plonknimbuzz translate from so

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Maybe it has no relationship to anything but the application as a whole.

(也许它与整个应用程序没有任何关系。)

This is is a fairly normal situation.

(这是很正常的情况。)

One way you could tie it in is if you link this to the user that created it, as that might be useful information, or if you can think of any other sorts of relationships that this data would naturally have.

(可以绑定它的一种方法是,将其链接到创建它的用户,因为这可能是有用的信息,或者可以想到该数据自然具有的任何其他类型的关系。)


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...