Database reference - sakila

sakila -  tables

Table overview

name created columns rows indexes triggers refers to refers from dependents data indexes comment
actor  3/19/2009 11:39:17 PM  200  16 kb  16 kb   
address  3/19/2009 11:39:17 PM  589  80 kb  16 kb   
category  3/19/2009 11:39:17 PM  16  16 kb  0 kb   
city  3/19/2009 11:39:17 PM  427  48 kb  16 kb   
country  3/19/2009 11:39:17 PM  109  16 kb  0 kb   
customer  3/19/2009 11:39:17 PM  541  80 kb  48 kb   
film  3/19/2009 11:39:17 PM  13  1,024  192 kb  80 kb   
film_actor  3/19/2009 11:39:17 PM  5,143  192 kb  80 kb   
film_category  3/19/2009 11:39:17 PM  533  64 kb  16 kb   
film_text  3/19/2009 11:39:17 PM  1,000  117 kb  201 kb   
inventory  3/19/2009 11:39:18 PM  4,673  176 kb  192 kb   
language  3/19/2009 11:39:18 PM  16 kb  0 kb   
payment  3/19/2009 11:39:18 PM  15,422  1,552 kb  624 kb   
rental  3/19/2009 11:39:18 PM  15,291  1,552 kb  1,232 kb   
staff  3/19/2009 11:39:18 PM  11  64 kb  32 kb   
store  3/19/2009 11:39:18 PM  16 kb  32 kb   
zzz_object_comments  3/22/2010 11:43:07 PM  16 kb  0 kb   

Tables referenced by views, procedures, or functions

name references
actor 2
address 3
category 4
city 3
country 3
customer 1
film 4
film_actor 3
film_category 4
inventory 6
payment 2
rental 5
staff 1
store 1

Tables not referenced by views, procedures, or functions

name
film_text
language
zzz_object_comments


Largest tables by size on disk Largest tables by row count Largest indexes by size on disk



Documentation generated by SqlSpec