Relationships of Basic Tables

Relationships based on fields

  • Company:
    • Project: Project.CompanyID = Company.CompanyID
    • Event: Event.CompanyID = Company.CompanyID
  • Project:
    • Company: Project.CompanyID = Company.CompanyID
    • Document: Document.BoID = Project.ProjectID
    • DocumentConnection: DocumentConnection.BoID = Project.ProjectID
    • Event: Event.ProjectID = Project.ProjectID
    • ProjectPeople: ProjectPeople.ProjectID = Project.ProjectID
    • WorkFlow: WorkFlow.WorkFlowID = Project.WorkFlowID
  • Event:
    • Company: Event.CompanyID = Company.CompanyID
    • Document: Document.BoID = Event.ProjectID
    • DocumentConnection: DocumentConnection.BoID = Event.EventID
    • EventPeople: EventPeople.EventID = Event.EventID
  • People:
    • PeopleGroupsPeople:
      • PeopleGroupsPeople.PeopleID = People.PeopleID
      • PeopleGroupsPeople.GroupID = People.PeopleID
  • ProjectPeople:
    • ProjectRole = ProjectRole.ProjectRoleID = ProjectPeople.RoleID

  • Last update: 5 weeks 6 days ago
  • Effector