Console
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 15 (16 total, Query took 0.0998 seconds.) [CONSTRAINT_CATALOG: DEF... - DEF...]
SELECT * FROM `REFERENTIAL_CONSTRAINTS` ORDER BY `CONSTRAINT_CATALOG` ASC
| Filter rows: |
|
CONSTRAINT_CATALOG 1
|
CONSTRAINT_SCHEMA | CONSTRAINT_NAME | UNIQUE_CONSTRAINT_CATALOG | UNIQUE_CONSTRAINT_SCHEMA | UNIQUE_CONSTRAINT_NAME | MATCH_OPTION | UPDATE_RULE | DELETE_RULE | TABLE_NAME | REFERENCED_TABLE_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| def | bill_tracking | users_ibfk_1 | def | bill_tracking | PRIMARY | NONE | RESTRICT | SET NULL | users | employees | |
| def | bill_tracking | fk_bill_checker | def | bill_tracking | PRIMARY | NONE | RESTRICT | RESTRICT | bills | employees | |
| def | bill_tracking | fk_page_invoice | def | bill_tracking | PRIMARY | NONE | RESTRICT | CASCADE | invoice_pages | invoices | |
| def | bill_tracking | fk_users_default_location | def | bill_tracking | PRIMARY | NONE | CASCADE | SET NULL | users | locations | |
| def | employee_management | fk_vacation_employee | def | employee_management | PRIMARY | NONE | RESTRICT | CASCADE | employee_vacations | employees | |
| def | bill_tracking | fk_page_assignment | def | bill_tracking | PRIMARY | NONE | RESTRICT | SET NULL | invoice_pages | picking_assignments | |
| def | bill_tracking | fk_assignment_location | def | bill_tracking | PRIMARY | NONE | RESTRICT | RESTRICT | picking_assignments | locations | |
| def | employee_management | fk_vacation_created_by | def | employee_management | PRIMARY | NONE | RESTRICT | SET NULL | employee_vacations | users | |
| def | bill_tracking | fk_bill_location | def | bill_tracking | PRIMARY | NONE | RESTRICT | RESTRICT | bills | locations | |
| def | bill_tracking | fk_assignment_invoice | def | bill_tracking | PRIMARY | NONE | RESTRICT | CASCADE | picking_assignments | invoices | |
| def | employee_management | fk_checklist_employee | def | employee_management | PRIMARY | NONE | RESTRICT | CASCADE | employee_document_checklist | employees | |
| def | bill_tracking | fk_bill_entered_user | def | bill_tracking | PRIMARY | NONE | RESTRICT | SET NULL | bills | users | |
| def | bill_tracking | fk_assignment_employee | def | bill_tracking | PRIMARY | NONE | RESTRICT | RESTRICT | picking_assignments | employees | |
| def | employee_management | fk_employee_created_by | def | employee_management | PRIMARY | NONE | RESTRICT | SET NULL | employees | users | |
| def | bill_tracking | fk_bill_employee | def | bill_tracking | PRIMARY | NONE | RESTRICT | RESTRICT | bills | employees | |
| def | bill_tracking | fk_assignment_checker | def | bill_tracking | PRIMARY | NONE | RESTRICT | RESTRICT | picking_assignments | employees |
| Filter rows: |