id |
74
|
Title |
Medical visit --> Posology
|
Type |
Database 6.1
|
Highlight group |
|
Description |
the medical visit posology are stored in the D_EVENTS_ATT table with domain "A_DPRES"
|
Code |
d_events_att |
|
id_events_att |
(primary key) |
id_event |
foreign key |
id_person |
patinet unique ID |
id_reference |
= 'VISIT' |
domain |
= 'A_DPRES' |
|
|
vt1 |
deliverable |
vt2 |
drug |
vt3 |
formulation |
vt4 |
freq det |
vt5 |
drug ID |
vt6 |
notes |
vt7 |
posology |
vt8 |
prescribed by |
vt9 |
prophilaxis type |
vt10 |
status |
vt11 |
treatment type |
vt12 |
|
vt13 |
user who inserted |
vt14 |
user who edited |
vd2 |
modification date |
vn1 |
frequency |
vn2 |
days |
vn3 |
morning |
vn4 |
midday |
vn5 |
afternoon |
vn6 |
prolonged |
vn7 |
quantity |
vn8 |
evening |
vd1 |
suspended |
vb1 |
as needed |
vb2 |
|
|
Ordine |
330
|