1 address staff Fk fk_city_country city ref country ( country_id ) Fk fk_city_country city ref country ( country_id ) country_id Fk fk_address_city address ref city ( city_id ) Fk fk_address_city address ref city ( city_id ) city_id Fk fk_store_address store ref address ( address_id ) Fk fk_store_address store ref address ( address_id ) address_id Fk fk_store_staff store ref staff ( manager_staff_id -> staff_id ) Fk fk_store_staff store ref staff ( manager_staff_id -> staff_id ) manager_staff_id Fk fk_staff_address staff ref address ( address_id ) Fk fk_staff_address staff ref address ( address_id ) address_id Fk fk_staff_store staff ref store ( store_id ) Fk fk_staff_store staff ref store ( store_id ) store_id cityTable dbo.city Pk PK__city__031491A965AA4887 ( city_id ) city_idcity_id * int Referred by address ( city_id ) citycity * varchar(50) t idx_fk_country_id ( country_id ) country_idcountry_id * smallint References country ( country_id ) last_updatelast_update * datetime default getdate() d addressTable dbo.address Pk PK__address__CAA247C92E638A69 ( address_id ) address_idaddress_id * int Referred by customer ( address_id ) Referred by staff ( address_id ) Referred by store ( address_id ) addressaddress * varchar(50) t address2address2 varchar(50) t districtdistrict * varchar(20) t idx_fk_city_id ( city_id ) city_idcity_id * int References city ( city_id ) postal_codepostal_code varchar(10) t phonephone * varchar(20) t last_updatelast_update * datetime default getdate() d countryTable dbo.country Pk PK__country__7E8CD0541DDF9DF9 ( country_id ) country_idcountry_id * smallint Referred by city ( country_id ) countrycountry * varchar(50) t last_updatelast_update datetime default getdate() d storeTable dbo.store Pk PK__store__A2F2A30D41A59115 ( store_id ) store_idstore_id * int Referred by customer ( store_id ) Referred by inventory ( store_id ) Referred by staff ( store_id ) Unq idx_fk_address_id ( manager_staff_id ) manager_staff_idmanager_staff_id * tinyint References staff ( manager_staff_id -> staff_id ) idx_fk_store_address ( address_id ) address_idaddress_id * int References address ( address_id ) last_updatelast_update * datetime default getdate() d staffTable dbo.staff Pk PK__staff__1963DD9D6E97842D ( staff_id ) staff_idstaff_id * tinyint Referred by payment ( staff_id ) Referred by rental ( staff_id ) Referred by store ( manager_staff_id -> staff_id ) first_namefirst_name * varchar(45) t last_namelast_name * varchar(45) t idx_fk_address_id ( address_id ) address_idaddress_id * int References address ( address_id ) picturepicture image ~ emailemail varchar(50) t idx_fk_store_id ( store_id ) store_idstore_id * int References store ( store_id ) activeactive * bit default 1 b usernameusername * varchar(16) t passwordpassword varchar(40) t last_updatelast_update * datetime default getdate() d