开发者

When creating a mysql table for local places whats the best primary key?

开发者 https://www.devze.com 2023-03-07 03:29 出处:网络
What would be the best primary key for a 开发者_如何学Cvenue in my area? From performance point of view - a 4 byte integer, so a surrogate key.

What would be the best primary key for a 开发者_如何学Cvenue in my area?


From performance point of view - a 4 byte integer, so a surrogate key. From some sort of a logical point of view, call it business logic - the name of the venue (natural key) assuming no 2 venues can share the same name.

0

精彩评论

暂无评论...
验证码 换一张
取 消