| Re: flexible approach [message #582 is a reply to message #581] |
Wed, 31 January 2007 03:51  |
AJM
Messages: 2355
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
In the first place you have misunderstood when to apply the contents of that article. It is used to replace a single record with a large number of fields with a separate record for each field, but all still on the same table.
In the second place the arrows on your diagram are going in the wrong direction, which is confusing. The direction should be from ONE to MANY, primary key to foreign key.
I do no understand what you mean by "change the type of value". Table EQP_DATA has VALUE and EQP_ATTRIB_ID, and EQP_ATTRIB_ID supplies a value for EQP_ATTRIB_TYPE_ID. This means that a value is applied to an attribute, and an attribute has a type. A value is not linked directly with a type.
When you create a record on EQP_DATA you must supply a value for EQP_ATTRIB_ID which in turn supplies a value for EQP_ATTRIB_TYPE_ID. You therefore cannot change to a different EQP_ATTRIB_TYPE_ID without changing EQP_ATTRIB_ID.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
