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 laptop_borrowing_system admin
* id : int(11)
* username : varchar(255)
* email : varchar(255)
* password_hash : varchar(255)
* created_at : timestamp
* status : enum('pending','approved')
* role : enum('user','it')
v laptop_borrowing_system borrowed_laptops
* borrow_id : int(11)
* laptop_id : int(11)
* borrower_name : varchar(255)
* borrower_email : varchar(255)
* contact_number : varchar(20)
* borrow_date : datetime
* expected_return_datetime : datetime
* actual_return_datetime : datetime
* return_date : datetime
* status : enum('borrowed','returned')
* is_overdue : tinyint(1)
v laptop_borrowing_system laptops
* laptop_id : int(11)
* serial_number : varchar(255)
* brand : varchar(100)
* model : varchar(100)
* availability : enum('available','borrowed')
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship