상황
An HR platform needs a database schema to track employee referrals from submission through hiring pipeline stages.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Separate Referral from Application to capture referral bonus eligibility independently of the application pipeline
02
Model hiring pipeline stages as a self-contained lookup table linked by ApplicationStageHistory for chronological state tracking
03
Use a self-referencing Employee.manager_id foreign key to map reporting lines
Use when designing or documenting an employee referral tracking system that includes application progress across defined hiring stages.