From dbscript Online Help
wikibot
Table
|
HumanResources.Employee
|
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
EmployeeID
|
int
|
not null
|
|
PK_Employee_EmployeeID
|
|
NationalIDNumber
|
nvarchar(15)
|
not null
|
|
|
AK_Employee_NationalIDNumber
|
ContactID
|
int
|
not null
|
|
|
|
LoginID
|
nvarchar(256)
|
not null
|
|
|
AK_Employee_LoginID
|
ManagerID
|
int
|
null
|
|
|
IX_Employee_ManagerID
|
Title
|
nvarchar(50)
|
not null
|
|
|
|
BirthDate
|
datetime
|
not null
|
|
|
|
MaritalStatus
|
nchar(1)
|
not null
|
|
|
|
Gender
|
nchar(1)
|
not null
|
|
|
|
HireDate
|
datetime
|
not null
|
|
|
|
SalariedFlag
|
dbo.Flag
|
not null
|
((1))
|
|
|
VacationHours
|
smallint
|
not null
|
((0))
|
|
|
SickLeaveHours
|
smallint
|
not null
|
((0))
|
|
|
CurrentFlag
|
dbo.Flag
|
not null
|
((1))
|
|
|
rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_Employee_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
Triggers
|
Type
|
dEmployee
|
INSTEAD OF DELETE
|
automatically generated
Table
|
HumanResources.Employee
|
Description
|
Employee information such as salary, department, and title.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
PK / Index
|
EmployeeID
|
int
|
not null
|
|
Primary key for Employee records.
|
PK_Employee_EmployeeID
|
NationalIDNumber
|
nvarchar(15)
|
not null
|
|
Unique national identification number such as a social security number.
|
AK_Employee_NationalIDNumber
|
ContactID
|
int
|
not null
|
|
Identifies the employee in the Contact table. Foreign key to Contact.ContactID.
|
|
LoginID
|
nvarchar(256)
|
not null
|
|
Network login.
|
AK_Employee_LoginID
|
ManagerID
|
int
|
null
|
|
Manager to whom the employee is assigned. Foreign Key to Employee.M
|
IX_Employee_ManagerID
|
Title
|
nvarchar(50)
|
not null
|
|
Work title such as Buyer or Sales Representative.
|
|
BirthDate
|
datetime
|
not null
|
|
Date of birth.
|
|
MaritalStatus
|
nchar(1)
|
not null
|
|
M = Married, S = Single
|
|
Gender
|
nchar(1)
|
not null
|
|
M = Male, F = Female
|
|
HireDate
|
datetime
|
not null
|
|
Employee hired on this date.
|
|
SalariedFlag
|
Flag
|
not null
|
(1)
|
Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
|
|
VacationHours
|
smallint
|
not null
|
(0)
|
Number of available vacation hours.
|
|
SickLeaveHours
|
smallint
|
not null
|
(0)
|
Number of available sick leave hours.
|
|
CurrentFlag
|
Flag
|
not null
|
(1)
|
0 = Inactive, 1 = Active
|
|
rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
AK_Employee_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
|
Triggers
|
Type
|
dEmployee
|
INSTEAD OF DELETE
|