test
Tables (3)
Approval
- ApprovalID — VARCHER — Primary key — NOT NULL
- RequestID — VARCHER — Foreign key → VacationRequest.RequestID — NOT NULL
- UserID (ApproverID) — VARCHER — Foreign key → User.UserID — NOT NULL
- Decision — ENUM
- DecisionDate — DATETIME
- Comments — VARCHER
User
- UserID — VARCHER — Primary key — NOT NULL
- Name — VARCHER
- Email — VARCHER
- RemainingVacationDays — NUMBER
VacationRequest
- RequestID — VARCHER — Primary key — NOT NULL
- UserID — VARCHER — Foreign key → User.UserID — NOT NULL
- UserID (ApproverID) — VARCHER — Foreign key → User.UserID — NOT NULL
- StartDate — DATETIME
- EndDate — DATETIME
- TotalDays — NUMBER
- Status — ENUM
- RequestDate — DATETIME