/ 
MySQL-Workbench-Parser-1.11
River stage one • 2 direct dependents • 2 total dependents
/ MySQL::Workbench::Parser::Column

NAME

MySQL::Workbench::Parser::Column - A column of the ER model

VERSION

version 1.11

METHODS

as_hash

return info about a column as a hash

my %info = $column->as_hash;

returns

(
    name          => 'id',
    datatype      => 'INT',
    length        => '',
    precision     => '0',
    not_null      => '1',
    autoincrement => '1',
    default_value => '',
)

as_string

Returns a stringified version of the column information

(
    name          => 'id',
    datatype      => 'INT',
    length        => '',
    precision     => '0',
    not_null      => '1',
    autoincrement => '1',
    default_value => '',
)

returns

id INT NOT NULL AUTOINCREMENT

ATTRIBUTES

  • autoincrement

  • comment

  • datatype

  • default_value

  • flags

    Any extra flags like binary, unsigned and/or zerofill.

  • id

  • length

  • name

  • node

  • not_null

  • precision

  • table

  • type_info

    More information about the datatype:

    • args

      The length, precision or a list of possible values (for enums).

    • gui_name

      The column type as shown in Workbench. For user defined types it is the label shown in the dropdowns.

    • length

      E.g. for VARCHAR columns, the max length of the value

    • name

      The SQL definition name. For user defined types, this is the underlying data type.

    • precision

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)