HolidayRequests

๐Ÿ“Š Overview: 7 Fields 2 Indexes

๐Ÿ“ Description

๐Ÿ—จ๏ธ HR transaction table managing staff holiday and time-off requests. Tracks request dates, approval status, and remaining holiday allowances.

โ„น๏ธ Table Information

  • Table ID: 79
  • UUID: 26B56558930CE9449F07B020C86BEA93
  • Primary Key: ๐Ÿ”‘ ID
  • Generated: ๐Ÿ• 2025-12-04T14:34:41Z

๐Ÿ“‘ Table of Contents


๐Ÿ“‹ Fields

Field Type Constraints Description
๐Ÿ”‘ ID Long Integer ๐Ÿ”‘ PK, โœจ Unique, โšก Auto -
StaffName String (255) ๐Ÿšซ Not Null -
FirstDate Date ๐Ÿšซ Not Null -
LastDate Date ๐Ÿšซ Not Null -
Days Real ๐Ÿšซ Not Null -
Comment String (255) ๐Ÿšซ Not Null -
Status String (255) ๐Ÿšซ Not Null -

๐Ÿ” Indexes

Field Type Kind Unique
ID Keywords regular โœจ Yes
Status Keywords regular -

Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:41Z