pay_table

Tables (4)

doo_table (Untitled3)

  • doo_time — num — Primary key
  • wage — num
  • doo_salary — num

no_table (Untitled2)

  • no_time — num — Primary key
  • wage — num
  • no_salary — num

pay_table (Untitled)

  • statement — varchar2 — NOT NULL
  • empno — num — NOT NULL
  • name — varchar2 — NOT NULL
  • department — varchar2 — NOT NULL
  • position — varchar2 — NOT NULL
  • salary — num
  • n_overtime — num
  • do_overtime — num
  • total_salary — num

sp_table (Untitled4)

  • hiredate — date
  • leavedate — date
  • empno — num
  • emp_name — varchar2
  • workdate — num
  • sev_pay — num