SQL_queries_to_DB.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "from dotenv import load_dotenv\n",
    "import pyodbc\n",
    "import sqlalchemy as sa\n",
    "from sqlalchemy import create_engine\n",
    "\n",
    "from urllib.parse import quote_plus\n",
    "\n",
    "load_dotenv()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql\n",
    "\n",
    "server = os.getenv('SQL_SERVER_NAME')\n",
    "database = os.getenv('SQL_DATABASE_NAME')\n",
    "username = os.getenv('SQL_USER')\n",
    "password = os.getenv('SQL_PASSWORD')\n",
    "\n",
    "driver = '{ODBC Driver 17 for SQL Server}'\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+server+';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+ password)\n",
    "cursor = conn.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "master SQL_Latin1_General_CP1_CI_AS\n",
      "AdventureWorks_v1 SQL_Latin1_General_CP1_CI_AS\n"
     ]
    }
   ],
   "source": [
    "cursor.execute(\"SELECT TOP 3 name, collation_name FROM sys.databases\")\n",
    "row = cursor.fetchone()\n",
    "while row:\n",
    "    print (str(row[0]) + \" \" + str(row[1]))\n",
    "    row = cursor.fetchone()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AdventureWorks_v1\n"
     ]
    }
   ],
   "source": [
    "query_get_current_database = \"\"\"SELECT DB_NAME() AS CurrentDatabase\"\"\"\n",
    "\n",
    "cursor.execute(query_get_current_database)\n",
    "\n",
    "row = cursor.fetchone()\n",
    "\n",
    "while row:\n",
    "    print (str(row[0]))\n",
    "    row = cursor.fetchone()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Table, and Column Details in the current database:\n",
      "\n",
      "Address  \n",
      "          AddressID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          AddressLine1 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          AddressLine2 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          StateProvinceID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          SpatialLocation \n",
      "          geography \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Address  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AddressType  \n",
      "          AddressTypeID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AddressType  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AddressType  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AddressType  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AWBuildVersion  \n",
      "          SystemInformationID \n",
      "          tinyint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AWBuildVersion  \n",
      "          Database Version \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AWBuildVersion  \n",
      "          VersionDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "AWBuildVersion  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          BillOfMaterialsID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          ProductAssemblyID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          ComponentID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          StartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          UnitMeasureCode \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          BOMLevel \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          PerAssemblyQty \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BillOfMaterials  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntity  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntity  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntity  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          AddressID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          AddressID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          AddressTypeID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          AddressTypeID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityAddress  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          PersonID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          PersonID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          ContactTypeID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          ContactTypeID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "BusinessEntityContact  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ContactType  \n",
      "          ContactTypeID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ContactType  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ContactType  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegion  \n",
      "          CountryRegionCode \n",
      "          nvarchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegion  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegion  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegionCurrency  \n",
      "          CountryRegionCode \n",
      "          nvarchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegionCurrency  \n",
      "          CountryRegionCode \n",
      "          nvarchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegionCurrency  \n",
      "          CurrencyCode \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegionCurrency  \n",
      "          CurrencyCode \n",
      "          nchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CountryRegionCurrency  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CreditCard  \n",
      "          CreditCardID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CreditCard  \n",
      "          CardType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CreditCard  \n",
      "          CardNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CreditCard  \n",
      "          ExpMonth \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CreditCard  \n",
      "          ExpYear \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CreditCard  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Culture  \n",
      "          CultureID \n",
      "          nchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Culture  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Culture  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Currency  \n",
      "          CurrencyCode \n",
      "          nchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Currency  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Currency  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CurrencyRate  \n",
      "          CurrencyRateID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CurrencyRate  \n",
      "          CurrencyRateDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CurrencyRate  \n",
      "          FromCurrencyCode \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CurrencyRate  \n",
      "          ToCurrencyCode \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CurrencyRate  \n",
      "          AverageRate \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CurrencyRate  \n",
      "          EndOfDayRate \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "CurrencyRate  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Customer  \n",
      "          CustomerID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Customer  \n",
      "          PersonID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Customer  \n",
      "          StoreID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Customer  \n",
      "          TerritoryID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Customer  \n",
      "          AccountNumber \n",
      "          varchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Customer  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Customer  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "database_firewall_rules  \n",
      "          id \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "database_firewall_rules  \n",
      "          name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "database_firewall_rules  \n",
      "          start_ip_address \n",
      "          varchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "database_firewall_rules  \n",
      "          end_ip_address \n",
      "          varchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "database_firewall_rules  \n",
      "          create_date \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "database_firewall_rules  \n",
      "          modify_date \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          DatabaseLogID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          PostTime \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          DatabaseUser \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          Event \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          Schema \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          Object \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          TSQL \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "DatabaseLog  \n",
      "          XmlEvent \n",
      "          xml \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Department  \n",
      "          DepartmentID \n",
      "          smallint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Department  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Department  \n",
      "          GroupName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Department  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          DocumentNode \n",
      "          hierarchyid \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          DocumentLevel \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          Owner \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          FolderFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          FileName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          FileExtension \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          Revision \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          ChangeNumber \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          Status \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          DocumentSummary \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          Document \n",
      "          varbinary \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          UNIQUE\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Document  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmailAddress  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmailAddress  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmailAddress  \n",
      "          EmailAddressID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmailAddress  \n",
      "          EmailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "EmailAddress  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmailAddress  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          NationalIDNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          LoginID \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          OrganizationNode \n",
      "          hierarchyid \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          OrganizationLevel \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          JobTitle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          BirthDate \n",
      "          date \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          MaritalStatus \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          Gender \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          HireDate \n",
      "          date \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          SalariedFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          VacationHours \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          SickLeaveHours \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          CurrentFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Employee  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          DepartmentID \n",
      "          smallint \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          DepartmentID \n",
      "          smallint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          ShiftID \n",
      "          tinyint \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          ShiftID \n",
      "          tinyint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          StartDate \n",
      "          date \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          EndDate \n",
      "          date \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "EmployeeDepartmentHistory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeePayHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeePayHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeePayHistory  \n",
      "          RateChangeDate \n",
      "          datetime \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeePayHistory  \n",
      "          Rate \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeePayHistory  \n",
      "          PayFrequency \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "EmployeePayHistory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorLogID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorTime \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          UserName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorNumber \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorSeverity \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorState \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorProcedure \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorLine \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ErrorLog  \n",
      "          ErrorMessage \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Illustration  \n",
      "          IllustrationID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Illustration  \n",
      "          Diagram \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Illustration  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "JobCandidate  \n",
      "          JobCandidateID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "JobCandidate  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "JobCandidate  \n",
      "          Resume \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "JobCandidate  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Location  \n",
      "          LocationID \n",
      "          smallint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Location  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Location  \n",
      "          CostRate \n",
      "          smallmoney \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Location  \n",
      "          Availability \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Location  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Password  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Password  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Password  \n",
      "          PasswordHash \n",
      "          varchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Password  \n",
      "          PasswordSalt \n",
      "          varchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Password  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Password  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          PersonType \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          NameStyle \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          EmailPromotion \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          AdditionalContactInfo \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          Demographics \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Person  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonCreditCard  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonCreditCard  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonCreditCard  \n",
      "          CreditCardID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonCreditCard  \n",
      "          CreditCardID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonCreditCard  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonPhone  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonPhone  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonPhone  \n",
      "          PhoneNumber \n",
      "          nvarchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonPhone  \n",
      "          PhoneNumberTypeID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonPhone  \n",
      "          PhoneNumberTypeID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PersonPhone  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PhoneNumberType  \n",
      "          PhoneNumberTypeID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PhoneNumberType  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PhoneNumberType  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ProductNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          MakeFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          FinishedGoodsFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          Color \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          SafetyStockLevel \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ReorderPoint \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          StandardCost \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ListPrice \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          Size \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          SizeUnitMeasureCode \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          WeightUnitMeasureCode \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          Weight \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          DaysToManufacture \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ProductLine \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          Class \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          Style \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ProductSubcategoryID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ProductModelID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          SellStartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          SellEndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          DiscontinuedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Product  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCategory  \n",
      "          ProductCategoryID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCategory  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCategory  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCategory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCostHistory  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCostHistory  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCostHistory  \n",
      "          StartDate \n",
      "          datetime \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCostHistory  \n",
      "          EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductCostHistory  \n",
      "          StandardCost \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductCostHistory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDescription  \n",
      "          ProductDescriptionID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDescription  \n",
      "          Description \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDescription  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDescription  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDocument  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDocument  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDocument  \n",
      "          DocumentNode \n",
      "          hierarchyid \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDocument  \n",
      "          DocumentNode \n",
      "          hierarchyid \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductDocument  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          LocationID \n",
      "          smallint \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          LocationID \n",
      "          smallint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          Shelf \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          Bin \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          Quantity \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductInventory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductListPriceHistory  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductListPriceHistory  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductListPriceHistory  \n",
      "          StartDate \n",
      "          datetime \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductListPriceHistory  \n",
      "          EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductListPriceHistory  \n",
      "          ListPrice \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductListPriceHistory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModel  \n",
      "          ProductModelID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModel  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModel  \n",
      "          CatalogDescription \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductModel  \n",
      "          Instructions \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductModel  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModel  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelIllustration  \n",
      "          ProductModelID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelIllustration  \n",
      "          ProductModelID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelIllustration  \n",
      "          IllustrationID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelIllustration  \n",
      "          IllustrationID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelIllustration  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelProductDescriptionCulture  \n",
      "          ProductModelID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelProductDescriptionCulture  \n",
      "          ProductModelID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelProductDescriptionCulture  \n",
      "          ProductDescriptionID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelProductDescriptionCulture  \n",
      "          ProductDescriptionID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelProductDescriptionCulture  \n",
      "          CultureID \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelProductDescriptionCulture  \n",
      "          CultureID \n",
      "          nchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductModelProductDescriptionCulture  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductPhoto  \n",
      "          ProductPhotoID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductPhoto  \n",
      "          ThumbNailPhoto \n",
      "          varbinary \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductPhoto  \n",
      "          ThumbnailPhotoFileName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductPhoto  \n",
      "          LargePhoto \n",
      "          varbinary \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductPhoto  \n",
      "          LargePhotoFileName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductPhoto  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductProductPhoto  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductProductPhoto  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductProductPhoto  \n",
      "          ProductPhotoID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductProductPhoto  \n",
      "          ProductPhotoID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductProductPhoto  \n",
      "          Primary \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductProductPhoto  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          ProductReviewID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          ReviewerName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          ReviewDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          EmailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          Rating \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          Comments \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductReview  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductSubcategory  \n",
      "          ProductSubcategoryID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductSubcategory  \n",
      "          ProductCategoryID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductSubcategory  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductSubcategory  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductSubcategory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          AverageLeadTime \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          StandardPrice \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          LastReceiptCost \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          LastReceiptDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          MinOrderQty \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          MaxOrderQty \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          OnOrderQty \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          UnitMeasureCode \n",
      "          nchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ProductVendor  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          PurchaseOrderID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          PurchaseOrderID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          PurchaseOrderDetailID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          DueDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          OrderQty \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          UnitPrice \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          LineTotal \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          ReceivedQty \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          RejectedQty \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          StockedQty \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderDetail  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          PurchaseOrderID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          RevisionNumber \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          Status \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          EmployeeID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          VendorID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          ShipMethodID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          OrderDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          ShipDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          SubTotal \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          TaxAmt \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          Freight \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          TotalDue \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "PurchaseOrderHeader  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          SalesOrderID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          SalesOrderID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          SalesOrderDetailID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          CarrierTrackingNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          OrderQty \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          SpecialOfferID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          UnitPrice \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          UnitPriceDiscount \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          LineTotal \n",
      "          numeric \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderDetail  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          SalesOrderID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          RevisionNumber \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          OrderDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          DueDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          ShipDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          Status \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          OnlineOrderFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          SalesOrderNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          PurchaseOrderNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          AccountNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          CustomerID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          SalesPersonID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          TerritoryID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          BillToAddressID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          ShipToAddressID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          ShipMethodID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          CreditCardID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          CreditCardApprovalCode \n",
      "          varchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          CurrencyRateID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          SubTotal \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          TaxAmt \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          Freight \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          TotalDue \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          Comment \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeader  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeaderSalesReason  \n",
      "          SalesOrderID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeaderSalesReason  \n",
      "          SalesOrderID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeaderSalesReason  \n",
      "          SalesReasonID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeaderSalesReason  \n",
      "          SalesReasonID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesOrderHeaderSalesReason  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          TerritoryID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          SalesQuota \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          Bonus \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          CommissionPct \n",
      "          smallmoney \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          SalesYTD \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          SalesLastYear \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPerson  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPersonQuotaHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPersonQuotaHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPersonQuotaHistory  \n",
      "          QuotaDate \n",
      "          datetime \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPersonQuotaHistory  \n",
      "          SalesQuota \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPersonQuotaHistory  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesPersonQuotaHistory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesReason  \n",
      "          SalesReasonID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesReason  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesReason  \n",
      "          ReasonType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesReason  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTaxRate  \n",
      "          SalesTaxRateID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTaxRate  \n",
      "          StateProvinceID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTaxRate  \n",
      "          TaxType \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTaxRate  \n",
      "          TaxRate \n",
      "          smallmoney \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTaxRate  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTaxRate  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTaxRate  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          TerritoryID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          CountryRegionCode \n",
      "          nvarchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          Group \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          SalesYTD \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          SalesLastYear \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          CostYTD \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          CostLastYear \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          TerritoryID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          TerritoryID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          StartDate \n",
      "          datetime \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SalesTerritoryHistory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ScrapReason  \n",
      "          ScrapReasonID \n",
      "          smallint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ScrapReason  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ScrapReason  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Shift  \n",
      "          ShiftID \n",
      "          tinyint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Shift  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Shift  \n",
      "          StartTime \n",
      "          time \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Shift  \n",
      "          EndTime \n",
      "          time \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Shift  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShipMethod  \n",
      "          ShipMethodID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShipMethod  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShipMethod  \n",
      "          ShipBase \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShipMethod  \n",
      "          ShipRate \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShipMethod  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShipMethod  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShoppingCartItem  \n",
      "          ShoppingCartItemID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShoppingCartItem  \n",
      "          ShoppingCartID \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShoppingCartItem  \n",
      "          Quantity \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShoppingCartItem  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShoppingCartItem  \n",
      "          DateCreated \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "ShoppingCartItem  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          SpecialOfferID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          Description \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          DiscountPct \n",
      "          smallmoney \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          Type \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          Category \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          StartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          MinQty \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          MaxQty \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOffer  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOfferProduct  \n",
      "          SpecialOfferID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOfferProduct  \n",
      "          SpecialOfferID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOfferProduct  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOfferProduct  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOfferProduct  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "SpecialOfferProduct  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          StateProvinceID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          StateProvinceCode \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          CountryRegionCode \n",
      "          nvarchar \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          IsOnlyStateProvinceFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          TerritoryID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "StateProvince  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Store  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Store  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Store  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Store  \n",
      "          SalesPersonID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Store  \n",
      "          Demographics \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Store  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Store  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          TransactionID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          ReferenceOrderID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          ReferenceOrderLineID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          TransactionDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          TransactionType \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          Quantity \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          ActualCost \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistory  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          TransactionID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          ProductID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          ReferenceOrderID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          ReferenceOrderLineID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          TransactionDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          TransactionType \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          Quantity \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          ActualCost \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "TransactionHistoryArchive  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "UnitMeasure  \n",
      "          UnitMeasureCode \n",
      "          nchar \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "UnitMeasure  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "UnitMeasure  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          TelephoneNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          TelephoneSpecialInstructions \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          Street \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          StateProvince \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          CountryRegion \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          HomeAddressSpecialInstructions \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          EMailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          EMailSpecialInstructions \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          EMailTelephoneNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vAdditionalContactInfo  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          JobTitle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          PhoneNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          PhoneNumberType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          EmailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          EmailPromotion \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          AddressLine1 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          AddressLine2 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          StateProvinceName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          CountryRegionName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployee  \n",
      "          AdditionalContactInfo \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          JobTitle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          Department \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          GroupName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartment  \n",
      "          StartDate \n",
      "          date \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          Shift \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          Department \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          GroupName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          StartDate \n",
      "          date \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vEmployeeDepartmentHistory  \n",
      "          EndDate \n",
      "          date \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          AccountNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          CreditRating \n",
      "          tinyint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          PreferredVendorStatus \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          ActiveFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          PurchasingWebServiceURL \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "Vendor  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          PhoneNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          PhoneNumberType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          EmailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          EmailPromotion \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          AddressType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          AddressLine1 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          AddressLine2 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          StateProvinceName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          CountryRegionName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vIndividualCustomer  \n",
      "          Demographics \n",
      "          xml \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          JobCandidateID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Name.Prefix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Name.First \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Name.Middle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Name.Last \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Name.Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Skills \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Addr.Type \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Addr.Loc.CountryRegion \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Addr.Loc.State \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Addr.Loc.City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          Addr.PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          EMail \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          WebSite \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidate  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          JobCandidateID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.Level \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.StartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.Degree \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.Major \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.Minor \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.GPA \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.GPAScale \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.School \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.Loc.CountryRegion \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.Loc.State \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEducation  \n",
      "          Edu.Loc.City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          JobCandidateID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.StartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.OrgName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.JobTitle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.Responsibility \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.FunctionCategory \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.IndustryCategory \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.Loc.CountryRegion \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.Loc.State \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vJobCandidateEmployment  \n",
      "          Emp.Loc.City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          TotalPurchaseYTD \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          DateFirstPurchase \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          BirthDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          MaritalStatus \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          YearlyIncome \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          Gender \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          TotalChildren \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          NumberChildrenAtHome \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          Education \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          Occupation \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          HomeOwnerFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vPersonDemographics  \n",
      "          NumberCarsOwned \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductAndDescription  \n",
      "          ProductID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductAndDescription  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductAndDescription  \n",
      "          ProductModel \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductAndDescription  \n",
      "          CultureID \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductAndDescription  \n",
      "          Description \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          ProductModelID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Summary \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Manufacturer \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Copyright \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          ProductURL \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          WarrantyPeriod \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          WarrantyDescription \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          NoOfYears \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          MaintenanceDescription \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Wheel \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Saddle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Pedal \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          BikeFrame \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Crankset \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          PictureAngle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          PictureSize \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          ProductPhotoID \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Material \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Color \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          ProductLine \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          Style \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          RiderExperience \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelCatalogDescription  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          ProductModelID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          Instructions \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          LocationID \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          SetupHours \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          MachineHours \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          LaborHours \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          LotSize \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          Step \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          rowguid \n",
      "          uniqueidentifier \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vProductModelInstructions  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          JobTitle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          PhoneNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          PhoneNumberType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          EmailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          EmailPromotion \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          AddressLine1 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          AddressLine2 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          StateProvinceName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          CountryRegionName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          TerritoryName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          TerritoryGroup \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          SalesQuota \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          SalesYTD \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPerson  \n",
      "          SalesLastYear \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPersonSalesByFiscalYears  \n",
      "          SalesPersonID \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPersonSalesByFiscalYears  \n",
      "          FullName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPersonSalesByFiscalYears  \n",
      "          JobTitle \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPersonSalesByFiscalYears  \n",
      "          SalesTerritory \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vSalesPersonSalesByFiscalYears  \n",
      "          2002 \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPersonSalesByFiscalYears  \n",
      "          2003 \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vSalesPersonSalesByFiscalYears  \n",
      "          2004 \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStateProvinceCountryRegion  \n",
      "          StateProvinceID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStateProvinceCountryRegion  \n",
      "          StateProvinceCode \n",
      "          nchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStateProvinceCountryRegion  \n",
      "          IsOnlyStateProvinceFlag \n",
      "          bit \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStateProvinceCountryRegion  \n",
      "          StateProvinceName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStateProvinceCountryRegion  \n",
      "          TerritoryID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStateProvinceCountryRegion  \n",
      "          CountryRegionCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStateProvinceCountryRegion  \n",
      "          CountryRegionName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          AddressType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          AddressLine1 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          AddressLine2 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          StateProvinceName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithAddresses  \n",
      "          CountryRegionName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          ContactType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          PhoneNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          PhoneNumberType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          EmailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithContacts  \n",
      "          EmailPromotion \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          AnnualSales \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          AnnualRevenue \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          BankName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          BusinessType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          YearOpened \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          Specialty \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          SquareFeet \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          Brands \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          Internet \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vStoreWithDemographics  \n",
      "          NumberEmployees \n",
      "          int \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          AddressType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          AddressLine1 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          AddressLine2 \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          City \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          StateProvinceName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          PostalCode \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithAddresses  \n",
      "          CountryRegionName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          BusinessEntityID \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          Name \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          ContactType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          Title \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          FirstName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          MiddleName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          LastName \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          Suffix \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          PhoneNumber \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          PhoneNumberType \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          EmailAddress \n",
      "          nvarchar \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "vVendorWithContacts  \n",
      "          EmailPromotion \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          WorkOrderID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          ProductID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          OrderQty \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          StockedQty \n",
      "          int \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          ScrappedQty \n",
      "          smallint \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          StartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          EndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          DueDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          ScrapReasonID \n",
      "          smallint \n",
      "          FOREIGN KEY\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "WorkOrder  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          WorkOrderID \n",
      "          int \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          WorkOrderID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ProductID \n",
      "          int \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          OperationSequence \n",
      "          smallint \n",
      "          PRIMARY KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          LocationID \n",
      "          smallint \n",
      "          FOREIGN KEY\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ScheduledStartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ScheduledEndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ActualStartDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ActualEndDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ActualResourceHrs \n",
      "          decimal \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          PlannedCost \n",
      "          money \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ActualCost \n",
      "          money \n",
      "          No Constraint\n",
      "          Nullable\n",
      "        \n",
      "\n",
      "WorkOrderRouting  \n",
      "          ModifiedDate \n",
      "          datetime \n",
      "          No Constraint\n",
      "          Not Nullable\n",
      "        \n"
     ]
    }
   ],
   "source": [
    "select_schema = \"\"\"\n",
    "SELECT\n",
    "    col.TABLE_NAME,\n",
    "    col.COLUMN_NAME,\n",
    "    col.DATA_TYPE,\n",
    "    ISNULL(tc.CONSTRAINT_TYPE, 'NONE') AS CONSTRAINT_TYPE,\n",
    "    col.IS_NULLABLE\n",
    "FROM\n",
    "    INFORMATION_SCHEMA.COLUMNS col\n",
    "LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu\n",
    "    ON col.COLUMN_NAME = kcu.COLUMN_NAME AND col.TABLE_NAME = kcu.TABLE_NAME\n",
    "LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc\n",
    "    ON kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME AND kcu.TABLE_NAME = tc.TABLE_NAME\n",
    "ORDER BY\n",
    "    col.TABLE_NAME,\n",
    "    col.ORDINAL_POSITION;\n",
    "\"\"\"\n",
    "\n",
    "cursor.execute(select_schema)\n",
    "\n",
    "\n",
    "columns = cursor.fetchall()\n",
    "print(\"Table, and Column Details in the current database:\")\n",
    "for column in columns:\n",
    "    print(f\"\"\"\\n{column.TABLE_NAME}  \n",
    "          {column.COLUMN_NAME} \n",
    "          {column.DATA_TYPE} \n",
    "          {'No Constraint' if column.CONSTRAINT_TYPE == 'NONE' else column.CONSTRAINT_TYPE}\n",
    "          {'Nullable' if column.IS_NULLABLE == 'YES' else 'Not Nullable'}\n",
    "        \"\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "First 10 rows:\n"
     ]
    }
   ],
   "source": [
    "get_query = \"\"\"SELECT TOP 10 * \n",
    "FROM dbo.Database_Schema\"\"\"\n",
    "\n",
    "cursor.execute(get_query)\n",
    "\n",
    "# Fetch and print the results\n",
    "rows = cursor.fetchall()\n",
    "print(\"First 10 rows:\")\n",
    "for row in rows:\n",
    "    print(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute(\"INSERT INTO dbo.Database_Schema (TableName, ColumnName, DataType, ConstraintType, Nullable) values(?,?,?,?,?)\", \"1\", \"2\", \"3\", \"4\", \"5\")\n",
    "\n",
    "conn.commit()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}