{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Lapa1"],"read":"whole","date_system":"1900"}

{"sheet":"Lapa1","index":0,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,1,1,2],[1,5,1,6],[1,9,1,10],[1,13,1,14],[9,1,9,2],[9,5,9,6],[9,9,9,10],[9,13,9,14]]}
[]
["Tabula, kas glabā datus par lietotājiem.","lietotaji",null,null,"Tabula, kas glabā failu kategorijas, ja tiek pievienoti, saglabājot failus.","kategorijas",null,null,"Tabula, kas glabā datus par izveidotām koplietošanas grupām.","grupas",null,null,"Tabula, kas sasaista failus ar grupām, kuros tie tiek dalīti.","grupas_faili",{"$nulls":3},"Komentāri atrodas tabulas kreisajā pusē!"]
["Lietotāja id","id","INT(11)",null,"Kategoriju ID","id","INT(11)",null,"Grupas ID","id","INT(11)",null,"Grupas un failu sasaistes ID","id","INT(11)"]
["Lietotāvārds","vards","VARCHAR(50)",null,"Kategorijas nosaukums","kategorija","VARCHAR(50)",null,"Grupas autora lietotāja ID (foreign key)","lietotaji_id","INT(11)",null,"Failu ID (foreign key)","faili_id","INT(11)"]
["Lietotāja parole","parole","VARCHAR(120)",{"$nulls":5},"Grupas nosaukums","nosaukums","VARCHAR(50)",null,"Grupas ID (foreign key)","grupas_id","INT(11)"]
[{"$nulls":8},"Grupas apraksts, ja tiek pievienots","apraksts","VARCHAR(255)"]
[]
[]
[]
["Tabula, kas sasaista lietotājus ar grupām, kuros viņi ir pievienoti.","dalibnieki",null,null,"Tabula, kas glabā datus par saglabātiem failiem.","faili",null,null,"Tabula, kas sasaista lietotājus ar viņu saglabātiem failiem.","faili_lietotaji",null,null,"Tabula, kas sasaista failus ar kategorijām, kas tika tiem pievienoti (ja tie tika pievienoti).","faili_kategorijas"]
["Dalībnieku ID","id","INT(11)",null,"Failu ID","id","INT(11)",null,"Lietotāju un failu sasaistes ID","id","INT(11)",null,"Failu un kategoriju sasaistes ID","id","INT(11)"]
["Lietotāju ID (foreign key(","lietotaji_id","INT(11)",null,"Failu nosaukums","nosaukums","VARCHAR(50)",null,"Lietotāju ID (foreign key)","lietotaji_id","INT(11)",null,"Failu ID (foreign key)","faili_id","INT(11)"]
["Grupas ID (foreign key)","grupas_id","INT(11)",null,"Faila iekļautais teksts, kuru lietotājs ievadīja un/vai stilizēja piezīmjblokā","teksts","TEXT",null,"Failu ID (foreign key)","faili_id","INT(11)",null,"Kategoriju ID (foreign key)","kategorijas_id","INT(11)"]
[{"$nulls":4},"Failu apraksts, ja pievienots","apraksts","TEXT"]
[{"$nulls":4},"Failu attels, ja pievienots","attels","MEDIUMBLOB"]
[{"$nulls":4},"Failu izveides datums","datums","DATE"]
[{"$nulls":4},"Failu izveides laiks","laiks","TIME"]
[]
[]
[]
[]
[]
[null,"\"piezimjbloks\" datubāzes ER diagramma"]