Feature #3614
Connect organizations to persons and vice versa
| Status: | New | Start date: | 2009-06-08 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assignee: | - | % Done: | 0% |
|
| Category: | - | |||
| Target version: | - | |||
| Votes: | 0 |
Description
We probably need a way to connect organizations to persons or the other way round to display relationships between both (f.e. persons that work for a certain company), but I'm not sure how to do that easiest. One way would be to refactor the database a bit, so we have
a) table for persons
- firstname, lastname, middlename
- birthday
- date / place of death
- ... (all things specific to a "real" person)
a table for organizations
- name
- representative
- ... (all things specific to an organization)
b) common fields table for both / address / location data table
- street and number
- city, zip, country
- phone numbers, email addresses
- ... (all fields that are common to both, organizations and people)