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