{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Start","Tables","Procedures","UniqueKeys","Relations"],"not_rendered":{"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":10,"n_cols":3,"rows_kept":10}
[]
[null,"Documentation name","New Documentation"]
[]
[]
[null,null,"Additional information:"]
[null,null,"Click the button to generate a script based on the Tables and Relations sheets."]
[null,null,"The script will be saved as a text file in your documents folder."]
[null,null,"The script first creates a new documentation with name as specified in C2 field above."]
[null,null,"Then it inserts the tables and columns, then relations."]
[null,null,"If an existing column or table can't be matched for keys or relations, it will be ignored"]

{"sheet":"Tables","index":1,"n_rows":38,"n_cols":52,"rows_kept":38}
["Schema","Table name","Type","Column name","Column title","Data type","PK","Nullable","Identity","Default value","Computed formula","Column description","CustomField_1","CustomField_2","CustomField_3","CustomField_4","CustomField_5","CustomField_6","CustomField_7","CustomField_8","CustomField_9","CustomField_10","CustomField_11","CustomField_12","CustomField_13","CustomField_14","CustomField_15","CustomField_16","CustomField_17","CustomField_18","CustomField_19","CustomField_20","CustomField_21","CustomField_22","CustomField_23","CustomField_24","CustomField_25","CustomField_26","CustomField_27","CustomField_28","CustomField_29","CustomField_30","CustomField_31","CustomField_32","CustomField_33","CustomField_34","CustomField_35","CustomField_36","CustomField_37","CustomField_38","CustomField_39","CustomField_40"]
["HumanResources","Department","TABLE","DepartmentID",null,"smallint",1,{"$nulls":4},"Primary key for Department records."]
["HumanResources","Department","TABLE","Name",null,"nvarchar",{"$nulls":5},"Name of the department."]
["HumanResources","Department","TABLE","GroupName",null,"nvarchar",{"$nulls":5},"Name of the group to which the department belongs."]
["HumanResources","Department","TABLE","ModifiedDate",null,"datetime",{"$nulls":5},"Date and time the record was last updated."]
["HumanResources","Employee","TABLE","BusinessEntityID",null,"int",1,{"$nulls":4},"Primary key for Employee records.  Foreign key to BusinessEntity.BusinessEntityID."]
["HumanResources","Employee","TABLE","NationalIDNumber",null,"nvarchar",{"$nulls":5},"Unique national identification number such as a social security number."]
["HumanResources","Employee","TABLE","LoginID",null,"nvarchar",{"$nulls":5},"Network login."]
["HumanResources","Employee","TABLE","OrganizationNode",null,"hierarchyid",null,1,{"$nulls":3},"Where the employee is located in corporate hierarchy."]
["HumanResources","Employee","TABLE","OrganizationLevel",null,"smallint",null,1,{"$nulls":3},"The depth of the employee in the corporate hierarchy."]
["HumanResources","Employee","TABLE","JobTitle",null,"nvarchar",{"$nulls":5},"Work title such as Buyer or Sales Representative."]
["HumanResources","Employee","TABLE","BirthDate",null,"date",{"$nulls":5},"Date of birth."]
["HumanResources","Employee","TABLE","MaritalStatus",null,"nchar",{"$nulls":5},"M = Married, S = Single"]
["HumanResources","Employee","TABLE","Gender",null,"nchar",{"$nulls":5},"M = Male, F = Female"]
["HumanResources","Employee","TABLE","HireDate",null,"date",{"$nulls":5},"Employee hired on this date."]
["HumanResources","Employee","TABLE","SalariedFlag",null,"bit",{"$nulls":5},"Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining."]
["HumanResources","Employee","TABLE","VacationHours",null,"smallint",{"$nulls":5},"Number of available vacation hours."]
["HumanResources","Employee","TABLE","SickLeaveHours",null,"smallint",{"$nulls":5},"Number of available sick leave hours."]
["HumanResources","Employee","TABLE","CurrentFlag",null,"bit",{"$nulls":5},"0 = Inactive, 1 = Active"]
["HumanResources","Employee","TABLE","rowguid",null,"uniqueidentifier"]
["HumanResources","Employee","TABLE","ModifiedDate",null,"datetime"]
["HumanResources","vEmployee","VIEW","BusinessEntityID",null,"int"]
["HumanResources","vEmployee","VIEW","Title",null,"nvarchar(8)",null,1]
["HumanResources","vEmployee","VIEW","FirstName",null,"nvarchar(50)"]
["HumanResources","vEmployee","VIEW","MiddleName",null,"nvarchar(50)"]
["HumanResources","vEmployee","VIEW","LastName",null,"nvarchar(50)"]
["HumanResources","vEmployee","VIEW","Suffix",null,"nvarchar(10)"]
["HumanResources","vEmployee","VIEW","JobTitle",null,"nvarchar(50)",null,1]
["HumanResources","vEmployee","VIEW","PhoneNumber",null,"nvarchar(25)"]
["HumanResources","vEmployee","VIEW","PhoneNumberType",null,"nvarchar(50)",null,1]
["HumanResources","vEmployee","VIEW","EmailAddress",null,"nvarchar(50)"]
["HumanResources","vEmployee","VIEW","EmailPromotion",null,"int",null,1]
["HumanResources","vEmployee","VIEW","AddressLine1",null,"nvarchar(60)"]
["HumanResources","vEmployee","VIEW","AddressLine2",null,"nvarchar(60)"]
["HumanResources","vEmployee","VIEW","City",null,"nvarchar(30)",null,1]
["HumanResources","vEmployee","VIEW","StateProvinceName",null,"nvarchar(50)",null,1]
["HumanResources","vEmployee","VIEW","PostalCode",null,"nvarchar(15)",null,1]
["HumanResources","vEmployee","VIEW","CountryRegionName",null,"nvarchar(50)",null,1]

{"sheet":"Procedures","index":2,"n_rows":1,"n_cols":47,"rows_kept":1,"hidden":true}
["Schema","Procedure name","Type","Parameter name","Data mode","Data type","Procedure description","CustomField_1","CustomField_2","CustomField_3","CustomField_4","CustomField_5","CustomField_6","CustomField_7","CustomField_8","CustomField_9","CustomField_10","CustomField_11","CustomField_12","CustomField_13","CustomField_14","CustomField_15","CustomField_16","CustomField_17","CustomField_18","CustomField_19","CustomField_20","CustomField_21","CustomField_22","CustomField_23","CustomField_24","CustomField_25","CustomField_26","CustomField_27","CustomField_28","CustomField_29","CustomField_30","CustomField_31","CustomField_32","CustomField_33","CustomField_34","CustomField_35","CustomField_36","CustomField_37","CustomField_38","CustomField_39","CustomField_40"]

{"sheet":"UniqueKeys","index":3,"n_rows":1,"n_cols":46,"rows_kept":1,"hidden":true}
["Key name","Table schema","Table name","Table type","Column name","Key description","CustomField_1","CustomField_2","CustomField_3","CustomField_4","CustomField_5","CustomField_6","CustomField_7","CustomField_8","CustomField_9","CustomField_10","CustomField_11","CustomField_12","CustomField_13","CustomField_14","CustomField_15","CustomField_16","CustomField_17","CustomField_18","CustomField_19","CustomField_20","CustomField_21","CustomField_22","CustomField_23","CustomField_24","CustomField_25","CustomField_26","CustomField_27","CustomField_28","CustomField_29","CustomField_30","CustomField_31","CustomField_32","CustomField_33","CustomField_34","CustomField_35","CustomField_36","CustomField_37","CustomField_38","CustomField_39","CustomField_40"]

{"sheet":"Relations","index":4,"n_rows":5,"n_cols":53,"rows_kept":5}
["Relation name","PK table schema","PK table name","PK table type","PK column name","PK cardinality type","FK cardinality type","FK table schema","FK table name","FK table type","FK column name","Relation title","Relation description","CustomField_1","CustomField_2","CustomField_3","CustomField_4","CustomField_5","CustomField_6","CustomField_7","CustomField_8","CustomField_9","CustomField_10","CustomField_11","CustomField_12","CustomField_13","CustomField_14","CustomField_15","CustomField_16","CustomField_17","CustomField_18","CustomField_19","CustomField_20","CustomField_21","CustomField_22","CustomField_23","CustomField_24","CustomField_25","CustomField_26","CustomField_27","CustomField_28","CustomField_29","CustomField_30","CustomField_31","CustomField_32","CustomField_33","CustomField_34","CustomField_35","CustomField_36","CustomField_37","CustomField_38","CustomField_39","CustomField_40"]
["relation_1","HumanResources","Department","TABLE","DepartmentID","ONE","ONE","HumanResources","Employee","TABLE","MaritalStatus"]
["relation_2","HumanResources","Employee","TABLE","BusinessEntityID","ONE","MANY","HumanResources","vEmployee","VIEW","EmailPromotion"]
["relation_2","HumanResources","Employee","TABLE","NationalIDNumber","ONE","MANY","HumanResources","vEmployee","VIEW","AddressLine1"]
["relation_3","HumanResources","vEmployee","VIEW","BusinessEntityID","MANY","MANY","HumanResources","Department","TABLE","Name"]