study
Tables (3)
dept (Untitled)
- deptno — DECIMAL(10, 0) — Primary key — NOT NULL
- dname — VARCHAR(14)
- loc — VARCHAR(13)
emp (Untitled2)
- empno — DECIMAL(10, 0) — Primary key — NOT NULL
- deptno — DECIMAL(10, 0) — Foreign key → dept.deptno — NOT NULL
- ename (Field) — VARCHAR(10)
- job (Field2) — DECIMAL(4,0)
- mgr (Field3) — DECIMAL(4,0)
- hiredate (Field4) — DATE
- sal (Field5) — DECIMAL(7,2)
- comm (Field6) — DECIMAL(7,2),
emp_dept_hist (Untitled3)
- fromdate (Key2) — DATE — Primary key — NOT NULL
- deptno — DECIMAL(10, 0) — Foreign key → dept.deptno — NOT NULL
- todate (Field) — DATE