SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create table ["table"]
  (id int);
insert into ["table"]
values (1), (2);
2 rows affected

WITH fk_info AS (
    SELECT 
        JSON_QUERY(
            '[' + STRING_AGG(
                CONVERT(nvarchar(max),
                JSON_QUERY(N'{"schema": "' + COALESCE(REPLACE(kcu.CONSTRAINT_SCHEMA, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            '", "table": "' + COALESCE(REPLACE(kcu.TABLE_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            '", "column": "' + COALESCE(REPLACE(kcu.COLUMN_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            '", "foreign_key_name": "' + COALESCE(REPLACE(kcu.CONSTRAINT_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            '", "reference_table": "' + COALESCE(REPLACE(rcu.TABLE_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            '", "reference_column": "' + COALESCE(REPLACE(rcu.COLUMN_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            '", "fk_def": "FOREIGN KEY (' + COALESCE(REPLACE(kcu.COLUMN_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            ') REFERENCES ' + COALESCE(REPLACE(rcu.TABLE_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            '(' + COALESCE(REPLACE(rcu.COLUMN_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            ') ON DELETE ' + rc.DELETE_RULE COLLATE SQL_Latin1_General_CP1_CI_AS + 
                            ' ON UPDATE ' + rc.UPDATE_RULE COLLATE SQL_Latin1_General_CP1_CI_AS + '"}')
                ), ','
            ) + N']'
        ) AS all_fks_json
    FROM 
        INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu
    JOIN 
        INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc 
        ON kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME 
        AND kcu.CONSTRAINT_SCHEMA = rc.CONSTRAINT_SCHEMA
    JOIN 
        INFORMATION_SCHEMA.KEY_COLUMN_USAGE rcu 
        ON rcu.CONSTRAINT_NAME = rc.UNIQUE_CONSTRAINT_NAME 
        AND rcu.CONSTRAINT_SCHEMA = rc.UNIQUE_CONSTRAINT_SCHEMA
        AND rcu.ORDINAL_POSITION = kcu.ORDINAL_POSITION
), pk_info AS (
    SELECT 
        JSON_QUERY(
            '[' + STRING_AGG(
                CONVERT(nvarchar(max),
                JSON_QUERY(N'{"schema": "' + COALESCE(REPLACE(pk.TABLE_SCHEMA, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "table": "' + COALESCE(REPLACE(pk.TABLE_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "column": "' + COALESCE(REPLACE(pk.COLUMN_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "pk_def": "PRIMARY KEY (' + pk.COLUMN_NAME COLLATE SQL_Latin1_General_CP1_CI_AS + ')"}')
                ), ','
            ) + N']'
        ) AS all_pks_json
    FROM 
        (
            SELECT 
                kcu.TABLE_SCHEMA,
                kcu.TABLE_NAME,
                kcu.COLUMN_NAME
            FROM 
                INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu
            JOIN 
                INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc 
                ON kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME 
                AND kcu.CONSTRAINT_SCHEMA = tc.CONSTRAINT_SCHEMA
            WHERE 
                tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
        ) pk
), 
cols AS (
    SELECT 
        JSON_QUERY(
            '[' + STRING_AGG(
                CONVERT(nvarchar(max),
                JSON_QUERY('{"schema": "' + COALESCE(REPLACE(cols.TABLE_SCHEMA, '"', ''), '') +
                '", "table": "' + COALESCE(REPLACE(cols.TABLE_NAME, '"', ''), '') + 
                '", "name": "' + COALESCE(REPLACE(cols.COLUMN_NAME, '"', ''), '') + 
                '", "ordinal_position": "' + CAST(cols.ORDINAL_POSITION AS NVARCHAR(MAX)) + 
                '", "type": "' + LOWER(cols.DATA_TYPE) + 
                '", "character_maximum_length": "' + 
                    COALESCE(CAST(cols.CHARACTER_MAXIMUM_LENGTH AS NVARCHAR(MAX)), 'null') + 
                '", "precision": ' + 
                    CASE 
                        WHEN cols.DATA_TYPE IN ('numeric', 'decimal') THEN 
                            CONCAT('{"precision":', COALESCE(CAST(cols.NUMERIC_PRECISION AS NVARCHAR(MAX)), 'null'), 
                            ',"scale":', COALESCE(CAST(cols.NUMERIC_SCALE AS NVARCHAR(MAX)), 'null'), '}')
                        ELSE 
                            'null' 
                    END + 
                ', "nullable": "' + 
                    CASE WHEN cols.IS_NULLABLE = 'YES' THEN 'true' ELSE 'false' END + 
                '", "default": "' + 
                    COALESCE(REPLACE(CAST(cols.COLUMN_DEFAULT AS NVARCHAR(MAX)), '"', '\\"'), '') +
                '", "collation": "' + 
                    COALESCE(cols.COLLATION_NAME, '') + 
                '"}') 
                ), ','
            ) + ']'
        ) AS all_columns_json
    FROM 
        INFORMATION_SCHEMA.COLUMNS cols
    WHERE 
        cols.TABLE_CATALOG = DB_NAME()
), 
indexes AS (
    SELECT 
        '[' + STRING_AGG(
            CONVERT(nvarchar(max),
            JSON_QUERY(
                N'{"schema": "' + COALESCE(REPLACE(s.name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "table": "' + COALESCE(REPLACE(t.name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "index_name": "' + COALESCE(REPLACE(i.name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "column_name": "' + COALESCE(REPLACE(c.name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "index_type": "' + LOWER(i.type_desc) COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "is_unique": ' + CASE WHEN i.is_unique = 1 THEN 'true' ELSE 'false' END + 
                ', "direction": "' + CASE WHEN ic.is_descending_key = 1 THEN 'desc' ELSE 'asc' END COLLATE SQL_Latin1_General_CP1_CI_AS + '"}'
            )
            ), ','
        ) + N']' AS all_indexes_json
    FROM 
        sys.indexes i
    JOIN 
        sys.tables t ON i.object_id = t.object_id
    JOIN 
        sys.schemas s ON t.schema_id = s.schema_id
    JOIN 
        sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
    JOIN 
        sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
    WHERE 
        s.name LIKE '%' 
        AND i.name IS NOT NULL
),
tbls AS (
    SELECT 
        '[' + STRING_AGG(
            CONVERT(nvarchar(max),
            JSON_QUERY(
                N'{"schema": "' + COALESCE(REPLACE(aggregated.schema_name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "table": "' + COALESCE(REPLACE(aggregated.table_name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "row_count": "' + CAST(aggregated.row_count AS NVARCHAR(MAX)) + 
                '", "table_type": "' + aggregated.table_type COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "creation_date": "' + CONVERT(NVARCHAR(MAX), aggregated.creation_date, 120) + '"}'
            )
            ), ','
        ) + N']' AS all_tables_json
    FROM 
        (
            SELECT 
                COALESCE(REPLACE(s.name, '"', ''), '') AS schema_name,
                COALESCE(REPLACE(t.name, '"', ''), '') AS table_name,
                SUM(p.rows) AS row_count,
                t.type_desc AS table_type,
                t.create_date AS creation_date
            FROM 
                sys.tables t
            JOIN 
                sys.schemas s ON t.schema_id = s.schema_id
            JOIN 
                sys.partitions p ON t.object_id = p.object_id AND p.index_id IN (0, 1)
            WHERE 
                s.name LIKE '%' 
            GROUP BY 
                s.name, t.name, t.type_desc, t.create_date
        ) AS aggregated
),
views AS (
    SELECT 
        '[' + STRING_AGG(
            CONVERT(nvarchar(max),
            JSON_QUERY(
                N'{"schema": "' + COALESCE(REPLACE(s.name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + 
                '", "view_name": "' + COALESCE(REPLACE(v.name, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS + '"}'
            )
            ), ','
        ) + N']' AS all_views_json
    FROM 
        sys.views v
    JOIN 
        sys.schemas s ON v.schema_id = s.schema_id
    WHERE 
        s.name LIKE '%'
)
SELECT JSON_QUERY(
        N'{"fk_info": ' + ISNULL((SELECT cast(all_fks_json as nvarchar(max)) FROM fk_info), N'[]') + 
        ', "pk_info": ' + ISNULL((SELECT cast(all_pks_json as nvarchar(max)) FROM pk_info), N'[]') + 
        ', "columns": ' + ISNULL((SELECT cast(all_columns_json as nvarchar(max)) FROM cols), N'[]') + 
        ', "indexes": ' + ISNULL((SELECT cast(all_indexes_json as nvarchar(max)) FROM indexes), N'[]') + 
        ', "tables": ' + ISNULL((SELECT cast(all_tables_json as nvarchar(max)) FROM tbls), N'[]') + 
        ', "views": ' + ISNULL((SELECT cast(all_views_json as nvarchar(max)) FROM views), N'[]') + 
        ', "database_name": "' + DB_NAME() + '"' +
        ', "version": ""}'
) AS full_json_result;


full_json_result


{"fk_info": [{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "column": "DepartmentID", "foreign_key_name": "FK_EmployeeDepartmentHistory_Department_DepartmentID", "reference_table": "Department", "reference_column": "DepartmentID", "fk_def": "FOREIGN KEY (DepartmentID) REFERENCES Department(DepartmentID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "column": "BusinessEntityID", "foreign_key_name": "FK_EmployeeDepartmentHistory_Employee_BusinessEntityID", "reference_table": "Employee", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Employee(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesPerson", "column": "BusinessEntityID", "foreign_key_name": "FK_SalesPerson_Employee_BusinessEntityID", "reference_table": "Employee", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Employee(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "column": "EmployeeID", "foreign_key_name": "FK_PurchaseOrderHeader_Employee_EmployeeID", "reference_table": "Employee", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (EmployeeID) REFERENCES Employee(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "Document", "column": "Owner", "foreign_key_name": "FK_Document_Employee_Owner", "reference_table": "Employee", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (Owner) REFERENCES Employee(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "HumanResources", "table": "EmployeePayHistory", "column": "BusinessEntityID", "foreign_key_name": "FK_EmployeePayHistory_Employee_BusinessEntityID", "reference_table": "Employee", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Employee(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "HumanResources", "table": "JobCandidate", "column": "BusinessEntityID", "foreign_key_name": "FK_JobCandidate_Employee_BusinessEntityID", "reference_table": "Employee", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Employee(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "column": "ShiftID", "foreign_key_name": "FK_EmployeeDepartmentHistory_Shift_ShiftID", "reference_table": "Shift", "reference_column": "ShiftID", "fk_def": "FOREIGN KEY (ShiftID) REFERENCES Shift(ShiftID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "BillToAddressID", "foreign_key_name": "FK_SalesOrderHeader_Address_BillToAddressID", "reference_table": "Address", "reference_column": "AddressID", "fk_def": "FOREIGN KEY (BillToAddressID) REFERENCES Address(AddressID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "ShipToAddressID", "foreign_key_name": "FK_SalesOrderHeader_Address_ShipToAddressID", "reference_table": "Address", "reference_column": "AddressID", "fk_def": "FOREIGN KEY (ShipToAddressID) REFERENCES Address(AddressID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "BusinessEntityAddress", "column": "AddressID", "foreign_key_name": "FK_BusinessEntityAddress_Address_AddressID", "reference_table": "Address", "reference_column": "AddressID", "fk_def": "FOREIGN KEY (AddressID) REFERENCES Address(AddressID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "BusinessEntityAddress", "column": "AddressTypeID", "foreign_key_name": "FK_BusinessEntityAddress_AddressType_AddressTypeID", "reference_table": "AddressType", "reference_column": "AddressTypeID", "fk_def": "FOREIGN KEY (AddressTypeID) REFERENCES AddressType(AddressTypeID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "Store", "column": "BusinessEntityID", "foreign_key_name": "FK_Store_BusinessEntity_BusinessEntityID", "reference_table": "BusinessEntity", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES BusinessEntity(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "Vendor", "column": "BusinessEntityID", "foreign_key_name": "FK_Vendor_BusinessEntity_BusinessEntityID", "reference_table": "BusinessEntity", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES BusinessEntity(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "Person", "column": "BusinessEntityID", "foreign_key_name": "FK_Person_BusinessEntity_BusinessEntityID", "reference_table": "BusinessEntity", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES BusinessEntity(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "BusinessEntityAddress", "column": "BusinessEntityID", "foreign_key_name": "FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID", "reference_table": "BusinessEntity", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES BusinessEntity(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "BusinessEntityContact", "column": "BusinessEntityID", "foreign_key_name": "FK_BusinessEntityContact_BusinessEntity_BusinessEntityID", "reference_table": "BusinessEntity", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES BusinessEntity(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "BusinessEntityContact", "column": "ContactTypeID", "foreign_key_name": "FK_BusinessEntityContact_ContactType_ContactTypeID", "reference_table": "ContactType", "reference_column": "ContactTypeID", "fk_def": "FOREIGN KEY (ContactTypeID) REFERENCES ContactType(ContactTypeID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesTerritory", "column": "CountryRegionCode", "foreign_key_name": "FK_SalesTerritory_CountryRegion_CountryRegionCode", "reference_table": "CountryRegion", "reference_column": "CountryRegionCode", "fk_def": "FOREIGN KEY (CountryRegionCode) REFERENCES CountryRegion(CountryRegionCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "CountryRegionCurrency", "column": "CountryRegionCode", "foreign_key_name": "FK_CountryRegionCurrency_CountryRegion_CountryRegionCode", "reference_table": "CountryRegion", "reference_column": "CountryRegionCode", "fk_def": "FOREIGN KEY (CountryRegionCode) REFERENCES CountryRegion(CountryRegionCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "StateProvince", "column": "CountryRegionCode", "foreign_key_name": "FK_StateProvince_CountryRegion_CountryRegionCode", "reference_table": "CountryRegion", "reference_column": "CountryRegionCode", "fk_def": "FOREIGN KEY (CountryRegionCode) REFERENCES CountryRegion(CountryRegionCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "HumanResources", "table": "Employee", "column": "BusinessEntityID", "foreign_key_name": "FK_Employee_Person_BusinessEntityID", "reference_table": "Person", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Person(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "Customer", "column": "PersonID", "foreign_key_name": "FK_Customer_Person_PersonID", "reference_table": "Person", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (PersonID) REFERENCES Person(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "PersonCreditCard", "column": "BusinessEntityID", "foreign_key_name": "FK_PersonCreditCard_Person_BusinessEntityID", "reference_table": "Person", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Person(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "PersonPhone", "column": "BusinessEntityID", "foreign_key_name": "FK_PersonPhone_Person_BusinessEntityID", "reference_table": "Person", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Person(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "BusinessEntityContact", "column": "PersonID", "foreign_key_name": "FK_BusinessEntityContact_Person_PersonID", "reference_table": "Person", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (PersonID) REFERENCES Person(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "EmailAddress", "column": "BusinessEntityID", "foreign_key_name": "FK_EmailAddress_Person_BusinessEntityID", "reference_table": "Person", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Person(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "Password", "column": "BusinessEntityID", "foreign_key_name": "FK_Password_Person_BusinessEntityID", "reference_table": "Person", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Person(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "PersonPhone", "column": "PhoneNumberTypeID", "foreign_key_name": "FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID", "reference_table": "PhoneNumberType", "reference_column": "PhoneNumberTypeID", "fk_def": "FOREIGN KEY (PhoneNumberTypeID) REFERENCES PhoneNumberType(PhoneNumberTypeID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesTaxRate", "column": "StateProvinceID", "foreign_key_name": "FK_SalesTaxRate_StateProvince_StateProvinceID", "reference_table": "StateProvince", "reference_column": "StateProvinceID", "fk_def": "FOREIGN KEY (StateProvinceID) REFERENCES StateProvince(StateProvinceID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "Address", "column": "StateProvinceID", "foreign_key_name": "FK_Address_StateProvince_StateProvinceID", "reference_table": "StateProvince", "reference_column": "StateProvinceID", "fk_def": "FOREIGN KEY (StateProvinceID) REFERENCES StateProvince(StateProvinceID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "column": "CultureID", "foreign_key_name": "FK_ProductModelProductDescriptionCulture_Culture_CultureID", "reference_table": "Culture", "reference_column": "CultureID", "fk_def": "FOREIGN KEY (CultureID) REFERENCES Culture(CultureID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductDocument", "column": "DocumentNode", "foreign_key_name": "FK_ProductDocument_Document_DocumentNode", "reference_table": "Document", "reference_column": "DocumentNode", "fk_def": "FOREIGN KEY (DocumentNode) REFERENCES Document(DocumentNode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductModelIllustration", "column": "IllustrationID", "foreign_key_name": "FK_ProductModelIllustration_Illustration_IllustrationID", "reference_table": "Illustration", "reference_column": "IllustrationID", "fk_def": "FOREIGN KEY (IllustrationID) REFERENCES Illustration(IllustrationID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "WorkOrderRouting", "column": "LocationID", "foreign_key_name": "FK_WorkOrderRouting_Location_LocationID", "reference_table": "Location", "reference_column": "LocationID", "fk_def": "FOREIGN KEY (LocationID) REFERENCES Location(LocationID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductInventory", "column": "LocationID", "foreign_key_name": "FK_ProductInventory_Location_LocationID", "reference_table": "Location", "reference_column": "LocationID", "fk_def": "FOREIGN KEY (LocationID) REFERENCES Location(LocationID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "ShoppingCartItem", "column": "ProductID", "foreign_key_name": "FK_ShoppingCartItem_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SpecialOfferProduct", "column": "ProductID", "foreign_key_name": "FK_SpecialOfferProduct_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "ProductVendor", "column": "ProductID", "foreign_key_name": "FK_ProductVendor_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "column": "ProductID", "foreign_key_name": "FK_PurchaseOrderDetail_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "WorkOrder", "column": "ProductID", "foreign_key_name": "FK_WorkOrder_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductProductPhoto", "column": "ProductID", "foreign_key_name": "FK_ProductProductPhoto_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductReview", "column": "ProductID", "foreign_key_name": "FK_ProductReview_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "TransactionHistory", "column": "ProductID", "foreign_key_name": "FK_TransactionHistory_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductInventory", "column": "ProductID", "foreign_key_name": "FK_ProductInventory_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductListPriceHistory", "column": "ProductID", "foreign_key_name": "FK_ProductListPriceHistory_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductCostHistory", "column": "ProductID", "foreign_key_name": "FK_ProductCostHistory_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductDocument", "column": "ProductID", "foreign_key_name": "FK_ProductDocument_Product_ProductID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "BillOfMaterials", "column": "ComponentID", "foreign_key_name": "FK_BillOfMaterials_Product_ComponentID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ComponentID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "BillOfMaterials", "column": "ProductAssemblyID", "foreign_key_name": "FK_BillOfMaterials_Product_ProductAssemblyID", "reference_table": "Product", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductAssemblyID) REFERENCES Product(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductSubcategory", "column": "ProductCategoryID", "foreign_key_name": "FK_ProductSubcategory_ProductCategory_ProductCategoryID", "reference_table": "ProductCategory", "reference_column": "ProductCategoryID", "fk_def": "FOREIGN KEY (ProductCategoryID) REFERENCES ProductCategory(ProductCategoryID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "column": "ProductDescriptionID", "foreign_key_name": "FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID", "reference_table": "ProductDescription", "reference_column": "ProductDescriptionID", "fk_def": "FOREIGN KEY (ProductDescriptionID) REFERENCES ProductDescription(ProductDescriptionID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "column": "ProductModelID", "foreign_key_name": "FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID", "reference_table": "ProductModel", "reference_column": "ProductModelID", "fk_def": "FOREIGN KEY (ProductModelID) REFERENCES ProductModel(ProductModelID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductModelIllustration", "column": "ProductModelID", "foreign_key_name": "FK_ProductModelIllustration_ProductModel_ProductModelID", "reference_table": "ProductModel", "reference_column": "ProductModelID", "fk_def": "FOREIGN KEY (ProductModelID) REFERENCES ProductModel(ProductModelID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "Product", "column": "ProductModelID", "foreign_key_name": "FK_Product_ProductModel_ProductModelID", "reference_table": "ProductModel", "reference_column": "ProductModelID", "fk_def": "FOREIGN KEY (ProductModelID) REFERENCES ProductModel(ProductModelID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "ProductProductPhoto", "column": "ProductPhotoID", "foreign_key_name": "FK_ProductProductPhoto_ProductPhoto_ProductPhotoID", "reference_table": "ProductPhoto", "reference_column": "ProductPhotoID", "fk_def": "FOREIGN KEY (ProductPhotoID) REFERENCES ProductPhoto(ProductPhotoID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "Product", "column": "ProductSubcategoryID", "foreign_key_name": "FK_Product_ProductSubcategory_ProductSubcategoryID", "reference_table": "ProductSubcategory", "reference_column": "ProductSubcategoryID", "fk_def": "FOREIGN KEY (ProductSubcategoryID) REFERENCES ProductSubcategory(ProductSubcategoryID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "WorkOrder", "column": "ScrapReasonID", "foreign_key_name": "FK_WorkOrder_ScrapReason_ScrapReasonID", "reference_table": "ScrapReason", "reference_column": "ScrapReasonID", "fk_def": "FOREIGN KEY (ScrapReasonID) REFERENCES ScrapReason(ScrapReasonID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "ProductVendor", "column": "UnitMeasureCode", "foreign_key_name": "FK_ProductVendor_UnitMeasure_UnitMeasureCode", "reference_table": "UnitMeasure", "reference_column": "UnitMeasureCode", "fk_def": "FOREIGN KEY (UnitMeasureCode) REFERENCES UnitMeasure(UnitMeasureCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "Product", "column": "SizeUnitMeasureCode", "foreign_key_name": "FK_Product_UnitMeasure_SizeUnitMeasureCode", "reference_table": "UnitMeasure", "reference_column": "UnitMeasureCode", "fk_def": "FOREIGN KEY (SizeUnitMeasureCode) REFERENCES UnitMeasure(UnitMeasureCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "Product", "column": "WeightUnitMeasureCode", "foreign_key_name": "FK_Product_UnitMeasure_WeightUnitMeasureCode", "reference_table": "UnitMeasure", "reference_column": "UnitMeasureCode", "fk_def": "FOREIGN KEY (WeightUnitMeasureCode) REFERENCES UnitMeasure(UnitMeasureCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "BillOfMaterials", "column": "UnitMeasureCode", "foreign_key_name": "FK_BillOfMaterials_UnitMeasure_UnitMeasureCode", "reference_table": "UnitMeasure", "reference_column": "UnitMeasureCode", "fk_def": "FOREIGN KEY (UnitMeasureCode) REFERENCES UnitMeasure(UnitMeasureCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Production", "table": "WorkOrderRouting", "column": "WorkOrderID", "foreign_key_name": "FK_WorkOrderRouting_WorkOrder_WorkOrderID", "reference_table": "WorkOrder", "reference_column": "WorkOrderID", "fk_def": "FOREIGN KEY (WorkOrderID) REFERENCES WorkOrder(WorkOrderID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "column": "PurchaseOrderID", "foreign_key_name": "FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID", "reference_table": "PurchaseOrderHeader", "reference_column": "PurchaseOrderID", "fk_def": "FOREIGN KEY (PurchaseOrderID) REFERENCES PurchaseOrderHeader(PurchaseOrderID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "ShipMethodID", "foreign_key_name": "FK_SalesOrderHeader_ShipMethod_ShipMethodID", "reference_table": "ShipMethod", "reference_column": "ShipMethodID", "fk_def": "FOREIGN KEY (ShipMethodID) REFERENCES ShipMethod(ShipMethodID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "column": "ShipMethodID", "foreign_key_name": "FK_PurchaseOrderHeader_ShipMethod_ShipMethodID", "reference_table": "ShipMethod", "reference_column": "ShipMethodID", "fk_def": "FOREIGN KEY (ShipMethodID) REFERENCES ShipMethod(ShipMethodID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "column": "VendorID", "foreign_key_name": "FK_PurchaseOrderHeader_Vendor_VendorID", "reference_table": "Vendor", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (VendorID) REFERENCES Vendor(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Purchasing", "table": "ProductVendor", "column": "BusinessEntityID", "foreign_key_name": "FK_ProductVendor_Vendor_BusinessEntityID", "reference_table": "Vendor", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES Vendor(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "CreditCardID", "foreign_key_name": "FK_SalesOrderHeader_CreditCard_CreditCardID", "reference_table": "CreditCard", "reference_column": "CreditCardID", "fk_def": "FOREIGN KEY (CreditCardID) REFERENCES CreditCard(CreditCardID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "PersonCreditCard", "column": "CreditCardID", "foreign_key_name": "FK_PersonCreditCard_CreditCard_CreditCardID", "reference_table": "CreditCard", "reference_column": "CreditCardID", "fk_def": "FOREIGN KEY (CreditCardID) REFERENCES CreditCard(CreditCardID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "CountryRegionCurrency", "column": "CurrencyCode", "foreign_key_name": "FK_CountryRegionCurrency_Currency_CurrencyCode", "reference_table": "Currency", "reference_column": "CurrencyCode", "fk_def": "FOREIGN KEY (CurrencyCode) REFERENCES Currency(CurrencyCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "CurrencyRate", "column": "FromCurrencyCode", "foreign_key_name": "FK_CurrencyRate_Currency_FromCurrencyCode", "reference_table": "Currency", "reference_column": "CurrencyCode", "fk_def": "FOREIGN KEY (FromCurrencyCode) REFERENCES Currency(CurrencyCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "CurrencyRate", "column": "ToCurrencyCode", "foreign_key_name": "FK_CurrencyRate_Currency_ToCurrencyCode", "reference_table": "Currency", "reference_column": "CurrencyCode", "fk_def": "FOREIGN KEY (ToCurrencyCode) REFERENCES Currency(CurrencyCode) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "CurrencyRateID", "foreign_key_name": "FK_SalesOrderHeader_CurrencyRate_CurrencyRateID", "reference_table": "CurrencyRate", "reference_column": "CurrencyRateID", "fk_def": "FOREIGN KEY (CurrencyRateID) REFERENCES CurrencyRate(CurrencyRateID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "CustomerID", "foreign_key_name": "FK_SalesOrderHeader_Customer_CustomerID", "reference_table": "Customer", "reference_column": "CustomerID", "fk_def": "FOREIGN KEY (CustomerID) REFERENCES Customer(CustomerID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "column": "SalesOrderID", "foreign_key_name": "FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID", "reference_table": "SalesOrderHeader", "reference_column": "SalesOrderID", "fk_def": "FOREIGN KEY (SalesOrderID) REFERENCES SalesOrderHeader(SalesOrderID) ON DELETE CASCADE ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderDetail", "column": "SalesOrderID", "foreign_key_name": "FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID", "reference_table": "SalesOrderHeader", "reference_column": "SalesOrderID", "fk_def": "FOREIGN KEY (SalesOrderID) REFERENCES SalesOrderHeader(SalesOrderID) ON DELETE CASCADE ON UPDATE NO ACTION"},{"schema": "Sales", "table": "Store", "column": "SalesPersonID", "foreign_key_name": "FK_Store_SalesPerson_SalesPersonID", "reference_table": "SalesPerson", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (SalesPersonID) REFERENCES SalesPerson(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "column": "BusinessEntityID", "foreign_key_name": "FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID", "reference_table": "SalesPerson", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES SalesPerson(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesTerritoryHistory", "column": "BusinessEntityID", "foreign_key_name": "FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID", "reference_table": "SalesPerson", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (BusinessEntityID) REFERENCES SalesPerson(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "SalesPersonID", "foreign_key_name": "FK_SalesOrderHeader_SalesPerson_SalesPersonID", "reference_table": "SalesPerson", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (SalesPersonID) REFERENCES SalesPerson(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "column": "SalesReasonID", "foreign_key_name": "FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID", "reference_table": "SalesReason", "reference_column": "SalesReasonID", "fk_def": "FOREIGN KEY (SalesReasonID) REFERENCES SalesReason(SalesReasonID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesPerson", "column": "TerritoryID", "foreign_key_name": "FK_SalesPerson_SalesTerritory_TerritoryID", "reference_table": "SalesTerritory", "reference_column": "TerritoryID", "fk_def": "FOREIGN KEY (TerritoryID) REFERENCES SalesTerritory(TerritoryID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesTerritoryHistory", "column": "TerritoryID", "foreign_key_name": "FK_SalesTerritoryHistory_SalesTerritory_TerritoryID", "reference_table": "SalesTerritory", "reference_column": "TerritoryID", "fk_def": "FOREIGN KEY (TerritoryID) REFERENCES SalesTerritory(TerritoryID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "TerritoryID", "foreign_key_name": "FK_SalesOrderHeader_SalesTerritory_TerritoryID", "reference_table": "SalesTerritory", "reference_column": "TerritoryID", "fk_def": "FOREIGN KEY (TerritoryID) REFERENCES SalesTerritory(TerritoryID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "Customer", "column": "TerritoryID", "foreign_key_name": "FK_Customer_SalesTerritory_TerritoryID", "reference_table": "SalesTerritory", "reference_column": "TerritoryID", "fk_def": "FOREIGN KEY (TerritoryID) REFERENCES SalesTerritory(TerritoryID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Person", "table": "StateProvince", "column": "TerritoryID", "foreign_key_name": "FK_StateProvince_SalesTerritory_TerritoryID", "reference_table": "SalesTerritory", "reference_column": "TerritoryID", "fk_def": "FOREIGN KEY (TerritoryID) REFERENCES SalesTerritory(TerritoryID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SpecialOfferProduct", "column": "SpecialOfferID", "foreign_key_name": "FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID", "reference_table": "SpecialOffer", "reference_column": "SpecialOfferID", "fk_def": "FOREIGN KEY (SpecialOfferID) REFERENCES SpecialOffer(SpecialOfferID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderDetail", "column": "ProductID", "foreign_key_name": "FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID", "reference_table": "SpecialOfferProduct", "reference_column": "ProductID", "fk_def": "FOREIGN KEY (ProductID) REFERENCES SpecialOfferProduct(ProductID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "SalesOrderDetail", "column": "SpecialOfferID", "foreign_key_name": "FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID", "reference_table": "SpecialOfferProduct", "reference_column": "SpecialOfferID", "fk_def": "FOREIGN KEY (SpecialOfferID) REFERENCES SpecialOfferProduct(SpecialOfferID) ON DELETE NO ACTION ON UPDATE NO ACTION"},{"schema": "Sales", "table": "Customer", "column": "StoreID", "foreign_key_name": "FK_Customer_Store_StoreID", "reference_table": "Store", "reference_column": "BusinessEntityID", "fk_def": "FOREIGN KEY (StoreID) REFERENCES Store(BusinessEntityID) ON DELETE NO ACTION ON UPDATE NO ACTION"}], "pk_info": [{"schema": "dbo", "table": "AWBuildVersion", "column": "SystemInformationID", "pk_def": "PRIMARY KEY (SystemInformationID)"},{"schema": "dbo", "table": "DatabaseLog", "column": "DatabaseLogID", "pk_def": "PRIMARY KEY (DatabaseLogID)"},{"schema": "dbo", "table": "ErrorLog", "column": "ErrorLogID", "pk_def": "PRIMARY KEY (ErrorLogID)"},{"schema": "HumanResources", "table": "Department", "column": "DepartmentID", "pk_def": "PRIMARY KEY (DepartmentID)"},{"schema": "HumanResources", "table": "Employee", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "column": "DepartmentID", "pk_def": "PRIMARY KEY (DepartmentID)"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "column": "ShiftID", "pk_def": "PRIMARY KEY (ShiftID)"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "column": "StartDate", "pk_def": "PRIMARY KEY (StartDate)"},{"schema": "HumanResources", "table": "EmployeePayHistory", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "HumanResources", "table": "EmployeePayHistory", "column": "RateChangeDate", "pk_def": "PRIMARY KEY (RateChangeDate)"},{"schema": "HumanResources", "table": "JobCandidate", "column": "JobCandidateID", "pk_def": "PRIMARY KEY (JobCandidateID)"},{"schema": "HumanResources", "table": "Shift", "column": "ShiftID", "pk_def": "PRIMARY KEY (ShiftID)"},{"schema": "Person", "table": "Address", "column": "AddressID", "pk_def": "PRIMARY KEY (AddressID)"},{"schema": "Person", "table": "AddressType", "column": "AddressTypeID", "pk_def": "PRIMARY KEY (AddressTypeID)"},{"schema": "Person", "table": "BusinessEntity", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Person", "table": "BusinessEntityAddress", "column": "AddressID", "pk_def": "PRIMARY KEY (AddressID)"},{"schema": "Person", "table": "BusinessEntityAddress", "column": "AddressTypeID", "pk_def": "PRIMARY KEY (AddressTypeID)"},{"schema": "Person", "table": "BusinessEntityAddress", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Person", "table": "BusinessEntityContact", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Person", "table": "BusinessEntityContact", "column": "ContactTypeID", "pk_def": "PRIMARY KEY (ContactTypeID)"},{"schema": "Person", "table": "BusinessEntityContact", "column": "PersonID", "pk_def": "PRIMARY KEY (PersonID)"},{"schema": "Person", "table": "ContactType", "column": "ContactTypeID", "pk_def": "PRIMARY KEY (ContactTypeID)"},{"schema": "Person", "table": "CountryRegion", "column": "CountryRegionCode", "pk_def": "PRIMARY KEY (CountryRegionCode)"},{"schema": "Person", "table": "EmailAddress", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Person", "table": "EmailAddress", "column": "EmailAddressID", "pk_def": "PRIMARY KEY (EmailAddressID)"},{"schema": "Person", "table": "Password", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Person", "table": "Person", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Person", "table": "PersonPhone", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Person", "table": "PersonPhone", "column": "PhoneNumber", "pk_def": "PRIMARY KEY (PhoneNumber)"},{"schema": "Person", "table": "PersonPhone", "column": "PhoneNumberTypeID", "pk_def": "PRIMARY KEY (PhoneNumberTypeID)"},{"schema": "Person", "table": "PhoneNumberType", "column": "PhoneNumberTypeID", "pk_def": "PRIMARY KEY (PhoneNumberTypeID)"},{"schema": "Person", "table": "StateProvince", "column": "StateProvinceID", "pk_def": "PRIMARY KEY (StateProvinceID)"},{"schema": "Production", "table": "BillOfMaterials", "column": "BillOfMaterialsID", "pk_def": "PRIMARY KEY (BillOfMaterialsID)"},{"schema": "Production", "table": "Culture", "column": "CultureID", "pk_def": "PRIMARY KEY (CultureID)"},{"schema": "Production", "table": "Document", "column": "DocumentNode", "pk_def": "PRIMARY KEY (DocumentNode)"},{"schema": "Production", "table": "Illustration", "column": "IllustrationID", "pk_def": "PRIMARY KEY (IllustrationID)"},{"schema": "Production", "table": "Location", "column": "LocationID", "pk_def": "PRIMARY KEY (LocationID)"},{"schema": "Production", "table": "Product", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Production", "table": "ProductCategory", "column": "ProductCategoryID", "pk_def": "PRIMARY KEY (ProductCategoryID)"},{"schema": "Production", "table": "ProductCostHistory", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Production", "table": "ProductCostHistory", "column": "StartDate", "pk_def": "PRIMARY KEY (StartDate)"},{"schema": "Production", "table": "ProductDescription", "column": "ProductDescriptionID", "pk_def": "PRIMARY KEY (ProductDescriptionID)"},{"schema": "Production", "table": "ProductDocument", "column": "DocumentNode", "pk_def": "PRIMARY KEY (DocumentNode)"},{"schema": "Production", "table": "ProductDocument", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Production", "table": "ProductInventory", "column": "LocationID", "pk_def": "PRIMARY KEY (LocationID)"},{"schema": "Production", "table": "ProductInventory", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Production", "table": "ProductListPriceHistory", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Production", "table": "ProductListPriceHistory", "column": "StartDate", "pk_def": "PRIMARY KEY (StartDate)"},{"schema": "Production", "table": "ProductModel", "column": "ProductModelID", "pk_def": "PRIMARY KEY (ProductModelID)"},{"schema": "Production", "table": "ProductModelIllustration", "column": "IllustrationID", "pk_def": "PRIMARY KEY (IllustrationID)"},{"schema": "Production", "table": "ProductModelIllustration", "column": "ProductModelID", "pk_def": "PRIMARY KEY (ProductModelID)"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "column": "CultureID", "pk_def": "PRIMARY KEY (CultureID)"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "column": "ProductDescriptionID", "pk_def": "PRIMARY KEY (ProductDescriptionID)"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "column": "ProductModelID", "pk_def": "PRIMARY KEY (ProductModelID)"},{"schema": "Production", "table": "ProductPhoto", "column": "ProductPhotoID", "pk_def": "PRIMARY KEY (ProductPhotoID)"},{"schema": "Production", "table": "ProductProductPhoto", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Production", "table": "ProductProductPhoto", "column": "ProductPhotoID", "pk_def": "PRIMARY KEY (ProductPhotoID)"},{"schema": "Production", "table": "ProductReview", "column": "ProductReviewID", "pk_def": "PRIMARY KEY (ProductReviewID)"},{"schema": "Production", "table": "ProductSubcategory", "column": "ProductSubcategoryID", "pk_def": "PRIMARY KEY (ProductSubcategoryID)"},{"schema": "Production", "table": "ScrapReason", "column": "ScrapReasonID", "pk_def": "PRIMARY KEY (ScrapReasonID)"},{"schema": "Production", "table": "TransactionHistory", "column": "TransactionID", "pk_def": "PRIMARY KEY (TransactionID)"},{"schema": "Production", "table": "TransactionHistoryArchive", "column": "TransactionID", "pk_def": "PRIMARY KEY (TransactionID)"},{"schema": "Production", "table": "UnitMeasure", "column": "UnitMeasureCode", "pk_def": "PRIMARY KEY (UnitMeasureCode)"},{"schema": "Production", "table": "WorkOrder", "column": "WorkOrderID", "pk_def": "PRIMARY KEY (WorkOrderID)"},{"schema": "Production", "table": "WorkOrderRouting", "column": "OperationSequence", "pk_def": "PRIMARY KEY (OperationSequence)"},{"schema": "Production", "table": "WorkOrderRouting", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Production", "table": "WorkOrderRouting", "column": "WorkOrderID", "pk_def": "PRIMARY KEY (WorkOrderID)"},{"schema": "Purchasing", "table": "ProductVendor", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Purchasing", "table": "ProductVendor", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "column": "PurchaseOrderDetailID", "pk_def": "PRIMARY KEY (PurchaseOrderDetailID)"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "column": "PurchaseOrderID", "pk_def": "PRIMARY KEY (PurchaseOrderID)"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "column": "PurchaseOrderID", "pk_def": "PRIMARY KEY (PurchaseOrderID)"},{"schema": "Purchasing", "table": "ShipMethod", "column": "ShipMethodID", "pk_def": "PRIMARY KEY (ShipMethodID)"},{"schema": "Purchasing", "table": "Vendor", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Sales", "table": "CountryRegionCurrency", "column": "CountryRegionCode", "pk_def": "PRIMARY KEY (CountryRegionCode)"},{"schema": "Sales", "table": "CountryRegionCurrency", "column": "CurrencyCode", "pk_def": "PRIMARY KEY (CurrencyCode)"},{"schema": "Sales", "table": "CreditCard", "column": "CreditCardID", "pk_def": "PRIMARY KEY (CreditCardID)"},{"schema": "Sales", "table": "Currency", "column": "CurrencyCode", "pk_def": "PRIMARY KEY (CurrencyCode)"},{"schema": "Sales", "table": "CurrencyRate", "column": "CurrencyRateID", "pk_def": "PRIMARY KEY (CurrencyRateID)"},{"schema": "Sales", "table": "Customer", "column": "CustomerID", "pk_def": "PRIMARY KEY (CustomerID)"},{"schema": "Sales", "table": "PersonCreditCard", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Sales", "table": "PersonCreditCard", "column": "CreditCardID", "pk_def": "PRIMARY KEY (CreditCardID)"},{"schema": "Sales", "table": "SalesOrderDetail", "column": "SalesOrderDetailID", "pk_def": "PRIMARY KEY (SalesOrderDetailID)"},{"schema": "Sales", "table": "SalesOrderDetail", "column": "SalesOrderID", "pk_def": "PRIMARY KEY (SalesOrderID)"},{"schema": "Sales", "table": "SalesOrderHeader", "column": "SalesOrderID", "pk_def": "PRIMARY KEY (SalesOrderID)"},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "column": "SalesOrderID", "pk_def": "PRIMARY KEY (SalesOrderID)"},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "column": "SalesReasonID", "pk_def": "PRIMARY KEY (SalesReasonID)"},{"schema": "Sales", "table": "SalesPerson", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "column": "QuotaDate", "pk_def": "PRIMARY KEY (QuotaDate)"},{"schema": "Sales", "table": "SalesReason", "column": "SalesReasonID", "pk_def": "PRIMARY KEY (SalesReasonID)"},{"schema": "Sales", "table": "SalesTaxRate", "column": "SalesTaxRateID", "pk_def": "PRIMARY KEY (SalesTaxRateID)"},{"schema": "Sales", "table": "SalesTerritory", "column": "TerritoryID", "pk_def": "PRIMARY KEY (TerritoryID)"},{"schema": "Sales", "table": "SalesTerritoryHistory", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"},{"schema": "Sales", "table": "SalesTerritoryHistory", "column": "StartDate", "pk_def": "PRIMARY KEY (StartDate)"},{"schema": "Sales", "table": "SalesTerritoryHistory", "column": "TerritoryID", "pk_def": "PRIMARY KEY (TerritoryID)"},{"schema": "Sales", "table": "ShoppingCartItem", "column": "ShoppingCartItemID", "pk_def": "PRIMARY KEY (ShoppingCartItemID)"},{"schema": "Sales", "table": "SpecialOffer", "column": "SpecialOfferID", "pk_def": "PRIMARY KEY (SpecialOfferID)"},{"schema": "Sales", "table": "SpecialOfferProduct", "column": "ProductID", "pk_def": "PRIMARY KEY (ProductID)"},{"schema": "Sales", "table": "SpecialOfferProduct", "column": "SpecialOfferID", "pk_def": "PRIMARY KEY (SpecialOfferID)"},{"schema": "Sales", "table": "Store", "column": "BusinessEntityID", "pk_def": "PRIMARY KEY (BusinessEntityID)"}], "columns": [{"schema": "HumanResources", "table": "EmployeePayHistory", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeePayHistory", "name": "RateChangeDate", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeePayHistory", "name": "Rate", "ordinal_position": "3", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeePayHistory", "name": "PayFrequency", "ordinal_position": "4", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeePayHistory", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "name": "SalesOrderID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "name": "SalesReasonID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "TerritoryID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "SalesQuota", "ordinal_position": "3", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "Bonus", "ordinal_position": "4", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "CommissionPct", "ordinal_position": "5", "type": "smallmoney", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "SalesYTD", "ordinal_position": "6", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "SalesLastYear", "ordinal_position": "7", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "rowguid", "ordinal_position": "8", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPerson", "name": "ModifiedDate", "ordinal_position": "9", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Illustration", "name": "IllustrationID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Illustration", "name": "Diagram", "ordinal_position": "2", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Illustration", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "JobCandidate", "name": "JobCandidateID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "JobCandidate", "name": "BusinessEntityID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "JobCandidate", "name": "Resume", "ordinal_position": "3", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "JobCandidate", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Location", "name": "LocationID", "ordinal_position": "1", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Location", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Location", "name": "CostRate", "ordinal_position": "3", "type": "smallmoney", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Location", "name": "Availability", "ordinal_position": "4", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":8,"scale":2}, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Location", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "FirstName", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "MiddleName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "LastName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "TelephoneNumber", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "TelephoneSpecialInstructions", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "Street", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "City", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "StateProvince", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "PostalCode", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "CountryRegion", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "HomeAddressSpecialInstructions", "ordinal_position": "12", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "EMailAddress", "ordinal_position": "13", "type": "nvarchar", "character_maximum_length": "128", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "EMailSpecialInstructions", "ordinal_position": "14", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "EMailTelephoneNumber", "ordinal_position": "15", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "rowguid", "ordinal_position": "16", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "vAdditionalContactInfo", "name": "ModifiedDate", "ordinal_position": "17", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployee", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployee", "name": "Title", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "FirstName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "MiddleName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "LastName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "Suffix", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "JobTitle", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "PhoneNumber", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "PhoneNumberType", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "EmailAddress", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "EmailPromotion", "ordinal_position": "11", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployee", "name": "AddressLine1", "ordinal_position": "12", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "AddressLine2", "ordinal_position": "13", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "City", "ordinal_position": "14", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "StateProvinceName", "ordinal_position": "15", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "PostalCode", "ordinal_position": "16", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "CountryRegionName", "ordinal_position": "17", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployee", "name": "AdditionalContactInfo", "ordinal_position": "18", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Person", "table": "Password", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Password", "name": "PasswordHash", "ordinal_position": "2", "type": "varchar", "character_maximum_length": "128", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Password", "name": "PasswordSalt", "ordinal_position": "3", "type": "varchar", "character_maximum_length": "10", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Password", "name": "rowguid", "ordinal_position": "4", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Password", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "Title", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "FirstName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "MiddleName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "LastName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "Suffix", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "JobTitle", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "Department", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "GroupName", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartment", "name": "StartDate", "ordinal_position": "10", "type": "date", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "Title", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "FirstName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "MiddleName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "LastName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "Suffix", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "Shift", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "Department", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "GroupName", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "StartDate", "ordinal_position": "10", "type": "date", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vEmployeeDepartmentHistory", "name": "EndDate", "ordinal_position": "11", "type": "date", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "name": "QuotaDate", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "name": "SalesQuota", "ordinal_position": "3", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "name": "rowguid", "ordinal_position": "4", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vIndividualCustomer", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vIndividualCustomer", "name": "Title", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "FirstName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "MiddleName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "LastName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "Suffix", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "PhoneNumber", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "PhoneNumberType", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "EmailAddress", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "EmailPromotion", "ordinal_position": "10", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vIndividualCustomer", "name": "AddressType", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "AddressLine1", "ordinal_position": "12", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "AddressLine2", "ordinal_position": "13", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "City", "ordinal_position": "14", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "StateProvinceName", "ordinal_position": "15", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "PostalCode", "ordinal_position": "16", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "CountryRegionName", "ordinal_position": "17", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vIndividualCustomer", "name": "Demographics", "ordinal_position": "18", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Person", "table": "Person", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Person", "name": "PersonType", "ordinal_position": "2", "type": "nchar", "character_maximum_length": "2", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Person", "name": "NameStyle", "ordinal_position": "3", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Person", "name": "Title", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Person", "name": "FirstName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Person", "name": "MiddleName", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Person", "name": "LastName", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Person", "name": "Suffix", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Person", "name": "EmailPromotion", "ordinal_position": "9", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Person", "name": "AdditionalContactInfo", "ordinal_position": "10", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Person", "table": "Person", "name": "Demographics", "ordinal_position": "11", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Person", "table": "Person", "name": "rowguid", "ordinal_position": "12", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Person", "name": "ModifiedDate", "ordinal_position": "13", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "TotalPurchaseYTD", "ordinal_position": "2", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "DateFirstPurchase", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "BirthDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "MaritalStatus", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vPersonDemographics", "name": "YearlyIncome", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vPersonDemographics", "name": "Gender", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vPersonDemographics", "name": "TotalChildren", "ordinal_position": "8", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "NumberChildrenAtHome", "ordinal_position": "9", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "Education", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vPersonDemographics", "name": "Occupation", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vPersonDemographics", "name": "HomeOwnerFlag", "ordinal_position": "12", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vPersonDemographics", "name": "NumberCarsOwned", "ordinal_position": "13", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidate", "name": "JobCandidateID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidate", "name": "BusinessEntityID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Name.Prefix", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Name.First", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Name.Middle", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Name.Last", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Name.Suffix", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Skills", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Addr.Type", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Addr.Loc.CountryRegion", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Addr.Loc.State", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Addr.Loc.City", "ordinal_position": "12", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "Addr.PostalCode", "ordinal_position": "13", "type": "nvarchar", "character_maximum_length": "20", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "EMail", "ordinal_position": "14", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "WebSite", "ordinal_position": "15", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidate", "name": "ModifiedDate", "ordinal_position": "16", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "JobCandidateID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.StartDate", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.EndDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.OrgName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.JobTitle", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.Responsibility", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.FunctionCategory", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.IndustryCategory", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.Loc.CountryRegion", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.Loc.State", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEmployment", "name": "Emp.Loc.City", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesReason", "name": "SalesReasonID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesReason", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesReason", "name": "ReasonType", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesReason", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "JobCandidateID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.Level", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.StartDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.EndDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.Degree", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.Major", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.Minor", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.GPA", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "5", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.GPAScale", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "5", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.School", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.Loc.CountryRegion", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.Loc.State", "ordinal_position": "12", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "vJobCandidateEducation", "name": "Edu.Loc.City", "ordinal_position": "13", "type": "nvarchar", "character_maximum_length": "100", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductAndDescription", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "vProductAndDescription", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductAndDescription", "name": "ProductModel", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductAndDescription", "name": "CultureID", "ordinal_position": "4", "type": "nchar", "character_maximum_length": "6", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductAndDescription", "name": "Description", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "400", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesTaxRate", "name": "SalesTaxRateID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTaxRate", "name": "StateProvinceID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTaxRate", "name": "TaxType", "ordinal_position": "3", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTaxRate", "name": "TaxRate", "ordinal_position": "4", "type": "smallmoney", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTaxRate", "name": "Name", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesTaxRate", "name": "rowguid", "ordinal_position": "6", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTaxRate", "name": "ModifiedDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "ProductModelID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Summary", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Manufacturer", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Copyright", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "ProductURL", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "WarrantyPeriod", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "WarrantyDescription", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "NoOfYears", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "MaintenanceDescription", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Wheel", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Saddle", "ordinal_position": "12", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Pedal", "ordinal_position": "13", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "BikeFrame", "ordinal_position": "14", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Crankset", "ordinal_position": "15", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "PictureAngle", "ordinal_position": "16", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "PictureSize", "ordinal_position": "17", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "ProductPhotoID", "ordinal_position": "18", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Material", "ordinal_position": "19", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Color", "ordinal_position": "20", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "ProductLine", "ordinal_position": "21", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "Style", "ordinal_position": "22", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "RiderExperience", "ordinal_position": "23", "type": "nvarchar", "character_maximum_length": "1024", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "rowguid", "ordinal_position": "24", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelCatalogDescription", "name": "ModifiedDate", "ordinal_position": "25", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "ProductModelID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelInstructions", "name": "Instructions", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelInstructions", "name": "LocationID", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "SetupHours", "ordinal_position": "5", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":9,"scale":4}, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "MachineHours", "ordinal_position": "6", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":9,"scale":4}, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "LaborHours", "ordinal_position": "7", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":9,"scale":4}, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "LotSize", "ordinal_position": "8", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "Step", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "1024", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "vProductModelInstructions", "name": "rowguid", "ordinal_position": "10", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "vProductModelInstructions", "name": "ModifiedDate", "ordinal_position": "11", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "PersonCreditCard", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "PersonCreditCard", "name": "CreditCardID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "PersonCreditCard", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPerson", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPerson", "name": "Title", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "FirstName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "MiddleName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "LastName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "Suffix", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "JobTitle", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "PhoneNumber", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "PhoneNumberType", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "EmailAddress", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "EmailPromotion", "ordinal_position": "11", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPerson", "name": "AddressLine1", "ordinal_position": "12", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "AddressLine2", "ordinal_position": "13", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "City", "ordinal_position": "14", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "StateProvinceName", "ordinal_position": "15", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "PostalCode", "ordinal_position": "16", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "CountryRegionName", "ordinal_position": "17", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "TerritoryName", "ordinal_position": "18", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "TerritoryGroup", "ordinal_position": "19", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPerson", "name": "SalesQuota", "ordinal_position": "20", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPerson", "name": "SalesYTD", "ordinal_position": "21", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPerson", "name": "SalesLastYear", "ordinal_position": "22", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPersonSalesByFiscalYears", "name": "SalesPersonID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPersonSalesByFiscalYears", "name": "FullName", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "152", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPersonSalesByFiscalYears", "name": "JobTitle", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPersonSalesByFiscalYears", "name": "SalesTerritory", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vSalesPersonSalesByFiscalYears", "name": "2002", "ordinal_position": "5", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPersonSalesByFiscalYears", "name": "2003", "ordinal_position": "6", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vSalesPersonSalesByFiscalYears", "name": "2004", "ordinal_position": "7", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Person", "table": "PersonPhone", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "PersonPhone", "name": "PhoneNumber", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "PersonPhone", "name": "PhoneNumberTypeID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "PersonPhone", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "vStateProvinceCountryRegion", "name": "StateProvinceID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "vStateProvinceCountryRegion", "name": "StateProvinceCode", "ordinal_position": "2", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vStateProvinceCountryRegion", "name": "IsOnlyStateProvinceFlag", "ordinal_position": "3", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "vStateProvinceCountryRegion", "name": "StateProvinceName", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vStateProvinceCountryRegion", "name": "TerritoryID", "ordinal_position": "5", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "vStateProvinceCountryRegion", "name": "CountryRegionCode", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "vStateProvinceCountryRegion", "name": "CountryRegionName", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesTerritory", "name": "TerritoryID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritory", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesTerritory", "name": "CountryRegionCode", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesTerritory", "name": "Group", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesTerritory", "name": "SalesYTD", "ordinal_position": "5", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritory", "name": "SalesLastYear", "ordinal_position": "6", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritory", "name": "CostYTD", "ordinal_position": "7", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritory", "name": "CostLastYear", "ordinal_position": "8", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritory", "name": "rowguid", "ordinal_position": "9", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritory", "name": "ModifiedDate", "ordinal_position": "10", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "AnnualSales", "ordinal_position": "3", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "AnnualRevenue", "ordinal_position": "4", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "BankName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "BusinessType", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "5", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "YearOpened", "ordinal_position": "7", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "Specialty", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "SquareFeet", "ordinal_position": "9", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "Brands", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "Internet", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithDemographics", "name": "NumberEmployees", "ordinal_position": "12", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Person", "table": "PhoneNumberType", "name": "PhoneNumberTypeID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "PhoneNumberType", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "PhoneNumberType", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithContacts", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithContacts", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "ContactType", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "Title", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "FirstName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "MiddleName", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "LastName", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "Suffix", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "PhoneNumber", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "PhoneNumberType", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "EmailAddress", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithContacts", "name": "EmailPromotion", "ordinal_position": "12", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "AddressType", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "AddressLine1", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "AddressLine2", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "City", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "StateProvinceName", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "PostalCode", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "vStoreWithAddresses", "name": "CountryRegionName", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "ProductNumber", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "MakeFlag", "ordinal_position": "4", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "FinishedGoodsFlag", "ordinal_position": "5", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "Color", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "SafetyStockLevel", "ordinal_position": "7", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "ReorderPoint", "ordinal_position": "8", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "StandardCost", "ordinal_position": "9", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "ListPrice", "ordinal_position": "10", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "Size", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "5", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "SizeUnitMeasureCode", "ordinal_position": "12", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "WeightUnitMeasureCode", "ordinal_position": "13", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "Weight", "ordinal_position": "14", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":8,"scale":2}, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "DaysToManufacture", "ordinal_position": "15", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "ProductLine", "ordinal_position": "16", "type": "nchar", "character_maximum_length": "2", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "Class", "ordinal_position": "17", "type": "nchar", "character_maximum_length": "2", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "Style", "ordinal_position": "18", "type": "nchar", "character_maximum_length": "2", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Product", "name": "ProductSubcategoryID", "ordinal_position": "19", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "ProductModelID", "ordinal_position": "20", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "SellStartDate", "ordinal_position": "21", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "SellEndDate", "ordinal_position": "22", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "DiscontinuedDate", "ordinal_position": "23", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "rowguid", "ordinal_position": "24", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Product", "name": "ModifiedDate", "ordinal_position": "25", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "ContactType", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "Title", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "FirstName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "MiddleName", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "LastName", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "Suffix", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "PhoneNumber", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "PhoneNumberType", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "EmailAddress", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithContacts", "name": "EmailPromotion", "ordinal_position": "12", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "AddressType", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "AddressLine1", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "AddressLine2", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "City", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "StateProvinceName", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "PostalCode", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "vVendorWithAddresses", "name": "CountryRegionName", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesTerritoryHistory", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritoryHistory", "name": "TerritoryID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritoryHistory", "name": "StartDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritoryHistory", "name": "EndDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritoryHistory", "name": "rowguid", "ordinal_position": "5", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesTerritoryHistory", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ScrapReason", "name": "ScrapReasonID", "ordinal_position": "1", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ScrapReason", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ScrapReason", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Shift", "name": "ShiftID", "ordinal_position": "1", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Shift", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Shift", "name": "StartTime", "ordinal_position": "3", "type": "time", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Shift", "name": "EndTime", "ordinal_position": "4", "type": "time", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Shift", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCategory", "name": "ProductCategoryID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCategory", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductCategory", "name": "rowguid", "ordinal_position": "3", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCategory", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ShipMethod", "name": "ShipMethodID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ShipMethod", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "ShipMethod", "name": "ShipBase", "ordinal_position": "3", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ShipMethod", "name": "ShipRate", "ordinal_position": "4", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ShipMethod", "name": "rowguid", "ordinal_position": "5", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ShipMethod", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCostHistory", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCostHistory", "name": "StartDate", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCostHistory", "name": "EndDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCostHistory", "name": "StandardCost", "ordinal_position": "4", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductCostHistory", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductDescription", "name": "ProductDescriptionID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductDescription", "name": "Description", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "400", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductDescription", "name": "rowguid", "ordinal_position": "3", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductDescription", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "ShoppingCartItem", "name": "ShoppingCartItemID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "ShoppingCartItem", "name": "ShoppingCartID", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "ShoppingCartItem", "name": "Quantity", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "ShoppingCartItem", "name": "ProductID", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "ShoppingCartItem", "name": "DateCreated", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "ShoppingCartItem", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductDocument", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductDocument", "name": "DocumentNode", "ordinal_position": "2", "type": "hierarchyid", "character_maximum_length": "892", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductDocument", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "DatabaseLog", "name": "DatabaseLogID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "DatabaseLog", "name": "PostTime", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "DatabaseLog", "name": "DatabaseUser", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "128", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "DatabaseLog", "name": "Event", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "128", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "DatabaseLog", "name": "Schema", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "128", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "DatabaseLog", "name": "Object", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "128", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "DatabaseLog", "name": "TSQL", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "DatabaseLog", "name": "XmlEvent", "ordinal_position": "8", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductInventory", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductInventory", "name": "LocationID", "ordinal_position": "2", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductInventory", "name": "Shelf", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "10", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductInventory", "name": "Bin", "ordinal_position": "4", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductInventory", "name": "Quantity", "ordinal_position": "5", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductInventory", "name": "rowguid", "ordinal_position": "6", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductInventory", "name": "ModifiedDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "SpecialOfferID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "Description", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "255", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SpecialOffer", "name": "DiscountPct", "ordinal_position": "3", "type": "smallmoney", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "Type", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SpecialOffer", "name": "Category", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SpecialOffer", "name": "StartDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "EndDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "MinQty", "ordinal_position": "8", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "MaxQty", "ordinal_position": "9", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "rowguid", "ordinal_position": "10", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOffer", "name": "ModifiedDate", "ordinal_position": "11", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorLogID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorTime", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "(getdate())", "collation": ""},{"schema": "dbo", "table": "ErrorLog", "name": "UserName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "128", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorNumber", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorSeverity", "ordinal_position": "5", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorState", "ordinal_position": "6", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorProcedure", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "126", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorLine", "ordinal_position": "8", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "dbo", "table": "ErrorLog", "name": "ErrorMessage", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "4000", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "table", "name": "id", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "ProductListPriceHistory", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductListPriceHistory", "name": "StartDate", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductListPriceHistory", "name": "EndDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "ProductListPriceHistory", "name": "ListPrice", "ordinal_position": "4", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductListPriceHistory", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Address", "name": "AddressID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Address", "name": "AddressLine1", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Address", "name": "AddressLine2", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "60", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Address", "name": "City", "ordinal_position": "4", "type": "nvarchar", "character_maximum_length": "30", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Address", "name": "StateProvinceID", "ordinal_position": "5", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Address", "name": "PostalCode", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "Address", "name": "SpatialLocation", "ordinal_position": "7", "type": "geography", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Person", "table": "Address", "name": "rowguid", "ordinal_position": "8", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "Address", "name": "ModifiedDate", "ordinal_position": "9", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOfferProduct", "name": "SpecialOfferID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOfferProduct", "name": "ProductID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOfferProduct", "name": "rowguid", "ordinal_position": "3", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SpecialOfferProduct", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModel", "name": "ProductModelID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModel", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductModel", "name": "CatalogDescription", "ordinal_position": "3", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModel", "name": "Instructions", "ordinal_position": "4", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModel", "name": "rowguid", "ordinal_position": "5", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModel", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "AddressType", "name": "AddressTypeID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "AddressType", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "AddressType", "name": "rowguid", "ordinal_position": "3", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "AddressType", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "StateProvince", "name": "StateProvinceID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "StateProvince", "name": "StateProvinceCode", "ordinal_position": "2", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "StateProvince", "name": "CountryRegionCode", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "StateProvince", "name": "IsOnlyStateProvinceFlag", "ordinal_position": "4", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "StateProvince", "name": "Name", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "StateProvince", "name": "TerritoryID", "ordinal_position": "6", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "StateProvince", "name": "rowguid", "ordinal_position": "7", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "StateProvince", "name": "ModifiedDate", "ordinal_position": "8", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModelIllustration", "name": "ProductModelID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModelIllustration", "name": "IllustrationID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModelIllustration", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "AWBuildVersion", "name": "SystemInformationID", "ordinal_position": "1", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "AWBuildVersion", "name": "Database Version", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "dbo", "table": "AWBuildVersion", "name": "VersionDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "dbo", "table": "AWBuildVersion", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "(getdate())", "collation": ""},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "name": "ProductModelID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "name": "ProductDescriptionID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "name": "CultureID", "ordinal_position": "3", "type": "nchar", "character_maximum_length": "6", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "BillOfMaterialsID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "ProductAssemblyID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "ComponentID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "StartDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "EndDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "UnitMeasureCode", "ordinal_position": "6", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "BillOfMaterials", "name": "BOMLevel", "ordinal_position": "7", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "PerAssemblyQty", "ordinal_position": "8", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":8,"scale":2}, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "BillOfMaterials", "name": "ModifiedDate", "ordinal_position": "9", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "Store", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "Store", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "Store", "name": "SalesPersonID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "Store", "name": "Demographics", "ordinal_position": "4", "type": "xml", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "Store", "name": "rowguid", "ordinal_position": "5", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "Store", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductPhoto", "name": "ProductPhotoID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductPhoto", "name": "ThumbNailPhoto", "ordinal_position": "2", "type": "varbinary", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "ProductPhoto", "name": "ThumbnailPhotoFileName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductPhoto", "name": "LargePhoto", "ordinal_position": "4", "type": "varbinary", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "ProductPhoto", "name": "LargePhotoFileName", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductPhoto", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductProductPhoto", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductProductPhoto", "name": "ProductPhotoID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductProductPhoto", "name": "Primary", "ordinal_position": "3", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductProductPhoto", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "TransactionID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "ProductID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "ReferenceOrderID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "ReferenceOrderLineID", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "TransactionDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "TransactionType", "ordinal_position": "6", "type": "nchar", "character_maximum_length": "1", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "TransactionHistory", "name": "Quantity", "ordinal_position": "7", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "ActualCost", "ordinal_position": "8", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistory", "name": "ModifiedDate", "ordinal_position": "9", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductReview", "name": "ProductReviewID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductReview", "name": "ProductID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductReview", "name": "ReviewerName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductReview", "name": "ReviewDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductReview", "name": "EmailAddress", "ordinal_position": "5", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductReview", "name": "Rating", "ordinal_position": "6", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductReview", "name": "Comments", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "3850", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductReview", "name": "ModifiedDate", "ordinal_position": "8", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntity", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntity", "name": "rowguid", "ordinal_position": "2", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntity", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "TransactionID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "ProductID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "ReferenceOrderID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "ReferenceOrderLineID", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "TransactionDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "TransactionType", "ordinal_position": "6", "type": "nchar", "character_maximum_length": "1", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "Quantity", "ordinal_position": "7", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "ActualCost", "ordinal_position": "8", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "TransactionHistoryArchive", "name": "ModifiedDate", "ordinal_position": "9", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductSubcategory", "name": "ProductSubcategoryID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductSubcategory", "name": "ProductCategoryID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductSubcategory", "name": "Name", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "ProductSubcategory", "name": "rowguid", "ordinal_position": "4", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "ProductSubcategory", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityAddress", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityAddress", "name": "AddressID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityAddress", "name": "AddressTypeID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityAddress", "name": "rowguid", "ordinal_position": "4", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityAddress", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "ProductID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "BusinessEntityID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "AverageLeadTime", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "StandardPrice", "ordinal_position": "4", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "LastReceiptCost", "ordinal_position": "5", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "LastReceiptDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "MinOrderQty", "ordinal_position": "7", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "MaxOrderQty", "ordinal_position": "8", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "OnOrderQty", "ordinal_position": "9", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Purchasing", "table": "ProductVendor", "name": "UnitMeasureCode", "ordinal_position": "10", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "ProductVendor", "name": "ModifiedDate", "ordinal_position": "11", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityContact", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityContact", "name": "PersonID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityContact", "name": "ContactTypeID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityContact", "name": "rowguid", "ordinal_position": "4", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "BusinessEntityContact", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "UnitMeasure", "name": "UnitMeasureCode", "ordinal_position": "1", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "UnitMeasure", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "UnitMeasure", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "Vendor", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "Vendor", "name": "AccountNumber", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "Vendor", "name": "Name", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "Vendor", "name": "CreditRating", "ordinal_position": "4", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "Vendor", "name": "PreferredVendorStatus", "ordinal_position": "5", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "Vendor", "name": "ActiveFlag", "ordinal_position": "6", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "Vendor", "name": "PurchasingWebServiceURL", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "1024", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Purchasing", "table": "Vendor", "name": "ModifiedDate", "ordinal_position": "8", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "ContactType", "name": "ContactTypeID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "ContactType", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "ContactType", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CountryRegionCurrency", "name": "CountryRegionCode", "ordinal_position": "1", "type": "nvarchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "CountryRegionCurrency", "name": "CurrencyCode", "ordinal_position": "2", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "CountryRegionCurrency", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "CountryRegion", "name": "CountryRegionCode", "ordinal_position": "1", "type": "nvarchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "CountryRegion", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "CountryRegion", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "WorkOrderID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "ProductID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "OrderQty", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "StockedQty", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "ScrappedQty", "ordinal_position": "5", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "StartDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "EndDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "DueDate", "ordinal_position": "8", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "ScrapReasonID", "ordinal_position": "9", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrder", "name": "ModifiedDate", "ordinal_position": "10", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "PurchaseOrderID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "PurchaseOrderDetailID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "DueDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "OrderQty", "ordinal_position": "4", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "ProductID", "ordinal_position": "5", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "UnitPrice", "ordinal_position": "6", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "LineTotal", "ordinal_position": "7", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "ReceivedQty", "ordinal_position": "8", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":8,"scale":2}, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "RejectedQty", "ordinal_position": "9", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":8,"scale":2}, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "StockedQty", "ordinal_position": "10", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":9,"scale":2}, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "name": "ModifiedDate", "ordinal_position": "11", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CreditCard", "name": "CreditCardID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CreditCard", "name": "CardType", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "CreditCard", "name": "CardNumber", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "CreditCard", "name": "ExpMonth", "ordinal_position": "4", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CreditCard", "name": "ExpYear", "ordinal_position": "5", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CreditCard", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Culture", "name": "CultureID", "ordinal_position": "1", "type": "nchar", "character_maximum_length": "6", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Culture", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Culture", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "WorkOrderID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ProductID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "OperationSequence", "ordinal_position": "3", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "LocationID", "ordinal_position": "4", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ScheduledStartDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ScheduledEndDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ActualStartDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ActualEndDate", "ordinal_position": "8", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ActualResourceHrs", "ordinal_position": "9", "type": "decimal", "character_maximum_length": "null", "precision": {"precision":9,"scale":4}, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "PlannedCost", "ordinal_position": "10", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ActualCost", "ordinal_position": "11", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "WorkOrderRouting", "name": "ModifiedDate", "ordinal_position": "12", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "Currency", "name": "CurrencyCode", "ordinal_position": "1", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "Currency", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "Currency", "name": "ModifiedDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "PurchaseOrderID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "RevisionNumber", "ordinal_position": "2", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "Status", "ordinal_position": "3", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "EmployeeID", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "VendorID", "ordinal_position": "5", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "ShipMethodID", "ordinal_position": "6", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "OrderDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "ShipDate", "ordinal_position": "8", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "SubTotal", "ordinal_position": "9", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "TaxAmt", "ordinal_position": "10", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "Freight", "ordinal_position": "11", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "TotalDue", "ordinal_position": "12", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "name": "ModifiedDate", "ordinal_position": "13", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CurrencyRate", "name": "CurrencyRateID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CurrencyRate", "name": "CurrencyRateDate", "ordinal_position": "2", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CurrencyRate", "name": "FromCurrencyCode", "ordinal_position": "3", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "CurrencyRate", "name": "ToCurrencyCode", "ordinal_position": "4", "type": "nchar", "character_maximum_length": "3", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "CurrencyRate", "name": "AverageRate", "ordinal_position": "5", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CurrencyRate", "name": "EndOfDayRate", "ordinal_position": "6", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "CurrencyRate", "name": "ModifiedDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "Customer", "name": "CustomerID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "Customer", "name": "PersonID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "Customer", "name": "StoreID", "ordinal_position": "3", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "Customer", "name": "TerritoryID", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "Customer", "name": "AccountNumber", "ordinal_position": "5", "type": "varchar", "character_maximum_length": "10", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "Customer", "name": "rowguid", "ordinal_position": "6", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "Customer", "name": "ModifiedDate", "ordinal_position": "7", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Department", "name": "DepartmentID", "ordinal_position": "1", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Department", "name": "Name", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Department", "name": "GroupName", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Department", "name": "ModifiedDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "DocumentNode", "ordinal_position": "1", "type": "hierarchyid", "character_maximum_length": "892", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "DocumentLevel", "ordinal_position": "2", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "Title", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Document", "name": "Owner", "ordinal_position": "4", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "FolderFlag", "ordinal_position": "5", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "FileName", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "400", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Document", "name": "FileExtension", "ordinal_position": "7", "type": "nvarchar", "character_maximum_length": "8", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Document", "name": "Revision", "ordinal_position": "8", "type": "nchar", "character_maximum_length": "5", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Document", "name": "ChangeNumber", "ordinal_position": "9", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "Status", "ordinal_position": "10", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "DocumentSummary", "ordinal_position": "11", "type": "nvarchar", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Production", "table": "Document", "name": "Document", "ordinal_position": "12", "type": "varbinary", "character_maximum_length": "-1", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "rowguid", "ordinal_position": "13", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Production", "table": "Document", "name": "ModifiedDate", "ordinal_position": "14", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "SalesOrderID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "SalesOrderDetailID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "CarrierTrackingNumber", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesOrderDetail", "name": "OrderQty", "ordinal_position": "4", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "ProductID", "ordinal_position": "5", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "SpecialOfferID", "ordinal_position": "6", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "UnitPrice", "ordinal_position": "7", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "UnitPriceDiscount", "ordinal_position": "8", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "LineTotal", "ordinal_position": "9", "type": "numeric", "character_maximum_length": "null", "precision": {"precision":38,"scale":6}, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "rowguid", "ordinal_position": "10", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderDetail", "name": "ModifiedDate", "ordinal_position": "11", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "EmailAddress", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "EmailAddress", "name": "EmailAddressID", "ordinal_position": "2", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "EmailAddress", "name": "EmailAddress", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Person", "table": "EmailAddress", "name": "rowguid", "ordinal_position": "4", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Person", "table": "EmailAddress", "name": "ModifiedDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "NationalIDNumber", "ordinal_position": "2", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Employee", "name": "LoginID", "ordinal_position": "3", "type": "nvarchar", "character_maximum_length": "256", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Employee", "name": "OrganizationNode", "ordinal_position": "4", "type": "hierarchyid", "character_maximum_length": "892", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "OrganizationLevel", "ordinal_position": "5", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "JobTitle", "ordinal_position": "6", "type": "nvarchar", "character_maximum_length": "50", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Employee", "name": "BirthDate", "ordinal_position": "7", "type": "date", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "MaritalStatus", "ordinal_position": "8", "type": "nchar", "character_maximum_length": "1", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Employee", "name": "Gender", "ordinal_position": "9", "type": "nchar", "character_maximum_length": "1", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "HumanResources", "table": "Employee", "name": "HireDate", "ordinal_position": "10", "type": "date", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "SalariedFlag", "ordinal_position": "11", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "VacationHours", "ordinal_position": "12", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "SickLeaveHours", "ordinal_position": "13", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "CurrentFlag", "ordinal_position": "14", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "rowguid", "ordinal_position": "15", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "Employee", "name": "ModifiedDate", "ordinal_position": "16", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "SalesOrderID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "RevisionNumber", "ordinal_position": "2", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "OrderDate", "ordinal_position": "3", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "DueDate", "ordinal_position": "4", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "ShipDate", "ordinal_position": "5", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "Status", "ordinal_position": "6", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "OnlineOrderFlag", "ordinal_position": "7", "type": "bit", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "SalesOrderNumber", "ordinal_position": "8", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "false", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesOrderHeader", "name": "PurchaseOrderNumber", "ordinal_position": "9", "type": "nvarchar", "character_maximum_length": "25", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesOrderHeader", "name": "AccountNumber", "ordinal_position": "10", "type": "nvarchar", "character_maximum_length": "15", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesOrderHeader", "name": "CustomerID", "ordinal_position": "11", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "SalesPersonID", "ordinal_position": "12", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "TerritoryID", "ordinal_position": "13", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "BillToAddressID", "ordinal_position": "14", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "ShipToAddressID", "ordinal_position": "15", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "ShipMethodID", "ordinal_position": "16", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "CreditCardID", "ordinal_position": "17", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "CreditCardApprovalCode", "ordinal_position": "18", "type": "varchar", "character_maximum_length": "15", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesOrderHeader", "name": "CurrencyRateID", "ordinal_position": "19", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "SubTotal", "ordinal_position": "20", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "TaxAmt", "ordinal_position": "21", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "Freight", "ordinal_position": "22", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "TotalDue", "ordinal_position": "23", "type": "money", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "Comment", "ordinal_position": "24", "type": "nvarchar", "character_maximum_length": "128", "precision": null, "nullable": "true", "default": "", "collation": "SQL_Latin1_General_CP1_CI_AS"},{"schema": "Sales", "table": "SalesOrderHeader", "name": "rowguid", "ordinal_position": "25", "type": "uniqueidentifier", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "Sales", "table": "SalesOrderHeader", "name": "ModifiedDate", "ordinal_position": "26", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "name": "BusinessEntityID", "ordinal_position": "1", "type": "int", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "name": "DepartmentID", "ordinal_position": "2", "type": "smallint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "name": "ShiftID", "ordinal_position": "3", "type": "tinyint", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "name": "StartDate", "ordinal_position": "4", "type": "date", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "name": "EndDate", "ordinal_position": "5", "type": "date", "character_maximum_length": "null", "precision": null, "nullable": "true", "default": "", "collation": ""},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "name": "ModifiedDate", "ordinal_position": "6", "type": "datetime", "character_maximum_length": "null", "precision": null, "nullable": "false", "default": "", "collation": ""}], "indexes": [{"schema": "HumanResources", "table": "EmployeePayHistory", "index_name": "PK_EmployeePayHistory_BusinessEntityID_RateChangeDate", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "EmployeePayHistory", "index_name": "PK_EmployeePayHistory_BusinessEntityID_RateChangeDate", "column_name": "RateChangeDate", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "index_name": "PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID", "column_name": "SalesOrderID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "index_name": "PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID", "column_name": "SalesReasonID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesPerson", "index_name": "PK_SalesPerson_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesPerson", "index_name": "AK_SalesPerson_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Illustration", "index_name": "PK_Illustration_IllustrationID", "column_name": "IllustrationID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "JobCandidate", "index_name": "PK_JobCandidate_JobCandidateID", "column_name": "JobCandidateID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "JobCandidate", "index_name": "IX_JobCandidate_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "Location", "index_name": "PK_Location_LocationID", "column_name": "LocationID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Location", "index_name": "AK_Location_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Password", "index_name": "PK_Password_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "index_name": "PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "index_name": "PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate", "column_name": "QuotaDate", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "index_name": "AK_SalesPersonQuotaHistory_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "PK_Person_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "IX_Person_LastName_FirstName_MiddleName", "column_name": "LastName", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "IX_Person_LastName_FirstName_MiddleName", "column_name": "FirstName", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "IX_Person_LastName_FirstName_MiddleName", "column_name": "MiddleName", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "AK_Person_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "PXML_Person_AddContact", "column_name": "AdditionalContactInfo", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "PXML_Person_Demographics", "column_name": "Demographics", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "XMLPATH_Person_Demographics", "column_name": "Demographics", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "XMLPROPERTY_Person_Demographics", "column_name": "Demographics", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "Person", "index_name": "XMLVALUE_Person_Demographics", "column_name": "Demographics", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "SalesReason", "index_name": "PK_SalesReason_SalesReasonID", "column_name": "SalesReasonID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTaxRate", "index_name": "PK_SalesTaxRate_SalesTaxRateID", "column_name": "SalesTaxRateID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTaxRate", "index_name": "AK_SalesTaxRate_StateProvinceID_TaxType", "column_name": "StateProvinceID", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTaxRate", "index_name": "AK_SalesTaxRate_StateProvinceID_TaxType", "column_name": "TaxType", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTaxRate", "index_name": "AK_SalesTaxRate_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "PersonCreditCard", "index_name": "PK_PersonCreditCard_BusinessEntityID_CreditCardID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "PersonCreditCard", "index_name": "PK_PersonCreditCard_BusinessEntityID_CreditCardID", "column_name": "CreditCardID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "PersonPhone", "index_name": "PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "PersonPhone", "index_name": "PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID", "column_name": "PhoneNumber", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "PersonPhone", "index_name": "PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID", "column_name": "PhoneNumberTypeID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "PersonPhone", "index_name": "IX_PersonPhone_PhoneNumber", "column_name": "PhoneNumber", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "SalesTerritory", "index_name": "PK_SalesTerritory_TerritoryID", "column_name": "TerritoryID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTerritory", "index_name": "AK_SalesTerritory_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTerritory", "index_name": "AK_SalesTerritory_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "PhoneNumberType", "index_name": "PK_PhoneNumberType_PhoneNumberTypeID", "column_name": "PhoneNumberTypeID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Product", "index_name": "PK_Product_ProductID", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Product", "index_name": "AK_Product_ProductNumber", "column_name": "ProductNumber", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Product", "index_name": "AK_Product_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Product", "index_name": "AK_Product_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTerritoryHistory", "index_name": "PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTerritoryHistory", "index_name": "PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID", "column_name": "TerritoryID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTerritoryHistory", "index_name": "PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID", "column_name": "StartDate", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesTerritoryHistory", "index_name": "AK_SalesTerritoryHistory_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ScrapReason", "index_name": "PK_ScrapReason_ScrapReasonID", "column_name": "ScrapReasonID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ScrapReason", "index_name": "AK_ScrapReason_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Shift", "index_name": "PK_Shift_ShiftID", "column_name": "ShiftID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Shift", "index_name": "AK_Shift_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Shift", "index_name": "AK_Shift_StartTime_EndTime", "column_name": "StartTime", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Shift", "index_name": "AK_Shift_StartTime_EndTime", "column_name": "EndTime", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductCategory", "index_name": "PK_ProductCategory_ProductCategoryID", "column_name": "ProductCategoryID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductCategory", "index_name": "AK_ProductCategory_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductCategory", "index_name": "AK_ProductCategory_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "ShipMethod", "index_name": "PK_ShipMethod_ShipMethodID", "column_name": "ShipMethodID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "ShipMethod", "index_name": "AK_ShipMethod_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "ShipMethod", "index_name": "AK_ShipMethod_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductCostHistory", "index_name": "PK_ProductCostHistory_ProductID_StartDate", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductCostHistory", "index_name": "PK_ProductCostHistory_ProductID_StartDate", "column_name": "StartDate", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductDescription", "index_name": "PK_ProductDescription_ProductDescriptionID", "column_name": "ProductDescriptionID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductDescription", "index_name": "AK_ProductDescription_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "ShoppingCartItem", "index_name": "PK_ShoppingCartItem_ShoppingCartItemID", "column_name": "ShoppingCartItemID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "ShoppingCartItem", "index_name": "IX_ShoppingCartItem_ShoppingCartID_ProductID", "column_name": "ShoppingCartID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "ShoppingCartItem", "index_name": "IX_ShoppingCartItem_ShoppingCartID_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductDocument", "index_name": "PK_ProductDocument_ProductID_DocumentNode", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductDocument", "index_name": "PK_ProductDocument_ProductID_DocumentNode", "column_name": "DocumentNode", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "dbo", "table": "DatabaseLog", "index_name": "PK_DatabaseLog_DatabaseLogID", "column_name": "DatabaseLogID", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductInventory", "index_name": "PK_ProductInventory_ProductID_LocationID", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductInventory", "index_name": "PK_ProductInventory_ProductID_LocationID", "column_name": "LocationID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SpecialOffer", "index_name": "PK_SpecialOffer_SpecialOfferID", "column_name": "SpecialOfferID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SpecialOffer", "index_name": "AK_SpecialOffer_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "dbo", "table": "ErrorLog", "index_name": "PK_ErrorLog_ErrorLogID", "column_name": "ErrorLogID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductListPriceHistory", "index_name": "PK_ProductListPriceHistory_ProductID_StartDate", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductListPriceHistory", "index_name": "PK_ProductListPriceHistory_ProductID_StartDate", "column_name": "StartDate", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "PK_Address_AddressID", "column_name": "AddressID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "AK_Address_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode", "column_name": "AddressLine1", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode", "column_name": "AddressLine2", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode", "column_name": "City", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode", "column_name": "StateProvinceID", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode", "column_name": "PostalCode", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "Address", "index_name": "IX_Address_StateProvinceID", "column_name": "StateProvinceID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "SpecialOfferProduct", "index_name": "PK_SpecialOfferProduct_SpecialOfferID_ProductID", "column_name": "SpecialOfferID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SpecialOfferProduct", "index_name": "PK_SpecialOfferProduct_SpecialOfferID_ProductID", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SpecialOfferProduct", "index_name": "AK_SpecialOfferProduct_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SpecialOfferProduct", "index_name": "IX_SpecialOfferProduct_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductModel", "index_name": "PK_ProductModel_ProductModelID", "column_name": "ProductModelID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModel", "index_name": "AK_ProductModel_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModel", "index_name": "AK_ProductModel_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModel", "index_name": "PXML_ProductModel_CatalogDescription", "column_name": "CatalogDescription", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductModel", "index_name": "PXML_ProductModel_Instructions", "column_name": "Instructions", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "AddressType", "index_name": "PK_AddressType_AddressTypeID", "column_name": "AddressTypeID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "AddressType", "index_name": "AK_AddressType_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "AddressType", "index_name": "AK_AddressType_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "StateProvince", "index_name": "PK_StateProvince_StateProvinceID", "column_name": "StateProvinceID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "StateProvince", "index_name": "AK_StateProvince_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "StateProvince", "index_name": "AK_StateProvince_StateProvinceCode_CountryRegionCode", "column_name": "StateProvinceCode", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "StateProvince", "index_name": "AK_StateProvince_StateProvinceCode_CountryRegionCode", "column_name": "CountryRegionCode", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "StateProvince", "index_name": "AK_StateProvince_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModelIllustration", "index_name": "PK_ProductModelIllustration_ProductModelID_IllustrationID", "column_name": "ProductModelID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModelIllustration", "index_name": "PK_ProductModelIllustration_ProductModelID_IllustrationID", "column_name": "IllustrationID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "dbo", "table": "AWBuildVersion", "index_name": "PK_AWBuildVersion_SystemInformationID", "column_name": "SystemInformationID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "index_name": "PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID", "column_name": "ProductModelID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "index_name": "PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID", "column_name": "ProductDescriptionID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "index_name": "PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID", "column_name": "CultureID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "BillOfMaterials", "index_name": "AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate", "column_name": "ProductAssemblyID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "BillOfMaterials", "index_name": "AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate", "column_name": "ComponentID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "BillOfMaterials", "index_name": "AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate", "column_name": "StartDate", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "BillOfMaterials", "index_name": "PK_BillOfMaterials_BillOfMaterialsID", "column_name": "BillOfMaterialsID", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "BillOfMaterials", "index_name": "IX_BillOfMaterials_UnitMeasureCode", "column_name": "UnitMeasureCode", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "Store", "index_name": "PK_Store_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "Store", "index_name": "AK_Store_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "Store", "index_name": "IX_Store_SalesPersonID", "column_name": "SalesPersonID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "Store", "index_name": "PXML_Store_Demographics", "column_name": "Demographics", "index_type": "xml", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductPhoto", "index_name": "PK_ProductPhoto_ProductPhotoID", "column_name": "ProductPhotoID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductProductPhoto", "index_name": "PK_ProductProductPhoto_ProductID_ProductPhotoID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductProductPhoto", "index_name": "PK_ProductProductPhoto_ProductID_ProductPhotoID", "column_name": "ProductPhotoID", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "TransactionHistory", "index_name": "PK_TransactionHistory_TransactionID", "column_name": "TransactionID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "TransactionHistory", "index_name": "IX_TransactionHistory_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "TransactionHistory", "index_name": "IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID", "column_name": "ReferenceOrderID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "TransactionHistory", "index_name": "IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID", "column_name": "ReferenceOrderLineID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductReview", "index_name": "PK_ProductReview_ProductReviewID", "column_name": "ProductReviewID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductReview", "index_name": "IX_ProductReview_ProductID_Name", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductReview", "index_name": "IX_ProductReview_ProductID_Name", "column_name": "ReviewerName", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductReview", "index_name": "IX_ProductReview_ProductID_Name", "column_name": "Comments", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "BusinessEntity", "index_name": "PK_BusinessEntity_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntity", "index_name": "AK_BusinessEntity_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "TransactionHistoryArchive", "index_name": "PK_TransactionHistoryArchive_TransactionID", "column_name": "TransactionID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "TransactionHistoryArchive", "index_name": "IX_TransactionHistoryArchive_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "TransactionHistoryArchive", "index_name": "IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID", "column_name": "ReferenceOrderID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "TransactionHistoryArchive", "index_name": "IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID", "column_name": "ReferenceOrderLineID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "ProductSubcategory", "index_name": "PK_ProductSubcategory_ProductSubcategoryID", "column_name": "ProductSubcategoryID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductSubcategory", "index_name": "AK_ProductSubcategory_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "ProductSubcategory", "index_name": "AK_ProductSubcategory_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityAddress", "index_name": "PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityAddress", "index_name": "PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID", "column_name": "AddressID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityAddress", "index_name": "PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID", "column_name": "AddressTypeID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityAddress", "index_name": "AK_BusinessEntityAddress_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityAddress", "index_name": "IX_BusinessEntityAddress_AddressID", "column_name": "AddressID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityAddress", "index_name": "IX_BusinessEntityAddress_AddressTypeID", "column_name": "AddressTypeID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Purchasing", "table": "ProductVendor", "index_name": "PK_ProductVendor_ProductID_BusinessEntityID", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "ProductVendor", "index_name": "PK_ProductVendor_ProductID_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "ProductVendor", "index_name": "IX_ProductVendor_UnitMeasureCode", "column_name": "UnitMeasureCode", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Purchasing", "table": "ProductVendor", "index_name": "IX_ProductVendor_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityContact", "index_name": "PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityContact", "index_name": "PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID", "column_name": "PersonID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityContact", "index_name": "PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID", "column_name": "ContactTypeID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityContact", "index_name": "AK_BusinessEntityContact_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityContact", "index_name": "IX_BusinessEntityContact_PersonID", "column_name": "PersonID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "BusinessEntityContact", "index_name": "IX_BusinessEntityContact_ContactTypeID", "column_name": "ContactTypeID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "UnitMeasure", "index_name": "PK_UnitMeasure_UnitMeasureCode", "column_name": "UnitMeasureCode", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "UnitMeasure", "index_name": "AK_UnitMeasure_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "Vendor", "index_name": "PK_Vendor_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "Vendor", "index_name": "AK_Vendor_AccountNumber", "column_name": "AccountNumber", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "ContactType", "index_name": "PK_ContactType_ContactTypeID", "column_name": "ContactTypeID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "ContactType", "index_name": "AK_ContactType_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "CountryRegionCurrency", "index_name": "PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode", "column_name": "CountryRegionCode", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "CountryRegionCurrency", "index_name": "PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode", "column_name": "CurrencyCode", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "CountryRegionCurrency", "index_name": "IX_CountryRegionCurrency_CurrencyCode", "column_name": "CurrencyCode", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "CountryRegion", "index_name": "PK_CountryRegion_CountryRegionCode", "column_name": "CountryRegionCode", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "CountryRegion", "index_name": "AK_CountryRegion_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "WorkOrder", "index_name": "PK_WorkOrder_WorkOrderID", "column_name": "WorkOrderID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "WorkOrder", "index_name": "IX_WorkOrder_ScrapReasonID", "column_name": "ScrapReasonID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "WorkOrder", "index_name": "IX_WorkOrder_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "index_name": "PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID", "column_name": "PurchaseOrderID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "index_name": "PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID", "column_name": "PurchaseOrderDetailID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "index_name": "IX_PurchaseOrderDetail_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "CreditCard", "index_name": "PK_CreditCard_CreditCardID", "column_name": "CreditCardID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "CreditCard", "index_name": "AK_CreditCard_CardNumber", "column_name": "CardNumber", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Culture", "index_name": "PK_Culture_CultureID", "column_name": "CultureID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Culture", "index_name": "AK_Culture_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "WorkOrderRouting", "index_name": "PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence", "column_name": "WorkOrderID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "WorkOrderRouting", "index_name": "PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence", "column_name": "ProductID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "WorkOrderRouting", "index_name": "PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence", "column_name": "OperationSequence", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "WorkOrderRouting", "index_name": "IX_WorkOrderRouting_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "Currency", "index_name": "PK_Currency_CurrencyCode", "column_name": "CurrencyCode", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "Currency", "index_name": "AK_Currency_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "index_name": "PK_PurchaseOrderHeader_PurchaseOrderID", "column_name": "PurchaseOrderID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "index_name": "IX_PurchaseOrderHeader_VendorID", "column_name": "VendorID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "index_name": "IX_PurchaseOrderHeader_EmployeeID", "column_name": "EmployeeID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "CurrencyRate", "index_name": "PK_CurrencyRate_CurrencyRateID", "column_name": "CurrencyRateID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "CurrencyRate", "index_name": "AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode", "column_name": "CurrencyRateDate", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "CurrencyRate", "index_name": "AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode", "column_name": "FromCurrencyCode", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "CurrencyRate", "index_name": "AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode", "column_name": "ToCurrencyCode", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "Customer", "index_name": "PK_Customer_CustomerID", "column_name": "CustomerID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "Customer", "index_name": "AK_Customer_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "Customer", "index_name": "AK_Customer_AccountNumber", "column_name": "AccountNumber", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "Customer", "index_name": "IX_Customer_TerritoryID", "column_name": "TerritoryID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "HumanResources", "table": "Department", "index_name": "PK_Department_DepartmentID", "column_name": "DepartmentID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Department", "index_name": "AK_Department_Name", "column_name": "Name", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Document", "index_name": "PK_Document_DocumentNode", "column_name": "DocumentNode", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Document", "index_name": "UQ__Document__F73921F7467F518D", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Document", "index_name": "AK_Document_DocumentLevel_DocumentNode", "column_name": "DocumentLevel", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Document", "index_name": "AK_Document_DocumentLevel_DocumentNode", "column_name": "DocumentNode", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Document", "index_name": "AK_Document_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Production", "table": "Document", "index_name": "IX_Document_FileName_Revision", "column_name": "FileName", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Production", "table": "Document", "index_name": "IX_Document_FileName_Revision", "column_name": "Revision", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderDetail", "index_name": "PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID", "column_name": "SalesOrderID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderDetail", "index_name": "PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID", "column_name": "SalesOrderDetailID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderDetail", "index_name": "AK_SalesOrderDetail_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderDetail", "index_name": "IX_SalesOrderDetail_ProductID", "column_name": "ProductID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Person", "table": "EmailAddress", "index_name": "PK_EmailAddress_BusinessEntityID_EmailAddressID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "EmailAddress", "index_name": "PK_EmailAddress_BusinessEntityID_EmailAddressID", "column_name": "EmailAddressID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Person", "table": "EmailAddress", "index_name": "IX_EmailAddress_EmailAddress", "column_name": "EmailAddress", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "HumanResources", "table": "Employee", "index_name": "PK_Employee_BusinessEntityID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Employee", "index_name": "IX_Employee_OrganizationNode", "column_name": "OrganizationNode", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "HumanResources", "table": "Employee", "index_name": "IX_Employee_OrganizationLevel_OrganizationNode", "column_name": "OrganizationLevel", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "HumanResources", "table": "Employee", "index_name": "IX_Employee_OrganizationLevel_OrganizationNode", "column_name": "OrganizationNode", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "HumanResources", "table": "Employee", "index_name": "AK_Employee_LoginID", "column_name": "LoginID", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Employee", "index_name": "AK_Employee_NationalIDNumber", "column_name": "NationalIDNumber", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "Employee", "index_name": "AK_Employee_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderHeader", "index_name": "PK_SalesOrderHeader_SalesOrderID", "column_name": "SalesOrderID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderHeader", "index_name": "AK_SalesOrderHeader_rowguid", "column_name": "rowguid", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderHeader", "index_name": "AK_SalesOrderHeader_SalesOrderNumber", "column_name": "SalesOrderNumber", "index_type": "nonclustered", "is_unique": true, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderHeader", "index_name": "IX_SalesOrderHeader_CustomerID", "column_name": "CustomerID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "Sales", "table": "SalesOrderHeader", "index_name": "IX_SalesOrderHeader_SalesPersonID", "column_name": "SalesPersonID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "index_name": "PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID", "column_name": "BusinessEntityID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "index_name": "PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID", "column_name": "DepartmentID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "index_name": "PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID", "column_name": "ShiftID", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "index_name": "PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID", "column_name": "StartDate", "index_type": "clustered", "is_unique": true, "direction": "asc"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "index_name": "IX_EmployeeDepartmentHistory_DepartmentID", "column_name": "DepartmentID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "index_name": "IX_EmployeeDepartmentHistory_ShiftID", "column_name": "ShiftID", "index_type": "nonclustered", "is_unique": false, "direction": "asc"}], "tables": [{"schema": "dbo", "table": "table", "row_count": "2", "table_type": "USER_TABLE", "creation_date": "2025-02-03 20:08:19"},{"schema": "dbo", "table": "AWBuildVersion", "row_count": "1", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "dbo", "table": "DatabaseLog", "row_count": "1591", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "dbo", "table": "ErrorLog", "row_count": "0", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "HumanResources", "table": "Department", "row_count": "16", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "HumanResources", "table": "Employee", "row_count": "290", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "HumanResources", "table": "EmployeeDepartmentHistory", "row_count": "296", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "HumanResources", "table": "EmployeePayHistory", "row_count": "316", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "HumanResources", "table": "JobCandidate", "row_count": "13", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "HumanResources", "table": "Shift", "row_count": "3", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Person", "table": "Address", "row_count": "19614", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Person", "table": "AddressType", "row_count": "6", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Person", "table": "BusinessEntity", "row_count": "20777", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Person", "table": "BusinessEntityAddress", "row_count": "19614", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Person", "table": "BusinessEntityContact", "row_count": "909", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Person", "table": "ContactType", "row_count": "20", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Person", "table": "CountryRegion", "row_count": "238", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Person", "table": "EmailAddress", "row_count": "19972", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Person", "table": "Password", "row_count": "19972", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Person", "table": "Person", "row_count": "19972", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Person", "table": "PersonPhone", "row_count": "19972", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Person", "table": "PhoneNumberType", "row_count": "3", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Person", "table": "StateProvince", "row_count": "181", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "BillOfMaterials", "row_count": "2679", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Production", "table": "Culture", "row_count": "8", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Production", "table": "Document", "row_count": "13", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "Illustration", "row_count": "5", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "Location", "row_count": "14", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "Product", "row_count": "504", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductCategory", "row_count": "4", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductCostHistory", "row_count": "395", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductDescription", "row_count": "762", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductDocument", "row_count": "32", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductInventory", "row_count": "1069", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductListPriceHistory", "row_count": "395", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductModel", "row_count": "128", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductModelIllustration", "row_count": "7", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductModelProductDescriptionCulture", "row_count": "762", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductPhoto", "row_count": "101", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductProductPhoto", "row_count": "504", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductReview", "row_count": "4", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ProductSubcategory", "row_count": "37", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "ScrapReason", "row_count": "16", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "TransactionHistory", "row_count": "113443", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "TransactionHistoryArchive", "row_count": "89253", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "UnitMeasure", "row_count": "38", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "WorkOrder", "row_count": "72591", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Production", "table": "WorkOrderRouting", "row_count": "67131", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Purchasing", "table": "ProductVendor", "row_count": "460", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Purchasing", "table": "PurchaseOrderDetail", "row_count": "8845", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Purchasing", "table": "PurchaseOrderHeader", "row_count": "4012", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Purchasing", "table": "ShipMethod", "row_count": "5", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Purchasing", "table": "Vendor", "row_count": "104", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "CountryRegionCurrency", "row_count": "109", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Sales", "table": "CreditCard", "row_count": "19118", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Sales", "table": "Currency", "row_count": "105", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Sales", "table": "CurrencyRate", "row_count": "13532", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Sales", "table": "Customer", "row_count": "19820", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:23"},{"schema": "Sales", "table": "PersonCreditCard", "row_count": "19118", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesOrderDetail", "row_count": "121317", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesOrderHeader", "row_count": "31465", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesOrderHeaderSalesReason", "row_count": "27647", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesPerson", "row_count": "17", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesPersonQuotaHistory", "row_count": "163", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesReason", "row_count": "10", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesTaxRate", "row_count": "29", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesTerritory", "row_count": "10", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SalesTerritoryHistory", "row_count": "17", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "ShoppingCartItem", "row_count": "3", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SpecialOffer", "row_count": "16", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "SpecialOfferProduct", "row_count": "538", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"},{"schema": "Sales", "table": "Store", "row_count": "701", "table_type": "USER_TABLE", "creation_date": "2022-11-23 18:04:24"}], "views": [{"schema": "Person", "view_name": "vAdditionalContactInfo"},{"schema": "HumanResources", "view_name": "vEmployee"},{"schema": "HumanResources", "view_name": "vEmployeeDepartment"},{"schema": "HumanResources", "view_name": "vEmployeeDepartmentHistory"},{"schema": "Sales", "view_name": "vIndividualCustomer"},{"schema": "Sales", "view_name": "vPersonDemographics"},{"schema": "HumanResources", "view_name": "vJobCandidate"},{"schema": "HumanResources", "view_name": "vJobCandidateEmployment"},{"schema": "HumanResources", "view_name": "vJobCandidateEducation"},{"schema": "Production", "view_name": "vProductAndDescription"},{"schema": "Production", "view_name": "vProductModelCatalogDescription"},{"schema": "Production", "view_name": "vProductModelInstructions"},{"schema": "Sales", "view_name": "vSalesPerson"},{"schema": "Sales", "view_name": "vSalesPersonSalesByFiscalYears"},{"schema": "Person", "view_name": "vStateProvinceCountryRegion"},{"schema": "Sales", "view_name": "vStoreWithDemographics"},{"schema": "Sales", "view_name": "vStoreWithContacts"},{"schema": "Sales", "view_name": "vStoreWithAddresses"},{"schema": "Purchasing", "view_name": "vVendorWithContacts"},{"schema": "Purchasing", "view_name": "vVendorWithAddresses"}], "database_name": "fiddle_7f90ff9102124c209634c9f5e74c48bb", "version": ""}