Bảng điều khiển
Chọn lựa hiện nay không chứa một cột duy nhất. Tính năng sửa lưới, dấu kiểm, Sửa, Chép và Xóa không sẵn có.
Hiển thị các hàng 0 - ... View này có ít nhất số lượng dòng này. Vui lòng tham khảo tài liệu. (Truy vấn cần 0.0619 giây.) [REFERENCED_TABLE_NAME: ACCOUNTS... - SHOPS...]
SELECT * FROM `REFERENTIAL_CONSTRAINTS` ORDER BY `REFERENCED_TABLE_NAME` ASC
| Số hàng: |
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | UNIQUE_CONSTRAINT_CATALOG | UNIQUE_CONSTRAINT_SCHEMA | UNIQUE_CONSTRAINT_NAME | MATCH_OPTION | UPDATE_RULE | DELETE_RULE | TABLE_NAME |
REFERENCED_TABLE_NAME 1
|
|
|---|---|---|---|---|---|---|---|---|---|---|---|
| def | quanlythuchi | fk_transaction_destination | def | quanlythuchi | PRIMARY | NONE | RESTRICT | RESTRICT | transactions | accounts | |
| def | quanlythuchi | fk_transaction_account | def | quanlythuchi | PRIMARY | NONE | RESTRICT | RESTRICT | transactions | accounts | |
| def | project_pmbh | products_ibfk_2 | def | project_pmbh | PRIMARY | NONE | RESTRICT | SET NULL | products | categories | |
| def | quanlythuchi | fk_transaction_category | def | quanlythuchi | PRIMARY | NONE | RESTRICT | SET NULL | transactions | categories | |
| def | procurement_db | materials_ibfk_1 | def | procurement_db | PRIMARY | NONE | RESTRICT | SET NULL | materials | categories | |
| def | quanlythuchi | fk_category_parent | def | quanlythuchi | PRIMARY | NONE | RESTRICT | SET NULL | categories | categories | |
| def | procurement_db | fk_chat_messages_session | def | procurement_db | PRIMARY | NONE | RESTRICT | CASCADE | chat_messages | chat_sessions | |
| def | procurement_db | users_ibfk_1 | def | procurement_db | PRIMARY | NONE | RESTRICT | SET NULL | users | departments | |
| def | procurement_db | purchase_requests_ibfk_1 | def | procurement_db | PRIMARY | NONE | RESTRICT | RESTRICT | purchase_requests | departments | |
| def | procurement_db | purchase_request_lines_ibfk_2 | def | procurement_db | PRIMARY | NONE | RESTRICT | RESTRICT | purchase_request_lines | materials | |
| def | procurement_db | vendor_materials_ibfk_2 | def | procurement_db | PRIMARY | NONE | RESTRICT | CASCADE | vendor_materials | materials | |
| def | like4like_ecom | transactions_ibfk_1 | def | like4like_ecom | PRIMARY | NONE | RESTRICT | RESTRICT | transactions | orders | |
| def | project_pmbh | order_items_ibfk_1 | def | project_pmbh | PRIMARY | NONE | RESTRICT | CASCADE | order_items | orders | |
| def | procurement_db | user_custom_permissions_ibfk_2 | def | procurement_db | PRIMARY | NONE | RESTRICT | CASCADE | user_custom_permissions | permissions | |
| def | procurement_db | role_permissions_ibfk_2 | def | procurement_db | PRIMARY | NONE | RESTRICT | CASCADE | role_permissions | permissions | |
| def | quanlythuchi | fk_up_permission | def | quanlythuchi | PRIMARY | NONE | RESTRICT | CASCADE | user_permissions | permissions | |
| def | auto_aff | fk_video_jobs_product | def | auto_aff | PRIMARY | NONE | RESTRICT | CASCADE | video_jobs | products | |
| def | auto_aff | fk_product_images_product | def | auto_aff | PRIMARY | NONE | RESTRICT | CASCADE | product_images | products | |
| def | auto_aff | fk_generated_videos_product | def | auto_aff | PRIMARY | NONE | RESTRICT | CASCADE | generated_videos | products | |
| def | like4like_ecom | orders_ibfk_1 | def | like4like_ecom | PRIMARY | NONE | RESTRICT | RESTRICT | orders | products | |
| def | auto_aff | fk_generated_contents_product | def | auto_aff | PRIMARY | NONE | RESTRICT | CASCADE | generated_contents | products | |
| def | procurement_db | purchase_request_lines_ibfk_1 | def | procurement_db | PRIMARY | NONE | RESTRICT | CASCADE | purchase_request_lines | purchase_requests | |
| def | procurement_db | role_permissions_ibfk_1 | def | procurement_db | PRIMARY | NONE | RESTRICT | CASCADE | role_permissions | roles | |
| def | procurement_db | user_roles_ibfk_2 | def | procurement_db | PRIMARY | NONE | RESTRICT | CASCADE | user_roles | roles | |
| def | project_pmbh | expenses_ibfk_1 | def | project_pmbh | PRIMARY | NONE | RESTRICT | CASCADE | expenses | shops |
| Số hàng: |