Revision 3c22e5f4
Von Bernd Bleßmann vor mehr als 3 Jahren hinzugefügt
| SL/DB/MetaSetup/TimeRecording.pm | ||
|---|---|---|
| 19 | 19 |
id => { type => 'serial', not_null => 1 },
|
| 20 | 20 |
itime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| 21 | 21 |
mtime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| 22 |
order_id => { type => 'integer' },
|
|
| 22 | 23 |
part_id => { type => 'integer' },
|
| 23 | 24 |
payroll => { type => 'boolean', default => 'false' },
|
| 24 | 25 |
project_id => { type => 'integer' },
|
| ... | ... | |
| 41 | 42 |
key_columns => { employee_id => 'id' },
|
| 42 | 43 |
}, |
| 43 | 44 |
|
| 45 |
order => {
|
|
| 46 |
class => 'SL::DB::Order', |
|
| 47 |
key_columns => { order_id => 'id' },
|
|
| 48 |
}, |
|
| 49 |
|
|
| 44 | 50 |
part => {
|
| 45 | 51 |
class => 'SL::DB::Part', |
| 46 | 52 |
key_columns => { part_id => 'id' },
|
| sql/Pg-upgrade2/time_recordings_add_order.sql | ||
|---|---|---|
| 1 |
-- @tag: time_recordings_add_order |
|
| 2 |
-- @description: Erweiterung Zeiterfassung um Fremdschlüssel zu Auftrag |
|
| 3 |
-- @depends: time_recordings_date_duration |
|
| 4 |
|
|
| 5 |
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