employeeInfo
Tables (3)
department (Untitled3)
- department_id (Key) — int — Primary key — NOT NULL
- department (Field) — varchar
employee (Untitled)
- emp_id (key) — int — Primary key — NOT NULL
- name (Field) — varchar
- emp_detail_id (Key) — int — Foreign key → employeedetail.emp_detail_id — NOT NULL
- department_id (Key2) — int — Foreign key → department.department_id — NOT NULL
employeedetail (Untitled2)
- emp_detail_id (Key) — int — Primary key — NOT NULL
- address, (Field) — varchar
- phone (Field2) — varchar
- emp_id (key) — int — Foreign key → employee.emp_id — NOT NULL