Tables and Columns
Report generated by Toad for SQL Server
Table Name Address
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
AddressID int Primary key for Address
records.
AddressLine1 nvarchar First street address line.
AddressLine1 nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
AddressLine1 nvarchar Contact Info
AddressLine1 nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
AddressLine1 nvarchar Confidential - GDPR
AddressLine2 nvarchar Second street address
line.
AddressLine2 nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
AddressLine2 nvarchar Contact Info
AddressLine2 nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
AddressLine2 nvarchar Confidential - GDPR
City nvarchar Name of the city.
City nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
City nvarchar Contact Info
City nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
City nvarchar Confidential - GDPR
StateProvinceID int Unique identification
number for the state or
province. Foreign key to
StateProvince table.
PostalCode nvarchar Postal code for the
street address.
PostalCode nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
PostalCode nvarchar Contact Info
PostalCode nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
PostalCode nvarchar Confidential - GDPR
SpatialLocation sys.geography Latitude and longitude of
this address.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name AddressType
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
AddressTypeID int Primary key for
AddressType records.
Name dbo.Name Address type
description. For
example, Billing, Home,
or Shipping.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name AWBuildVersion
Schema Name dbo
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:14
Column Name Data Type Default Not Null Extended Properties
SystemInformationID tinyint Primary key for
AWBuildVersion records.
Database Version nvarchar Version number of the
database in
9.yy.mm.dd.00 format.
VersionDate datetime Date and time the record
was last updated.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BillOfMaterials
Schema Name Production
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BillOfMaterialsID int Primary key for
BillOfMaterials records.
ProductAssemblyID int Parent product
identification number.
Foreign key to
Product.ProductID.
ComponentID int Component identification
number. Foreign key to
Product.ProductID.
StartDate datetime (getdate()) Date the component
started being used in the
assembly item.
EndDate datetime Date the component
stopped being used in
the assembly item.
UnitMeasureCode nchar Standard code
identifying the unit of
measure for the quantity.
BOMLevel smallint Indicates the depth the
component is from its
parent (AssemblyID).
PerAssemblyQty decimal ((1.00)) Quantity of the
component needed to
create the assembly.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BusinessEntity
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key for all
customers, vendors, and
employees.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BusinessEntityAddress
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. Foreign key
to
BusinessEntity.Business
EntityID.
AddressID int Primary key. Foreign key
to Address.AddressID.
AddressTypeID int Primary key. Foreign key
to
AddressType.AddressTy
peID.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BusinessEntityContact
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. Foreign key
to
BusinessEntity.Business
EntityID.
PersonID int Primary key. Foreign key
to
Person.BusinessEntityID
.
ContactTypeID int Primary key.  Foreign
key to
ContactType.ContactTyp
eID.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ContactType
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
ContactTypeID int Primary key for
ContactType records.
Name dbo.Name Contact type description.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CountryRegion
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:20
Column Name Data Type Default Not Null Extended Properties
CountryRegionCode nvarchar ISO standard code for
countries and regions.
Name dbo.Name Country or region name.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CountryRegionCurrency
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
CountryRegionCode nvarchar ISO code for countries
and regions. Foreign key
to
CountryRegion.Country
RegionCode.
CurrencyCode nchar ISO standard currency
code. Foreign key to
Currency.CurrencyCode.
CurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyCode nchar Financial
CurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyCode nchar Confidential
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CreditCard
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CreditCardID int Primary key for
CreditCard records.
CreditCardID int D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CreditCardID int Credit Card
CreditCardID int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CreditCardID int Confidential
CardType nvarchar Credit card name.
CardType nvarchar D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CardType nvarchar Credit Card
CardType nvarchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CardType nvarchar Confidential
CardNumber nvarchar Credit card number.
CardNumber nvarchar D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CardNumber nvarchar Credit Card
CardNumber nvarchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CardNumber nvarchar Confidential
ExpMonth tinyint Credit card expiration
month.
ExpMonth tinyint D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
ExpMonth tinyint Credit Card
ExpMonth tinyint 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ExpMonth tinyint Confidential
ExpYear smallint Credit card expiration
year.
ExpYear smallint D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
ExpYear smallint Credit Card
ExpYear smallint 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ExpYear smallint Confidential
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Culture
Schema Name Production
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CultureID nchar Primary key for Culture
records.
Name dbo.Name Culture description.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Currency
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
CurrencyCode nchar The ISO code for the
Currency.
CurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyCode nchar Financial
CurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyCode nchar Confidential
Name dbo.Name Currency name.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CurrencyRate
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CurrencyRateID int Primary key for
CurrencyRate records.
CurrencyRateID int C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyRateID int Financial
CurrencyRateID int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyRateID int Confidential
CurrencyRateDate datetime Date and time the
exchange rate was
obtained.
CurrencyRateDate datetime C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyRateDate datetime Financial
CurrencyRateDate datetime 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyRateDate datetime Confidential
FromCurrencyCode nchar Exchange rate was
converted from this
currency code.
FromCurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
FromCurrencyCode nchar Financial
FromCurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
FromCurrencyCode nchar Confidential
ToCurrencyCode nchar Exchange rate was
converted to this
currency code.
ToCurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
ToCurrencyCode nchar Financial
ToCurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ToCurrencyCode nchar Confidential
AverageRate money Average exchange rate
for the day.
EndOfDayRate money Final exchange rate for
the day.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Customer
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CustomerID int Primary key.
PersonID int Foreign key to
Person.BusinessEntityID
StoreID int Foreign key to
Store.BusinessEntityID
TerritoryID int ID of the territory in
which the customer is
located. Foreign key to
SalesTerritory.SalesTerri
toryID.
AccountNumber varchar Unique number
identifying the customer
assigned by the
accounting system.
AccountNumber varchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
AccountNumber varchar Financial
AccountNumber varchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
AccountNumber varchar Confidential
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name DatabaseLog
Schema Name dbo
Create Date 11.06.2018 13:42:51
Modified Date 11.06.2018 13:43:16
Column Name Data Type Default Not Null Extended Properties
DatabaseLogID int Primary key for
DatabaseLog records.
PostTime datetime The date and time the
DDL change occurred.
DatabaseUser sysname The user who
implemented the DDL
change.
Event sysname The type of DDL
statement that was
executed.
Schema sysname The schema to which
the changed object
belongs.
Object sysname The object that was
changed by the DDL
statment.
TSQL nvarchar The exact Transact-SQL
statement that was
executed.
TSQL nvarchar
TSQL nvarchar ajjjjj
TSQL nvarchar 684a0db2-d514-49d8-
8c0c-df84a7b083eb
TSQL nvarchar ojjjjj
XmlEvent xml The raw XML data
generated by database
trigger.
XmlEvent xml C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
XmlEvent xml Credentials
XmlEvent xml 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
XmlEvent xml Confidential
Table Name dataedo_interfacing_tables
Schema Name dbo
Create Date 30.11.2018 17:57:21
Modified Date 30.11.2018 17:57:21
Column Name Data Type Default Not Null Extended Properties
procedure_name sysname
procedure_schema nvarchar
name nvarchar
position int
parameter_mode nvarchar
datatype nvarchar
data_length int
description sql_variant
Table Name Department
Schema Name HumanResources
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
DepartmentID smallint Primary key for
Department records.
DepartmentID smallint 9C5B4809-0CCC-0637-
6547-91A6F8BB609D
DepartmentID smallint Other
DepartmentID smallint 1866ca45-1973-4c28-
9d12-04d407f147ad
DepartmentID smallint Public
Name dbo.Name Name of the department.
GroupName dbo.Name Name of the group to
which the department
belongs.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Document
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
DocumentNode sys.hierarchyid Primary key for
Document records.
DocumentLevel smallint Depth in the document
hierarchy.
Title nvarchar Title of the document.
Owner int Employee who controls
the document.  Foreign
key to
Employee.BusinessEntit
yID
FolderFlag bit ((0)) 0 = This is a folder, 1 =
This is a document.
FileName nvarchar File name of the
document
FileExtension nvarchar File extension indicating
the document type. For
example, .doc or .txt.
Revision nchar Revision number of the
document.
ChangeNumber int ((0)) Engineering change
approval number.
Status tinyint 1 = Pending approval, 2
= Approved, 3 =
Obsolete
DocumentSummary nvarchar Document abstract.
Document varbinary Complete document.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Required for
FileStream.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name EmailAddress
Schema Name Person
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. Person
associated with this
email address.  Foreign
key to
Person.BusinessEntityID
EmailAddressID int Primary key. ID of this
email address.
EmailAddress nvarchar E-mail address for the
person.
EmailAddress nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
EmailAddress nvarchar Contact Info
EmailAddress nvarchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
EmailAddress nvarchar Confidential
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Employee
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key for
Employee records.
Foreign key to
BusinessEntity.Business
EntityID.
NationalIDNumber nvarchar Unique national
identification number
such as a social security
number.
NationalIDNumber nvarchar 6F5A11A7-08B1-19C3-
59E5-8C89CF4F8444
NationalIDNumber nvarchar National ID
NationalIDNumber nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
NationalIDNumber nvarchar Confidential - GDPR
LoginID nvarchar Network login. Test2
OrganizationNode sys.hierarchyid Where the employee is
located in corporate
hierarchy.
OrganizationLevel smallint The depth of the
employee in the
corporate hierarchy.
JobTitle nvarchar Work title such as Buyer
or Sales Representative.
BirthDate date Date of birth.
MaritalStatus nchar M = Married, S = Single
Gender nchar M = Male, F = Female
HireDate date Employee hired on this
date.
SalariedFlag dbo.Flag ((1)) Job classification. 0 =
Hourly, not exempt from
collective bargaining. 1 =
Salaried, exempt from
collective bargaining.
VacationHours smallint ((0)) Number of available
vacation hours.
SickLeaveHours smallint ((0)) Number of available sick
leave hours.
CurrentFlag dbo.Flag ((1)) 0 = Inactive, 1 = Active
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name EmployeeDepartmentHistory
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Employee identification
number. Foreign key to
Employee.BusinessEntit
yID.
DepartmentID smallint Department in which the
employee worked
including currently.
Foreign key to
Department.DepartmentI
D.
ShiftID tinyint Identifies which 8-hour
shift the employee
works. Foreign key to
Shift.Shift.ID.
StartDate date Date the employee
started work in the
department.
EndDate date Date the employee left
the department. NULL =
Current department.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name EmployeePayHistory
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Employee identification
number. Foreign key to
Employee.BusinessEntit
yID.
RateChangeDate datetime Date the change in pay
is effective
Rate money Salary hourly rate.
PayFrequency tinyint 1 = Salary received
monthly, 2 = Salary
received biweekly
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ErrorLog
Schema Name dbo
Create Date 11.06.2018 13:42:53
Modified Date 11.06.2018 13:42:55
Column Name Data Type Default Not Null Extended Properties
ErrorLogID int Primary key for ErrorLog
records.
ErrorTime datetime (getdate()) The date and time at
which the error occurred.
UserName sysname The user who executed
the batch in which the
error occurred.
UserName sysname C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
UserName sysname Credentials
UserName sysname 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
UserName sysname Confidential
ErrorNumber int The error number of the
error that occurred.
ErrorNumber int C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
ErrorNumber int Credentials
ErrorNumber int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ErrorNumber int Confidential
ErrorSeverity int The severity of the error
that occurred.
ErrorState int The state number of the
error that occurred.
ErrorProcedure nvarchar The name of the stored
procedure or trigger
where the error
occurred.
ErrorProcedure nvarchar D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
ErrorProcedure nvarchar Credit Card
ErrorProcedure nvarchar 1866ca45-1973-4c28-
9d12-04d407f147ad
ErrorProcedure nvarchar Public
ErrorLine int The line number at
which the error occurred.
ErrorLine int C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
ErrorLine int Credentials
ErrorLine int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ErrorLine int Confidential
ErrorMessage nvarchar The message text of the
error that occurred.
ErrorMessage nvarchar
ErrorMessage nvarchar CredCredWutWut
ErrorMessage nvarchar
ErrorMessage nvarchar ConfConfWutWut
Table Name Illustration
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
IllustrationID int Primary key for
Illustration records.
Diagram xml Illustrations used in
manufacturing
instructions. Stored as
XML.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name JobCandidate
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
JobCandidateID int Primary key for
JobCandidate records.
BusinessEntityID int Employee identification
number if applicant was
hired. Foreign key to
Employee.BusinessEntit
yID.
Resume xml Résumé in XML format.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.