Skip to Content
avatar image
Former Member

Powerdesigner Entity Historic

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    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

    Patrick

    Add comment
    10|10000 characters needed characters exceeded

  • 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 :).

    Add comment
    10|10000 characters needed characters exceeded