السيناريو
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.