identifiertype

Table: identifiertype

The identifiertype table stores different types of identifiers used in the system.
It defines the format, requirements, and location-specific behavior for each identifier type.

---

Columns

Column Name	Data Type	Constraints	Description
identifierTypeId	int(11)	NOT NULL, AUTO_INCREMENT, PRIMARY KEY	Unique ID for each identifier type
name	varchar(45)	UNIQUE	Name of the identifier type
format	varchar(255)	NULL	Format or pattern for the identifier
locationBehavior	varchar(255)	NULL	Specifies how the identifier behaves at different locations
required	tinyint(1)	NULL	Flag indicating if the identifier is mandatory (1 = required, 0 = optional)
description	varchar(255)	NULL	Additional details or description about the identifier type

---

Indexes

1. PRIMARY - Primary key on identifierTypeId
2. UNIQUE - name_UNIQUE on name

---

Foreign Key Relations

• None

---

Usage Notes

• Defines identifier types used across children, campaigns, or other entities.
• format ensures that identifiers conform to a specific pattern for consistency.
• locationBehavior allows customization of identifier usage based on the location.
• The required flag enforces mandatory identifiers where necessary.