TravelersReference
Reference
Reference for travelers, passports, and documents
Reference
Reference documentation for the traveler management system.
Reference Guides
Field Definitions
Complete field reference for travelers, passports, and documents
Expiry Statuses
Passport expiry status definitions and thresholds
API Reference
API endpoints for traveler management
Quick Reference
Traveler Types
| Type | Code | Age Range |
|---|---|---|
| Adult | ADT | 12+ years |
| Child | CHD | 2-11 years |
| Infant | INF | 0-1 years |
Traveler Titles
| Code | Display |
|---|---|
mr | Mr. |
mrs | Mrs. |
ms | Ms. |
miss | Miss |
mstr | Master |
Document Categories
| Category | Code |
|---|---|
| Passport | PASSPORT |
| Visa | VISA |
| Residency | RESIDENCY |
| Other | OTHER |
Expiry Thresholds
| Status | Days Until Expiry |
|---|---|
| Expired | Less than 0 |
| Critical | 0-60 days |
| Warning | 60-180 days |
| Valid | 180+ days |
Constraints
Uniqueness
| Entity | Unique Constraint |
|---|---|
| Passport | (travelerId, nationality, deletedAt) |
| Document | None (allows duplicates) |
Foreign Keys
| Entity | Field | References |
|---|---|---|
| Traveler | userId | User.id |
| Passport | travelerId | Traveler.id |
| Document | travelerId | Traveler.id |
Cascade Behavior
| Action | Behavior |
|---|---|
| Delete Traveler | Soft deletes traveler; passports and documents cascade |
| Delete Passport | Soft deletes passport; linked documents cascade |
| Delete User | Does not cascade to travelers (blocked by foreign key) |
All deletions are soft deletes. Records are marked with a deletedAt timestamp rather than being permanently removed.