The store_employees table contains the store, employer, and manager ids, and other information about store employees in the pubs3 database.
store_employees is defined as follows:
create table store_employees (stor_id char(4) null references stores(stor_id), emp_id id not null, mgr_id id null references store_employees(emp_id), emp_lname varchar(40) not null, emp_fname varchar(20) not null, phone char(12) null, address varchar(40) null, city varchar(20) null, state char(2) null, country varchar(12) null, postalcode varchar(10) null, unique nonclustered (emp_id))
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
