View source for Personale/Anagrafico

{|style="color:black;background-color:#c3e8ff;" border="1" cellspacing="0"
|+''Tabella anagrafico''
|- style="color:black;background-color:#ddddff;" border="1" cellspacing="0"
!Field
!Type
!Attributes
!Null
!Default
!Extra
|-
|CodiceUtente
|smallint(5)
|UNSIGNED
|No
|
|auto_increment
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|Attivo
|enum('NO', 'SI')
|
|No
|SI
|
|-
|NumeroBadge
|int(4)
|UNSIGNED
|Yes
|NULL
| 	
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|Qualifica
|smallint(5)
|UNSIGNED
|Yes
|NULL  	  	
|
|-
|Stipendio
|set('SI', 'NO')
|
|Yes
|NULL
|	  	
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|Matricola
|int(5) 	 
|UNSIGNED
|Yes
|NULL
|
|-
|Titolo
|varchar(16)
|
|Yes
|NULL
|
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|Cognome
|varchar(32)
|
|No
|
|
|-
|Nome
|varchar(32)
|
|No
|
|
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|CittaNascitaID  
|smallint(5) 	 
|UNSIGNED 	
|Yes  	
|NULL  	  	
|
|-
|DataNascita  	 
|date 	  	 
|              
|Yes  	
|NULL  	  	
|
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|Sesso  	 
|enum('M', 'F')
|
|Yes
|M  	  	
|
|-
|Indirizzo
|varchar(132)
|
|Yes
|NULL  	  	
|
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|CAP
|varchar(5)
|
|Yes
|NULL  	  	
|
|-
|CittaID
|smallint(5)
|UNSIGNED
|Yes
|NULL
|  	  	
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|ResidenzaIE
|enum('I', 'E')
|
|Yes
|I
|  	  	
|-
|Telefono
|varchar(32)
|
|Yes
|NULL
|  	  	
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|NazionalitaID
|smallint(5)
|UNSIGNED
|Yes
|NULL
|  	  	
|-
|CodiceFiscale
|varchar(16)
|
|Yes
|NULL  	  	
|
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|Email
|varchar(32)
|
|Yes 
|NULL
|  	  	
|-
|ResidenzaPisa
|varchar(132)
|
|Yes
|NULL
|  	  	
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|TelefonoPisa
|varchar(32)
|
|Yes
|NULL
|  	  	
|-
|DataInserimento
|date
|
|Yes
|NULL
|  	  	
|- style="color:black;background-color:#c3e8dd;" border="1" cellspacing="0"
|Foto
|mediumblob
|BINARY
|Yes
|NULL
|
|-
|SBF
|enum('SI', 'NO')
|
|No
|SI
|
|}
[http://vmweb.pi.infn.it/wiki/index.php/Personale/Visualizza_elenco_tabelle Elenco Tabelle Dati]