Revision 3c22e5f4
Von Bernd Bleßmann vor fast 4 Jahren hinzugefügt
| SL/DB/MetaSetup/TimeRecording.pm | ||
|---|---|---|
|
id => { type => 'serial', not_null => 1 },
|
||
|
itime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
||
|
mtime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
||
|
order_id => { type => 'integer' },
|
||
|
part_id => { type => 'integer' },
|
||
|
payroll => { type => 'boolean', default => 'false' },
|
||
|
project_id => { type => 'integer' },
|
||
| ... | ... | |
|
key_columns => { employee_id => 'id' },
|
||
|
},
|
||
|
|
||
|
order => {
|
||
|
class => 'SL::DB::Order',
|
||
|
key_columns => { order_id => 'id' },
|
||
|
},
|
||
|
|
||
|
part => {
|
||
|
class => 'SL::DB::Part',
|
||
|
key_columns => { part_id => 'id' },
|
||
| sql/Pg-upgrade2/time_recordings_add_order.sql | ||
|---|---|---|
|
-- @tag: time_recordings_add_order
|
||
|
-- @description: Erweiterung Zeiterfassung um Fremdschlüssel zu Auftrag
|
||
|
-- @depends: time_recordings_date_duration
|
||
|
|
||
|
ALTER TABLE time_recordings ADD COLUMN order_id INTEGER REFERENCES oe (id);
|
||
Auch abrufbar als: Unified diff
Zeiterfassung: Fremdschlüssel für Auftrag: DB-Upgrade und Rose