Foorum::Schema::Topic - Table 'topic'

Foorum documentation Contained in the Foorum distribution.

Index

Code Index:

NAME

Top

Foorum::Schema::Topic - Table 'topic'

COLUMNS

Top

topic_id

INT(11)

NOT NULL, PRIMARY KEY

forum_id

INT(11)

NOT NULL

post_on

INT(11)

NOT NULL

title

VARCHAR(255)

closed

ENUM(1)

NOT NULL

sticky

ENUM(1)

NOT NULL

elite

ENUM(1)

NOT NULL

hit

INT(11)

NOT NULL

last_updator_id

INT(11)

NOT NULL

last_update_date

INT(11)

author_id

INT(11)

NOT NULL

total_replies

INT(11)

NOT NULL

status

ENUM(7)

NOT NULL, DEFAULT VALUE 'healthy'

AUTHOR

Top

Fayland Lam <fayland at gmail.com>

Foorum documentation Contained in the Foorum distribution. 
package Foorum::Schema::Topic;

use strict;
use warnings;
our $VERSION = '1.001000';
use base 'DBIx::Class';

__PACKAGE__->load_components(qw/Core/);
__PACKAGE__->table('topic');
__PACKAGE__->add_columns(
    'topic_id',
    {   data_type     => 'INT',
        default_value => undef,
        is_nullable   => 0,
        size          => 11
    },
    'forum_id',
    { data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
    'post_on',
    {   data_type     => 'INT',
        default_value => 0,
        is_nullable   => 0,
        size          => 11,
    },
    'title',
    {   data_type     => 'VARCHAR',
        default_value => undef,
        is_nullable   => 1,
        size          => 255,
    },
    'closed',
    { data_type => 'ENUM', default_value => 0, is_nullable => 0, size => 1 },
    'sticky',
    { data_type => 'ENUM', default_value => 0, is_nullable => 0, size => 1 },
    'elite',
    { data_type => 'ENUM', default_value => 0, is_nullable => 0, size => 1 },
    'hit',
    { data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
    'last_updator_id',
    { data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
    'last_update_date',
    {   data_type     => 'INT',
        default_value => 0,
        is_nullable   => 1,
        size          => 11,
    },
    'author_id',
    { data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
    'total_replies',
    { data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
    'status',
    {   data_type     => 'ENUM',
        default_value => 'healthy',
        is_nullable   => 0,
        size          => 7,
    },
);
__PACKAGE__->set_primary_key('topic_id');

__PACKAGE__->might_have(
    'author' => 'Foorum::Schema::User',
    { 'foreign.user_id' => 'self.author_id' }
);
__PACKAGE__->might_have(
    'last_updator' => 'Foorum::Schema::User',
    { 'foreign.user_id' => 'self.last_updator_id' }
);
__PACKAGE__->belongs_to(
    'forum' => 'Foorum::Schema::Forum',
    { 'foreign.forum_id' => 'self.forum_id' }
);

__PACKAGE__->resultset_class('Foorum::ResultSet::Topic');

1;
__END__