Name Owner Type Created_datetime -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- ----------------------- Employee dbo user table 2009-05-09 17:06:19.687 Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- -------------------------------------------------------------------------------------------------------------------------------- Emp_id int no 4 10 0 no (n/a) (n/a) NULL Last_name varchar no 15 no no no SQL_Latin1_General_CP1_CI_AS First_name varchar no 15 no no no SQL_Latin1_General_CP1_CI_AS Emp_address varchar no 50 no no no SQL_Latin1_General_CP1_CI_AS Emp_city varchar no 20 no no no SQL_Latin1_General_CP1_CI_AS State_Code varchar no 2 no no no SQL_Latin1_General_CP1_CI_AS Telephone_area_code int no 4 10 0 no (n/a) (n/a) NULL Telephone_number varchar no 10 no no no SQL_Latin1_General_CP1_CI_AS EEO_1_classification varchar no 50 no no no SQL_Latin1_General_CP1_CI_AS Hire_date datetime no 8 no (n/a) (n/a) NULL Emp_salary decimal no 9 10 2 yes (n/a) (n/a) NULL Emp_gender char no 1 no no no SQL_Latin1_General_CP1_CI_AS Emp_age int no 4 10 0 no (n/a) (n/a) NULL Job_id varchar no 5 yes no yes SQL_Latin1_General_CP1_CI_AS Identity Seed Increment Not For Replication -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- ------------------- Emp_id 1 1 0 RowGuidCol -------------------------------------------------------------------------------------------------------------------------------- No rowguidcol column defined. Data_located_on_filegroup -------------------------------------------------------------------------------------------------------------------------------- PRIMARY index_name index_description index_keys -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PK__Employee__1DE57479 clustered, unique, primary key located on PRIMARY Emp_id constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys -------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FOREIGN KEY FK_Employee_Job_title No Action No Action Enabled Is_For_Replication Job_id REFERENCES Kudler Fine Foods.dbo.Job_Title (Job_id) PRIMARY KEY (clustered) PK__Employee__1DE57479 (n/a) (n/a) (n/a) (n/a) Emp_id No foreign keys reference table 'Employee', or you do not have permissions on referencing tables. No views with schema binding reference table 'Employee'. Name Owner Type Created_datetime -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- ----------------------- Job_Title dbo user table 2009-05-09 17:06:19.687 Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- -------------------------------------------------------------------------------------------------------------------------------- Job_id varchar no 5 no no no SQL_Latin1_General_CP1_CI_AS EEO-1 Classification varchar no 50 no no no SQL_Latin1_General_CP1_CI_AS Job_title varchar no 50 no no no SQL_Latin1_General_CP1_CI_AS Job_description varchar no 100 no no no SQL_Latin1_General_CP1_CI_AS Exempt_Status bit no 1 no (n/a) (n/a) NULL Identity Seed Increment Not For Replication -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- ------------------- No identity column defined. NULL NULL NULL RowGuidCol -------------------------------------------------------------------------------------------------------------------------------- No rowguidcol column defined. Data_located_on_filegroup -------------------------------------------------------------------------------------------------------------------------------- PRIMARY index_name index_description index_keys -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PK__Job_Title__1BFD2C07 clustered, unique, primary key located on PRIMARY Job_id constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys -------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PRIMARY KEY (clustered) PK__Job_Title__1BFD2C07 (n/a) (n/a) (n/a) (n/a) Job_id Table is referenced by foreign key ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Kudler Fine Foods.dbo.Employee: FK_Employee_Job_title No views with schema binding reference table 'Job_Title'. (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) Emp_id Last_name First_name Emp_address Emp_city State_Code Telephone_area_code Telephone_number EEO_1_classification Hire_date Emp_salary Emp_gender Emp_age Job_id ----------- --------------- --------------- -------------------------------------------------- -------------------- ---------- ------------------- ---------------- -------------------------------------------------- ----------------------- --------------------------------------- ---------- ----------- ------ 1 Edelman Glenn 0 Sales Workers 2003-10-07 00:00:00.000 21500.00 M 64 CASHR 2 McMullen Eric 0 Sales Workers 2002-11-01 00:00:00.000 13500.00 M 20 CASHR 3 Slentz Raj 0 Assistant Manager Officials & Managers 2000-06-01 00:00:00.000 48000.00 M 34 ASTMG 4 Broun Erin 0 Sales Worker 2003-03-12 00:00:00.000 10530.00 F 24 BGGER 5 Carpenter Donald 0 Office/Clerical 2003-11-01 00:00:00.000 15000.00 M 18 OFCLR 6 Esquivez David 0 Asst. -Butchers & Seafood Specialists 2003-07-25 00:00:00.000 18500.00 M 25 RBSFP 7 Sharp Nancy 0 Asst. -Butchers & Seafood Specialists 2003-07-12 00:00:00.000 21000.00 F 24 RBSFP (7 row(s) affected) Job_id EEO-1 Classification Job_title Job_description Exempt_Status ------ -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------- ACCLK Sales Worker Accounting Clerk Accounting Clerk 0 ASTMG Officials & Managers Asst. Manager Asst. Manager 1 BGGER Sales Workers Bagger Bagger 0 CASHR Sales Workers Cashier Cashier 0 CMPSS Operatives (Semi Skilled) Computer Support Specialist Computer Support Specialist 0 DROFA Officials & Managers Director of Finance & Accounting Director of Finance & Accounting 1 OFCLR Office/Clerical Stocker Stocker 0 RBSFP Operatives (Semi Skilled) Retail Asst. Butchers and Seafood Specialists Retail Asst. Butchers and Seafood Specialists 0 RTABP Operatives (Semi Skilled) Retail Asst. Bakery & Pastry Retail Asst. Bakery & Pastry 0 (9 row(s) affected)