HRM

Tables (3)

users

  • 회원ID (user_id) — INT — Primary key — NOT NULL
  • 사번 (employee_id) — VARCHAR(20) — NOT NULL
  • 이름 (name) — VARCHAR(50) — NOT NULL
  • 이메일 (email) — VARCHAR(120) — NOT NULL
  • 팀 (team) — VARCHAR(50)
  • 직책 (position) — VARCHAR(50)

work_status

  • 현황ID (status_id) — BIGINT — Primary key — NOT NULL
  • 회원ID (user_id) — INT — Foreign key → users.회원ID — NOT NULL
  • 날짜 (date) — DATE — NOT NULL
  • 근무형태ID (work_type_id) — INT — Foreign key → work_types.근무형태ID — NOT NULL
  • 상세근무지 (location_text) — VARCHAR(200)
  • 메모 (memo_text) — VARCHAR(300)
  • 수정자 (updated_by) — INT — Foreign key → users.회원ID — NOT NULL
  • 수정일 (updated_at) — DATETIME — NOT NULL

work_types

  • 근무형태ID (work_type_id) — INT — Primary key — NOT NULL
  • 라벨 (label) — VARCHAR(30) — NOT NULL
  • 표시순서 (display_order) — INT — NOT NULL
  • 활성화 (is_active) — TINYINT — NOT NULL