| id |
25
|
| Title |
From Gravidanze to D_Status e D_Events
|
| Type |
Migration 5 to 6
|
| Highlight group |
|
| Description |
in d_status there are only the start and the stop of the pregnancy (two records)
in d_events there are all the informations about the pregnancy in only one row
nota: there are no d_events_att for Gravidanze
|
| Code |
From Gravidanze to D_Status | DREAM 5 | DREAM 6 | Note | | idGravidanza | id_status (modified see note) | modified with code GS | | IdAnagrafica | id_person | | | | | | | | domain = 'ST_PREGN' | | DataConcepimento (for YES) or
DataEsito (for NO) | date_started | | | | Status | if dataEsito is not null -> NO , null -> YES | | | usr_INS | usr_INS | | | usr_MOD | usr_MOD | | | usr_DATAMOD | usr_DATAMOD | | | | active | = 1 if last |
From Gravidanze to D_Events | DREAM 5 | DREAM 6 | Note | | idGravidanza | id_event | | | | | | | | domain = 'PREGNANCY' | | | idAnagrafica | id_person | | | DataConcepimento | date_start | | | DataEsito | date_event | | | Esito | event_status | | | DataInizioPrev | ev_vd1 | | | DataPresuntaParto | ev_vd2 | | | GRFLD01 | ev_vt1 | | | GRFLD02 | ev_vt2 | | | GRFLD03 | ev_vt3 | | | Nati_Morti | ev_vn1 | | | Nati_Vivi | ev_vn2 | | | InizioTardivo | ev_vn3 | | | Settimana | ev_vn4 | | | StartTarv | ev_vd3 | | | Tipo_Parto | ev_vt4 | | | usr_INS | usr_ins | | | usr_MOD | usr_mod | | | usr_DATAMOD | usr_datamod | |
|
| Ordine |
|
