[UML] Dicccionario de datos con MYSQL workbench 5.2.33 CE o superior

 Primero tener instalado MYSQL workbench 5.2.33 o superior, no importa el sistema operativo.
Bajar plugin para el WB desde:

wb-datadict/downloads

Seguir los pasos a continuacion:

Debaria aparecer al final de instalar:

Una vez reiniciado el WB ir a un modelo ER y:

Guardar como HTML y el modelo saldra algo como:

sakila
Data Dictionay

2014-03-05

Alphabetic Index

• actor
• address
• category
• city
• country
• customer
• film
• film_actor
• film_category
• film_text
• inventory
• language
• payment
• rental
• staff
• store

actor

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
actor_id	SMALLINT	✔	✔			✔		✔
first_name	VARCHAR(45)		✔
last_name	VARCHAR(45)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

address

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
address_id	SMALLINT	✔	✔			✔		✔
address	VARCHAR(50)		✔
address2	VARCHAR(50)								NULL
district	VARCHAR(20)		✔
city_id	SMALLINT		✔			✔
postal_code	VARCHAR(10)								NULL
phone	VARCHAR(20)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

category

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
category_id	TINYINT	✔	✔			✔		✔
name	VARCHAR(25)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

city

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
city_id	SMALLINT	✔	✔			✔		✔
city	VARCHAR(50)		✔
country_id	SMALLINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

country

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
country_id	SMALLINT	✔	✔			✔		✔
country	VARCHAR(50)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

customer

Table storing all customers. Holds foreign keys to the address table and the store table where this customer is registered. Basic information about the customer like first and last name are stored in the table itself. Same for the date the record was created and when the information was last updated.
Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
customer_id	SMALLINT	✔	✔			✔		✔
store_id	TINYINT		✔			✔
first_name	VARCHAR(45)		✔
last_name	VARCHAR(45)		✔
email	VARCHAR(50)								NULL
address_id	SMALLINT		✔			✔
active	TINYINT(1)		✔						TRUE
create_date	DATETIME		✔
last_update	TIMESTAMP								CURRENT_TIMESTAMP

film

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
film_id	SMALLINT	✔	✔			✔		✔
title	VARCHAR(255)		✔
description	TEXT								NULL
release_year	YEAR								NULL
language_id	TINYINT		✔			✔
original_language_id	TINYINT					✔			NULL
rental_duration	TINYINT		✔			✔			3
rental_rate	DECIMAL(4,2)		✔						4.99
length	SMALLINT					✔			NULL
replacement_cost	DECIMAL(5,2)		✔						19.99
rating	ENUM('G','PG','PG-13','R','NC-17')								'G'
special_features	SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')								NULL
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

film_actor

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
actor_id	SMALLINT	✔	✔			✔
film_id	SMALLINT	✔	✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

film_category

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
film_id	SMALLINT	✔	✔			✔
category_id	TINYINT	✔	✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

film_text

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
film_id	SMALLINT	✔	✔			✔
title	VARCHAR(255)		✔
description	TEXT								NULL

inventory

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
inventory_id	MEDIUMINT	✔	✔			✔		✔
film_id	SMALLINT		✔			✔
store_id	TINYINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

language

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
language_id	TINYINT	✔	✔			✔		✔
name	CHAR(20)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

payment

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
payment_id	SMALLINT	✔	✔			✔		✔
customer_id	SMALLINT		✔			✔
staff_id	TINYINT		✔			✔
rental_id	INT								NULL
amount	DECIMAL(5,2)		✔
payment_date	DATETIME		✔
last_update	TIMESTAMP								CURRENT_TIMESTAMP

rental

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
rental_id	INT	✔	✔					✔
rental_date	DATETIME		✔
inventory_id	MEDIUMINT		✔			✔
customer_id	SMALLINT		✔			✔
return_date	DATETIME								NULL
staff_id	TINYINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

staff

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
staff_id	TINYINT	✔	✔			✔		✔
first_name	VARCHAR(45)		✔
last_name	VARCHAR(45)		✔
address_id	SMALLINT		✔			✔
picture	BLOB								NULL
email	VARCHAR(50)								NULL
store_id	TINYINT		✔			✔
active	TINYINT(1)		✔						TRUE
username	VARCHAR(16)		✔
password	VARCHAR(40)				✔				NULL
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

store

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
store_id	TINYINT	✔	✔			✔		✔
manager_staff_id	TINYINT		✔			✔
address_id	SMALLINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP