line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package AproJo::DB::Schema::Result::Address; |
2
|
|
|
|
|
|
|
|
3
|
2
|
|
|
2
|
|
793
|
use strict; |
|
2
|
|
|
|
|
3
|
|
|
2
|
|
|
|
|
51
|
|
4
|
2
|
|
|
2
|
|
7
|
use warnings; |
|
2
|
|
|
|
|
2
|
|
|
2
|
|
|
|
|
37
|
|
5
|
|
|
|
|
|
|
|
6
|
2
|
|
|
2
|
|
6
|
use base 'DBIx::Class::Core'; |
|
2
|
|
|
|
|
2
|
|
|
2
|
|
|
|
|
371
|
|
7
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
__PACKAGE__->table('addresses'); |
9
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
__PACKAGE__->add_columns( |
11
|
|
|
|
|
|
|
'address_id', |
12
|
|
|
|
|
|
|
{data_type => 'integer', is_auto_increment => 1, is_nullable => 0}, |
13
|
|
|
|
|
|
|
'name', |
14
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 0, size => 50}, |
15
|
|
|
|
|
|
|
'name2', |
16
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
17
|
|
|
|
|
|
|
'name3', |
18
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
19
|
|
|
|
|
|
|
'department', |
20
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
21
|
|
|
|
|
|
|
'contact_id', |
22
|
|
|
|
|
|
|
{data_type => 'integer', is_nullable => 0, is_foreign_key => 1}, |
23
|
|
|
|
|
|
|
'street', |
24
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
25
|
|
|
|
|
|
|
'zip', |
26
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 20}, |
27
|
|
|
|
|
|
|
'boxno', |
28
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 20}, |
29
|
|
|
|
|
|
|
'zipbox', |
30
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 20}, |
31
|
|
|
|
|
|
|
'city', |
32
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 0, size => 50}, |
33
|
|
|
|
|
|
|
'state', |
34
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
35
|
|
|
|
|
|
|
'country', |
36
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 6}, |
37
|
|
|
|
|
|
|
'vat_id', |
38
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
39
|
|
|
|
|
|
|
'phone', |
40
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
41
|
|
|
|
|
|
|
'fax', |
42
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 50}, |
43
|
|
|
|
|
|
|
'email', |
44
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 100}, |
45
|
|
|
|
|
|
|
'url', |
46
|
|
|
|
|
|
|
{data_type => 'varchar', default_value => '', is_nullable => 1, size => 100}, |
47
|
|
|
|
|
|
|
); |
48
|
|
|
|
|
|
|
|
49
|
|
|
|
|
|
|
__PACKAGE__->set_primary_key('address_id'); |
50
|
|
|
|
|
|
|
|
51
|
|
|
|
|
|
|
1; |