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