co

Tables (8)

Attendance

  • attendance_id — INT — NOT NULL
  • employee_id — INT
  • date — DATE
  • check_in — TIME
  • check_out — TIME

Department

  • department_id — INT — NOT NULL
  • department_name — VARCHAR(100)

Employee

  • employee_id (Key) — Primary key — NOT NULL
  • employee_id — INT — NOT NULL
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • department_id — INT
  • position_id — INT
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • hire_date — DATE

Employee_Project

  • employee_project_id — INT — NOT NULL
  • employee_id — INT
  • project_id — INT
  • assigned_date — DATE
  • role — VARCHAR(50)

Leave

  • leave_id — INT — NOT NULL
  • employee_id — INT
  • leave_start — DATE
  • leave_end — DATE
  • leave_type — VARCHAR(50)

Position

  • position_id — INT — NOT NULL
  • position_title — VARCHAR(100)

Project

  • project_id — INT — NOT NULL
  • project_name — VARCHAR(100)
  • start_date — DATE
  • end_date — DATE

Salary

  • salary_id — INT — NOT NULL
  • employee_id — INT
  • amount — DECIMAL(15,2)
  • start_date — DATE
  • end_date — DATE