Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
| | '''Table | | | '''Table |
| | Purchasing.VendorAddress | | | Purchasing.VendorAddress |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Cross-reference mapping vendors and addresses.
| |
| |} | | |} |
| | | |
− | === Columns ===
| + | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| |- style="background:silver" | | |- style="background:silver" |
Line 17: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description | + | | '''PK |
− | | + | | '''Index |
− | |- valign="top" | + | |
| + | |- |
| | VendorID | | | VendorID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to Vendor.VendorID. | + | | PK_VendorAddress_VendorID_AddressID |
− | |- valign="top" | + | | |
| + | |- |
| | AddressID | | | AddressID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to Address.AddressID.
| |
− | |- valign="top"
| |
− | | AddressTypeID
| |
− | | int
| |
− | | not null
| |
− | |
| |
− | | Address type. Foreign key to AddressType.AddressTypeID.
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (getdate())
| |
− | | Date and time the record was last updated.
| |
− | |}
| |
− |
| |
− | === Primary Key ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Primary Key
| |
− | | '''Columns
| |
− | |- valign="top"
| |
| | PK_VendorAddress_VendorID_AddressID | | | PK_VendorAddress_VendorID_AddressID |
− | | VendorID, AddressID
| |
− | |}
| |
− |
| |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− |
| |
− | |- valign="top"
| |
| | IX_VendorAddress_AddressID | | | IX_VendorAddress_AddressID |
− | | | + | |- |
− | | AddressID
| |
− | |}
| |
− | | |
− | === Foreign Keys ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Relation
| |
− | | '''Column
| |
− | | '''Referenced Column
| |
− | | |
− | |- valign="top"
| |
− | | [[Person.Address_(table)|Person.Address]]
| |
− | | AddressID
| |
− | | AddressID
| |
− | |- valign="top"
| |
− | | [[Person.AddressType_(table)|Person.AddressType]]
| |
| | AddressTypeID | | | AddressTypeID |
− | | AddressTypeID
| |
− | |- valign="top"
| |
− | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| |
− | | VendorID
| |
− | | VendorID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Purchasing_(schema)|Purchasing]]
| |
− |
| |
− | |}
| |
− |
| |
− | === Dependencies ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |- valign="top"
| |
− | | Select
| |
− | | View
| |
− | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |-
| |
− | | '''Table
| |
− | | Purchasing.VendorAddress
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Cross-reference mapping vendors and addresses.
| |
− | |-
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description / PK / Index
| |
− |
| |
− | |- valign="top"
| |
− | | VendorID
| |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to Vendor.VendorID.<br />PK_VendorAddress_VendorID_AddressID
| |
− | |- valign="top"
| |
− | | AddressID
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | Primary key. Foreign key to Address.AddressID.<br />PK_VendorAddress_VendorID_AddressIDIX_VendorAddress_AddressID
| |
− | |- valign="top"
| |
− | | AddressTypeID
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | Address type. Foreign key to AddressType.AddressTypeID.<br />
| + | |- |
− | |- valign="top" | |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
− | | (GETDATE()) | + | | (getdate()) |
− | | Date and time the record was last updated.<br /> | + | | |
| + | | |
| |} | | |} |
| | | |
Line 185: |
Line 68: |
| | VendorID | | | VendorID |
| | VendorID | | | VendorID |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Purchasing_(schema)|Purchasing]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |-
| |
− | | Select
| |
− | | View
| |
− | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
| |
− |
| |
| |} | | |} |