Tuesday, December 11, 2007

S_ACT_CONTACT : Description

This table associates a contact with its activities. This relation is suported by column con_id (par_row_id from s_contact) and activity_id (activity_uid from s_evt_act).
This is a one-to-many relationship : A contact can have more than one activity associated, but a position can only be related with one contact.
Keep in mind that con_id is foreign key from s_party and activity_id from s_evt_act.

No comments: