Database reference - sakila

sakila -  tables -  category

Description

none

Table properties

namevalue
namecategory 
created3/19/2009 11:39:17 PM 
modified 
row count16 
Size of data16 kb
Size of indexes0 kb
average row size1,024 b
engineInnoDB 
version10 
row formatCompact 
max data length0 kb
data free5242880 
auto increment17 
table collationutf8_general_ci 
create options 

Columns

columndatatypelengthbytesprecisionscaledefaultnullsPKFKUQextraprivilegescomment
category_id  tinyint(3) unsigned      3  0    NO  yes    yes  auto_increment  select,insert,update,references   
name  varchar(25)  25  75        NO          select,insert,update,references   
last_update  timestamp          CURRENT_TIMESTAMP  NO        on update CURRENT_TIMESTAMP  select,insert,update,references   

Indexes

namecolumnsuniquecardinalitytypecomment
PRIMARY  category_id  yes  16  BTREE   

Referenced by

name
film_category

Foreign key graph

categoryfilm_category

Dependency graph

categoryactor_infofilm_listnicer_but_slower_film_listsales_by_film_category

Objects that depend on category

nameobject typelevel
actor_infoview1
film_listview1
nicer_but_slower_film_listview1
sales_by_film_categoryview1

Sample rows

category_idnamelast_update
1  Action  2/15/2006 4:46:27 AM 
2  Animation  2/15/2006 4:46:27 AM 
3  Children  2/15/2006 4:46:27 AM 
4  Classics  2/15/2006 4:46:27 AM 
5  Comedy  2/15/2006 4:46:27 AM 
6  Documentary  2/15/2006 4:46:27 AM 
7  Drama  2/15/2006 4:46:27 AM 
8  Family  2/15/2006 4:46:27 AM 
9  Foreign  2/15/2006 4:46:27 AM 
10  Games  2/15/2006 4:46:27 AM 

Code

CREATE TABLE `category` (
  `category_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8



Documentation generated by SqlSpec