Main relationship between Party partygroup of OFBiz

ArticleDirectory

• Main link structure of OFBiz party

For example, there are different people and organizations when logging on to OFBiz. For example, Michael of Alibaba software logs on to OFBiz,

The following tables are involved:

Select * from party where party_id = 'company ';

Select * From party_group where party_id = 'company'

Select * From party_role where party_id = 'company' and role_type_id = 'carrier'

Select * From role_type where role_type_id = 'carrier'

Select * from party where party_id = 'admin' -- admin is the partyid of John

Select * From person where party_id = 'admin'

 

 

The essence of the main relationship between the parties that extract the acceleration OFBizCode:

 

Main link structure of OFBiz party

 

Entity

 

Party participants

 

Partytype: partygroup and person

 

Partygroup organization information

 

Person personnel information

 

 

View

 

Partyandgroup displays company information

 

Partyandperson: displays personnel information

 

Partyanduserlogin displays participants and logon information

 

Partyanduserloginandperson: displays personnel information and logon information

 

Userloginandpartydetails displays all staff information and company information

 

 

 

Other entities

 

Partyrole role

 

Partystatus participant status

 

Relationship between partyrelationship participants

 

 

A basic and scalable model of personnel and enterprise management is built.