很多人都很喜欢 [英] Many to Many cOnFuSiOn

问题描述

目前有3个表的麻烦。我不包括不相关的

字段...


tbl_users

PK_user_ID


tbl_developers

PK_developer_ID

FK_developer_user_ID

FK_developer_project_ID


tbl_projects

PK_project_ID

这是一个管理具有3级访问权限的用户的应用程序。所有

用户都在用户表中，并确定了他们的访问级别

。三个级别是1（管理员），2（开发人员）和3（客户端）。

目前我的问题是开发人员。我最初创建了

开发人员表作为桥。表。

意图的回应是每个

项目可能有多个开发人员，创建了多个。我怎么能解决这个问题？


谢谢!!

The trouble currently with 3 tables. I''m excluding non-relevant
fields...

tbl_users
PK_user_ID

tbl_developers
PK_developer_ID
FK_developer_user_ID
FK_developer_project_ID

tbl_projects
PK_project_ID
This is an application that manages users with 3 levels of access. All
users are in the users table and their access level is identified
there. The three levels are 1 (admin), 2 (developer), and 3 (client).
Currently my problem is with developers. I originally created the
developers table as a "bridge" table. What''s backfiring that
intention is that there could be more than one developer for each
project, creating a many to many. How can I solve this?

Thanks!!

推荐答案

其他约翰写道：

目前有3个表的麻烦。我排除了不相关的领域...

tbl_users
PK_user_ID

tbl_developers
PK_developer_ID
FK_developer_user_ID
FK_developer_project_ID

tbl_projects
PK_project_ID

这是一个管理具有3级访问权限的用户的应用程序。
所有用户都在users表中并确定了他们的访问级别。三个级别是1（管理员），2（开发人员）和3（客户端）。
目前我的问题是开发人员。我最初创建了
开发人员表作为桥梁。表。
意图是每个
项目可能有多个开发人员创建多对多，这是什么回事。


嗯，这就是创建桥牌表的原因：解决

多对多关系。为什么你说这是反击？

如何解决这个问题？

The trouble currently with 3 tables. I''m excluding non-relevant
fields...

tbl_users
PK_user_ID

tbl_developers
PK_developer_ID
FK_developer_user_ID
FK_developer_project_ID

tbl_projects
PK_project_ID
This is an application that manages users with 3 levels of access.
All users are in the users table and their access level is identified
there. The three levels are 1 (admin), 2 (developer), and 3 (client).
Currently my problem is with developers. I originally created the
developers table as a "bridge" table. What''s backfiring that
intention is that there could be more than one developer for each
project, creating a many to many.
Well, that is the reason for creating a bridge table: to resolve a
many-to-many relationship. Why do you say this is "backfiring"?
How can I solve this?

你需要解决什么？


-

Microsoft MVP - ASP / ASP.NET

请回复新闻组。我的From

标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。

What do you need to solve?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.

许多项目可能有很多开发人员，我不会知道如何解决这个问题。正如我所说，我很困惑。我这么难吗？我是没有看到的东西

The there can be many developers for many projects, I don''t know how to
solve this. As I said, I''m confused. Am I making this harder? Am I
not seeing something

其他的约翰写道：

可能有很多许多项目的开发人员，我不知道如何解决这个问题。正如我所说，我很困惑。我是否正在努力？
我没有看到什么

The there can be many developers for many projects, I don''t know how
to solve this. As I said, I''m confused. Am I making this harder?
Am I not seeing something

:-)

我想是的。我当然没有看到什么...


有什么问题？给我们一些特定的答案。什么直接

任务你有问题？


当你说你不知道如何解决这个问题时，你会怎么做？意思是这个？

我的意思是：你的数据库设计正确，可以模拟

多对多关系。所以必须有一些其他的任务让你感到困惑

。这是什么任务？


Bob Barrows

-

Microsoft MVP - ASP / ASP.NET

请回复新闻组。我的From

标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。

:-)
I guess so. I''m certainly not seeing something ...

What is the problem? Give us something specific to answer. What immediate
task are you having an issue with?

When you say you don''t know how to "solve this", what do you mean by "this"?
I mean: you''ve got your database correctly designed to model the
many-to-many relationship. So there must be some other task that''s confusing
you. What task is that?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.

这篇关于很多人都很喜欢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！