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