stockvaccine
Table: stockvaccine
The stockvaccine table stores information about each vaccine type used in the system.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| stockVaccineId | smallint(6) | NO | Primary key identifying the vaccine |
| name | varchar(255) | YES | Name of the vaccine |
| value | varchar(255) | YES | Optional code or value associated with vaccine |
| doses | int(11) | NO | Number of doses per vial |
| createdDate | datetime | YES | Date when the vaccine record was created |
| dateAdded | datetime | YES | Date vaccine was added to stock |
| lastEditedDate | datetime | YES | Last edited date |
| createdByUserId | int(11) | YES | User who created the record |
| lastEditedByUserId | int(11) | YES | User who last edited the record |
| isMultiDose | tinyint(1) | YES | Flag indicating if vaccine is multi-dose |
| vaccineEntity | varchar(45) | YES | Entity type, default is CHILD |
Indexes
name— Unique index onname
Foreign Key Relations
- None
Usage Notes
- Used to define vaccine types and their dose information.
- Supports both single and multi-dose vaccines.