Hi
I have a problem about modelling data of my application and I don't
know how resolve it.
I present my situation:
My E-R is
__________ _____________
| | N /\ M | |
| Document |<--------/ \-------->| DocumentField |
|___ ______| \ / |______________|
\/
Now in the relation HABTM with Document and DocumentField I have the
attribute "value".
The relational mode is:
Document:
id , title , created
DocumentField:
id,name , type( it is the type of the field , It can be a string , a
text , a datetime,a url, a number) , created
The HABTM relation is:
id, document_id , document_field_id , value (the value of the field in
the document)
Now my problem is how manage the attribute "value" in Mysql because
it can be a datetime , a varchar , a longtext.lo
If I have more attribute , every which its type (like value_datetime,
value_text, value_varchar) I have many and many attribute that are
null (every record has a single attribute with value the other are
null).
If I have a single attribute with for example type longtext I have a
very confused and unmanageable situation
Has anyone any suggestions?
I hope someone can help me about this.
Many thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
