Drop files here

SQL upload ( 0 ) x -

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
Restore default values
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 my house Branch
* branchNo : char(4)
* street : varchar(16)
* city : varchar(10)
* postcode : char(8)
v my house Client
* clientNo : char(4)
* fName : varchar(10)
* lName : varchar(10)
* telNo : varchar(14)
* prefType : varchar(6)
* maxRent : int(11)
v my house PrivateOwner
* ownerNo : char(4)
* fName : varchar(10)
* lName : varchar(10)
* address : varchar(32)
* telNo : varchar(14)
v my house PropertyForRent
* propertyNo : char(4)
* street : varchar(16)
* city : varchar(10)
* postcode : char(8)
* type : varchar(6)
* rooms : int(11)
* rent : int(11)
* ownerNo : char(4)
* staffNo : char(4)
* branchNo : char(4)
v my house Registration
* clientNo : char(4)
* branchNo : char(4)
* staffNo : char(4)
* dateJoined : date
v my house Staff
* staffNo : char(4)
* fName : varchar(10)
* lName : varchar(10)
* position : varchar(10)
* sex : char(1)
* DOB : date
* salary : decimal(8,2)
* branchNo : char(4)
v my house Viewing
* clientNo : char(4)
* propertyNo : char(4)
* viewDate : date
* comments : varchar(20)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship