Revision 7e0130b0
Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt
| SL/DB/MetaSetup/Customer.pm | ||
|---|---|---|
| 33 | 33 |
fax => { type => 'varchar', length => 30 },
|
| 34 | 34 |
greeting => { type => 'text' },
|
| 35 | 35 |
homepage => { type => 'text' },
|
| 36 |
hourly_rate => { type => 'numeric', precision => 2, scale => 8 },
|
|
| 36 |
hourly_rate => { type => 'numeric', precision => 8, scale => 2 },
|
|
| 37 | 37 |
iban => { type => 'varchar', length => 100 },
|
| 38 | 38 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 39 | 39 |
itime => { type => 'timestamp', default => 'now()' },
|
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
| 28 | 28 |
coa => { type => 'text' },
|
| 29 | 29 |
company => { type => 'text' },
|
| 30 | 30 |
currency_id => { type => 'integer', not_null => 1 },
|
| 31 |
customer_hourly_rate => { type => 'numeric', precision => 2, scale => 8 },
|
|
| 31 |
customer_hourly_rate => { type => 'numeric', precision => 8, scale => 2 },
|
|
| 32 | 32 |
customernumber => { type => 'text' },
|
| 33 | 33 |
datev_check_on_ap_transaction => { type => 'boolean', default => 'true' },
|
| 34 | 34 |
datev_check_on_ar_transaction => { type => 'boolean', default => 'true' },
|
| SL/DB/MetaSetup/Project.pm | ||
|---|---|---|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 | 12 |
active => { type => 'boolean', default => 'true' },
|
| 13 | 13 |
billable_customer_id => { type => 'integer' },
|
| 14 |
budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
|
|
| 14 |
budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
|
|
| 15 | 15 |
budget_minutes => { type => 'integer', default => '0', not_null => 1 },
|
| 16 | 16 |
customer_id => { type => 'integer' },
|
| 17 | 17 |
description => { type => 'text' },
|
| ... | ... | |
| 19 | 19 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 20 | 20 |
itime => { type => 'timestamp', default => 'now()' },
|
| 21 | 21 |
mtime => { type => 'timestamp' },
|
| 22 |
order_value => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
|
|
| 22 |
order_value => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
|
|
| 23 | 23 |
project_status_id => { type => 'integer', not_null => 1 },
|
| 24 | 24 |
project_type_id => { type => 'integer', not_null => 1 },
|
| 25 | 25 |
projectnumber => { type => 'text' },
|
| SL/DB/MetaSetup/ProjectParticipant.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('project_participants');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
cost_per_hour => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 12 |
cost_per_hour => { type => 'numeric', precision => 15, scale => 5 },
|
|
| 13 | 13 |
employee_id => { type => 'integer', not_null => 1 },
|
| 14 | 14 |
id => { type => 'serial', not_null => 1 },
|
| 15 | 15 |
itime => { type => 'timestamp', default => 'now()' },
|
| SL/DB/MetaSetup/ProjectPhase.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('project_phases');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
|
|
| 12 |
budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
|
|
| 13 | 13 |
budget_minutes => { type => 'integer', default => '0', not_null => 1 },
|
| 14 | 14 |
description => { type => 'text', not_null => 1 },
|
| 15 | 15 |
end_date => { type => 'date' },
|
| 16 |
general_cost_per_hour => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
|
|
| 16 |
general_cost_per_hour => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
|
|
| 17 | 17 |
general_minutes => { type => 'integer', default => '0', not_null => 1 },
|
| 18 | 18 |
id => { type => 'serial', not_null => 1 },
|
| 19 | 19 |
itime => { type => 'timestamp', default => 'now()' },
|
| SL/DB/MetaSetup/ProjectPhaseParticipant.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('project_phase_participants');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
cost_per_hour => { type => 'numeric', precision => 5, scale => 15 },
|
|
| 12 |
cost_per_hour => { type => 'numeric', precision => 15, scale => 5 },
|
|
| 13 | 13 |
employee_id => { type => 'integer', not_null => 1 },
|
| 14 | 14 |
id => { type => 'serial', not_null => 1 },
|
| 15 | 15 |
itime => { type => 'timestamp', default => 'now()' },
|
| SL/DB/MetaSetup/ProjectStatus.pm | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 | 12 |
description => { type => 'text', not_null => 1 },
|
| 13 |
id => { type => 'serial', not_null => 1 },
|
|
| 13 |
id => { type => 'integer', not_null => 1, sequence => 'project_status_id_seq' },
|
|
| 14 | 14 |
itime => { type => 'timestamp', default => 'now()' },
|
| 15 | 15 |
mtime => { type => 'timestamp' },
|
| 16 | 16 |
name => { type => 'text', not_null => 1 },
|
| SL/DB/MetaSetup/RequirementSpec.pm | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 | 12 |
customer_id => { type => 'integer' },
|
| 13 |
hourly_rate => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 8 },
|
|
| 13 |
hourly_rate => { type => 'numeric', default => '0', not_null => 1, precision => 8, scale => 2 },
|
|
| 14 | 14 |
id => { type => 'serial', not_null => 1 },
|
| 15 | 15 |
is_template => { type => 'boolean', default => 'false' },
|
| 16 | 16 |
itime => { type => 'timestamp', default => 'now()' },
|
| ... | ... | |
| 20 | 20 |
previous_section_number => { type => 'integer', not_null => 1 },
|
| 21 | 21 |
project_id => { type => 'integer' },
|
| 22 | 22 |
status_id => { type => 'integer' },
|
| 23 |
time_estimation => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
|
|
| 23 |
time_estimation => { type => 'numeric', default => '0', not_null => 1, precision => 12, scale => 2 },
|
|
| 24 | 24 |
title => { type => 'text', not_null => 1 },
|
| 25 | 25 |
type_id => { type => 'integer' },
|
| 26 | 26 |
working_copy_id => { type => 'integer' },
|
| SL/DB/MetaSetup/RequirementSpecItem.pm | ||
|---|---|---|
| 24 | 24 |
position => { type => 'integer', not_null => 1 },
|
| 25 | 25 |
requirement_spec_id => { type => 'integer', not_null => 1 },
|
| 26 | 26 |
risk_id => { type => 'integer' },
|
| 27 |
time_estimation => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
|
|
| 27 |
time_estimation => { type => 'numeric', default => '0', not_null => 1, precision => 12, scale => 2 },
|
|
| 28 | 28 |
title => { type => 'text' },
|
| 29 | 29 |
); |
| 30 | 30 |
|
Auch abrufbar als: Unified diff
Pflichtenhefte: Meta-Setups nach RDBO-Update neu gebaut