Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Count: Waktu yang dipakai:
Opsi
Kembalikan nilai bawaan
Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Kueri gagal Basis data: Waktu eksekusi kueri:
Belum ada nama *
v Show/Hide tables list View in fullscreen Tambahkan tabel dari database lainya New page Buka halaman Simpan halaman Simpan halaman sebagai Delete pages Buat tabel Create relationship Pilih kolom untuk ditampilkan Muat ulang Bantuan Tautan angular / Tautan langsung Lekatkan kepada kisi v Small/Big All Toggle small/big Toggle relationship lines Export schema > Pindahkan Menu > Sematkan teks
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 : 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
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship