vaccinationcentercloseday
Table Name: vaccinationcentercloseday
The vaccinationcentercloseday table maintains records of days when vaccination centers are closed, including metadata about the closure and tracking information.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| vaccinationCenterCloseDayId | int(11) | Primary Key, Auto-Increment | Unique identifier for the closed day record. |
| createdDate | datetime | Timestamp when the record was created. | |
| dateClosed | datetime | Date and time the vaccination center was closed. | |
| description | varchar(50) | Brief description of the closure. | |
| lastEditedDate | datetime | Timestamp of the last modification to the record. | |
| status | varchar(20) | Status of the closure (e.g., planned, unplanned). | |
| vaccinationCenterId | int(11) | Foreign Key | ID of the vaccination center associated with the closure. |
| voided | tinyint(1) | Indicates if the record is voided (0 = active, 1 = voided). | |
| voidedDate | datetime | Timestamp of when the record was voided, if applicable. | |
| voidedReason | varchar(50) | Reason for voiding the record, if applicable. | |
| createdByUserId | int(11) | Foreign Key | ID of the user who created the record. |
| lastEditedByUserId | int(11) | Foreign Key | ID of the user who last edited the record. |
Indexes
- Primary Key:
- vaccinationCenterCloseDayId: Ensures uniqueness for each closure record.
- Additional Indexes:
- vaccinationCenterCloseDay_createdByUserId_user_mappedId_FK: Index for the createdByUserId column.
- vaccinationCenterCloseDay_lastEditedByUserId_user_mappedId_FK: Index for the lastEditedByUserId column.
- complianceManagement_vaccinationCenter_location_locationId_FK: Index for the vaccinationCenterId column.
Foreign Key Relations
vaccinationCenterId
-
References the location table's locationId column.
-
Associates the closure record with a specific vaccination center.
createdByUserId -
References the user table's mappedId column.
-
Tracks which user created the closure record.
lastEditedByUserId
-
References the user table's mappedId column.
-
Tracks which user last edited the closure record.
Usage Notes
- Purpose:
- To manage and document days when vaccination centers are closed.
- Allows tracking closures for compliance, planning, and operational adjustments.
- Reference Usage:
- The vaccinationCenterId links closures to a specific vaccination center for analysis and reporting.
- User-related fields (createdByUserId, lastEditedByUserId) provide traceability for record management.