Hello @all, I need to create a database schema that can handle the following situation:
1. a company has many branches 2. a branch has many addresses - for each branch address there is one additional dataset with shipping information 3. a person has many addresses - for eachperson address there is one additional dataset with houseing information I would like to store the addresses in one table, as I would like to search over one set of addresses. And I need the ability to reach the company/person object from the address object. How can I do this? Can this be done at all? Do I have to create two address tables? Every idea is very welcome. Greets, Mario Minati _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]