NAME

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

VERSION

version 1.08

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)