Database reference - AdventureWorks2008

AdventureWorks2008 -  tables -  [Person].[BusinessEntityContact]

Description

Cross-reference table mapping stores, vendors, and employees to people 

Table properties

namevalue
name[Person].[BusinessEntityContact]
createdMar 19 2009 9:09PM
modifiedMar 19 2009 9:10PM 
ansi nullson 
quoted identifieron 
row count909
Size of data48 kb
Size of indexes128 kb
Maximum size of a single row36 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
BusinessEntityIDint104 no  composite PK  BusinessEntity.BusinessEntityID      no  Primary key. Foreign key to BusinessEntity.BusinessEntityID. 
PersonIDint104 no  composite PK  Person.BusinessEntityID      no  Primary key. Foreign key to Person.BusinessEntityID. 
ContactTypeIDint104 no  composite PK  ContactType.ContactTypeID      no  Primary key. Foreign key to ContactType.ContactTypeID. 
rowguiduniqueidentifier3616(newid())no      no  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime238(getdate())no      no  Date and time the record was last updated. 

Indexes

namedescriptioncolumncomment
AK_BusinessEntityContact_rowguidnonclustered, unique located on PRIMARYrowguidUnique nonclustered index. Used to support replication samples. 
IX_BusinessEntityContact_ContactTypeIDnonclustered located on PRIMARYContactTypeIDNonclustered index. 
IX_BusinessEntityContact_PersonIDnonclustered located on PRIMARYPersonIDNonclustered index. 
PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeIDclustered, unique, primary key located on PRIMARYBusinessEntityID, PersonID, ContactTypeIDClustered index created by a primary key constraint. 

References

name
BusinessEntity
ContactType
Person

Foreign key graph

BusinessEntityContactTypePersonBusinessEntityContact

Foreign keys

namecolumnsforeign columnstypecomment
FK_BusinessEntityContact_BusinessEntity_BusinessEntityIDBusinessEntityIDBusinessEntity.BusinessEntityID   Foreign key constraint referencing BusinessEntity.BusinessEntityID. 
FK_BusinessEntityContact_Person_PersonIDPersonIDPerson.BusinessEntityID   Foreign key constraint referencing Person.BusinessEntityID. 
FK_BusinessEntityContact_ContactType_ContactTypeIDContactTypeIDContactType.ContactTypeID   Foreign key constraint referencing ContactType.ContactTypeID. 

Defaults

default namecolumncomment
DF_BusinessEntityContact_rowguidrowguidDefault constraint value of NEWID() 
DF_BusinessEntityContact_ModifiedDateModifiedDateDefault constraint value of GETDATE() 

Dependency graph

DF_BusinessEntityContact_ModifiedDateDF_BusinessEntityContact_rowguidBusinessEntityContactAK_BusinessEntityContact_rowguid...IX_BusinessEntityContact_ContactTypeID...IX_BusinessEntityContact_PersonID...PK_BusinessEntityContact_BusinessEntityID_PersonID...Store Contacts 2008ufnGetContactInformationvVendorWithContactsvStoreWithContacts

Objects that depend on [Person].[BusinessEntityContact]

nameobject typedatabaseserverlevel
Store Contacts 2008Reportreportserver_katmaiSPRING1
ufnGetContactInformationmulti-statement table valued functionAdventureWorks2008SPRING\KATMAI1
vVendorWithContactsviewAdventureWorks2008SPRING\KATMAI1
vStoreWithContactsviewAdventureWorks2008SPRING\KATMAI1

Sample rows

BusinessEntityIDPersonIDContactTypeIDrowguidModifiedDate
292  291  11  7d4d2dbc-4a44-48f5-911d-a63abafd5120  1/14/2008 1:21:02 PM 
294  293  11  3ea25b65-9579-4260-977d-d6f00d7d20ee  1/14/2008 1:21:02 PM 
296  295  11  dadac1ff-3351-4827-9ae0-95004885c193  1/14/2008 1:21:02 PM 
298  297  11  b924f26f-6446-45d1-a92b-6f418374f075  1/14/2008 1:21:02 PM 
300  299  11  5ba4e7be-8d29-46a2-b68d-67b1615b124a  1/14/2008 1:21:02 PM 
302  301  11  6cc8f248-8d96-4afd-adcc-61d93e8de3b1  1/14/2008 1:21:02 PM 
304  303  11  33b4da81-4448-481f-bf7c-357ea4d23f21  1/14/2008 1:21:02 PM 
306  305  11  70d35526-7c2f-470f-98cb-f9299a754f16  1/14/2008 1:21:02 PM 
308  307  14  da33b75d-32fb-432d-a275-9e9d32e78f3e  1/14/2008 1:21:02 PM 
310  309  14  c2dee145-a902-477e-ab21-29659ac3e97e  1/14/2008 1:21:02 PM 

Code

CREATE TABLE [Person].[BusinessEntityContact](
    [BusinessEntityID] [int] NOT NULL,
    [PersonID] [int] NOT NULL,
    [ContactTypeID] [int] NOT NULL,
    [rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
    [BusinessEntityID] [int] NOT NULL,
    [PersonID] [int] NOT NULL,
    [ContactTypeID] [int] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID] PRIMARY KEY CLUSTERED 
(
    [BusinessEntityID] ASC,
    [PersonID] ASC,
    [ContactTypeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Person].[BusinessEntityContact]  WITH CHECK ADD  CONSTRAINT [FK_BusinessEntityContact_BusinessEntity_BusinessEntityID] FOREIGN KEY([BusinessEntityID])
REFERENCES [Person].[BusinessEntity] ([BusinessEntityID])
ALTER TABLE [Person].[BusinessEntityContact] CHECK CONSTRAINT [FK_BusinessEntityContact_BusinessEntity_BusinessEntityID]
ALTER TABLE [Person].[BusinessEntityContact]  WITH CHECK ADD  CONSTRAINT [FK_BusinessEntityContact_ContactType_ContactTypeID] FOREIGN KEY([ContactTypeID])
REFERENCES [Person].[ContactType] ([ContactTypeID])
ALTER TABLE [Person].[BusinessEntityContact] CHECK CONSTRAINT [FK_BusinessEntityContact_ContactType_ContactTypeID]
ALTER TABLE [Person].[BusinessEntityContact]  WITH CHECK ADD  CONSTRAINT [FK_BusinessEntityContact_Person_PersonID] FOREIGN KEY([PersonID])
REFERENCES [Person].[Person] ([BusinessEntityID])
ALTER TABLE [Person].[BusinessEntityContact] CHECK CONSTRAINT [FK_BusinessEntityContact_Person_PersonID]
ALTER TABLE [Person].[BusinessEntityContact] ADD  CONSTRAINT [DF_BusinessEntityContact_rowguid]  DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Person].[BusinessEntityContact] ADD  CONSTRAINT [DF_BusinessEntityContact_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]



Documentation generated by SqlSpec