@extends ('backend.layouts.app')

@section('title', 'Table Schema View' )

@section('page-header')
<h1>Schema of {{$table}}</h1>
@endsection

@section('content')

<div class="box box-info">
        <div class="box-header with-border">
            <a href="{{ route('admin.dbmanager.index') }}" class="btn btn-primary btn-sm gotoTBL">
                Return
            </a>
        </div>
        <!--box-header with-border-->

        <div class="box-body">
            <div class="table-responsive data-table-wrapper">
                <table id="dbtable-table" class="table table-condensed table-hover table-bordered">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th scope="col" class="col-1">Field Name</th>
                            <th scope="col" class="col-1">Type Name</th>
                            <th scope="col" class="col-1">Null</th>
                            <th scope="col" class="col-1">Default</th>
                            <th scope="col" class="col-1">Auto Increment</th>
                            <th scope="col" class="col-1">Collation</th>
                            <th scope="col" class="col-1">Comment</th>
                        </tr>
                    </thead>
                    <tbody>
                    @if( !empty($columnsSchema) )
                        @foreach  ($columnsSchema as $columnSchema)
                        <tr>
                            <td>{{ $loop->iteration }}</td>
                            <td><b>{{ $columnSchema['name'] }}</b></td>
                            <td>{{ $columnSchema['type'] }}</td>
                            <td>{{ $columnSchema['nullable'] }}</td>
                            <td>{{ $columnSchema['default'] }}</td>
                            <td>{{ $columnSchema['auto_increment'] }}</td>
                            <td>{{ $columnSchema['collation'] }}</td>
                            <td>{{ $columnSchema['comment'] }}</td>
                        </tr>
                        @endforeach
                    @endif
                    </tbody>
                </table>
            </div>
            <!--table-responsive-->
        </div><!-- /.box-body -->
    </div>
    <!--box-->
@endsection

@section('after-scripts')


<script>

</script>

@endsection