PowerDesigner identifier作用

在使用powerdesigner构建CDM的时候,对于entity的Identifier作用很不是了解,既然有了primary key 为什么还要y有identifier,后面找到一段解释,着实解惑。

原文:

There can be many ways to identify an occurrence of an entity.  For
instance, phone number, SSN, full name, and employee ID all could identify
an employee in an Employee entity.  In the CDM, you could create identifiers
for each of those.  One, and only one, of the identifiers is "promoted" as
the primary identifier of the entity.  Typically, this is chosen as the
smallest and least volatile attribute (or set of attributes) in the entity.
In the example, if employee ID was a system generated numeric value, I would
nominate it as the primary.  The other identifiers become "alternate
identifiers", and are reflected in the diagram as "ai1", "ai2", etc.  Even
though the business may recognize something like "full name" as an
identifier, you may not want to generate that into the database as a unique
constraint, since in reality, two people could actually have the same name.
But, it is useful to understand what the business thinks in the CDM.

大概意思是identifier只是助于理解设计CDM 和表的设计并没有太大关系


另外可以在powerdesigner中关闭identifier的显示 tools>display preference>Entity>  可以选择是否显示Identifier(版本16)

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值