Northwind Database (Document! X Sample)
AdventureWorks Database / PRIMARY File Group
In This Topic
    PRIMARY File Group
    In This Topic
    Properties
    Default FileGroup
    Read Only
    Tables
    TableDescription
    Current version number of the AdventureWorks 2016 sample database.
    Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
    Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.
    Lookup table containing the departments within the Adventure Works Cycles company.
    Employee information such as salary, department, and title.
    Employee department transfers.
    Employee pay history.
    Résumés submitted to Human Resources by job applicants.
    Work shift lookup table.
    Street address information for customers, employees, and vendors.
    Types of addresses stored in the Address table.
    Source of the ID that connects vendors, customers, and employees with address and contact information.
    Cross-reference table mapping customers, vendors, and employees to their addresses.
    Cross-reference table mapping stores, vendors, and employees to people
    Lookup table containing the types of business entity contacts.
    Lookup table containing the ISO standard codes for countries and regions.
    Where to send a person email.
    One way hashed authentication information
    Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.
    Telephone number and type of a person.
    Type of phone number of a person.
    State and province lookup table.
    Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
    Lookup table containing the languages in which some AdventureWorks data is stored.
    Product maintenance documents.
    Bicycle assembly diagrams.
    Product inventory and manufacturing locations.
    Products sold or used in the manfacturing of sold products.
    High-level product categorization.
    Changes in the cost of a product over time.
    Product descriptions in several languages.
    Cross-reference table mapping products to related product documents.
    Product inventory information.
    Changes in the list price of a product over time.
    Product model classification.
    Cross-reference table mapping product models and illustrations.
    Cross-reference table mapping product descriptions and the language the description is written in.
    Product images.
    Cross-reference table mapping products and product photos.
    Customer reviews of products they have purchased.
    Product subcategories. See ProductCategory table.
    Manufacturing failure reasons lookup table.
    Record of each purchase order, sales order, or work order transaction year to date.
    Transactions for previous years.
    Unit of measure lookup table.
    Manufacturing work orders.
    Work order details.

    Vendors are added to the table before any POs are processed.

    Individual products associated with a specific purchase order. See PurchaseOrderHeader.
    General purchase order information. See PurchaseOrderDetail.
    Shipping company lookup table.
    Companies from whom Adventure Works Cycles purchases parts or other goods.
    Cross-reference table mapping ISO currency codes to a country or region.
    Customer credit card information.
    Lookup table containing standard ISO currencies.
    Currency exchange rates.
    Current customer information. Also see the Person and Store tables.
    Cross-reference table mapping people to their credit card information in the CreditCard table.
    Individual products associated with a specific sales order. See SalesOrderHeader.
    General sales order information.
    Cross-reference table mapping sales orders to sales reason codes.
    Sales representative current information.
    Sales performance tracking.
    Lookup table of customer purchase reasons.
    Tax rate lookup table.
    Sales territory lookup table.
    Sales representative transfers to other sales territories.
    Contains online customer orders until the order is submitted or cancelled.
    Sale discounts lookup table.
    Cross-reference table mapping products to special offer discounts.
    Customers (resellers) of Adventure Works products.
    Indexes
    IndexDescriptionPrimaryUnique
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Clustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support FileStream. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. Used to support replication samples. 
    Unique nonclustered index. 
    Unique nonclustered index. 
    Nonclustered index. 
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Unique nonclustered index.  
    Nonclustered index.  
    Unique nonclustered index.  
    Unique nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
       
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Nonclustered index.  
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (nonclustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary key (clustered) constraint
    Primary XML index.  
    Primary XML index.  
    Primary XML index.  
    Primary XML index.  
    Primary XML index.  
      
    Secondary XML index for path.  
    Secondary XML index for property.  
    Secondary XML index for value.  
    See Also

    Related Objects

    AdventureWorks Database