{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["OOOTORG_LOGUTOV"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OOOTORG_LOGUTOV","index":0,"n_rows":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":false,"merged":[[26,0,26,4],[0,0,0,4],[1,0,1,4],[3,0,3,4],[18,0,18,4],[8,0,8,4],[13,0,13,4],[68,0,68,4],[73,0,73,4],[33,0,33,4],[39,0,39,4],[50,0,50,4],[55,0,55,4],[62,0,62,4]]}
["Data Dictionary"]
[]
[]
["City"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id города","int","Y","Указать id города"]
[null,"Наименование","VARCHAR (50)","Y","Указать наименование"]
[]
["Company"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
[null,"id компании","int","Y","Указать id компании"]
[null,"Наименование","VARCHAR (50)","Y","Указать наименование"]
[]
["Countries"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id страны","int","Y","Указать id страны"]
[null,"Наименование","nvarchar(50)","Y","Указать наименование"]
[]
["Customers"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id заказчика","int","Y","Указать id заказчика"]
[null,"ФИО","VARCHAR (200)","Y","Указать ФИО заказчика"]
[null,"Номер телефона","nvarchar(12)","Y","Указать номер телефона заказчика"]
["FK","Город","int","Y","Указать айди города заказчика"]
["FK","Страна","int","Y","Указать айди страны заказчика"]
[]
["Goods"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id товара","int","Y","Указать id товара"]
[null,"Наименование","nvarchar(50)","Y","Указать наименование товара"]
["FK","Производитель","int","Y","Указать id производителя"]
["FK","Цена","int","Y","Указать id цены товара"]
[]
["Manufacturers"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id производителя","int","Y","Указать id производителя"]
[null,"Наименование","nvarchar(50)","Y","Указать наименование производителя"]
["FK","Компания","int","Y","Указать id компании"]
[]
["Orders"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id заказа","int","Y","Указать id заказа"]
["FK","id товара","int","Y","Указать id товара"]
[null,"Наименование","nvarchar(50)","Y","Указать наименование заказа"]
["FK","Заказчик","int","Y","Указать id заказчика"]
[null,"Номер телефона","nvarchar(12)","Y","Указать номер телефона закчика"]
["FK","Статус заказа","int","Y","Указать id статуса заказа"]
["FK","Спопоб оплаты","int","Y","Указать id способа оплаты заказчика"]
["FK","Единица измерения","int","Y","Указать id единицы измерения "]
[]
["Payment"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id способа оплаты","int","Y","Указать id способа оплаты"]
[null,"Наименование","nvarchar(50)","Y","Указать наименование спопосба оплаты"]
[]
["Prices"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id цены","int","Y","Указать id цены"]
["FK","id товара","int","Y","Указать id товара"]
[null,"Цена","nvarchar(50)","Y","Указать Цену"]
[null,"Дата","date","Y","Указать дату"]
[]
["Sales"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id продажи","int","Y","Указать id продажи"]
["FK","Заказчик","int","Y","Указать id заказчика"]
["FK","Товар","int","Y","Указать id товара"]
[]
["Status"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id статуса","int","Y","Указать id статуса"]
[null,"Наименование","nvarchar(50)","Y","Указать наименование"]
[]
["Units"]
["KEY","FIELD NAME","DATA TYPE / FIELD SIZE","REQUIRED?","NOTES"]
["PK","id единицы измерения","int","Y","Указать id единицы измерения"]
[null,"Наименование","nvarchar(50)","Y","Указать наименование"]