Relationship

classDiagram
  class crm_relationship {
    int id
    uuid uuid
    int revision_id
    sting bundle
    bool status
    datetime start_date
    datetime end_date
    int created
    int changed
  }

  class crm_relationship_revision {
    int id
    uuid uuid
    int revision_id
    int bundle
    bool status
    datetime start_date
    datetime end_date
    int created
    int changed
    int revision_uid
    int revision_timestamp
    string revision_log
  }

  class crm_relationship__contacts {
    int entity_id
    int revision_id
    int delta
    int target_id  --> crm_contact.id
  }

  class crm_contact {
    int id
    string name
    ...
  }

  crm_relationship --> crm_relationship_revision : revisions
  crm_relationship --> crm_relationship__contacts : contacts
  crm_relationship__contacts --> crm_contact : target_id