Revision 1561b7f3
Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt
SL/DB/MetaSetup/Default.pm | ||
---|---|---|
66 | 66 |
profit_determination => { type => 'text' }, |
67 | 67 |
purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' }, |
68 | 68 |
purchase_order_show_delete => { type => 'boolean', default => 'true' }, |
69 |
requirement_spec_section_number_format => { type => 'text', default => 'A00', not_null => 1 }, |
|
70 | 69 |
requirement_spec_function_block_number_format => { type => 'text', default => 'FB000', not_null => 1 }, |
70 |
requirement_spec_section_number_format => { type => 'text', default => 'A00', not_null => 1 }, |
|
71 | 71 |
revtrans => { type => 'boolean', default => 'false' }, |
72 | 72 |
rfqnumber => { type => 'text' }, |
73 | 73 |
rmanumber => { type => 'text' }, |
SL/DB/MetaSetup/Project.pm | ||
---|---|---|
25 | 25 |
projectnumber => { type => 'text' }, |
26 | 26 |
start_date => { type => 'date' }, |
27 | 27 |
timeframe => { type => 'boolean', default => 'false', not_null => 1 }, |
28 |
type => { type => 'text' }, |
|
29 | 28 |
valid => { type => 'boolean', default => 'true' }, |
30 | 29 |
); |
31 | 30 |
|
... | ... | |
36 | 35 |
__PACKAGE__->meta->allow_inline_column_values(1); |
37 | 36 |
|
38 | 37 |
__PACKAGE__->meta->foreign_keys( |
39 |
customer => { |
|
40 |
class => 'SL::DB::Customer', |
|
41 |
key_columns => { customer_id => 'id' }, |
|
42 |
}, |
|
43 |
|
|
44 |
project_type => { |
|
45 |
class => 'SL::DB::ProjectType', |
|
46 |
key_columns => { project_type_id => 'id' }, |
|
47 |
}, |
|
48 |
|
|
49 | 38 |
billable_customer => { |
50 | 39 |
class => 'SL::DB::Customer', |
51 | 40 |
key_columns => { billable_customer_id => 'id' }, |
SL/DB/MetaSetup/ProjectParticipant.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'project_participants', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
project_id => { type => 'integer', not_null => 1 }, |
|
15 |
employee_id => { type => 'integer', not_null => 1 }, |
|
16 |
project_role_id => { type => 'integer', not_null => 1 }, |
|
17 |
minutes => { type => 'integer', default => '0', not_null => 1 }, |
|
18 |
cost_per_hour => { type => 'numeric', precision => 5, scale => 15 }, |
|
19 |
itime => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' }, |
|
20 |
mtime => { type => 'timestamp' }, |
|
21 |
], |
|
22 |
|
|
23 |
primary_key_columns => [ 'id' ], |
|
24 |
|
|
25 |
foreign_keys => [ |
|
26 |
employee => { |
|
27 |
class => 'SL::DB::Employee', |
|
28 |
key_columns => { employee_id => 'id' }, |
|
29 |
}, |
|
30 |
|
|
31 |
project => { |
|
32 |
class => 'SL::DB::Project', |
|
33 |
key_columns => { project_id => 'id' }, |
|
34 |
}, |
|
35 |
|
|
36 |
project_role => { |
|
37 |
class => 'SL::DB::ProjectRole', |
|
38 |
key_columns => { project_role_id => 'id' }, |
|
39 |
}, |
|
40 |
], |
|
9 |
__PACKAGE__->meta->table('project_participants'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
cost_per_hour => { type => 'numeric', precision => 5, scale => 15 }, |
|
13 |
employee_id => { type => 'integer', not_null => 1 }, |
|
14 |
id => { type => 'serial', not_null => 1 }, |
|
15 |
itime => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' }, |
|
16 |
minutes => { type => 'integer', default => '0', not_null => 1 }, |
|
17 |
mtime => { type => 'timestamp' }, |
|
18 |
project_id => { type => 'integer', not_null => 1 }, |
|
19 |
project_role_id => { type => 'integer', not_null => 1 }, |
|
20 |
); |
|
21 |
|
|
22 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
|
23 |
|
|
24 |
__PACKAGE__->meta->foreign_keys( |
|
25 |
employee => { |
|
26 |
class => 'SL::DB::Employee', |
|
27 |
key_columns => { employee_id => 'id' }, |
|
28 |
}, |
|
29 |
|
|
30 |
project => { |
|
31 |
class => 'SL::DB::Project', |
|
32 |
key_columns => { project_id => 'id' }, |
|
33 |
}, |
|
34 |
|
|
35 |
project_role => { |
|
36 |
class => 'SL::DB::ProjectRole', |
|
37 |
key_columns => { project_role_id => 'id' }, |
|
38 |
}, |
|
41 | 39 |
); |
42 | 40 |
|
43 | 41 |
1; |
SL/DB/MetaSetup/ProjectPhase.pm | ||
---|---|---|
1 |
# This file has been auto-generated. Do not modify it; it will be overwritten |
|
2 |
# by rose_auto_create_model.pl automatically. |
|
3 |
package SL::DB::ProjectPhase; |
|
4 |
|
|
5 |
use strict; |
|
6 |
|
|
7 |
use base qw(SL::DB::Object); |
|
8 |
|
|
9 |
__PACKAGE__->meta->table('project_phases'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 }, |
|
13 |
budget_minutes => { type => 'integer', default => '0', not_null => 1 }, |
|
14 |
description => { type => 'text', not_null => 1 }, |
|
15 |
end_date => { type => 'date' }, |
|
16 |
general_cost_per_hour => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 }, |
|
17 |
general_minutes => { type => 'integer', default => '0', not_null => 1 }, |
|
18 |
id => { type => 'serial', not_null => 1 }, |
|
19 |
itime => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' }, |
|
20 |
mtime => { type => 'timestamp' }, |
|
21 |
name => { type => 'text', not_null => 1 }, |
|
22 |
project_id => { type => 'integer' }, |
|
23 |
start_date => { type => 'date' }, |
|
24 |
); |
|
25 |
|
|
26 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
|
27 |
|
|
28 |
__PACKAGE__->meta->foreign_keys( |
|
29 |
project => { |
|
30 |
class => 'SL::DB::Project', |
|
31 |
key_columns => { project_id => 'id' }, |
|
32 |
}, |
|
33 |
); |
|
34 |
|
|
35 |
__PACKAGE__->meta->relationships( |
|
36 |
project_phase_participants => { |
|
37 |
class => 'SL::DB::ProjectPhaseParticipant', |
|
38 |
column_map => { id => 'project_phase_id' }, |
|
39 |
type => 'one to many', |
|
40 |
}, |
|
41 |
); |
|
42 |
|
|
43 |
1; |
|
44 |
; |
SL/DB/MetaSetup/ProjectPhaseParticipant.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'project_phase_participants', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
project_phase_id => { type => 'integer', not_null => 1 }, |
|
15 |
employee_id => { type => 'integer', not_null => 1 }, |
|
16 |
project_role_id => { type => 'integer', not_null => 1 }, |
|
17 |
minutes => { type => 'integer', default => '0', not_null => 1 }, |
|
18 |
cost_per_hour => { type => 'numeric', precision => 5, scale => 15 }, |
|
19 |
itime => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' }, |
|
20 |
mtime => { type => 'timestamp' }, |
|
21 |
], |
|
22 |
|
|
23 |
primary_key_columns => [ 'id' ], |
|
24 |
|
|
25 |
foreign_keys => [ |
|
26 |
employee => { |
|
27 |
class => 'SL::DB::Employee', |
|
28 |
key_columns => { employee_id => 'id' }, |
|
29 |
}, |
|
30 |
|
|
31 |
project_role => { |
|
32 |
class => 'SL::DB::ProjectRole', |
|
33 |
key_columns => { project_role_id => 'id' }, |
|
34 |
}, |
|
35 |
], |
|
9 |
__PACKAGE__->meta->table('project_phase_participants'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
cost_per_hour => { type => 'numeric', precision => 5, scale => 15 }, |
|
13 |
employee_id => { type => 'integer', not_null => 1 }, |
|
14 |
id => { type => 'serial', not_null => 1 }, |
|
15 |
itime => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' }, |
|
16 |
minutes => { type => 'integer', default => '0', not_null => 1 }, |
|
17 |
mtime => { type => 'timestamp' }, |
|
18 |
project_phase_id => { type => 'integer', not_null => 1 }, |
|
19 |
project_role_id => { type => 'integer', not_null => 1 }, |
|
20 |
); |
|
21 |
|
|
22 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
|
23 |
|
|
24 |
__PACKAGE__->meta->foreign_keys( |
|
25 |
employee => { |
|
26 |
class => 'SL::DB::Employee', |
|
27 |
key_columns => { employee_id => 'id' }, |
|
28 |
}, |
|
29 |
|
|
30 |
project_role => { |
|
31 |
class => 'SL::DB::ProjectRole', |
|
32 |
key_columns => { project_role_id => 'id' }, |
|
33 |
}, |
|
36 | 34 |
); |
37 | 35 |
|
38 | 36 |
1; |
SL/DB/MetaSetup/ProjectRole.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'project_roles', |
|
9 |
__PACKAGE__->meta->table('project_roles'); |
|
11 | 10 |
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
name => { type => 'text', not_null => 1 }, |
|
15 |
description => { type => 'text', not_null => 1 }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
itime => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' }, |
|
18 |
mtime => { type => 'timestamp' }, |
|
19 |
], |
|
20 |
|
|
21 |
primary_key_columns => [ 'id' ], |
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text', not_null => 1 }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
name => { type => 'text', not_null => 1 }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
22 | 18 |
); |
23 | 19 |
|
20 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
|
21 |
|
|
24 | 22 |
1; |
25 | 23 |
; |
SL/DB/MetaSetup/ProjectStatus.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'project_status', |
|
9 |
__PACKAGE__->meta->table('project_status'); |
|
11 | 10 |
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
name => { type => 'text', not_null => 1 }, |
|
15 |
description => { type => 'text', not_null => 1 }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
itime => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' }, |
|
18 |
mtime => { type => 'timestamp' }, |
|
19 |
], |
|
20 |
|
|
21 |
primary_key_columns => [ 'id' ], |
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text', not_null => 1 }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
name => { type => 'text', not_null => 1 }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
22 | 18 |
); |
23 | 19 |
|
20 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
|
21 |
|
|
24 | 22 |
1; |
25 | 23 |
; |
SL/DB/MetaSetup/RequirementSpec.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_specs', |
|
9 |
__PACKAGE__->meta->table('requirement_specs'); |
|
11 | 10 |
|
12 |
columns => [
|
|
13 |
id => { type => 'serial', not_null => 1 },
|
|
14 |
type_id => { type => 'integer' },
|
|
15 |
status_id => { type => 'integer' },
|
|
16 |
version_id => { type => 'integer' },
|
|
17 |
customer_id => { type => 'integer' },
|
|
18 |
project_id => { type => 'integer' },
|
|
19 |
title => { type => 'text', not_null => 1 },
|
|
20 |
hourly_rate => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 8 },
|
|
21 |
net_sum => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
|
|
22 |
working_copy_id => { type => 'integer' },
|
|
23 |
previous_section_number => { type => 'integer', not_null => 1 },
|
|
24 |
previous_fb_number => { type => 'integer', not_null => 1 },
|
|
25 |
is_template => { type => 'boolean', default => 'false' },
|
|
26 |
itime => { type => 'timestamp', default => 'now()' },
|
|
27 |
mtime => { type => 'timestamp' },
|
|
28 |
],
|
|
11 |
__PACKAGE__->meta->columns(
|
|
12 |
customer_id => { type => 'integer' },
|
|
13 |
hourly_rate => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 8 },
|
|
14 |
id => { type => 'serial', not_null => 1 },
|
|
15 |
is_template => { type => 'boolean', default => 'false' },
|
|
16 |
itime => { type => 'timestamp', default => 'now()' },
|
|
17 |
mtime => { type => 'timestamp' },
|
|
18 |
net_sum => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
|
|
19 |
previous_fb_number => { type => 'integer', not_null => 1 },
|
|
20 |
previous_section_number => { type => 'integer', not_null => 1 },
|
|
21 |
project_id => { type => 'integer' },
|
|
22 |
status_id => { type => 'integer' },
|
|
23 |
title => { type => 'text', not_null => 1 },
|
|
24 |
type_id => { type => 'integer' },
|
|
25 |
version_id => { type => 'integer' },
|
|
26 |
working_copy_id => { type => 'integer' },
|
|
27 |
);
|
|
29 | 28 |
|
30 |
primary_key_columns => [ 'id' ],
|
|
29 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
31 | 30 |
|
32 |
allow_inline_column_values => 1,
|
|
31 |
__PACKAGE__->meta->allow_inline_column_values(1);
|
|
33 | 32 |
|
34 |
foreign_keys => [
|
|
35 |
customer => {
|
|
36 |
class => 'SL::DB::Customer',
|
|
37 |
key_columns => { customer_id => 'id' },
|
|
38 |
},
|
|
33 |
__PACKAGE__->meta->foreign_keys(
|
|
34 |
customer => { |
|
35 |
class => 'SL::DB::Customer', |
|
36 |
key_columns => { customer_id => 'id' }, |
|
37 |
}, |
|
39 | 38 |
|
40 |
project => {
|
|
41 |
class => 'SL::DB::Project',
|
|
42 |
key_columns => { project_id => 'id' },
|
|
43 |
},
|
|
39 |
project => { |
|
40 |
class => 'SL::DB::Project', |
|
41 |
key_columns => { project_id => 'id' }, |
|
42 |
}, |
|
44 | 43 |
|
45 |
status => {
|
|
46 |
class => 'SL::DB::RequirementSpecStatus',
|
|
47 |
key_columns => { status_id => 'id' },
|
|
48 |
},
|
|
44 |
status => { |
|
45 |
class => 'SL::DB::RequirementSpecStatus', |
|
46 |
key_columns => { status_id => 'id' }, |
|
47 |
}, |
|
49 | 48 |
|
50 |
type => {
|
|
51 |
class => 'SL::DB::RequirementSpecType',
|
|
52 |
key_columns => { type_id => 'id' },
|
|
53 |
},
|
|
49 |
type => { |
|
50 |
class => 'SL::DB::RequirementSpecType', |
|
51 |
key_columns => { type_id => 'id' }, |
|
52 |
}, |
|
54 | 53 |
|
55 |
version => {
|
|
56 |
class => 'SL::DB::RequirementSpecVersion',
|
|
57 |
key_columns => { version_id => 'id' },
|
|
58 |
},
|
|
54 |
version => { |
|
55 |
class => 'SL::DB::RequirementSpecVersion', |
|
56 |
key_columns => { version_id => 'id' }, |
|
57 |
}, |
|
59 | 58 |
|
60 |
working_copy => { |
|
61 |
class => 'SL::DB::RequirementSpec', |
|
62 |
key_columns => { working_copy_id => 'id' }, |
|
63 |
}, |
|
64 |
], |
|
59 |
working_copy => { |
|
60 |
class => 'SL::DB::RequirementSpec', |
|
61 |
key_columns => { working_copy_id => 'id' }, |
|
62 |
}, |
|
65 | 63 |
); |
66 | 64 |
|
67 | 65 |
1; |
SL/DB/MetaSetup/RequirementSpecAcceptanceStatus.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_acceptance_statuses', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
name => { type => 'text', not_null => 1 }, |
|
15 |
description => { type => 'text' }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
itime => { type => 'timestamp', default => 'now()' }, |
|
18 |
mtime => { type => 'timestamp' }, |
|
19 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_acceptance_statuses'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text' }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => 'now()' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
name => { type => 'text', not_null => 1 }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
18 |
); |
|
20 | 19 |
|
21 |
primary_key_columns => [ 'id' ],
|
|
20 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
22 | 21 |
|
23 |
unique_key => [ 'name', 'description' ],
|
|
22 |
__PACKAGE__->meta->unique_keys([ 'name', 'description' ]);
|
|
24 | 23 |
|
25 |
allow_inline_column_values => 1, |
|
26 |
); |
|
24 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
27 | 25 |
|
28 | 26 |
1; |
29 | 27 |
; |
SL/DB/MetaSetup/RequirementSpecComplexity.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_complexities', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
description => { type => 'text', not_null => 1 }, |
|
15 |
position => { type => 'integer', not_null => 1 }, |
|
16 |
itime => { type => 'timestamp', default => 'now()' }, |
|
17 |
mtime => { type => 'timestamp' }, |
|
18 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_complexities'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text', not_null => 1 }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => 'now()' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
); |
|
19 | 18 |
|
20 |
primary_key_columns => [ 'id' ],
|
|
19 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
21 | 20 |
|
22 |
unique_key => [ 'description' ],
|
|
21 |
__PACKAGE__->meta->unique_keys([ 'description' ]);
|
|
23 | 22 |
|
24 |
allow_inline_column_values => 1, |
|
25 |
); |
|
23 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
26 | 24 |
|
27 | 25 |
1; |
28 | 26 |
; |
SL/DB/MetaSetup/RequirementSpecDependency.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_item_dependencies', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
depending_item_id => { type => 'integer', not_null => 1 }, |
|
14 |
depended_item_id => { type => 'integer', not_null => 1 }, |
|
15 |
], |
|
16 |
|
|
17 |
primary_key_columns => [ 'depending_item_id', 'depended_item_id' ], |
|
18 |
|
|
19 |
foreign_keys => [ |
|
20 |
depended_item => { |
|
21 |
class => 'SL::DB::RequirementSpecItem', |
|
22 |
key_columns => { depended_item_id => 'id' }, |
|
23 |
}, |
|
24 |
|
|
25 |
depending_item => { |
|
26 |
class => 'SL::DB::RequirementSpecItem', |
|
27 |
key_columns => { depending_item_id => 'id' }, |
|
28 |
}, |
|
29 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_item_dependencies'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
depended_item_id => { type => 'integer', not_null => 1 }, |
|
13 |
depending_item_id => { type => 'integer', not_null => 1 }, |
|
14 |
); |
|
15 |
|
|
16 |
__PACKAGE__->meta->primary_key_columns([ 'depending_item_id', 'depended_item_id' ]); |
|
17 |
|
|
18 |
__PACKAGE__->meta->foreign_keys( |
|
19 |
depended_item => { |
|
20 |
class => 'SL::DB::RequirementSpecItem', |
|
21 |
key_columns => { depended_item_id => 'id' }, |
|
22 |
}, |
|
23 |
|
|
24 |
depending_item => { |
|
25 |
class => 'SL::DB::RequirementSpecItem', |
|
26 |
key_columns => { depending_item_id => 'id' }, |
|
27 |
}, |
|
30 | 28 |
); |
31 | 29 |
|
32 | 30 |
1; |
SL/DB/MetaSetup/RequirementSpecItem.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_items', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
requirement_spec_id => { type => 'integer', not_null => 1 }, |
|
15 |
item_type => { type => 'text', not_null => 1 }, |
|
16 |
parent_id => { type => 'integer' }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
18 |
fb_number => { type => 'text', not_null => 1 }, |
|
19 |
title => { type => 'text' }, |
|
20 |
description => { type => 'text' }, |
|
21 |
complexity_id => { type => 'integer' }, |
|
22 |
risk_id => { type => 'integer' }, |
|
23 |
time_estimation => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 }, |
|
24 |
net_sum => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 }, |
|
25 |
is_flagged => { type => 'boolean', default => 'false', not_null => 1 }, |
|
26 |
acceptance_status_id => { type => 'integer' }, |
|
27 |
acceptance_text => { type => 'text' }, |
|
28 |
itime => { type => 'timestamp', default => 'now()', not_null => 1 }, |
|
29 |
mtime => { type => 'timestamp' }, |
|
30 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_items'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
acceptance_status_id => { type => 'integer' }, |
|
13 |
acceptance_text => { type => 'text' }, |
|
14 |
complexity_id => { type => 'integer' }, |
|
15 |
description => { type => 'text' }, |
|
16 |
fb_number => { type => 'text', not_null => 1 }, |
|
17 |
id => { type => 'serial', not_null => 1 }, |
|
18 |
is_flagged => { type => 'boolean', default => 'false', not_null => 1 }, |
|
19 |
item_type => { type => 'text', not_null => 1 }, |
|
20 |
itime => { type => 'timestamp', default => 'now()', not_null => 1 }, |
|
21 |
mtime => { type => 'timestamp' }, |
|
22 |
net_sum => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 }, |
|
23 |
parent_id => { type => 'integer' }, |
|
24 |
position => { type => 'integer', not_null => 1 }, |
|
25 |
requirement_spec_id => { type => 'integer', not_null => 1 }, |
|
26 |
risk_id => { type => 'integer' }, |
|
27 |
time_estimation => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 }, |
|
28 |
title => { type => 'text' }, |
|
29 |
); |
|
31 | 30 |
|
32 |
primary_key_columns => [ 'id' ],
|
|
31 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
33 | 32 |
|
34 |
allow_inline_column_values => 1,
|
|
33 |
__PACKAGE__->meta->allow_inline_column_values(1);
|
|
35 | 34 |
|
36 |
foreign_keys => [
|
|
37 |
acceptance_status => {
|
|
38 |
class => 'SL::DB::RequirementSpecAcceptanceStatus',
|
|
39 |
key_columns => { acceptance_status_id => 'id' },
|
|
40 |
},
|
|
35 |
__PACKAGE__->meta->foreign_keys(
|
|
36 |
acceptance_status => { |
|
37 |
class => 'SL::DB::RequirementSpecAcceptanceStatus', |
|
38 |
key_columns => { acceptance_status_id => 'id' }, |
|
39 |
}, |
|
41 | 40 |
|
42 |
complexity => {
|
|
43 |
class => 'SL::DB::RequirementSpecComplexity',
|
|
44 |
key_columns => { complexity_id => 'id' },
|
|
45 |
},
|
|
41 |
complexity => { |
|
42 |
class => 'SL::DB::RequirementSpecComplexity', |
|
43 |
key_columns => { complexity_id => 'id' }, |
|
44 |
}, |
|
46 | 45 |
|
47 |
parent => {
|
|
48 |
class => 'SL::DB::RequirementSpecItem',
|
|
49 |
key_columns => { parent_id => 'id' },
|
|
50 |
},
|
|
46 |
parent => { |
|
47 |
class => 'SL::DB::RequirementSpecItem', |
|
48 |
key_columns => { parent_id => 'id' }, |
|
49 |
}, |
|
51 | 50 |
|
52 |
requirement_spec => {
|
|
53 |
class => 'SL::DB::RequirementSpec',
|
|
54 |
key_columns => { requirement_spec_id => 'id' },
|
|
55 |
},
|
|
51 |
requirement_spec => { |
|
52 |
class => 'SL::DB::RequirementSpec', |
|
53 |
key_columns => { requirement_spec_id => 'id' }, |
|
54 |
}, |
|
56 | 55 |
|
57 |
risk => { |
|
58 |
class => 'SL::DB::RequirementSpecRisk', |
|
59 |
key_columns => { risk_id => 'id' }, |
|
60 |
}, |
|
61 |
], |
|
56 |
risk => { |
|
57 |
class => 'SL::DB::RequirementSpecRisk', |
|
58 |
key_columns => { risk_id => 'id' }, |
|
59 |
}, |
|
62 | 60 |
); |
63 | 61 |
|
64 | 62 |
1; |
SL/DB/MetaSetup/RequirementSpecPredefinedText.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_predefined_texts', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
description => { type => 'text', not_null => 1 }, |
|
15 |
title => { type => 'text', not_null => 1 }, |
|
16 |
text => { type => 'text', not_null => 1 }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
18 |
itime => { type => 'timestamp', default => 'now()' }, |
|
19 |
mtime => { type => 'timestamp' }, |
|
20 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_predefined_texts'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text', not_null => 1 }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => 'now()' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
text => { type => 'text', not_null => 1 }, |
|
18 |
title => { type => 'text', not_null => 1 }, |
|
19 |
); |
|
21 | 20 |
|
22 |
primary_key_columns => [ 'id' ],
|
|
21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
23 | 22 |
|
24 |
unique_key => [ 'description' ],
|
|
23 |
__PACKAGE__->meta->unique_keys([ 'description' ]);
|
|
25 | 24 |
|
26 |
allow_inline_column_values => 1, |
|
27 |
); |
|
25 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
28 | 26 |
|
29 | 27 |
1; |
30 | 28 |
; |
SL/DB/MetaSetup/RequirementSpecRisk.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_risks', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
description => { type => 'text', not_null => 1 }, |
|
15 |
position => { type => 'integer', not_null => 1 }, |
|
16 |
itime => { type => 'timestamp', default => 'now()' }, |
|
17 |
mtime => { type => 'timestamp' }, |
|
18 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_risks'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text', not_null => 1 }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => 'now()' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
); |
|
19 | 18 |
|
20 |
primary_key_columns => [ 'id' ],
|
|
19 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
21 | 20 |
|
22 |
unique_key => [ 'description' ],
|
|
21 |
__PACKAGE__->meta->unique_keys([ 'description' ]);
|
|
23 | 22 |
|
24 |
allow_inline_column_values => 1, |
|
25 |
); |
|
23 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
26 | 24 |
|
27 | 25 |
1; |
28 | 26 |
; |
SL/DB/MetaSetup/RequirementSpecStatus.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_statuses', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
name => { type => 'text', not_null => 1 }, |
|
15 |
description => { type => 'text', not_null => 1 }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
itime => { type => 'timestamp', default => 'now()' }, |
|
18 |
mtime => { type => 'timestamp' }, |
|
19 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_statuses'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text', not_null => 1 }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => 'now()' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
name => { type => 'text', not_null => 1 }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
18 |
); |
|
20 | 19 |
|
21 |
primary_key_columns => [ 'id' ],
|
|
20 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
22 | 21 |
|
23 |
unique_key => [ 'name', 'description' ],
|
|
22 |
__PACKAGE__->meta->unique_keys([ 'name', 'description' ]);
|
|
24 | 23 |
|
25 |
allow_inline_column_values => 1, |
|
26 |
); |
|
24 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
27 | 25 |
|
28 | 26 |
1; |
29 | 27 |
; |
SL/DB/MetaSetup/RequirementSpecTextBlock.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_text_blocks', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
requirement_spec_id => { type => 'integer', not_null => 1 }, |
|
15 |
title => { type => 'text', not_null => 1 }, |
|
16 |
text => { type => 'text' }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
18 |
output_position => { type => 'integer', default => 1, not_null => 1 }, |
|
19 |
itime => { type => 'timestamp', default => 'now()', not_null => 1 }, |
|
20 |
mtime => { type => 'timestamp' }, |
|
21 |
is_flagged => { type => 'boolean', default => 'false', not_null => 1 }, |
|
22 |
], |
|
23 |
|
|
24 |
primary_key_columns => [ 'id' ], |
|
25 |
|
|
26 |
allow_inline_column_values => 1, |
|
27 |
|
|
28 |
foreign_keys => [ |
|
29 |
requirement_spec => { |
|
30 |
class => 'SL::DB::RequirementSpec', |
|
31 |
key_columns => { requirement_spec_id => 'id' }, |
|
32 |
}, |
|
33 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_text_blocks'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
id => { type => 'serial', not_null => 1 }, |
|
13 |
is_flagged => { type => 'boolean', default => 'false', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => 'now()', not_null => 1 }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
output_position => { type => 'integer', default => 1, not_null => 1 }, |
|
17 |
position => { type => 'integer', not_null => 1 }, |
|
18 |
requirement_spec_id => { type => 'integer', not_null => 1 }, |
|
19 |
text => { type => 'text' }, |
|
20 |
title => { type => 'text', not_null => 1 }, |
|
21 |
); |
|
22 |
|
|
23 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
|
24 |
|
|
25 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
26 |
|
|
27 |
__PACKAGE__->meta->foreign_keys( |
|
28 |
requirement_spec => { |
|
29 |
class => 'SL::DB::RequirementSpec', |
|
30 |
key_columns => { requirement_spec_id => 'id' }, |
|
31 |
}, |
|
34 | 32 |
); |
35 | 33 |
|
36 | 34 |
1; |
SL/DB/MetaSetup/RequirementSpecType.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_types', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
description => { type => 'text', not_null => 1 }, |
|
15 |
position => { type => 'integer', not_null => 1 }, |
|
16 |
itime => { type => 'timestamp', default => 'now()' }, |
|
17 |
mtime => { type => 'timestamp' }, |
|
18 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_types'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
description => { type => 'text', not_null => 1 }, |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
itime => { type => 'timestamp', default => 'now()' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
position => { type => 'integer', not_null => 1 }, |
|
17 |
); |
|
19 | 18 |
|
20 |
primary_key_columns => [ 'id' ],
|
|
19 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
|
21 | 20 |
|
22 |
unique_key => [ 'description' ],
|
|
21 |
__PACKAGE__->meta->unique_keys([ 'description' ]);
|
|
23 | 22 |
|
24 |
allow_inline_column_values => 1, |
|
25 |
); |
|
23 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
26 | 24 |
|
27 | 25 |
1; |
28 | 26 |
; |
SL/DB/MetaSetup/RequirementSpecVersion.pm | ||
---|---|---|
6 | 6 |
|
7 | 7 |
use base qw(SL::DB::Object); |
8 | 8 |
|
9 |
__PACKAGE__->meta->setup( |
|
10 |
table => 'requirement_spec_versions', |
|
11 |
|
|
12 |
columns => [ |
|
13 |
id => { type => 'serial', not_null => 1 }, |
|
14 |
version_number => { type => 'integer' }, |
|
15 |
description => { type => 'text', not_null => 1 }, |
|
16 |
comment => { type => 'text' }, |
|
17 |
order_date => { type => 'date' }, |
|
18 |
order_number => { type => 'text' }, |
|
19 |
order_id => { type => 'integer' }, |
|
20 |
itime => { type => 'timestamp', default => 'now()' }, |
|
21 |
mtime => { type => 'timestamp' }, |
|
22 |
], |
|
23 |
|
|
24 |
primary_key_columns => [ 'id' ], |
|
25 |
|
|
26 |
allow_inline_column_values => 1, |
|
27 |
|
|
28 |
foreign_keys => [ |
|
29 |
order => { |
|
30 |
class => 'SL::DB::Order', |
|
31 |
key_columns => { order_id => 'id' }, |
|
32 |
}, |
|
33 |
], |
|
9 |
__PACKAGE__->meta->table('requirement_spec_versions'); |
|
10 |
|
|
11 |
__PACKAGE__->meta->columns( |
|
12 |
comment => { type => 'text' }, |
|
13 |
description => { type => 'text', not_null => 1 }, |
|
14 |
id => { type => 'serial', not_null => 1 }, |
|
15 |
itime => { type => 'timestamp', default => 'now()' }, |
|
16 |
mtime => { type => 'timestamp' }, |
|
17 |
order_date => { type => 'date' }, |
|
18 |
order_id => { type => 'integer' }, |
|
19 |
order_number => { type => 'text' }, |
|
20 |
version_number => { type => 'integer' }, |
|
21 |
); |
|
22 |
|
|
23 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
|
24 |
|
|
25 |
__PACKAGE__->meta->allow_inline_column_values(1); |
|
26 |
|
|
27 |
__PACKAGE__->meta->foreign_keys( |
|
28 |
order => { |
|
29 |
class => 'SL::DB::Order', |
|
30 |
key_columns => { order_id => 'id' }, |
|
31 |
}, |
|
34 | 32 |
); |
35 | 33 |
|
36 | 34 |
1; |
SL/DB/ProjectParticipant.pm | ||
---|---|---|
7 | 7 |
|
8 | 8 |
use SL::DB::MetaSetup::ProjectParticipant; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. |
11 | 13 |
__PACKAGE__->meta->make_manager_class; |
12 | 14 |
|
SL/DB/ProjectPhase.pm | ||
---|---|---|
1 |
# This file has been auto-generated only because it didn't exist. |
|
2 |
# Feel free to modify it at will; it will not be overwritten automatically. |
|
3 |
|
|
4 |
package SL::DB::ProjectPhase; |
|
5 |
|
|
6 |
use strict; |
|
7 |
|
|
8 |
use SL::DB::MetaSetup::ProjectPhase; |
|
9 |
|
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
12 |
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. |
|
13 |
__PACKAGE__->meta->make_manager_class; |
|
14 |
|
|
15 |
1; |
SL/DB/ProjectPhaseParticipant.pm | ||
---|---|---|
7 | 7 |
|
8 | 8 |
use SL::DB::MetaSetup::ProjectPhaseParticipant; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. |
11 | 13 |
__PACKAGE__->meta->make_manager_class; |
12 | 14 |
|
SL/DB/ProjectRole.pm | ||
---|---|---|
7 | 7 |
|
8 | 8 |
use SL::DB::MetaSetup::ProjectRole; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. |
11 | 13 |
__PACKAGE__->meta->make_manager_class; |
12 | 14 |
|
SL/DB/RequirementSpecAcceptanceStatus.pm | ||
---|---|---|
9 | 9 |
use SL::DB::Helper::ActsAsList; |
10 | 10 |
use SL::Locale::String; |
11 | 11 |
|
12 |
__PACKAGE__->meta->initialize; |
|
13 |
|
|
12 | 14 |
our @valid_names = qw(accepted accepted_with_defects accepted_with_defects_to_be_fixed not_accepted); |
13 | 15 |
|
14 | 16 |
sub validate { |
SL/DB/RequirementSpecComplexity.pm | ||
---|---|---|
7 | 7 |
use SL::DB::Helper::ActsAsList; |
8 | 8 |
use SL::Locale::String; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
sub validate { |
11 | 13 |
my ($self) = @_; |
12 | 14 |
|
SL/DB/RequirementSpecDependency.pm | ||
---|---|---|
7 | 7 |
|
8 | 8 |
use SL::DB::MetaSetup::RequirementSpecDependency; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. |
11 | 13 |
__PACKAGE__->meta->make_manager_class; |
12 | 14 |
|
SL/DB/RequirementSpecPredefinedText.pm | ||
---|---|---|
7 | 7 |
use SL::DB::Helper::ActsAsList; |
8 | 8 |
use SL::Locale::String; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
sub validate { |
11 | 13 |
my ($self) = @_; |
12 | 14 |
|
SL/DB/RequirementSpecRisk.pm | ||
---|---|---|
7 | 7 |
use SL::DB::Helper::ActsAsList; |
8 | 8 |
use SL::Locale::String; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
sub validate { |
11 | 13 |
my ($self) = @_; |
12 | 14 |
|
SL/DB/RequirementSpecStatus.pm | ||
---|---|---|
9 | 9 |
use SL::DB::Helper::ActsAsList; |
10 | 10 |
use SL::Locale::String; |
11 | 11 |
|
12 |
__PACKAGE__->meta->initialize; |
|
13 |
|
|
12 | 14 |
our @valid_names = qw(planning running done); |
13 | 15 |
|
14 | 16 |
sub validate { |
SL/DB/RequirementSpecType.pm | ||
---|---|---|
7 | 7 |
use SL::DB::Helper::ActsAsList; |
8 | 8 |
use SL::Locale::String; |
9 | 9 |
|
10 |
__PACKAGE__->meta->initialize; |
|
11 |
|
|
10 | 12 |
sub validate { |
11 | 13 |
my ($self) = @_; |
12 | 14 |
|
SL/DB/RequirementSpecVersion.pm | ||
---|---|---|
5 | 5 |
use SL::DB::MetaSetup::RequirementSpecVersion; |
6 | 6 |
use SL::Locale::String; |
7 | 7 |
|
8 |
__PACKAGE__->meta->initialize; |
|
9 |
|
|
8 | 10 |
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. |
9 | 11 |
__PACKAGE__->meta->make_manager_class; |
10 | 12 |
|
Auch abrufbar als: Unified diff
Rose-Setup Pflichtenhefte/Projekte an Umstellung setup()/initialize() angepasst