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:
Debugiraj SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Osvježi
Add
No bookmarks
Add bookmark
Opcije
Set default
Collapse Expand Requery Uređivanje Explain Izrada profila Bookmark Query failed Baza podataka: Queried time:
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Izradi tablicu Create relationship Choose column to display Osvježi Pomoć Kutne veze / Izravne veze Poravnaj s mrežom v Malo / Sve veliko Malo / Veliko Toggle relationship lines Export schema > Premjesti izbornik > Pin text
Number of tables: 0
v sakila actor
* actor_id : smallint(5) unsigned
* first_name : varchar(45)
* last_name : varchar(45)
* last_update : timestamp
v sakila actor_info
* actor_id : smallint(5) unsigned
* first_name : varchar(45)
* last_name : varchar(45)
* film_info : mediumtext
v sakila address
* address_id : smallint(5) unsigned
* address : varchar(50)
* address2 : varchar(50)
* district : varchar(20)
* city_id : smallint(5) unsigned
* postal_code : varchar(10)
* phone : varchar(20)
* last_update : timestamp
v sakila category
* category_id : tinyint(3) unsigned
* name : varchar(25)
* last_update : timestamp
v sakila city
* city_id : smallint(5) unsigned
* city : varchar(50)
* country_id : smallint(5) unsigned
* last_update : timestamp
v sakila country
* country_id : smallint(5) unsigned
* country : varchar(50)
* last_update : timestamp
v sakila customer
* customer_id : smallint(5) unsigned
* store_id : tinyint(3) unsigned
* first_name : varchar(45)
* last_name : varchar(45)
* email : varchar(50)
* address_id : smallint(5) unsigned
* active : tinyint(1)
* create_date : datetime
* last_update : timestamp
v sakila customer_list
* ID : smallint(5) unsigned
* name : varchar(91)
* address : varchar(50)
* zip code : varchar(10)
* phone : varchar(20)
* city : varchar(50)
* country : varchar(50)
* notes : varchar(6)
* SID : tinyint(3) unsigned
v sakila film
* film_id : smallint(5) unsigned
* title : varchar(255)
* description : text
* release_year : year(4)
* language_id : tinyint(3) unsigned
* original_language_id : tinyint(3) unsigned
* rental_duration : tinyint(3) unsigned
* rental_rate : decimal(4,2)
* length : smallint(5) unsigned
* replacement_cost : decimal(5,2)
* rating : enum('G','PG','PG-13','R','NC-17')
* special_features : set('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')
* last_update : timestamp
v sakila film_actor
* actor_id : smallint(5) unsigned
* film_id : smallint(5) unsigned
* last_update : timestamp
v sakila film_category
* film_id : smallint(5) unsigned
* category_id : tinyint(3) unsigned
* last_update : timestamp
v sakila film_list
* FID : smallint(5) unsigned
* title : varchar(255)
* description : text
* category : varchar(25)
* price : decimal(4,2)
* length : smallint(5) unsigned
* rating : enum('G','PG','PG-13','R','NC-17')
* actors : mediumtext
v sakila film_text
* film_id : smallint(6)
* title : varchar(255)
* description : text
v sakila inventory
* inventory_id : mediumint(8) unsigned
* film_id : smallint(5) unsigned
* store_id : tinyint(3) unsigned
* last_update : timestamp
v sakila language
* language_id : tinyint(3) unsigned
* name : char(20)
* last_update : timestamp
v sakila nicer_but_slower_film_list
* FID : smallint(5) unsigned
* title : varchar(255)
* description : text
* category : varchar(25)
* price : decimal(4,2)
* length : smallint(5) unsigned
* rating : enum('G','PG','PG-13','R','NC-17')
* actors : mediumtext
v sakila payment
* payment_id : smallint(5) unsigned
* customer_id : smallint(5) unsigned
* staff_id : tinyint(3) unsigned
* rental_id : int(11)
* amount : decimal(5,2)
* payment_date : datetime
* last_update : timestamp
v sakila rental
* rental_id : int(11)
* rental_date : datetime
* inventory_id : mediumint(8) unsigned
* customer_id : smallint(5) unsigned
* return_date : datetime
* staff_id : tinyint(3) unsigned
* last_update : timestamp
v sakila sales_by_film_category
* category : varchar(25)
* total_sales : decimal(27,2)
v sakila sales_by_store
* store : varchar(101)
* manager : varchar(91)
* total_sales : decimal(27,2)
v sakila staff
* staff_id : tinyint(3) unsigned
* first_name : varchar(45)
* last_name : varchar(45)
* address_id : smallint(5) unsigned
* picture : blob
* email : varchar(50)
* store_id : tinyint(3) unsigned
* active : tinyint(1)
* username : varchar(16)
* password : varchar(40)
* last_update : timestamp
v sakila staff_list
* ID : tinyint(3) unsigned
* name : varchar(91)
* address : varchar(50)
* zip code : varchar(10)
* phone : varchar(20)
* city : varchar(50)
* country : varchar(50)
* SID : tinyint(3) unsigned
v sakila store
* store_id : tinyint(3) unsigned
* manager_staff_id : tinyint(3) unsigned
* address_id : smallint(5) unsigned
* last_update : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship