Aktuální výběr neobsahuje unikátní klíč. Editování v mřížce, zaškrtávací políčka nebo odkazy na editaci a mazání proto nejsou k dispozici.
Zobrazeny záznamy 0 - 14 (15 celkem, Dotaz trval 0,0614 sekund.) [DELETE_RULE: SET NULL... - CASCADE...]
SELECT * FROM `REFERENTIAL_CONSTRAINTS` ORDER BY `DELETE_RULE` DESC
| Filtrovat řádky: |
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | UNIQUE_CONSTRAINT_CATALOG | UNIQUE_CONSTRAINT_SCHEMA | UNIQUE_CONSTRAINT_NAME | MATCH_OPTION | UPDATE_RULE |
DELETE_RULE 1
|
TABLE_NAME | REFERENCED_TABLE_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| def | idochazka | fk_att_creator | def | idochazka | PRIMARY | NONE | RESTRICT | SET NULL | attendance | users | |
| def | idochazka | fk_emp_dept | def | idochazka | PRIMARY | NONE | RESTRICT | SET NULL | employees | departments | |
| def | idochazka | fk_emp_cal | def | idochazka | PRIMARY | NONE | RESTRICT | SET NULL | employees | work_calendars | |
| def | idochazka | fk_leave_approver | def | idochazka | PRIMARY | NONE | RESTRICT | SET NULL | leaves | users | |
| def | idochazka | fk_closure_user | def | idochazka | PRIMARY | NONE | RESTRICT | SET NULL | closures | users | |
| def | idochazka | fk_audit_user | def | idochazka | PRIMARY | NONE | RESTRICT | SET NULL | audit_log | users | |
| def | idochazka | fk_emp_user | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | employees | users | |
| def | idochazka | fk_me_emp | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | medical_exams | employees | |
| def | idochazka | fk_leave_emp | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | leaves | employees | |
| def | idochazka | fk_sched_emp | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | work_schedules | employees | |
| def | idochazka | fk_ecv_field | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | employee_custom_values | custom_field_defs | |
| def | idochazka | fk_oa_item | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | oopp_assignments | oopp_items | |
| def | idochazka | fk_ecv_emp | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | employee_custom_values | employees | |
| def | idochazka | fk_oa_emp | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | oopp_assignments | employees | |
| def | idochazka | fk_att_emp | def | idochazka | PRIMARY | NONE | RESTRICT | CASCADE | attendance | employees |
| Filtrovat řádky: |