shop2

Tables (7)

departments

  • dept_id — NUMBER
  • dept_name — VARCHAR2(100)
  • location_id — NUMBER

employee_projects

  • emp_id — NUMBER
  • project_id — NUMBER
  • assigned_date — DATE

employees

  • emp_id — NUMBER
  • emp_name — VARCHAR2(100)
  • dept_id — NUMBER
  • hire_date — DATE
  • job_title — VARCHAR2(50)

locations

  • location_id — NUMBER
  • location_name — VARCHAR2(100)
  • city — VARCHAR2(50)
  • country — VARCHAR2(50)

managers

  • manager_id — NUMBER
  • emp_id — NUMBER
  • level — VARCHAR2(20)

projects

  • project_id — NUMBER
  • project_name — VARCHAR2(100)
  • start_date — DATE
  • end_date — DATE

salaries

  • salary_id — NUMBER
  • emp_id — NUMBER
  • salary_date — DATE
  • amount — NUMBER(10, 2)