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)