CoreCommunity ExtensionsIncubatorDistributionsTYPO3 4.5 ProjectsTYPO3 4.6 ProjectsTYPO3 4.7 ProjectsTYPO3 6.0 ProjectsTYPO3 6.1 ProjectsTYPO3 6.2 Projects (+)

Feature #3614

Connect organizations to persons and vice versa

Added by Fabien Udriot almost 4 years ago. Updated over 2 years ago.

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)

Also available in: Atom PDF