Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in full-screen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
Number of tables: 0
v skin_disease_app feedback
* id : int(11)
* feedback : text
* rating : int(11)
* improvement_area : varchar(100)
* submitted_at : timestamp
v skin_disease_app inventory_logs
* id : int(11)
* action : varchar(50)
* user_id : int(11)
* username : varchar(50)
* product_id : int(11)
* details : text
* created_at : timestamp
* remarks : text
v skin_disease_app patients
* id : int(11)
* first_name : varchar(100)
* last_name : varchar(100)
* middle_name : varchar(100)
* age : int(11)
* gender : varchar(20)
* contact : varchar(50)
* email : varchar(150)
* created_at : timestamp
v skin_disease_app predicted
* id : int(11)
* image_name : varchar(255)
* primary_prediction : varchar(100)
* primary_percentage : float
* top_predictions : text
* top_percentages : text
* submitted_at : datetime
* patient_id : int(11)
* service_fee : decimal(10,2)
v skin_disease_app products
* id : int(11)
* name : varchar(100)
* description : text
* price : decimal(10,2)
* stock : int(11)
* created_at : timestamp
* image_path : varchar(255)
* status : varchar(20)
v skin_disease_app product_batches
* id : int(11)
* product_id : int(11)
* batch_number : varchar(50)
* quantity : int(11)
* expiry_date : date
* created_at : timestamp
v skin_disease_app sales
* id : int(11)
* total : decimal(10,2)
* created_at : timestamp
* amount_tendered : decimal(10,2)
* change_amount : decimal(10,2)
* user_id : int(11)
v skin_disease_app sale_items
* id : int(11)
* sale_id : int(11)
* product_id : int(11)
* quantity : int(11)
* price : decimal(10,2)
v skin_disease_app users
* id : int(11)
* username : varchar(50)
* password : varchar(255)
* role : varchar(20)
* created_at : timestamp
* status : varchar(20)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship