m180920_103032_create_idm_table.php 3.14 KB
Newer Older
Marcello Pivanti's avatar
Marcello Pivanti committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php

/**
 * Art-ER Attrattività, ricerca e territorio dell’Emilia-Romagna
 * OPEN 2.0
 *
 * @package    Open20Package
 * @category   CategoryName
 * @author     Elite Division S.r.l.
 */

use elitedivision\amos\core\migration\AmosMigrationTableCreation;

/**
 * Class m180920_103032_create_idm_table
 */
class m180920_103032_create_idm_table extends AmosMigrationTableCreation
{
    /**
     * @inheritdoc
     */
    protected function setTableName()
    {
        $this->tableName = '{{%social_idm_user}}';
    }

    /**
     * @inheritdoc
     */
    protected function setTableFields()
    {
        $this->tableFields = [
            'id' => $this->primaryKey(),
            'user_id' => $this->integer(11)->null()->comment('User ID'),
            'numeroMatricola' => $this->string(255)->notNull()->comment('Numero di Matricola'),
            'codiceFiscale' => $this->string(255)->null()->comment('Codice Fiscale'),
            'nome' => $this->string(255)->null()->comment('Nome'),
            'cognome' => $this->string(255)->null()->comment('Cognome'),
            'ssoDN' => $this->string(255)->null()->comment('ssoDN'),
            'tipoAutenticazione' => $this->string(255)->null()->comment('Tipo di Autenticazione'),
            'ssoUrlLogout' => $this->string(255)->null()->comment('Url di Logout SSO'),
            'responseBase64' => $this->string(255)->null()->comment('Risposta BASE64'),
            'emailAddress' => $this->string(255)->null()->comment('Indirizzo Email'),
            'livelloVerifica' => $this->string(255)->null()->comment('Livello di Verifica'),
            'nomeUtente' => $this->string(255)->null()->comment('Nome Utente'),
            'sesso' => $this->string(255)->null()->comment('Sesso'),
            'dataNascita' => $this->string(255)->null()->comment('Data di Nascita'),
            'luogoNascita' => $this->string(255)->null()->comment('Luogo di Nascita'),
            'provinciaNascita' => $this->string(255)->null()->comment('Provincia di Nascita'),
            'statoNascita' => $this->string(255)->null()->comment('Stato di Nascita'),
            'identificativoUtente' => $this->string(255)->null()->comment('Identificativo Utente'),
            'cellulare' => $this->string(255)->null()->comment('Cellulare'),
            'ragioneSociale' => $this->string(255)->null()->comment('Ragione Sociale'),
            'sedeLegale' => $this->string(255)->null()->comment('Sede Legale'),
            'partitaIVA' => $this->string(255)->null()->comment('Partita IVA'),
            'docIdentita' => $this->string(255)->null()->comment('Documento di Identita'),
            'scadDocIdentita' => $this->string(255)->null()->comment('Scadenza Documento'),
            'domicilioFisico' => $this->string(255)->null()->comment('Domicilio Fisico'),
            'domicilioDigitale' => $this->string(255)->null()->comment('Domicilio Digitale'),
            'origineDatiUtente' => $this->string(255)->null()->comment('Origina Dati'),
            'statoValidazioneProfiloUtente' => $this->string(255)->null()->comment('Stato di Validazione Profilo'),
            'idComuneRegistrazione' => $this->string(255)->null()->comment('ID Comune di Registrazione')
        ];
    }
}