<% title "'#{@table.name}' Schema" %>

Table: <%= @table.name %>

<%= render '/rails_db/shared/exp_col' %>

<%= link_to raw("#{fa_icon('table')} Records"), table_data_path(@table), remote: true %>

<%= link_to raw("#{fa_icon('tasks')} Schema"), table_path(@table), remote: true %>

<%= select_top_from_table(@table.name) %>

<%= link_to raw("#{fa_icon('file-excel-o')} Export"), table_csv_path(@table) %>

Schema

<% if @table.primary_key.present? %> <% end %> <% @table.column_properties.each do |key| %> <% end %> <% @table.columns.each do |col| %> <% if @table.primary_key %> <% if @table.primary_key == col.name %> <% else %> <% end %> <% end %> <% @table.column_properties.each do |key| %> <% end %> <% end %>

PK	<%= key.titleize.upcase %>
<%= fa_icon 'key' %>		<% value = col.send(key) %> <%= value %>

Indexes

<% if Rails::VERSION::MAJOR >= 4 %> <% end %> <% @table.indexes.each do |index| %> <% if Rails::VERSION::MAJOR >= 4 %> <% end %> <% end %> <% if @table.indexes.none? %> <% end %>

Name	Unique	Columns	Length	Orders	Where	Type	Using
<%= index.name %>	<%= index.unique %>	<%= index.columns %>	<%= index.lengths %>	<%= index.orders %>	<%= index.where %>	<%= index.type %>	<%= index.using %>
No Indexes