Solte os arquivos aqui

Envio de SQL ( 0 ) x -

Configurações da página Clique na barra para rolar até o topo da página
Pressione Ctrl+Enter para executar consulta Pressione Enter para executar consulta
ascendente
descendente
Ordem:
Depurar SQL
Contagem
Ordem de execução
Tempo gasto
Ordenar por:
Agrupar consultas
Desagrupar consultas
Recolher Expandir Mostrar rastro Ocultar rastro Contagem: Tempo gasto:
Opções
Restore default values
Recolher Expandir Repetir consulta Editar Demonstrar SQL Perfil Falha na consulta Banco de dados: Tempo de execução da consulta:
Sem título *
v Mostrar/ocultar lista de tabelas Ver em tela cheia Adicione tabelas de outra base de dados Nova página Páginas abertas Selecionar página Salvar página como Apagar páginas Criar tabela Criar relacionamento Marque a coluna para exibir Recarregar Ajuda Links angulares / Links diretos Ajustar à grade v Tudo pequeno/grande Mudar para pequeno/grande Alternar linhas de relação Exportar estrutura > Mover Menu > Fixar texto
v v
Número de tabelas: 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 : text
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 : text
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 : text
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
Criar relacionamento
FOREIGN KEY
on delete
on update
Apagar relacionamento