HumanResources.EmployeeAddress (table) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:52Z

2010-06-23T22:00:03Z

2010-02-02T22:05:31Z

2009-12-28T21:54:31Z

2009-11-30T05:59:16Z

2009-11-30T05:34:38Z

2009-11-30T05:33:29Z

2009-11-30T05:31:57Z

2009-11-30T05:23:53Z

2009-11-26T23:12:46Z

@@ Line 95: / Line 95: @@
 | Schema
 | Schema
-| [[HumanResources_(_(schema))|HumanResources]]
+| [[HumanResources_(schema)|HumanResources]]
 |}
@@ Line 109: / Line 109: @@
 | Select
 | View
-| [[HumanResources.vEmployee_(_(view))|HumanResources.vEmployee]]
+| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 |- valign="top"
 | Select
 | View
-| [[Sales.vSalesPerson_(_(view))|Sales.vSalesPerson]]
+| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | HumanResources.EmployeeAddress
@@ Line 8: / Line 8: @@
 | '''Description
 | Cross-reference table mapping employees to their address(es).
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | EmployeeID
@@ Line 52: / Line 50: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_EmployeeAddress_EmployeeID_AddressID
 | EmployeeID, AddressID
@@ Line 63: / Line 61: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_EmployeeAddress_rowguid
 | Unique
@@ Line 76: / Line 74: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.Address_(table)|Person.Address]]
 | AddressID
 | AddressID
-|-
+|- valign="top"
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
 | EmployeeID
@@ Line 94: / Line 92: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(schema)|HumanResources]]
+| [[HumanResources_(_(schema))|HumanResources]]
 |}
@@ Line 108: / Line 106: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
-| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
+| [[HumanResources.vEmployee_(_(view))|HumanResources.vEmployee]]
-|-
+|- valign="top"
 | Select
 | View
-| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
+| [[Sales.vSalesPerson_(_(view))|Sales.vSalesPerson]]
 |}

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key. Foreign key to Employee.EmployeeID.<br />PK_EmployeeAddress_EmployeeID_AddressID
+| Primary key. Foreign key to Employee.EmployeeID.
 |- valign="top"
 | AddressID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Primary key. Foreign key to Address.AddressID.<br />PK_EmployeeAddress_EmployeeID_AddressID
+| Primary key. Foreign key to Address.AddressID.
 |- valign="top"
 | rowguid
@@ Line 37: / Line 38: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_EmployeeAddress_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 43: / Line 44: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 64: / Line 87: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 82: / Line 119: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | HumanResources.EmployeeAddress
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | EmployeeID
 | int
 | not null
+|
-| PK_EmployeeAddress_EmployeeID_AddressID
+| Primary key. Foreign key to Employee.EmployeeID.<br />PK_EmployeeAddress_EmployeeID_AddressID
+|- valign="top"
 | AddressID
 | int
 | not null
+|
-| PK_EmployeeAddress_EmployeeID_AddressID
+| Primary key. Foreign key to Address.AddressID.<br />PK_EmployeeAddress_EmployeeID_AddressID
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_EmployeeAddress_rowguid
-| AK_EmployeeAddress_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 65: / Line 63: @@
 | EmployeeID
 |}
 == automatically generated ==

@@ Line 72: / Line 72: @@
 | HumanResources.EmployeeAddress
 |- valign="top"
 | '''Description
 | Cross-reference table mapping employees to their address(es).
 |-
 |}

@@ Line 130: / Line 130: @@
 | EmployeeID
 | EmployeeID
 |}
@@ Line 138: / Line 151: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]