Hy All! I have got four main entities: OBJECTS (for example immovables), PARTS (of objects, e. g. garden, room, bathroom), CHARACTERS (e. g. basic area, color, number, but I think the CHARACTERS is not an entity, because the PARTS <-> CHARACTERS relationship is 1:N) and CHARACTER_VALUES. The main goal of application is that user can search for an OBJECT by characters of objects parts. The PARTS can contain other parts physically (it's N:M recursive relationship, because bathroom can contain a douche and/or basin, but sitting room can't, and both have got walls), can have valid characters (bedroom can have a character basic area, but basin can't) and can inherit characters from other parts (room have basic area and bedroom too). There are some (not all) CHARACTERS_PARTS which have only some kind of CHARACTER_VALUES. E.g. the "type of heating" can have only several CHARACTER_VALUES: gas, tree or hot water, but "basic area" don't needs validation. So I have some validation tables:
VALID_CHARACTERS_OF_PARTS(id, character_id or character, part_id) (we don't need the CHARACTERS table separately) VALID_CONTAINERS_OF_PARTS(id, part_id, container_part_id) VALID_CHARACTERS_OF_PARTS_CHARACTER_VALUES(id, valid_characters_of_part_id, character_value_id) I think I have a self-join table for PARTS which I can use to inherit CHARACTERS between PARTS. How can I join OBJECTS with his PARTS and CHARACTERS of these PARTS? ALL_TOGETHER(object_id, valid_containers_of_part_id, valid_characters_of_part_id, character_value_id) or at times: ALL_TOGETHER(object_id, valid_containers_of_part_id, valid_characters_of_parts_character_value_id) And how can I to use inherited characters of parts? PS.: The CHARACTER_VALUES table has only one attribute, the id. It's a generalisation of some more tables (e.g STRING_TYPE_VALUES(id, character_value_id, value)), which contains the different data types. Sorry about my english, and the large post --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
