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
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
v v
Number of tables: 0
v task DimBook
* BookID : int(11)
* Title : varchar(255)
* Category : varchar(100)
* Price : decimal(10,2)
v task DimCustomer
* CustomerID : int(11)
* Name : varchar(255)
* AgeGroup : varchar(50)
* City : varchar(100)
v task DimDate
* DateID : int(11)
* FullDate : date
* Day : int(11)
* Month : int(11)
* MonthName : varchar(20)
* Quarter : int(11)
* Year : int(11)
* WeekOfYear : int(11)
* DayOfWeek : int(11)
* DayName : varchar(10)
v task DimRating
* RatingID : int(11)
* RatingValue : decimal(3,2)
* RatingDescription : varchar(255)
v task dim_time
* date_id : int(11)
* full_date : date
* year : int(11)
* quarter : int(11)
* quarter_name : varchar(2)
* month : int(11)
* month_name : varchar(20)
* day_of_month : int(11)
* day_of_week : int(11)
* day_name : varchar(20)
* is_weekend : bit(1)
* is_holiday : bit(1)
* holiday_name : varchar(50)
v task FactSales
* SaleID : int(11)
* BookID : int(11)
* CustomerID : int(11)
* RatingID : int(11)
* DateID : int(11)
* QuantitySold : int(11)
* TotalSalesAmount : decimal(15,2)
v task SF_DimAuthor
* Author_ID : int(11)
* Author_Name : varchar(255)
v task SF_DimBook
* Book_ID : int(11)
* Title : varchar(255)
* Author_ID : int(11)
* Genre_ID : int(11)
* Publisher_ID : int(11)
* Price : decimal(10,2)
v task SF_DimCustomer
* Customer_ID : int(11)
* Customer_Name : varchar(255)
* Location_ID : int(11)
v task SF_DimGenre
* Genre_ID : int(11)
* Genre_Name : varchar(255)
v task SF_DimLocation
* Location_ID : int(11)
* City : varchar(100)
* State : varchar(100)
* Country : varchar(100)
v task SF_DimPublisher
* Publisher_ID : int(11)
* Publisher_Name : varchar(255)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship