SchemaSpy - View sakila.staff

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
ID	tinyint unsigned	3		0
name	varchar	91	√	null
address	varchar	50
zip code	varchar	10	√	null
phone	varchar	20
city	varchar	50
country	varchar	50
SID	tinyint unsigned	3

Analyzed at Thu Aug 12 09:42 MDT 2010

View Definition:

select `s`.`staff_id` AS `ID`,concat(`s`.`first_name`,' ',`s`.`last_name`) AS `name`,`a`.`address` AS `address`,`a`.`postal_code` AS `zip code`,`a`.`phone` AS `phone`,`sakila`.`city`.`city` AS `city`,`sakila`.`country`.`country` AS `country`,`s`.`store_id` AS `SID` from (((`sakila`.`staff` `s` join `sakila`.`address` `a` on((`s`.`address_id` = `a`.`address_id`))) join `sakila`.`city` on((`a`.`city_id` = `sakila`.`city`.`city_id`))) join `sakila`.`country` on((`sakila`.`city`.`country_id` = `sakila`.`country`.`country_id`)))

Possibly Referenced Tables/Views:

address city country staff