vaccinatordailystock
Table: vaccinatordailystock
The vaccinatordailystock table tracks the daily stock of vaccines handled by each vaccinator, including opening, closing, administered, and wastage doses.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| vaccinatorDailyStockId | int(11) | NO | Primary key identifying each daily stock record |
| administeredDoses | int(11) | YES | Number of doses administered |
| closedVialWastageDoses | int(11) | YES | Doses wasted from closed vials |
| closingBalance | int(11) | YES | Closing stock balance |
| createdDate | datetime | YES | Record creation timestamp |
| editedDate | datetime | YES | Record edit timestamp |
| lastEditedDate | datetime | YES | Last edit timestamp |
| mappedId | int(11) | YES | Reference ID for the vaccinator or related entity |
| openVialWastageDoses | int(11) | YES | Doses wasted from open vials |
| openingDoses | int(11) | YES | Opening stock balance |
| recievedDoses | int(11) | YES | Number of doses received |
| stockAdded | datetime | YES | Timestamp when stock was added |
| stockType | varchar(255) | YES | Type of stock (e.g., routine, campaign) |
| stockVaccineId | int(11) | NO | Reference to the vaccine in stock |
| vaccinationCenterId | int(11) | NO | Reference to the vaccination center |
| vaccinationEventType | varchar(255) | YES | Type of vaccination event |
| voided | tinyint(1) | YES | Flag indicating if record is voided |
| voidedDate | datetime | YES | Timestamp when record was voided |
| voidedReason | varchar(255) | YES | Reason for voiding the record |
| createdByUserId | int(11) | YES | User who created the record |
| lastEditedByUserId | int(11) | YES | User who last edited the record |
Indexes
dailystock_vaccinationCenterId_vaccinationcenter_mappedId_FK— Index onvaccinationCenterIddailystock_lastEditedByUserId_user_mappedId_FK— Index onlastEditedByUserIddailystock_createdByUserId_user_mappedId_FK— Index oncreatedByUserId
Foreign Key Relations
createdByUserId → user.mappedIdlastEditedByUserId → user.mappedIdvaccinationCenterId → vaccinationcenter.mappedId
Usage Notes
- Tracks daily stock movement for each vaccinator.
- Helps monitor vaccine usage, wastage, and inventory control at vaccination centers.
- Essential for planning vaccine replenishment and auditing stock.