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)