<& href, text => 'jump to columns', path => 'view_table' . Alzabo::GUI::Mason::Config::mason_extension(), query => { table => $t->name, schema => $s->name, }, &>

% if ( $t->all_foreign_keys ) {

Foreign keys

% foreach my $fk ($t->all_foreign_keys) { % if ( $fk->comment && length $fk->comment ) { % } % }

From		To
% foreach my $c_from ($fk->columns_from) { <& 'href', text => $c_from->name, path => 'view_column' . Alzabo::GUI::Mason::Config::mason_extension(), query => { schema => $t->schema->name, table => $t->name, column => $c_from->name } &> % unless ($c_from->name eq ($fk->columns_from)[-1]->name) { % } % } - <% $fk->from_is_dependent ? '' : 'in' %>dependent	<% join '..', $fk->cardinality %>	% foreach my $c_to ($fk->columns_to) { <& 'href', text => $fk->table_to->name, path => 'view_table' . Alzabo::GUI::Mason::Config::mason_extension(), query => { schema => $t->schema->name, table => $fk->table_to->name } &> . <& 'href', text => $c_to->name, path => 'view_column' . Alzabo::GUI::Mason::Config::mason_extension(), query => { schema => $t->schema->name, table => $fk->table_to->name, column => $c_to->name } &> % unless ($c_to->name eq ($fk->columns_to)[-1]->name) { % } % }
<% $fk->comment | h %>

% }

Create relationship

To table:

% foreach my $t ( sort {$a->name cmp $b->name} $s->tables ) { % next unless $t->columns; <% $t->name %> % }

% } % if ($t->columns) { % } <%args> $s $t <%init> my @columns = $t->columns; my $last = $columns[-1]; <%def .index> % if ( $i->can('function') && $i->function ) { <% $i->function | h %> - % } <% join ', ', @c %> % if ($i->unique) { - unique % } % if ($i->fulltext) { - fulltext % } <%init> my $i = shift; my @c; foreach my $c ( $i->columns ) { my $url = $m->scomp( 'href', text => $c->name, path => 'view_column' . Alzabo::GUI::Mason::Config::mason_extension(), query => { schema => $i->table->schema->name, table => $i->table->name, column => $c->name } ); $url .= '(' . $i->prefix($c) . ')' if $i->prefix($c); push @c, $url; } <%attr> show_columns => 0