<?php

return [
    'mappings' => [
        'tables' => [
            'players' => [
                'name'    => 'ply_players',
                'columns' => [
                    'id'          => 'id',
                    'username'    => 'username',
                    'password'    => 'password',
                    'last-name'   => 'last_name',
                    'first-name'  => 'first_name',
                    'middle-name' => 'middle_name',
                    'suffix'      => 'suffix',
                    'nickname'    => 'nickname',
                    'email'       => 'email',
                    'phone'       => 'phone',
                    'birthdate'   => 'birthdate',
                    'question-1'  => 'question_1',
                    'question-2'  => 'question_2',
                    'is-core'     => 'is_core',
                    'is-active'   => 'is_active',
                    'created-by'  => 'created_by',
                    'created-on'  => 'created_on',
                    'updated-by'  => 'updated_by',
                    'updated-on'  => 'updated_on',
                    'deleted-by'  => 'deleted_by',
                    'deleted-on'  => 'deleted_on',
                ],
            ],
        ],
        'views'  => [
            'players_active' => [
                'name'    => 'ply_players_active',
                'columns' => [
                    'id'          => 'id',
                    'username'    => 'username',
                    'password'    => 'password',
                    'last-name'   => 'last_name',
                    'first-name'  => 'first_name',
                    'middle-name' => 'middle_name',
                    'suffix'      => 'suffix',
                    'nickname'    => 'nickname',
                    'email'       => 'email',
                    'phone'       => 'phone',
                    'birthdate'   => 'birthdate',
                    'question-1'  => 'question_1',
                    'question-2'  => 'question_2',
                    'is-core'     => 'is_core',
                    'is-active'   => 'is_active',
                    'created-by'  => 'created_by',
                    'created-on'  => 'created_on',
                    'updated-by'  => 'updated_by',
                    'updated-on'  => 'updated_on',
                    'deleted-by'  => 'deleted_by',
                    'deleted-on'  => 'deleted_on',
                ],
            ],
        ],
    ],
];
