test

Tables (3)

tb_employee

  • Key (employee_id) — number — Primary key — NOT NULL
  • Field (employee_name) — varchar2(50)
  • Field (job_name) — varchar2(50)
  • Field (hire_date) — date
  • Field (dept_id) — number

tb_salary

  • Key (employee_id) — number — Primary key — NOT NULL
  • Field (salary_ym) — date
  • Field (salary_amt) — number

td_dept

  • Key (dept_id) — Number — Primary key — NOT NULL
  • Field (dept_name) — varchar2(50)