新足迹 › 论坛 › 澳洲生活区 › 工作学习 › 学习交流 › DB design question, 2 columns as PK or just 1 is goo ...

精华好帖回顾
· 双职工家庭的福音之四汤粥小菜腌辣椒 (2005-4-8) binbingogo	· 提车交作业 2驱手动 X-trail st ............逆天了，里程接近2万公里，市区短途，经常大脚油门，油耗居然降到了8.0升 (2012-5-24) iamwhoami
· 超级无敌Sydney和Melbourne大对比(3)---Banking and Tax(updated:19Mar@2:43pm) (2005-3-18) richstudio	· 回忆旅行——伦敦游记（所有坑都填完啦！！！！） (2008-2-5) xingbu

查看: 1225|回复: 0

[全澳] DB design question, 2 columns as PK or just 1 is good [复制链接]

lubber

头像被屏蔽

禁止发言

发表于 2013-8-27 12:13 |显示全部楼层

此文章由 lubber 原创或转贴，不代表本站立场和观点，版权归 oursteps.com.au 和作者 lubber 所有！转贴必须注明作者、出处和本声明，并保持内容完整

for example:

Users table:-
logic sense, there should be siteid and userid as the primary key, but if I use UserId as PK only, siteId is just for selection or filter purpose, then table join will be easy,

am I right or wrong?

签名被屏蔽

返回列表

		自动登录	找回密码
密码			注册

精华好帖回顾

[全澳] DB design question, 2 columns as PK or just 1 is good [复制链接]

发表回复

浏览过的版块