Skip to main content

Could anybody help me to understand these two tables? 

create table company_emp_tab
(
  company     varchar2(20) not null,
  employee_id varchar2(11) not null,
  person_id   varchar2(20) not null,
...
)
primary key (company, employee_id)

create table company_person_tab
(
  company_id             varchar2(20) not null,
  emp_no                 varchar2(11) not null,
  operator               varchar2(30) not null,
...
)
primary key (company_id, emp_no)


I see that company_emp_tab belongs to the ENTERP module, while company_person_tab belongs to the PERSON module.

Is the operator = user_id?

The name company_person_tab suggests it is meant to store information about a person, but it seems to store employee data instead.

Be the first to reply!

Reply