Skip to main content

Employee To Organizational Entity

Data Dictionary - Entity Table: Employee_To_Organizational_Entity#

This table models the Job responsibilities within the Organizational Entity. Examples of Organizational Entity responibilities:

**Members**: Several employees typically form a team. An employee is represented by a Employee and a team is represented by an Organizational Entity.
**Supervisor**: The members of a team are typically controlled by a team lead. Similarly, all other teams/divisions from higher up in the organizational hierarchy have a manager who is responsible for all underlying organizational entities.
Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
Relationship_TypeBIGINT(12)NULL1Relationship_type id
EmployeeBIGINT(12)NULL1Employee id from Employee table
Organizational_EntityBIGINT(12)NULL1Organizational entity id
Employee_to_OE_OE(Organizational_Entity)Organizational_Entity (id)NO ACTIONNO ACTION
Employee(Employee)Bank_Employee (id)NO ACTIONNO ACTION
EmployeetoOEType(Relationship_Type)Employee_To_OE_Type (id)NO ACTIONNO ACTION
OE_idxEmployee_To_Organizational_Entity(Organizational_Entity ASC)VISIBLE.
Employee_idxEmployee_To_Organizational_Entity(Employee ASC)VISIBLE.
Type_idxEmployee_To_Organizational_Entity(Relationship_Type ASC)VISIBLE.