Product Unit Properties

This table defines the structure of the product unit entity, including all properties and their descriptions. Product units represent individual instances of products that can be tracked and managed independently.

🔑 Core Properties

Property	Type	Required	Description
id	string	No (Auto)	Unique identifier for the unit
productId	string	Yes	ID of the parent product
active	boolean	No	Whether the unit is active (default: true)
serialNumber	string	No	Unique serial number for physical units
assignedTo	string	No	ID of user or group assigned to this unit

📘 Interpretation

• id is auto-generated if not provided
• productId must reference an existing product
• active controls unit availability
• serialNumber should be unique when provided
• assignedTo references a user or group ID

🎯 Example Use Cases

{
    "id": "unit_01G5H2V6J7K8L9M0N",
    "productId": "prod_01F4G5H6J7K8L9M0",
    "active": true,
    "serialNumber": "SN2025051234",
    "assignedTo": "user_01A2B3C4D5E6F7G8"
}

📊 Status Properties

Property	Type	Required	Description
status	string	No	Current status of the unit
statusReason	string	No	Reason for current status
lastActive	datetime	No	Last time unit was active

📘 Interpretation

• status can be: "available", "assigned", "inactive"
• statusReason provides context for status changes
• lastActive is auto-updated on status changes

🎯 Example Use Cases

{
    "status": "assigned",
    "statusReason": "Allocated to development team",
    "lastActive": "2025-05-22T15:30:00Z"
}

🏷️ Metadata Properties

Property	Type	Required	Description
notes	string	No	Additional information about the unit
tags	string[]	No	Custom tags for categorization
extraFields	object	No	Custom additional fields

📘 Interpretation

• notes can contain any relevant information
• tags help with unit categorization
• extraFields allows custom properties

🎯 Example Use Cases

{
    "notes": "Development license - Team A",
    "tags": ["development", "temporary"],
    "extraFields": {
        "location": "HQ Office",
        "department": "Engineering"
    }
}

⌛ Tracking Properties

Property	Type	Required	Description
createdAt	datetime	No (Auto)	Unit creation timestamp
updatedAt	datetime	No (Auto)	Last update timestamp
assignedAt	datetime	No	When unit was assigned
expiresAt	datetime	No	Unit expiration date

📘 Interpretation

• createdAt and updatedAt are system-maintained
• assignedAt tracks assignment timing
• expiresAt used for time-limited units

🎯 Example Use Cases

{
    "createdAt": "2025-05-22T10:00:00Z",
    "updatedAt": "2025-05-22T15:30:00Z",
    "assignedAt": "2025-05-22T15:30:00Z",
    "expiresAt": "2026-05-22T23:59:59Z"
}

📝 Validation Rules

1. Core Properties

   • id must be unique
   • productId must reference valid product
   • serialNumber must be unique if provided

2. Status Properties

   • status must be valid enum value
   • lastActive must be valid datetime

3. Metadata Properties

   • tags array items must be strings
   • extraFields must be valid JSON object

4. Tracking Properties

   • expiresAt must be future date
   • All dates must be valid ISO 8601