SELECT * FROM `KEY_COLUMN_USAGE`
Filter rows: |
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
def | assets | PRIMARY | def | assets | inventory_breakage | id | 1 | NULL | NULL | NULL | NULL | |
def | assets | PRIMARY | def | assets | tbl_admin | id | 1 | NULL | NULL | NULL | NULL | |
def | assetslhr | PRIMARY | def | assetslhr | inventory_breakage | id | 1 | NULL | NULL | NULL | NULL | |
def | assetslhr | PRIMARY | def | assetslhr | tbl_admin | id | 1 | NULL | NULL | NULL | NULL | |
def | bistro | PRIMARY | def | bistro | commentcard | id | 1 | NULL | NULL | NULL | NULL | |
def | bistro | PRIMARY | def | bistro | page_permissions | id | 1 | NULL | NULL | NULL | NULL | |
def | bistro | PRIMARY | def | bistro | ratings | id | 1 | NULL | NULL | NULL | NULL | |
def | bistro | PRIMARY | def | bistro | restaurantinfo | id | 1 | NULL | NULL | NULL | NULL | |
def | bistro | PRIMARY | def | bistro | tbl_admin | id | 1 | NULL | NULL | NULL | NULL | |
def | bistro | PRIMARY | def | bistro | tbl_daily_cash | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | customer_types | type_id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | designation | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | purchaser_details | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_admin | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_attendance | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_brands | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_calculations | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_cashdetails | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_cities | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | title | def | cafe | tbl_cities | title | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_customers | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | title | def | cafe | tbl_customers | title | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_cus_payments | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_daily_cash | id | 1 | NULL | NULL | NULL | NULL | |
def | cafe | PRIMARY | def | cafe | tbl_daily_closing | demand_id | 1 | NULL | NULL | NULL | NULL |
Filter rows: |