Skip to Content

Powerdesigner Entity Historic

Dec 21, 2016 at 01:05 PM


avatar image

How can i create an entity that is an historic of value of an entity?

I have an entity (ClsCI) with several attributes that defines the behavior of the entity. This entity is refered by others entities each month. I need to be able to "restore" the definitions of attibute at a moment in the past.

I try to add all attributes of my ClsCI + a time stamp. I try to use this time stamp + the key of my ClsCi entity, but it is refused.

Is there any solution/suggestion to solve this issue?

10 |10000 characters needed characters left characters exceeded

Patrick, is this a PowerDesigner or a PowerBuilder question? I'm not sure whether you're asking about defining an entity or populating data.

* Please Login or Register to Answer, Follow or Comment.

2 Answers

patrick sandron Dec 22, 2016 at 11:43 AM

Hi George, it is about PowerDesigner. I want create/adapt the conceptual model of an existing database. Physically I have a table of CI's with different attributes and a table of historic definition of CI's. But in power designer (I am newbie), I cannot reuse a fields that are primary key on another entity.

Probably is it a semantic error that I do, but I do not find how solve this.

I have similar issue with Entities "Definition" and Entities "Occurrences", but I solve it by separating in 2 différents models.

By advance, thanks


10 |10000 characters needed characters left characters exceeded
George McGeachie Dec 29, 2016 at 10:42 AM

To 'reuse' PK attributes in a Logical Data Model, you create a relationship.

To 'reuse' PK columns in a Physical Data Model, you create a reference.

In a Conceptual Data Model (CDM), no attributes are migrated, ever, so creating a relationship does not result in the creation of Foreign Key attributes. That's not an issue, it's how the CDM works :).

10 |10000 characters needed characters left characters exceeded