| id |
int(11)
|
|
|
|
| NumeroIstanza |
varchar(10)
|
utf8_bin
|
|
|
| NumeroProtocollo |
varchar(255)
|
utf8_bin
|
|
|
| richiedenteCf |
varchar(16)
|
utf8_bin
|
|
|
| richiedenteNome |
text
|
utf8_bin
|
|
|
| richiedenteCognome |
text
|
utf8_bin
|
|
|
| richiedenteDataNascita |
date
|
|
|
|
| richiedenteLuogoNascita |
text
|
utf8_bin
|
|
|
| richiedenteProvinciaNascita |
text
|
utf8_bin
|
|
|
| richiedenteVia |
text
|
utf8_bin
|
|
|
| richiedenteCivico |
text
|
utf8_bin
|
|
|
| richiedenteLocalita |
text
|
utf8_bin
|
|
|
| richiedenteProvincia |
text
|
utf8_bin
|
|
|
| richiedenteCap |
varchar(30)
|
utf8_bin
|
|
|
| richiedenteEmail |
text
|
utf8_bin
|
|
|
| richiedenteTel |
text
|
utf8_bin
|
|
|
| richiedenteNazionalita |
text
|
utf8_bin
|
|
|
| richiedenteProfessione |
text
|
utf8_bin
|
|
|
| richiedenteScolarita |
text
|
utf8_bin
|
|
|
| pgRuolo |
text
|
utf8_bin
|
|
|
| pgDenominazione |
text
|
utf8_bin
|
|
|
| pgTipologia |
varchar(30)
|
utf8_bin
|
|
|
| pgSedeLegaleIndirizzo |
text
|
utf8_bin
|
|
|
| pgSedeLegaleLocalita |
text
|
utf8_bin
|
|
|
| pgSedeLegaleProvincia |
varchar(30)
|
utf8_bin
|
|
|
| pgSedeLegaleCap |
varchar(30)
|
utf8_bin
|
|
|
| pgCf |
text
|
utf8_bin
|
|
|
| pgPiva |
text
|
utf8_bin
|
|
|
| pgTelefono |
text
|
utf8_bin
|
|
|
| pgEmail |
text
|
utf8_bin
|
|
|
| pgPec |
text
|
utf8_bin
|
|
|
| defuntoNome |
text
|
utf8_bin
|
|
|
| defuntoCognome |
text
|
utf8_bin
|
|
|
| defuntoDataNascita |
date
|
|
|
|
| defuntoLuogoNascita |
text
|
utf8_bin
|
|
|
| defuntoVia |
text
|
utf8_bin
|
|
|
| defuntoLocalita |
text
|
utf8_bin
|
|
|
| defuntoProvincia |
text
|
utf8_bin
|
|
|
| defuntoCap |
varchar(10)
|
utf8_bin
|
|
|
| decessoLuogo |
text
|
utf8_bin
|
|
|
| decessoLocalita |
text
|
utf8_bin
|
|
|
| decessoData |
date
|
|
|
|
| tipoTrasporto |
varchar(1)
|
utf8_bin
|
|
|
| trasportoCadavereCassa |
varchar(255)
|
utf8_bin
|
|
|
| trasportoCadavereDaLuogo |
text
|
utf8_bin
|
|
|
| trasportoCadavereData |
date
|
|
|
|
| trasportoCadavereDaOra |
varchar(255)
|
utf8_bin
|
|
|
| trasportoCeneriDaLuogo |
text
|
utf8_bin
|
|
|
| trasportoCeneriData |
date
|
|
|
|
| trasportoCeneriDaOra |
varchar(255)
|
utf8_bin
|
|
|
| trasportoCeneriALuogo |
text
|
utf8_bin
|
|
|
| destFinale |
varchar(1)
|
utf8_bin
|
|
|
| altraDestFinale |
text
|
utf8_bin
|
|
|
| destinazioneCrematorio |
text
|
utf8_bin
|
|
|
| mdbIstanzaData |
date
|
|
|
|
| mdbIstanzaNumero |
varchar(255)
|
utf8_bin
|
|
|
| uploadCertificatoMedico |
text
|
utf8_bin
|
|
|
| uploadProcessoVerbale |
text
|
utf8_bin
|
|
|
| uploadTrasportoCassaAperta |
text
|
utf8_bin
|
|
|
| status_id |
int(11)
|
|
|
|
| id_orig |
int(11)
|
|
|
|
| data_compilazione |
timestamp
|
|
|
|
| ultimo_aggiornamento |
timestamp
|
|
|
|
