Database reference - sakila

sakila -  tables

Table overview

namecreatedcolumnsrowsindexestriggersrefers torefers fromdependentsdataindexescomment
actor  12/23/2006 7:10:34 PM  200  5 kb  7 kb   
address  12/23/2006 7:10:34 PM  603  38 kb  13 kb   
category  12/23/2006 7:10:34 PM  16  0 kb  2 kb   
city  12/23/2006 7:56:04 PM  4,079  267 kb  83 kb   
country  12/23/2006 7:10:56 PM  15  239  61 kb  5 kb   
countrylanguage  12/23/2006 7:10:56 PM  984  37 kb  23 kb   
customer  12/23/2006 7:10:34 PM  599  41 kb  28 kb   
film  12/23/2006 7:10:34 PM  13  1,000  132 kb  54 kb   
film_actor  12/23/2006 7:10:34 PM  5,462  48 kb  101 kb   
film_category  12/23/2006 7:10:34 PM  1,000  8 kb  19 kb   
film_text  12/23/2006 7:10:34 PM  1,000  117 kb  201 kb   
inventory  12/23/2006 7:10:35 PM  4,581  49 kb  123 kb   
language  12/23/2006 7:10:35 PM  0 kb  2 kb   
payment  12/23/2006 7:10:35 PM  16,049  392 kb  708 kb   
product  12/26/2006 3:37:00 PM  0 kb  1 kb  this is the product table 
product_order  12/26/2006 3:34:35 PM  0 kb  1 kb   
rental  12/23/2006 7:10:35 PM  16,044  486 kb  935 kb   
staff  12/23/2006 7:10:35 PM  11  36 kb  4 kb   
store  12/23/2006 7:10:35 PM  0 kb  4 kb   

Tables referenced by views, procedures, or functions

namereferences
actor2
address3
category4
city3
country3
customer1
film4
film_actor3
film_category4
inventory6
payment2
rental5
staff1
store1

Tables not referenced by views, procedures, or functions

name
countrylanguage
film_text
language
product
product_order


Largest tables by size on diskLargest tables by row countLargest indexes by size on disk



Documentation generated by SqlSpec