minitest

Tables (4)

EMPLOYEE (Untitled)

  • emp_id (Key) — Primary key — NOT NULL
  • emp_nm (Field)
  • is_chief (Field2)
  • contact (Field4)
  • hire_date (Field5)
  • job_desc (Field6)
  • branch_cd (Field3)
  • salary (Field7)
  • job_duty (Field8)
  • main_or (Field9)

main_branch (Untitled4)

  • branch_cd (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

vac_used (Untitled3)

  • emp_id (Key) — Primary key — NOT NULL
  • year_vac_used (Field)
  • dev_vac_used (Field2)
  • health_vac_used (Field3)
  • reward_vac_used (Field4)
  • Field5
  • Field6
  • Field7

vacation (Untitled2)

  • emp_id (Key) — Primary key — NOT NULL
  • total_vac (Field)
  • year_vac (Field2)
  • dev_vac (Field3)
  • health_vac (Field4)
  • reward_vac (Field5)