[jira] [Closed] (CAY-209) Improve support for meaningful primary keys

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAY-209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-209.
-------------------------------

       Resolution: Won't Fix
    Fix Version/s:     (was: Undefined future)

Current versions of Cayenne fully support meaningful PK already.
                
> Improve support for meaningful primary keys
> -------------------------------------------
>
>                 Key: CAY-209
>                 URL: https://issues.apache.org/jira/browse/CAY-209
>             Project: Cayenne
>          Issue Type: Improvement
>          Components: Modeler
>    Affects Versions: 1.1 [LEGACY]
>            Reporter: Derek Rendall
>            Assignee: Andrus Adamchik
>
> I would like the ability (as a preference, particularly when reverse engineering?) to treat string ids as meaningful attributes. I know from my EOF days that meaningful ids are to be avoided, but sometimes they just make life easier (or you have no choice :-). All the numeric ids I deal with are meaningless, but the string ids are meaningful. 
> For example, our database has a number of key "type" lookup tables - having a string as the PK saves lots of lookups on the DB for reports, summary list displays etc. The type table in turn can contain data that aids certain business processing logic based around the type (at which point the lookup is not a big hit in the scheme of things). It also enforces simple referential integrity.
> A possible extention would be to have a button that makes an object's primary key "visible"/"invisible", with the option to ask that the attributes in other objects that are fk links to this object become "visible"/"invisible" as well.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira