Revision 1168e9c9
Von Kivitendo Admin vor etwa 11 Jahren hinzugefügt
SL/DB/MetaSetup/GLTransaction.pm | ||
---|---|---|
37 | 37 |
key_columns => { department_id => 'id' }, |
38 | 38 |
}, |
39 | 39 |
|
40 |
employee => { |
|
41 |
class => 'SL::DB::Employee', |
|
42 |
key_columns => { employee_id => 'id' }, |
|
43 |
}, |
|
44 |
|
|
40 | 45 |
storno_obj => { |
41 | 46 |
class => 'SL::DB::GLTransaction', |
42 | 47 |
key_columns => { storno_id => 'id' }, |
sql/Pg-upgrade2/gl_add_employee_foreign_key.sql | ||
---|---|---|
1 |
-- @tag: gl_add_employee_foreign_key |
|
2 |
-- @description: Dialogbuchungen mit Bearbeiter verknüpfen |
|
3 |
-- @depends: release_3_0_0 |
|
4 |
-- @ignore: 0 |
|
5 |
ALTER TABLE gl ADD FOREIGN KEY (employee_id) REFERENCES employee(id); |
Auch abrufbar als: Unified diff
Fremdschlüssel für Bearbeiter in gl einführen