Sql Database设计 - 产品Web应用程序 [英] Sql Database design - product web application

问题描述

我想创建一个Product Web应用程序，其中多个用户和组织可以登录到该应用程序。所以我想在数据库设计方面提供帮助，假设在应用程序中，有3个组织，组织数据A。只有该组织的用户可以看到，组织B可以是唯一的。对于B的用户和组织C对于c

的用户，请建议数据库设计

I want to create a Product web application ,where multiple users and organization can login into it. So i want help in database design where, Suppose in app, there are 3 organizations ,data of organization "A" can be visible to only users of that orgnization, Org "B" to users of "B" and Org "C" to users of c
please suggest database design

推荐答案

对每个组织使用表分区。 http://www.sqlskills.com/resources/whitepapers/分区％20in％20sql％20server％202005％20beta％20ii.htm [ ^ ]



如果您正在寻找云，您可以想到Azure 。

Use table partition on for each organisation. http://www.sqlskills.com/resources/whitepapers/partitioning%20in%20sql%20server%202005%20beta%20ii.htm[^]

You can think of Azure if you are lookin for cloud.

没有全球解决方案。

这取决于你的权利和需求。

这个细节是不足以设计整个数据库，但你可以这样做。



1）首先清除你申请的所有要求

2注意它在粗糙的垫子上。

3）记下所有表格名称。

4）为特定组织和组织成员设置主要 - 外键。

5）以这种方式进行选择查询，只有特定成员组织只能看到他/她的详细信息。

6）设置组织成员的所有标准验证和权利。

7）成员只能看到哪个是允许的他/她根据权利。

There are no global solution for that.
It depends what kind of rights and need of yours.
This detailing is not enough to design whole database, But you can do this in that way.

1)First clear all requirements of your application
2)Note it on rough pad.
3)Note down all the tables name.
4)Set primary - foreign keys for particular organizations and member of organization.
5)make select query in this way that only member of particular organization can see only his/her detail.
6)set all the criteria validations and rights of organization member.
7)The member can only see which is allow to him/her according to rights.

这篇关于Sql Database设计 - 产品Web应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！