Description
noneTable properties
| name | value |
|---|
| name | actor
|
| created | 3/19/2009 11:39:17 PM
|
| modified |
|
| row count | 200
|
| Size of data | 16 kb
|
| Size of indexes | 16 kb |
| average row size | 81 b
|
| engine | InnoDB
|
| version | 10
|
| row format | Compact
|
| max data length | 0 kb
|
| data free | 5242880
|
| auto increment | 201
|
| table collation | utf8_general_ci
|
| create options |
|
Columns
| column | datatype | length | bytes | precision | scale | default | nulls | PK | FK | UQ | extra | privileges | comment |
|---|
| actor_id
| smallint(5) unsigned
|
|
| 5
| 0
|
| NO
| yes
|
| yes
| auto_increment
| select,insert,update,references
|
|
| first_name
| varchar(45)
| 45
| 135
|
|
|
| NO
|
|
|
|
| select,insert,update,references
|
|
| last_name
| varchar(45)
| 45
| 135
|
|
|
| NO
|
|
|
|
| select,insert,update,references
|
|
| last_update
| timestamp
|
|
|
|
| CURRENT_TIMESTAMP
| NO
|
|
|
| on update CURRENT_TIMESTAMP
| select,insert,update,references
|
|
Indexes
| name | columns | unique | cardinality | type | comment |
|---|
| PRIMARY
| actor_id
| yes
| 200
| BTREE
|
|
| idx_actor_last_name
| last_name
| no
| 200
| BTREE
|
|
Referenced by
Foreign key graph
Dependency graph
Objects that depend on actor
Sample rows
| actor_id | first_name | last_name | last_update |
|---|
| 1
| PENELOPE
| GUINESS
| 2/15/2006 4:34:33 AM
|
| 2
| NICK
| WAHLBERG
| 2/15/2006 4:34:33 AM
|
| 3
| ED
| CHASE
| 2/15/2006 4:34:33 AM
|
| 4
| JENNIFER
| DAVIS
| 2/15/2006 4:34:33 AM
|
| 5
| JOHNNY
| LOLLOBRIGIDA
| 2/15/2006 4:34:33 AM
|
| 6
| BETTE
| NICHOLSON
| 2/15/2006 4:34:33 AM
|
| 7
| GRACE
| MOSTEL
| 2/15/2006 4:34:33 AM
|
| 8
| MATTHEW
| JOHANSSON
| 2/15/2006 4:34:33 AM
|
| 9
| JOE
| SWANK
| 2/15/2006 4:34:33 AM
|
| 10
| CHRISTIAN
| GABLE
| 2/15/2006 4:34:33 AM
|
Code
CREATE TABLE `actor` (
`actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(45) NOT NULL,
`last_name` varchar(45) NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`actor_id`),
KEY `idx_actor_last_name` (`last_name`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8