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 |
| | Person.ContactType | | | Person.ContactType |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Lookup table containing the types of contacts stored in Contact.
| |
| |} | | |} |
| | | |
− | === 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" | + | |
| + | |- |
| | ContactTypeID | | | ContactTypeID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key for ContactType records. | + | | PK_ContactType_ContactTypeID |
− | |- valign="top" | + | | |
| + | |- |
| | Name | | | Name |
| | dbo.Name | | | dbo.Name |
| | not null | | | not null |
| | | | | |
− | | Contact type description. | + | | |
− | |- valign="top" | + | | AK_ContactType_Name |
| + | |- |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
| | (getdate()) | | | (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_ContactType_ContactTypeID
| |
− | | ContactTypeID
| |
− | |}
| |
− |
| |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− |
| |
− | |- valign="top"
| |
− | | AK_ContactType_Name
| |
− | | Unique
| |
− | | Name
| |
− | |}
| |
− |
| |
− | === Detail Tables ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Detail Table
| |
− | | '''Column
| |
− | | '''Referencing Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Sales.StoreContact_(table)|Sales.StoreContact]]
| |
− | | ContactTypeID
| |
− | | ContactTypeID
| |
− | |- valign="top"
| |
− | | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
| |
− | | ContactTypeID
| |
− | | ContactTypeID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Data Type
| |
− | | Type
| |
− | | [[dbo.Name_(type)|dbo.Name]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Person_(schema)|Person]]
| |
− |
| |
− | |}
| |
− |
| |
− | === 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]]
| |
− |
| |
− | |- valign="top"
| |
− | | Select
| |
− | | View
| |
− | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
| |
− |
| |
− | |- valign="top"
| |
− | | Select
| |
− | | SQL table-valued-function
| |
− | | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == wikivalues ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- valign="top"
| |
− | | '''Table Values
| |
− | | Person.ContactType
| |
− | |}
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− |
| |
− | | '''ContactTypeID
| |
− | | '''Name
| |
− | |- valign="top"
| |
− |
| |
− | | 1
| |
− | | Accounting Manager
| |
− | |- valign="top"
| |
− |
| |
− | | 2
| |
− | | Assistant Sales Agent
| |
− | |- valign="top"
| |
− |
| |
− | | 3
| |
− | | Assistant Sales Representative
| |
− | |- valign="top"
| |
− |
| |
− | | 4
| |
− | | Coordinator Foreign Markets
| |
− | |- valign="top"
| |
− |
| |
− | | 5
| |
− | | Export Administrator
| |
− | |- valign="top"
| |
− |
| |
− | | 6
| |
− | | International Marketing Manager
| |
− | |- valign="top"
| |
− |
| |
− | | 7
| |
− | | Marketing Assistant
| |
− | |- valign="top"
| |
− |
| |
− | | 8
| |
− | | Marketing Manager
| |
− | |- valign="top"
| |
− |
| |
− | | 9
| |
− | | Marketing Representative
| |
− | |- valign="top"
| |
− |
| |
− | | 10
| |
− | | Order Administrator
| |
− | |- valign="top"
| |
− |
| |
− | | 11
| |
− | | Owner
| |
− | |- valign="top"
| |
− |
| |
− | | 12
| |
− | | Owner/Marketing Assistant
| |
− | |- valign="top"
| |
− |
| |
− | | 13
| |
− | | Product Manager
| |
− | |- valign="top"
| |
− |
| |
− | | 14
| |
− | | Purchasing Agent
| |
− | |- valign="top"
| |
− |
| |
− | | 15
| |
− | | Purchasing Manager
| |
− | |- valign="top"
| |
− |
| |
− | | 16
| |
− | | Regional Account Representative
| |
− | |- valign="top"
| |
− |
| |
− | | 17
| |
− | | Sales Agent
| |
− | |- valign="top"
| |
− |
| |
− | | 18
| |
− | | Sales Associate
| |
− | |- valign="top"
| |
− |
| |
− | | 19
| |
− | | Sales Manager
| |
− | |- valign="top"
| |
− |
| |
− | | 20
| |
− | | Sales Representative
| |
− | |}
| |
− |
| |
− | == automatically generated ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |-
| |
− | | '''Table
| |
− | | Person.ContactType
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Lookup table containing the types of contacts stored in Contact.
| |
− | |-
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description / PK / Index
| |
− |
| |
− | |- valign="top"
| |
− | | ContactTypeID
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | Primary key for ContactType records.<br />PK_ContactType_ContactTypeID
| |
− | |- valign="top"
| |
− | | Name
| |
− | | Name
| |
− | | not null
| |
| | | | | |
− | | Contact type description.<br />AK_ContactType_Name
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (GETDATE())
| |
− | | Date and time the record was last updated.<br />
| |
| |} | | |} |
| | | |
Line 276: |
Line 58: |
| | ContactTypeID | | | ContactTypeID |
| |} | | |} |
− | | + | == wikivalues == |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
| |- | | |- |
− | | Data Type | + | | '''Table Values |
− | | Type | + | | Person.ContactType |
− | | [[dbo.Name_(type)|dbo.Name]]
| |
− | | |
| |- | | |- |
− | | Schema
| |
− | | Schema
| |
− | | [[Person_(schema)|Person]]
| |
− |
| |
| |} | | |} |
| | | |
| | | |
− | {| 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" |
− | | '''Reference Type | + | | '''ContactTypeID |
− | | '''Object Type | + | | '''Name |
− | | '''Referencing Object | + | |- |
− | | + | | 1 |
− | |- | + | | Accounting Manager |
− | | Select | + | |- |
− | | View | + | | 2 |
− | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]] | + | | Assistant Sales Agent |
− | | + | |- |
− | |- | + | | 3 |
− | | Select | + | | Assistant Sales Representative |
− | | View | + | |- |
− | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] | + | | 4 |
− | | + | | Coordinator Foreign Markets |
− | |- | + | |- |
− | | Select | + | | 5 |
− | | SQL table-valued-function | + | | Export Administrator |
− | | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]] | + | |- |
− | | + | | 6 |
| + | | International Marketing Manager |
| + | |- |
| + | | 7 |
| + | | Marketing Assistant |
| + | |- |
| + | | 8 |
| + | | Marketing Manager |
| + | |- |
| + | | 9 |
| + | | Marketing Representative |
| + | |- |
| + | | 10 |
| + | | Order Administrator |
| + | |- |
| + | | 11 |
| + | | Owner |
| + | |- |
| + | | 12 |
| + | | Owner/Marketing Assistant |
| + | |- |
| + | | 13 |
| + | | Product Manager |
| + | |- |
| + | | 14 |
| + | | Purchasing Agent |
| + | |- |
| + | | 15 |
| + | | Purchasing Manager |
| + | |- |
| + | | 16 |
| + | | Regional Account Representative |
| + | |- |
| + | | 17 |
| + | | Sales Agent |
| + | |- |
| + | | 18 |
| + | | Sales Associate |
| + | |- |
| + | | 19 |
| + | | Sales Manager |
| + | |- |
| + | | 20 |
| + | | Sales Representative |
| |} | | |} |