attendance management system

Tables (6)

gn_accesslog (Untitled3)

  • access_id (출입코드) — INT — Primary key — NOT NULL
  • employee_id (직원코드) — INT — Foreign key → gn_employee.employee_id — NOT NULL
  • timestamp (출입시간) — DATETIME
  • access_type (출입위치) — VARCHAR(50)

gn_attendance (Untitled2)

  • attendance_id (등록코드) — INT — Primary key — NOT NULL
  • employee_id (직원코드) — INT — Foreign key → gn_employee.employee_id — NOT NULL
  • check_in (입장예정시간) — TIMESTAMP
  • check_out (퇴장예정시간) — TIMESTAMP
  • status (상태) — VARCHAR(50)

gn_department (Untitled6)

  • department_id (부서코드) — INT — Primary key — NOT NULL
  • department_name (부서이름) — VARCHAR(50)

gn_employee (Untitled)

  • employee_id (직원코드) — INT — Primary key — NOT NULL
  • user_id (유저ID) — VARCHAR(50)
  • name (이름) — VARCHAR(50)
  • password (비밀번호) — VARCHAR(50)
  • email (이메일) — VARCHAR(100)
  • phone (전화번호) — VARCHAR(50)
  • department_id (부서코드) — INT — Foreign key → gn_department.department_id — NOT NULL
  • role (직무) — VARCHAR(50)
  • authority (권한) — VARCHAR(50)

gn_visitor (Untitled4)

  • visitor_id (방문자코드) — INT — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)
  • email (이메일) — VARCHAR(100)
  • phone (전화번호) — VARCHAR(20)
  • company (회사이름) — VARCHAR(50)

gn_visits (Untitled5)

  • visit_id (방문코드) — INT — Primary key — NOT NULL
  • visitor_id (방문자코드) — INT — Foreign key → gn_visitor.visitor_id — NOT NULL
  • employee_id (직원코드) — INT — Foreign key → gn_employee.employee_id — NOT NULL
  • visit_check_in (방문예정시간) — TIMESTAMP
  • visit_check_out (방문종료시간) — TIMESTAMP
  • purpose (방문목적) — VARCHAR(255)