{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ManualTables"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"ManualTables","index":0,"n_rows":41,"n_cols":8,"rows_kept":41}
["Documentation","My new database"]
[]
["Schema","Table name","Type","Column","Data type","PK","Nullable","Description"]
["HumanResources","Department","TABLE","DepartmentID","smallint",1,null,"Primary key for Department records."]
["HumanResources","Department","TABLE","Name","nvarchar(50)",null,null,"Name of the department."]
["HumanResources","Department","TABLE","GroupName","nvarchar(50)",null,null,"Name of the group to which the department belongs."]
["HumanResources","Department","TABLE","ModifiedDate","datetime",null,null,"Date and time the record was last updated."]
["HumanResources","Employee","TABLE","BusinessEntityID","int",1,null,"Primary key for Employee records.  Foreign key to BusinessEntity.BusinessEntityID."]
["HumanResources","Employee","TABLE","NationalIDNumber","nvarchar(15)",null,null,"Unique national identification number such as a social security number."]
["HumanResources","Employee","TABLE","LoginID","nvarchar(256)",null,null,"Network login."]
["HumanResources","Employee","TABLE","OrganizationNode","hierarchyid",null,1,"Where the employee is located in corporate hierarchy."]
["HumanResources","Employee","TABLE","OrganizationLevel","smallint",null,1,"The depth of the employee in the corporate hierarchy."]
["HumanResources","Employee","TABLE","JobTitle","nvarchar(50)",null,null,"Work title such as Buyer or Sales Representative."]
["HumanResources","Employee","TABLE","BirthDate","date",null,null,"Date of birth."]
["HumanResources","Employee","TABLE","MaritalStatus","nchar(1)",null,null,"M = Married, S = Single"]
["HumanResources","Employee","TABLE","Gender","nchar(1)",null,null,"M = Male, F = Female"]
["HumanResources","Employee","TABLE","HireDate","date",null,null,"Employee hired on this date."]
["HumanResources","Employee","TABLE","SalariedFlag","bit",null,null,"Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining."]
["HumanResources","Employee","TABLE","VacationHours","smallint",null,null,"Number of available vacation hours."]
["HumanResources","Employee","TABLE","SickLeaveHours","smallint",null,null,"Number of available sick leave hours."]
["HumanResources","Employee","TABLE","CurrentFlag","bit",null,null,"0 = Inactive, 1 = Active"]
["HumanResources","Employee","TABLE","rowguid","uniqueidentifier"]
["HumanResources","Employee","TABLE","ModifiedDate","datetime"]
["HumanResources","vEmployee","VIEW","BusinessEntityID","int"]
["HumanResources","vEmployee","VIEW","Title","nvarchar(8)",null,1]
["HumanResources","vEmployee","VIEW","FirstName","nvarchar(50)"]
["HumanResources","vEmployee","VIEW","MiddleName","nvarchar(50)"]
["HumanResources","vEmployee","VIEW","LastName","nvarchar(50)"]
["HumanResources","vEmployee","VIEW","Suffix","nvarchar(10)"]
["HumanResources","vEmployee","VIEW","JobTitle","nvarchar(50)",null,1]
["HumanResources","vEmployee","VIEW","PhoneNumber","nvarchar(25)"]
["HumanResources","vEmployee","VIEW","PhoneNumberType","nvarchar(50)",null,1]
["HumanResources","vEmployee","VIEW","EmailAddress","nvarchar(50)"]
["HumanResources","vEmployee","VIEW","EmailPromotion","int",null,1]
["HumanResources","vEmployee","VIEW","AddressLine1","nvarchar(60)"]
["HumanResources","vEmployee","VIEW","AddressLine2","nvarchar(60)"]
["HumanResources","vEmployee","VIEW","City","nvarchar(30)",null,1]
["HumanResources","vEmployee","VIEW","StateProvinceName","nvarchar(50)",null,1]
["HumanResources","vEmployee","VIEW","PostalCode","nvarchar(15)",null,1]
["HumanResources","vEmployee","VIEW","CountryRegionName","nvarchar(50)",null,1]
["HumanResources","vEmployee","VIEW","AdditionalContactInfo","xml"]