NAME

MySQL::Workbench::Parser::Table - A table of the ER model

VERSION

version 1.11

METHODS

as_hash

return info about a table as a hash

    my %info = $table->as_hash;

returns

    (
        name         => 'table_name',
        primary_key  => [ 'id' ],
        foreign_keys => {
            second_table => [
                {
                    foreign => 'id',
                    me      => 'second_id',
                },
            ],
        },
        columns      => [
            {
                name          => 'id',
                datatype      => 'INT',
                length        => '',
                precision     => '0',
                not_null      => '1',
                autoincrement => '1',
                default_value => '',
            }
        ],
    )

get_datatype

get datatype for a workbench column datatype

    my $datatype = $table->get_datatype( 'com.mysql.rdbms.mysql.datatype.mediumtext' );

returns the MySQL name of the datatype

    MEDIUMTEXT

ATTRIBUTES

• comment

• columns

  An array reference of MySQL::Workbench::Parser::Column objects

• foreign_keys

  An array reference of all relationships to other tables

• name

  The name of the table

• node

• parser

• primary_key

• indexes

• column_mapping

MISC

BUILD

AUTHOR

Renee Baecker <reneeb@cpan.org>

COPYRIGHT AND LICENSE

This software is Copyright (c) 2018 by Renee Baecker.

This is free software, licensed under:

  The Artistic License 2.0 (GPL Compatible)