Employees

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
EmployeeID INTEGER 2000000000,10 null
Employees.ReportsTo R
EmployeeTerritories.EmployeeID R
Orders.EmployeeID R
Orders Qry.EmployeeID Implied ConstraintR
LastName TEXT 2000000000,10 null
FirstName TEXT 2000000000,10 null
Title TEXT 2000000000,10 null
TitleOfCourtesy TEXT 2000000000,10 null
BirthDate DATE 2000000000,10 null
HireDate DATE 2000000000,10 null
Address TEXT 2000000000,10 null
City TEXT 2000000000,10 null
Region TEXT 2000000000,10 null
PostalCode TEXT 2000000000,10 null
Country TEXT 2000000000,10 null
HomePhone TEXT 2000000000,10 null
Extension TEXT 2000000000,10 null
Photo BLOB 2000000000,10 null
Notes TEXT 2000000000,10 null
ReportsTo INTEGER 2000000000,10 null
Employees.EmployeeID R
PhotoPath TEXT 2000000000,10 null

Indexes

Constraint Name Type Sort Column(s)
Employees_s_pk Primary key Asc EmployeeID

Relationships