view release on metacpan or  search on metacpan

lib/Parse/Dia/SQL/Output/HTML.pm  view on Meta::CPAN

=head3 tablekeyrow, tablerow

Details of an individual field (column) from the (table) in the table detail.

tablekeyrow is used for primary key fields, tablerow for other fields.

I<Placeholders>: name, type, default, comment.

I<Default> B<tablekeyrow>: <tr><td><b>{name}</b></td><td>{type}</td><td>{default}</td><td>{comment}</td></tr>

I<Default> B<tablerow>: <tr><td>{name}</td><td>{type}</td><td>{default}</td><td>{comment}</td></tr>


=head3 tablecomment

Table comments/description.

I<Placeholders>: comment

I<Default>: <p>{comment}</p>

=head3 tablecommentlist

Table comments/description in a list context

I<Placeholders>: comment

I<Default>: {comment}

=head3 autoupdate

Auto update code, if used.

I<Placeholders>: autoupdate

I<Default>: <p>Automatically set:{autoupdate}</p>


=head3 refby, refto

References by - a list of tables that refer to this one via foreign keys.

References to - a list of tables to which this table refers via foreign keys.

The whole section is omitted if there are no references (including any static text).

I<Placeholders>: refbylist, reftolist respectively.

I<Default>: B<refby> <p>Referenced by: {refbylist}</p>

I<Default>: B<refto> <p>References: {reftolist}</p>


=head3 refbyitem, reftoitem

A single item in the reference by list

I<Placeholders>: tablename, key, fk, action, refname

Here I<tablename> is the other table, I<key> is the field in this table, I<fk> is the field in the other table,
I<action> in the action on update/delete (such as cascade or update) and I<refname> is the name of the constraint.

I<Default>: <a href='#{tablename}'>{tablename}</a>


=head3 refbysep, reftosep

Separator between references.

I<Default>: C<, >

=head3 indices

List of indices on this tables.

The whole section is omitted if there are no indices (including any static text).

I<Placeholders>: indexlist

I<Default>: <h4>Indices</h4><p>{indexlist}</p>

=head3 indexitem

A single item in the index list

I<Placeholders>: tablename, columns, comment, type, indexname

Here I<tablename> is the indexed (ie current) table, I<columns> is the set of columns in the index, I<comment> is the index comment if any,
I<type> is 'unique' (or blank) and I<indexname> is the name of the index.

I<Default>: {indexname}: {type} on {columns} {comment}

=head3 indexsep

Separator between indices.

I<Default>: C<<br\>>


=head3 permission

A list of permissions granted on this table.

I<Placeholders>: permissionlist

I<Default>: <h4>Permissions</h4><p>{permissionlist}</p>


=head3 permissionitem

A single permission in the list

I<Placeholders>: permission

I<Default>: {permission}


=head3 permissionsep

Separator between permissions.