6.6.2.3 TreatmentProduct
6.6.2.3.1 Purpose¶
One product used in a treatment, with dose, route, quantity taken from stock and withdrawal periods (how long milk or meat from the animal cannot be sold afterwards).
6.6.2.3.2 Questions it answers¶
- Which medicine was given, at which dose and by which route?
- Which withdrawal periods apply?
- How much product was taken from stock?
6.6.2.3.3 Fields¶
| Field | Type | Cardinality | Description |
|---|---|---|---|
id |
string (uuid) |
1..1 |
Key. |
product_code |
string |
0..1 |
Official medicine code when known (e.g. the Italian AIC code). |
product_name |
string |
1..1 |
|
dose |
decimal |
0..1 |
|
dose_unit |
string |
0..1 |
UCUM or a package unit (tube, dose, piece). |
dose_basis |
enum | 1..1 |
Values: per_animal, per_100kg_bodyweight, per_quarter, total, unknown. Default: unknown.e.g. "20 ML / 100 Kg" = dose 20, unit mL, basis per_100kg_bodyweight; "1 TUBO X QUARTO" = per_quarter. |
total_quantity |
decimal |
0..1 |
Total quantity unloaded from stock for this treatment, in dose_unit. |
route |
enum | 1..1 |
Values: injection, oral, intramammary, topical, intrauterine, other, unknown. |
withdrawals |
WithdrawalSpec | 0..* |
|
created_at |
datetime |
1..1 |
|
updated_at |
datetime |
1..1 |
6.6.2.3.4 Relationships¶
Referenced by
TreatmentEvent.products(0..*)GroupTreatmentEvent.products(0..*)
Uses types
6.6.2.3.5 Rules & constraints¶
- One product in a treatment's evidence, with its reported administration/stock semantics.
- Immutable child payload of an exact event revision; do not update children of historical events.
- A correction creates new child rows; the owning event revision lists them in products.