http://dbshelp.devio.at/index.php?action=history&feed=atom&title=HumanResources.EmployeeAddresstable 2026-05-03T05:21:35Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=HumanResources.EmployeeAddresstable&diff=2565&oldid=prev 2010-06-23T22:07:59Z

<p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- valign=&quot;top&quot; | &#039;&#039;&#039;Table | HumanResources.EmployeeAddress |- valign=&quot;top&quot; | &#039;&#039;&#039;Description |...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- valign=&quot;top&quot;<br /> | '''Table<br /> | HumanResources.EmployeeAddress<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Cross-reference table mapping employees to their address(es).<br /> |}<br /> <br /> === Columns ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Column<br /> | '''Data Type<br /> | '''Nullable<br /> | '''Default<br /> | '''Description<br /> <br /> |- valign=&quot;top&quot;<br /> | EmployeeID<br /> | int<br /> | not null<br /> | <br /> | Primary key. Foreign key to Employee.EmployeeID.<br /> |- valign=&quot;top&quot;<br /> | AddressID<br /> | int<br /> | not null<br /> | <br /> | Primary key. Foreign key to Address.AddressID.<br /> |- valign=&quot;top&quot;<br /> | rowguid<br /> | uniqueidentifier<br /> | not null<br /> | (newid())<br /> | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br /> |- valign=&quot;top&quot;<br /> | ModifiedDate<br /> | datetime<br /> | not null<br /> | (getdate())<br /> | Date and time the record was last updated.<br /> |}<br /> <br /> === Primary Key ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Primary Key<br /> | '''Columns<br /> |- valign=&quot;top&quot;<br /> | PK_EmployeeAddress_EmployeeID_AddressID<br /> | EmployeeID, AddressID<br /> |}<br /> <br /> === Indexes ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Index<br /> | '''Type<br /> | '''Columns<br /> <br /> |- valign=&quot;top&quot;<br /> | AK_EmployeeAddress_rowguid<br /> | Unique<br /> | rowguid<br /> |}<br /> <br /> === Foreign Keys ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Relation<br /> | '''Column<br /> | '''Referenced Column<br /> <br /> |- valign=&quot;top&quot;<br /> | [[Person.Address_(table)|Person.Address]]<br /> | AddressID<br /> | AddressID<br /> |- valign=&quot;top&quot;<br /> | [[HumanResources.Employee_(table)|HumanResources.Employee]]<br /> | EmployeeID<br /> | EmployeeID<br /> |}<br /> <br /> === References ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Dependency Type<br /> | '''Object Type<br /> | '''Referenced Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Schema<br /> | Schema<br /> | [[HumanResources_(schema)|HumanResources]]<br /> <br /> |}<br /> <br /> === Dependencies ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Reference Type<br /> | '''Object Type<br /> | '''Referencing Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Select<br /> | View<br /> | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]<br /> <br /> |- valign=&quot;top&quot;<br /> | Select<br /> | View<br /> | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]<br /> <br /> |}</div>

Bot