﻿# `label_print_jobs`

**Module:** Attendance

---

## Purpose

Tracks label print requests generated at each check-in. Supports angpao, souvenir, and VIP label types.

---

## Columns (Summary)

| Column | Notes |
|--------|-------|
| `id BIGINT UNSIGNED AUTO_INCREMENT PK` | — |
| `checkin_id BIGINT UNSIGNED NOT NULL FK→checkins` | — |
| `workspace_id BIGINT UNSIGNED NOT NULL (denormalized)` | — |
| `template_type VARCHAR(20) NOT NULL (angpao|souvenir|vip)` | — |
| `labels_generated TINYINT UNSIGNED DEFAULT 1` | — |
| `is_acknowledged TINYINT(1) DEFAULT 0` | — |
| `created_at DATETIME DEFAULT CURRENT_TIMESTAMP` | — |
| `acknowledged_at DATETIME NULL` | — |

---

## Referenced By

None

---

## Notes

See `docs/database/RELATIONSHIP.md` for full entity relationships and `database/schema.sql` for authoritative DDL.
