|
|
| (47 intermediate revisions by 47 users not shown) |
| Line 1: |
Line 1: |
| − | == wikibot ==
| + | Hi there, |
| | | | |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| + | We run an Instagram growth service, which increases your number of followers both safely and practically. |
| − | |-
| |
| − | | '''Table
| |
| − | | Person.Contact
| |
| − | |- valign="top"
| |
| − | | '''Description
| |
| − | | Names of each employee, customer contact, and vendor contact.
| |
| − | |-
| |
| − | |}
| |
| | | | |
| | + | - Guaranteed: We guarantee to gain you 400-1200+ followers per month. |
| | + | - Real, human followers: People follow you because they are interested in your business or niche. |
| | + | - Safe: All actions are made manually. We do not use any bots. |
| | | | |
| − | === Columns ===
| + | The price is just $60 (USD) per month, and we can start immediately. |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Column
| |
| − | | '''Data Type
| |
| − | | '''Nullable
| |
| − | | '''Default
| |
| − | | '''Description
| |
| − |
| |
| − | |- valign="top"
| |
| − | | ContactID
| |
| − | | int
| |
| − | | not null
| |
| − | |
| |
| − | | Primary key for Contact records.
| |
| − | |- valign="top"
| |
| − | | NameStyle
| |
| − | | dbo.NameStyle
| |
| − | | not null
| |
| − | | ((0))
| |
| − | | 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
| |
| − | |- valign="top"
| |
| − | | Title
| |
| − | | nvarchar(8)
| |
| − | | null
| |
| − | |
| |
| − | | A courtesy title. For example, Mr. or Ms.
| |
| − | |- valign="top"
| |
| − | | FirstName
| |
| − | | dbo.Name
| |
| − | | not null
| |
| − | |
| |
| − | | First name of the person.
| |
| − | |- valign="top"
| |
| − | | MiddleName
| |
| − | | dbo.Name
| |
| − | | null
| |
| − | |
| |
| − | | Middle name or middle initial of the person.
| |
| − | |- valign="top"
| |
| − | | LastName
| |
| − | | dbo.Name
| |
| − | | not null
| |
| − | |
| |
| − | | Last name of the person.
| |
| − | |- valign="top"
| |
| − | | Suffix
| |
| − | | nvarchar(10)
| |
| − | | null
| |
| − | |
| |
| − | | Surname suffix. For example, Sr. or Jr.
| |
| − | |- valign="top"
| |
| − | | EmailAddress
| |
| − | | nvarchar(50)
| |
| − | | null
| |
| − | |
| |
| − | | E-mail address for the person.
| |
| − | |- valign="top"
| |
| − | | EmailPromotion
| |
| − | | int
| |
| − | | not null
| |
| − | | ((0))
| |
| − | | 0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
| |
| − | |- valign="top"
| |
| − | | Phone
| |
| − | | dbo.Phone
| |
| − | | null
| |
| − | |
| |
| − | | Phone number associated with the person.
| |
| − | |- valign="top"
| |
| − | | PasswordHash
| |
| − | | varchar(128)
| |
| − | | not null
| |
| − | |
| |
| − | | Password for the e-mail account.
| |
| − | |- valign="top"
| |
| − | | PasswordSalt
| |
| − | | varchar(10)
| |
| − | | not null
| |
| − | |
| |
| − | | Random value concatenated with the password string before the password is hashed.
| |
| − | |- valign="top"
| |
| − | | AdditionalContactInfo
| |
| − | | xml
| |
| − | | null
| |
| − | |
| |
| − | | Additional contact information about the person stored in xml format.
| |
| − | |- valign="top"
| |
| − | | rowguid
| |
| − | | uniqueidentifier
| |
| − | | not null
| |
| − | | (newid())
| |
| − | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
| |
| − | |- valign="top"
| |
| − | | ModifiedDate
| |
| − | | datetime
| |
| − | | not null
| |
| − | | (getdate())
| |
| − | | Date and time the record was last updated.
| |
| − | |}
| |
| | | | |
| − | === Primary Key ===
| + | If you are interested, and would like to see some of our previous work, let me know and we can discuss further. |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Primary Key
| |
| − | | '''Columns
| |
| − | |-
| |
| − | | PK_Contact_ContactID
| |
| − | | ContactID
| |
| − | |}
| |
| | | | |
| − | === Indexes ===
| + | Kind Regards, |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| + | Megan |
| − | |- style="background:silver"
| |
| − | | '''Index
| |
| − | | '''Type
| |
| − | | '''Columns
| |
| − |
| |
| − | |-
| |
| − | | AK_Contact_rowguid
| |
| − | | Unique
| |
| − | | rowguid
| |
| − | |-
| |
| − | | IX_Contact_EmailAddress
| |
| − | |
| |
| − | | EmailAddress
| |
| − | |-
| |
| − | | PXML_Contact_AddContact
| |
| − | |
| |
| − | | AdditionalContactInfo
| |
| − | |}
| |
| | | | |
| − | === Check Constraints ===
| + | To unsubscribe: https://removeme.click/unsubscribe.php?d=dbshelp.devio.at |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Check Constraint
| |
| − | | '''Expression
| |
| − | | '''Description
| |
| − |
| |
| − | |-
| |
| − | | CK_Contact_EmailPromotion
| |
| − | | ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))
| |
| − | | Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2)
| |
| − | |}
| |
| − | | |
| − | === Detail Tables ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Detail Table
| |
| − | | '''Column
| |
| − | | '''Referencing Column
| |
| − |
| |
| − | |-
| |
| − | | [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[HumanResources.Employee_(table)|HumanResources.Employee]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Sales.Individual_(table)|Sales.Individual]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Sales.StoreContact_(table)|Sales.StoreContact]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |}
| |
| − | | |
| − | === References ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Dependency Type
| |
| − | | '''Object Type
| |
| − | | '''Referenced Object
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | Type
| |
| − | | [[dbo.Name_(type)|dbo.Name]]
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | Type
| |
| − | | [[dbo.NameStyle_(type)|dbo.NameStyle]]
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | Type
| |
| − | | [[dbo.Phone_(type)|dbo.Phone]]
| |
| − | | |
| − | |-
| |
| − | | Schema
| |
| − | | Schema
| |
| − | | [[Person_(schema)|Person]]
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | XML Schema Collection
| |
| − | | [[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|Person.AdditionalContactInfoSchemaCollection]]
| |
| − | | |
| − | |}
| |
| − | | |
| − | === Dependencies ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''Referencing Object
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | Procedure
| |
| − | | [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | Procedure
| |
| − | | [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | SQL table-valued-function
| |
| − | | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
| |
| − | | |
| − | |}
| |
| − | | |
| − | | |
| − | == automatically generated ==
| |
| − | | |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |-
| |
| − | | '''Table
| |
| − | | Person.Contact
| |
| − | |- valign="top"
| |
| − | | '''Description
| |
| − | | Names of each employee, customer contact, and vendor contact.
| |
| − | |-
| |
| − | |}
| |
| − | | |
| − | | |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Column
| |
| − | | '''Data Type
| |
| − | | '''Nullable
| |
| − | | '''Default
| |
| − | | '''Description / PK / Index
| |
| − |
| |
| − | |- valign="top"
| |
| − | | ContactID
| |
| − | | int
| |
| − | | not null
| |
| − | |
| |
| − | | Primary key for Contact records.<br />PK_Contact_ContactID
| |
| − | |- valign="top"
| |
| − | | NameStyle
| |
| − | | NameStyle
| |
| − | | not null
| |
| − | | (0)
| |
| − | | 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.<br />
| |
| − | |- valign="top"
| |
| − | | Title
| |
| − | | nvarchar(8)
| |
| − | | null
| |
| − | |
| |
| − | | A courtesy title. For example, Mr. or Ms.<br />
| |
| − | |- valign="top"
| |
| − | | FirstName
| |
| − | | Name
| |
| − | | not null
| |
| − | |
| |
| − | | First name of the person.<br />
| |
| − | |- valign="top"
| |
| − | | MiddleName
| |
| − | | Name
| |
| − | | null
| |
| − | |
| |
| − | | Middle name or middle initial of the person.<br />
| |
| − | |- valign="top"
| |
| − | | LastName
| |
| − | | Name
| |
| − | | not null
| |
| − | |
| |
| − | | Last name of the person.<br />
| |
| − | |- valign="top"
| |
| − | | Suffix
| |
| − | | nvarchar(10)
| |
| − | | null
| |
| − | |
| |
| − | | Surname suffix. For example, Sr. or Jr.<br />
| |
| − | |- valign="top"
| |
| − | | EmailAddress
| |
| − | | nvarchar(50)
| |
| − | | null
| |
| − | |
| |
| − | | E-mail address for the person.<br />IX_Contact_EmailAddress
| |
| − | |- valign="top"
| |
| − | | EmailPromotion
| |
| − | | int
| |
| − | | not null
| |
| − | | (0)
| |
| − | | 0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners. <br />
| |
| − | |- valign="top"
| |
| − | | Phone
| |
| − | | Phone
| |
| − | | null
| |
| − | |
| |
| − | | Phone number associated with the person.<br />
| |
| − | |- valign="top"
| |
| − | | PasswordHash
| |
| − | | varchar(128)
| |
| − | | not null
| |
| − | |
| |
| − | | Password for the e-mail account.<br />
| |
| − | |- valign="top"
| |
| − | | PasswordSalt
| |
| − | | varchar(10)
| |
| − | | not null
| |
| − | |
| |
| − | | Random value concatenated with the password string before the password is hashed.<br />
| |
| − | |- valign="top"
| |
| − | | AdditionalContactInfo
| |
| − | | XML
| |
| − | | null
| |
| − | |
| |
| − | | Additional contact information about the person stored in xml format. <br />PXML_Contact_AddContact
| |
| − | |- valign="top"
| |
| − | | rowguid
| |
| − | | uniqueidentifier
| |
| − | | not null
| |
| − | | (NEWID())
| |
| − | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Contact_rowguid
| |
| − | |- valign="top"
| |
| − | | ModifiedDate
| |
| − | | datetime
| |
| − | | not null
| |
| − | | (GETDATE())
| |
| − | | Date and time the record was last updated.<br />
| |
| − | |}
| |
| − | | |
| − | | |
| − | | |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Detail Table
| |
| − | | '''Column
| |
| − | | '''Referencing Column
| |
| − |
| |
| − | |-
| |
| − | | [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[HumanResources.Employee_(table)|HumanResources.Employee]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Sales.Individual_(table)|Sales.Individual]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Sales.StoreContact_(table)|Sales.StoreContact]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |-
| |
| − | | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
| |
| − | | ContactID
| |
| − | | ContactID
| |
| − | |}
| |
| − | | |
| − | | |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Dependency Type
| |
| − | | '''Object Type
| |
| − | | '''Referenced Object
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | Type
| |
| − | | [[dbo.Name_(type)|dbo.Name]]
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | Type
| |
| − | | [[dbo.NameStyle_(type)|dbo.NameStyle]]
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | Type
| |
| − | | [[dbo.Phone_(type)|dbo.Phone]]
| |
| − | | |
| − | |-
| |
| − | | Schema
| |
| − | | Schema
| |
| − | | [[Person_(schema)|Person]]
| |
| − | | |
| − | |-
| |
| − | | Data Type
| |
| − | | XML Schema Collection
| |
| − | | [[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|Person.AdditionalContactInfoSchemaCollection]]
| |
| − | | |
| − | |}
| |
| − | | |
| − | | |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''Referencing Object
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | View
| |
| − | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | Procedure
| |
| − | | [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | Procedure
| |
| − | | [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
| |
| − | | |
| − | |-
| |
| − | | Select
| |
| − | | SQL table-valued-function
| |
| − | | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
| |
| − | | |
| − | |}
| |
