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