Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-209
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-209
Summary: Improve support for meaningful primary keys
Type: New Feature
Status: Assigned
Priority: Major
Project: Cayenne
Components:
CayenneModeler GUI
Versions:
1.1
Assignee: Andrus Adamchik
Reporter: Derek Rendall
Created: Wed, 6 Oct 2004 9:49 PM
Updated: Wed, 6 Oct 2004 9:49 PM
Description:
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.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Wed Oct 06 2004 - 21:50:50 EDT