{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Sheet1","ieteikumi","ERD","ERD2","ERD3","ERD4","presentation","dokumentation"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":36,"n_cols":24,"rows_kept":36,"merged":[[5,2,5,12],[7,3,7,6],[7,8,7,12],[7,14,7,23],[12,3,12,5]]}
[]
[]
[]
[]
[]
[null,null,"MANGA-IZER ERD"]
[]
[{"$nulls":3},"SEARCH",{"$nulls":4},"SORT",{"$nulls":5},"TABULA"]
[{"$nulls":3},"ID","NAME","SCORE","IMG",null,"ID","SCORE","GENRE","AUTHOR","IMG",null,"mainīgo nosaukums","ID","NAME","AUTHOR","GENRE","SCORE","TYPE","DATE_OF_PUBLISHING","ONGOING","IMG"]
[{"$nulls":3},"(int)","(string)","(varchar)","(png)",null,"(int)","(varchar)","(string)","(string)","(png)",null,"atšifrējums","id","nosaukums","autors","žanrs","vērtējums","tips","izlaišanas datums","vai vēl tiek izlaista","bilde"]
[{"$nulls":14},"datu tips","(int)","(string)","(string)","(string)","(varchar)","(string)","(date)","(boolean)","(png)"]
[]
[{"$nulls":3},"MANGA DB"]
[{"$nulls":4},"ID","NAME"]
[{"$nulls":4},"(int)","(string)"]
[]
[{"$nulls":4},"ID","AUTHOR"]
[{"$nulls":4},"(int)","(string)"]
[]
[{"$nulls":4},"ID","SCORE"]
[{"$nulls":4},"(int)","(varchar)"]
[]
[{"$nulls":4},"ID","GENRE"]
[{"$nulls":4},"(int)","(string)"]
[]
[{"$nulls":4},"ID","TYPE"]
[{"$nulls":4},"(int)","(string)"]
[]
[{"$nulls":4},"ID","IMG"]
[{"$nulls":4},"(int)","(png)"]
[]
[{"$nulls":4},"ID","DATE_OF_PUBLISHING"]
[{"$nulls":4},"(int)","(date)"]
[]
[{"$nulls":4},"ID","ONGOING"]
[{"$nulls":4},"(int)","(boolean)"]

{"sheet":"ieteikumi","index":1,"n_rows":15,"n_cols":31,"rows_kept":15,"merged":[[0,11,0,16],[0,18,0,19],[0,21,0,22],[0,24,0,30]]}
["ID","NAME","AUTHOR","GENRE","SCORE","TYPE","DATE_OF_PUBLISHING","ONGOING","IMG",null,null,"albuma nosaukums",{"$nulls":6},"autors",null,null,"zandrs",null,null,"bilde"]
["id","nosaukums","autors","žanrs","vērtējums","tips","izlaišanas datums","vai vēl tiek izlaista","bildes nosaukums",null,null,"ID","NAME","DATE_OF_PUBLISHING","ONGOING","zandrs_id","autors_id",null,"ID","AUTHOR",null,"ID","GENRE",null,"ID","NAME","DATE_OF_PUBLISHING","IMG","SCORE","TYPE","alb_id"]
["(int)","varchar(???)","varchar(???)","varchar(???)","(varchar)","(string)","(date)","tinyint(1)","varchar(50)",null,null,"id","nosaukums","izlaišanas datums","vai vēl tiek izlaista","Zandra id","autora_id",null,"id","autors",null,"id","žanrs",null,"id","nosaukums","izlaišanas datums","bildes nosaukums","vērtējums","tips","albuma_id"]
[{"$nulls":11},"(int)","varchar(???)","(date)","tinyint(1)","(int)","(int)",null,"(int)","varchar(???)",null,"(int)","varchar(???)",null,"(int)","varchar(???)","(date)","varchar(50)","(varchar)","(string)","(int)"]
{"$rows_empty":10}
["Vai katrai bildei ir nosaukums vai ar bilžu grupai ir nosaukums?"]

{"sheet":"ERD","index":2,"n_rows":97,"n_cols":27,"rows_kept":97,"merged":[[2,2,2,4],[2,6,2,8],[3,2,3,4],[3,6,3,8],[7,6,7,8],[8,6,8,8],[12,2,12,4],[13,2,13,4],[13,6,13,8],[14,6,14,8],[17,2,17,4],[18,2,18,4],[18,6,18,8],[19,6,19,8],[23,2,23,4],[24,2,24,4],[31,0,32,10],[31,11,32,17],[31,18,32,27],[33,1,36,1],[33,3,33,9],[33,12,34,12],[33,14,33,16],[33,19,34,19],[33,21,33,26],[34,3,34,9],[35,3,35,9],[39,19,40,26],[40,12,41,16],[43,1,43,9],[44,1,47,1],[44,3,44,9],[45,3,45,9],[45,19,46,19],[45,21,45,26],[46,3,46,9],[46,12,47,12],[46,14,46,16],[48,19,48,26],[50,12,50,16],[52,1,52,9],[53,1,56,1],[53,3,53,9],[54,3,54,9],[54,19,55,19],[54,21,54,26],[55,3,55,9],[55,12,56,12],[55,14,55,16],[57,19,57,26],[58,12,58,16],[59,1,59,9],[60,1,63,1],[60,3,60,9],[61,3,61,9],[62,3,62,9],[62,12,63,12],[62,14,62,16],[63,19,64,19],[63,21,63,26],[65,12,65,16],[66,1,66,9],[66,19,66,26],[67,1,70,1],[67,3,67,9],[68,3,68,9],[69,3,69,9],[69,12,70,12],[69,14,69,16],[72,12,72,16],[73,1,73,9],[74,1,77,1],[74,3,74,9],[75,3,75,9],[76,3,76,9],[76,12,77,12],[76,14,76,16],[80,1,80,9],[80,12,80,16],[81,1,84,1],[81,3,81,9],[82,3,82,9],[83,3,83,9],[84,12,85,12],[84,14,84,16],[87,12,87,16],[88,1,88,9],[89,1,92,1],[89,3,89,9],[90,3,90,9],[91,3,91,9],[91,12,92,12],[91,14,91,16],[94,12,94,16],[96,1,96,9],[97,1,97,9]]}
[]
[]
[null,null,"title",{"$nulls":3},"status"]
[null,null,"Albuma nosaukums",{"$nulls":3},"Albuma izlaišanas status"]
[null,null,"ID","id","(int)",null,"ID","id","(int)"]
[null,null,"NAME","nosaukums","varchar(100)",null,"STATUS","Albuma status","varchar(20)"]
[null,null,"DATE_OF_PUBLISHING","izlaišanas datums","(date)"]
[null,null,"STATUS_ID","statusa id","(int)",null,"title_genre"]
[null,null,"GENRE_ID","žanra id","(int)",null,"ar titulu saistītie žanri"]
[null,null,"AUTHOR_ID","autora id","(int)",null,"ID","id","(int)"]
[null,null,"DESCRIPTION_ID","apraksta id","(int)",null,"TITLE_ID","albuma id","(int)"]
[{"$nulls":6},"GENRE_ID","žanra id","(int)"]
[null,null,"description"]
[null,null,"albuma apraksts",{"$nulls":3},"genre"]
[null,null,"ID","id","(int)",null,"žanrs"]
[null,null,"DESCRIPTION","Albuma apraksts","varchar(1500)",null,"ID","id","(int)"]
[{"$nulls":6},"GENRE","žanrs","varchar(30)"]
[null,null,"title_author"]
[null,null,"ar titulu saistītie autori",{"$nulls":3},"image"]
[null,null,"ID","id","(int)",null,"bilde"]
[null,null,"TITLE_ID","albuma id","(int)",null,"ID","id","(int)"]
[null,null,"AUTHOR_ID","autora id","(int)",null,"NAME","nosaukums","varchar(40)"]
[{"$nulls":6},"SCORE","vērtējums","dec(5,2)"]
[null,null,"author",{"$nulls":3},"MANGA_ID","albuma id","(int)"]
[null,null,"autori"]
[null,null,"ID","id","(int)"]
[null,null,"AUTHOR","autors","varchar(50)"]
[]
[]
[]
[]
["Apraksts",{"$nulls":10},"Indekss",{"$nulls":6},"Relācijas"]
[]
[null,"NR.","Tabulas nosaukums","title",{"$nulls":8},"NR.","Tabulas nosaukums","title",{"$nulls":4},"NR.","Tabulas nosaukums","title"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Komentārs","Albuma nosaukums",{"$nulls":8},1,"PRIMARY","PK","Jā","ID",null,null,1,"STATUS_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,2,"kid","FK","Nē","kid",null,null,2,"GENRE_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"Albuma id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},3,"kid","FK","Nē","kid",null,null,3,"AUTHOR_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,2,"NAME","varchar(100)",null,"nosaukums","Nē",{"$nulls":5},4,"kid","FK","Nē","kid",null,null,4,"DESCRIPTION_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,3,"DATE_OF_PUBLISHING","date",null,"izlaišanas datums","Nē",{"$nulls":5},5,"kid","FK","Nē","kid",null,null,"Ši tabula parāda relāciju starp title, status (STATUS_ID), genre (GENRE_ID), author (AUTHOR_ID) un description (DESCRIPTION_ID)"]
[null,4,"STATUS","varchar(20)",null,"vai vēl tiek izlaista","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un title_genre, title un title_author, title un status un starp title un description"]
[null,5,"GENRE_ID","int",true,"Zandra id","Nē",null,"FK",{"$nulls":11},"`"]
[null,6,"AUTHOR_ID","int",true,"autora id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti albūma nosaukumi (NAME), izlaišanas datumi (DATE) un vai vel tiek izlaista (STATUS)"]
[null,"NR.","Tabulas nosaukums","image"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":15},"NR.","Tabulas nosaukums","image"]
[null,null,"Komentārs","Bildes",{"$nulls":8},"NR.","Tabulas nosaukums","image",{"$nulls":5},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,1,"MANGA_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"Bildes id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID",null,null,"Ši tabula parāda relāciju starp image un title (MANGA_ID)"]
[null,2,"NAME","varchar(40)",null,"nosaukums","Nē",{"$nulls":5},2,"kid","FK","Nē","kid"]
[null,4,"SCORE","dec(5,2)",true,"vērtējums","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp image un title"]
[null,5,"MANGE_ID","int",true,"albuma id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti bilžu nosaukumi (NAME) un albūmu vērtejumi (SCORE)"]
[null,"NR.","Tabulas nosaukums","author"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":15},"NR.","Tabulas nosaukums","title_genre"]
[null,null,"Komentārs","Albuma autors",{"$nulls":8},"NR.","Tabulas nosaukums","title_author",{"$nulls":5},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,1,"GENRE_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"autora id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID",null,null,"Ši tabula parāda relāciju starp title_genre un title (MANGA_ID)"]
[null,2,"AUTHOR","varchar(50)",null,"albuma id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un title_author"]
[null,"Šajā tabulā tiek glabāti autoru vārdi, uzvārdi (AUTHOR)"]
[null,"NR.","Tabulas nosaukums","genre"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","žanrs",{"$nulls":8},"NR.","Tabulas nosaukums","title_genre"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"NR.","Tabulas nosaukums","title_author"]
[null,1,"ID","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,2,"GENRE","varchar(30)",null,"albuma id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un title_genre",{"$nulls":6},1,"AUTHOR_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,"Šajā tabulā tiek glabāti albūmu žanri (GENRE)",{"$nulls":17},"Ši tabula parāda relāciju starp title_author un title (MANGA_ID)"]
[null,"NR.","Tabulas nosaukums","status"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","žanrs",{"$nulls":8},"NR.","Tabulas nosaukums","status"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,1,"ID","int",true,"status id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,2,"STATUS","varchar(30)",null,"Albuma status","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp image un title"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (STATUS)"]
[null,"NR.","Tabulas nosaukums","description"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","apraksts",{"$nulls":8},"NR.","Tabulas nosaukums","genre"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,1,"ID","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,2,"DESCRIPTION","varchar(250)",null,"apraksta id","Nē",{"$nulls":5},2,"kid","FK","Nē","kid"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (DESCRIPTION)",{"$nulls":10},"Ši tabula parāda Indeksu starp title_genre un genre"]
[null,"NR.","Tabulas nosaukums","title_genre"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","žanrs"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,"NR.","Tabulas nosaukums","description"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":4},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,2,"TITLE_ID","int",null,"albuma id","nē",{"$nulls":5},1,"PRIMARY","PK","Jā","ID"]
[null,3,"GENRE_ID","int",null,"žanra id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un description"]
[null,"Šajā tabulā tiek albumam saistīti žanri"]
[null,"NR.","Tabulas nosaukums","title_author"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","autors",{"$nulls":8},"NR.","Tabulas nosaukums","author"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,2,"TITLE_ID","int",null,"albuma id","nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title_author un author"]
[null,3,"AUTHOR_ID","int",null,"žanra id","Nē"]
[null,"Šajā tabulā tiek albumam saistīti autori"]

{"sheet":"ERD2","index":3,"n_rows":96,"n_cols":27,"rows_kept":96,"merged":[[2,2,2,4],[2,6,2,8],[2,10,2,12],[2,14,2,16],[3,2,3,4],[3,6,3,8],[3,10,3,12],[3,14,3,16],[7,6,7,8],[7,14,7,16],[8,6,8,8],[8,14,8,16],[12,2,12,4],[12,10,12,12],[13,2,13,4],[13,6,13,8],[13,10,13,12],[14,6,14,8],[17,2,17,4],[18,2,18,4],[18,6,18,8],[19,6,19,8],[23,2,23,4],[24,2,24,4],[30,0,31,10],[30,11,31,17],[30,18,31,27],[32,1,35,1],[32,3,32,9],[32,12,33,12],[32,14,32,16],[32,19,33,19],[32,21,32,26],[33,3,33,9],[34,3,34,9],[38,19,39,26],[39,12,40,16],[42,1,42,9],[43,1,46,1],[43,3,43,9],[44,3,44,9],[44,19,45,19],[44,21,44,26],[45,3,45,9],[45,12,46,12],[45,14,45,16],[47,19,47,26],[49,12,49,16],[51,1,51,9],[52,1,55,1],[52,3,52,9],[53,3,53,9],[53,19,54,19],[53,21,53,26],[54,3,54,9],[54,12,55,12],[54,14,54,16],[56,19,56,26],[57,12,57,16],[58,1,58,9],[59,1,62,1],[59,3,59,9],[60,3,60,9],[61,3,61,9],[61,12,62,12],[61,14,61,16],[62,19,63,19],[62,21,62,26],[64,12,64,16],[65,1,65,9],[65,19,65,26],[66,1,69,1],[66,3,66,9],[67,3,67,9],[68,3,68,9],[68,12,69,12],[68,14,68,16],[71,12,71,16],[72,1,72,9],[73,1,76,1],[73,3,73,9],[74,3,74,9],[75,3,75,9],[75,12,76,12],[75,14,75,16],[79,1,79,9],[79,12,79,16],[80,1,83,1],[80,3,80,9],[81,3,81,9],[82,3,82,9],[83,12,84,12],[83,14,83,16],[86,12,86,16],[87,1,87,9],[88,1,91,1],[88,3,88,9],[89,3,89,9],[90,3,90,9],[90,12,91,12],[90,14,90,16],[93,12,93,16],[95,1,95,9],[96,1,96,9]]}
[]
[]
[null,null,"title",{"$nulls":3},"status",{"$nulls":3},"login",{"$nulls":3},"username"]
[null,null,"Albuma nosaukums",{"$nulls":3},"Albuma izlaišanas status",{"$nulls":3},"login logs",{"$nulls":3},"lietotāju nosaukumu saraksts"]
[null,null,"ID","id","(int)",null,"ID","id","(int)",null,"ID","id","(int)",null,"ID","id","(int)"]
[null,null,"NAME","nosaukums","varchar(100)",null,"STATUS","Albuma status","varchar(20)",null,"USER_ID","nosaukuma id","(int)",null,"USER","nosaukums","varchar(100)"]
[null,null,"DATE_OF_PUBLISHING","izlaišanas datums","(date)",{"$nulls":5},"PASSWORD_ID","paroles id","(int)"]
[null,null,"STATUS_ID","statusa id","(int)",null,"title_genre",{"$nulls":7},"password"]
[null,null,"GENRE_ID","žanra id","(int)",null,"ar titulu saistītie žanri",{"$nulls":7},"paroļu saraksts"]
[null,null,"AUTHOR_ID","autora id","(int)",null,"ID","id","(int)",{"$nulls":5},"ID","id","(int)"]
[null,null,"DESCRIPTION_ID","apraksta id","(int)",null,"TITLE_ID","albuma id","(int)",{"$nulls":5},"PASSWORD","parole","char(60)"]
[{"$nulls":6},"GENRE_ID","žanra id","(int)"]
[null,null,"description",{"$nulls":7},"list"]
[null,null,"albuma apraksts",{"$nulls":3},"genre",{"$nulls":3},"uzdevumu saraksts"]
[null,null,"ID","id","(int)",null,"žanrs",{"$nulls":3},"ID","id","(int)"]
[null,null,"DESCRIPTION","Albuma apraksts","varchar(1500)",null,"ID","id","(int)",null,"MANGA_ID","albuma id","(int)"]
[{"$nulls":6},"GENRE","žanrs","varchar(30)",null,"USER_ID","lietotāja id","(int)"]
[null,null,"title_author"]
[null,null,"ar titulu saistītie autori",{"$nulls":3},"image"]
[null,null,"ID","id","(int)",null,"bilde"]
[null,null,"TITLE_ID","albuma id","(int)",null,"ID","id","(int)"]
[null,null,"AUTHOR_ID","autora id","(int)",null,"NAME","nosaukums","varchar(40)"]
[{"$nulls":6},"SCORE","vērtējums","dec(5,2)"]
[null,null,"author",{"$nulls":3},"MANGA_ID","albuma id","(int)"]
[null,null,"autori"]
[null,null,"ID","id","(int)"]
[null,null,"AUTHOR","autors","varchar(50)",{"$nulls":4}," "]
[]
[]
[]
["Apraksts",{"$nulls":10},"Indekss",{"$nulls":6},"Relācijas"]
[]
[null,"NR.","Tabulas nosaukums","title",{"$nulls":8},"NR.","Tabulas nosaukums","title",{"$nulls":4},"NR.","Tabulas nosaukums","title"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Komentārs","Albuma nosaukums",{"$nulls":8},1,"PRIMARY","PK","Jā","ID",null,null,1,"STATUS_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,2,"kid","FK","Nē","kid",null,null,2,"GENRE_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"Albuma id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},3,"kid","FK","Nē","kid",null,null,3,"AUTHOR_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,2,"NAME","varchar(100)",null,"nosaukums","Nē",{"$nulls":5},4,"kid","FK","Nē","kid",null,null,4,"DESCRIPTION_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,3,"DATE_OF_PUBLISHING","date",null,"izlaišanas datums","Nē",{"$nulls":5},5,"kid","FK","Nē","kid",null,null,"Ši tabula parāda relāciju starp title, status (STATUS_ID), genre (GENRE_ID), author (AUTHOR_ID) un description (DESCRIPTION_ID)"]
[null,4,"STATUS","varchar(20)",null,"vai vēl tiek izlaista","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un title_genre, title un title_author, title un status un starp title un description"]
[null,5,"GENRE_ID","int",true,"Zandra id","Nē",null,"FK",{"$nulls":11},"`"]
[null,6,"AUTHOR_ID","int",true,"autora id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti albūma nosaukumi (NAME), izlaišanas datumi (DATE) un vai vel tiek izlaista (STATUS)"]
[null,"NR.","Tabulas nosaukums","image"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":15},"NR.","Tabulas nosaukums","image"]
[null,null,"Komentārs","Bildes",{"$nulls":8},"NR.","Tabulas nosaukums","image",{"$nulls":5},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,1,"MANGA_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"Bildes id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID",null,null,"Ši tabula parāda relāciju starp image un title (MANGA_ID)"]
[null,2,"NAME","varchar(40)",null,"nosaukums","Nē",{"$nulls":5},2,"kid","FK","Nē","kid"]
[null,4,"SCORE","dec(5,2)",true,"vērtējums","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp image un title"]
[null,5,"MANGE_ID","int",true,"albuma id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti bilžu nosaukumi (NAME) un albūmu vērtejumi (SCORE)"]
[null,"NR.","Tabulas nosaukums","author"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":15},"NR.","Tabulas nosaukums","title_genre"]
[null,null,"Komentārs","Albuma autors",{"$nulls":8},"NR.","Tabulas nosaukums","title_author",{"$nulls":5},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,1,"GENRE_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"autora id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID",null,null,"Ši tabula parāda relāciju starp title_genre un title (MANGA_ID)"]
[null,2,"AUTHOR","varchar(50)",null,"albuma id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un title_author"]
[null,"Šajā tabulā tiek glabāti autoru vārdi, uzvārdi (AUTHOR)"]
[null,"NR.","Tabulas nosaukums","genre"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","žanrs",{"$nulls":8},"NR.","Tabulas nosaukums","title_genre"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"NR.","Tabulas nosaukums","title_author"]
[null,1,"ID","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,2,"GENRE","varchar(30)",null,"albuma id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un title_genre",{"$nulls":6},1,"AUTHOR_ID","Kaskāde","Kaskāde","kid","dragrejs","klients","id"]
[null,"Šajā tabulā tiek glabāti albūmu žanri (GENRE)",{"$nulls":17},"Ši tabula parāda relāciju starp title_author un title (MANGA_ID)"]
[null,"NR.","Tabulas nosaukums","status"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","žanrs",{"$nulls":8},"NR.","Tabulas nosaukums","status"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,1,"ID","int",true,"status id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,2,"STATUS","varchar(30)",null,"Albuma status","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp image un title"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (STATUS)"]
[null,"NR.","Tabulas nosaukums","description"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","apraksts",{"$nulls":8},"NR.","Tabulas nosaukums","genre"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,1,"ID","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,2,"DESCRIPTION","varchar(250)",null,"apraksta id","Nē",{"$nulls":5},2,"kid","FK","Nē","kid"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (DESCRIPTION)",{"$nulls":10},"Ši tabula parāda Indeksu starp title_genre un genre"]
[null,"NR.","Tabulas nosaukums","title_genre"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","žanrs"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,"NR.","Tabulas nosaukums","description"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":4},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,2,"TITLE_ID","int",null,"albuma id","nē",{"$nulls":5},1,"PRIMARY","PK","Jā","ID"]
[null,3,"GENRE_ID","int",null,"žanra id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title un description"]
[null,"Šajā tabulā tiek albumam saistīti žanri"]
[null,"NR.","Tabulas nosaukums","title_author"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","autors",{"$nulls":8},"NR.","Tabulas nosaukums","author"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",{"$nulls":3},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,2,"TITLE_ID","int",null,"albuma id","nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title_author un author"]
[null,3,"AUTHOR_ID","int",null,"žanra id","Nē"]
[null,"Šajā tabulā tiek albumam saistīti autori"]

{"sheet":"ERD3","index":4,"n_rows":150,"n_cols":27,"rows_kept":150,"merged":[[2,2,2,4],[2,6,2,8],[2,10,2,12],[2,14,2,16],[3,2,3,4],[3,6,3,8],[3,10,3,12],[3,14,3,16],[7,6,7,8],[7,14,7,16],[8,6,8,8],[8,14,8,16],[11,10,11,12],[12,10,12,12],[13,2,13,4],[13,6,13,8],[14,2,14,4],[14,6,14,8],[17,10,17,12],[18,2,18,4],[18,6,18,8],[18,10,18,12],[19,2,19,4],[19,6,19,8],[23,2,23,4],[24,2,24,4],[29,2,29,4],[30,2,30,4],[36,0,37,10],[36,11,37,17],[36,18,37,27],[38,1,41,1],[38,3,38,9],[38,12,39,12],[38,14,38,16],[38,19,39,19],[38,21,38,26],[39,3,39,9],[40,3,40,9],[45,19,46,26],[46,12,47,16],[50,1,50,9],[50,19,51,19],[50,21,50,26],[51,1,54,1],[51,3,51,9],[52,3,52,9],[52,12,53,12],[52,14,52,16],[53,3,53,9],[53,19,53,26],[56,12,56,16],[59,1,59,9],[59,19,60,19],[59,21,59,26],[60,1,63,1],[60,3,60,9],[61,3,61,9],[61,12,62,12],[61,14,61,16],[62,3,62,9],[62,19,62,26],[64,12,64,16],[66,1,66,9],[67,1,70,1],[67,3,67,9],[68,3,68,9],[68,12,69,12],[68,14,68,16],[68,19,69,19],[68,21,68,26],[69,3,69,9],[71,12,71,16],[71,19,71,26],[73,1,73,9],[74,1,77,1],[74,3,74,9],[75,3,75,9],[75,12,76,12],[75,14,75,16],[76,3,76,9],[76,19,77,19],[76,21,76,26],[78,12,78,16],[79,19,79,26],[80,1,80,9],[81,1,84,1],[81,3,81,9],[82,3,82,9],[82,12,83,12],[82,14,82,16],[83,3,83,9],[85,19,86,19],[85,21,85,26],[86,12,86,16],[87,1,87,9],[87,12,88,12],[87,14,87,16],[88,1,91,1],[88,3,88,9],[89,3,89,9],[90,3,90,9],[90,12,90,16],[90,19,90,26],[94,12,95,12],[94,14,94,16],[95,1,95,9],[96,1,99,1],[96,3,96,9],[97,3,97,9],[97,12,97,16],[98,3,98,9],[101,12,102,12],[101,14,101,16],[103,1,103,9],[104,1,107,1],[104,3,104,9],[104,12,104,16],[105,3,105,9],[106,3,106,9],[108,12,109,12],[108,14,108,16],[110,1,110,9],[111,1,114,1],[111,3,111,9],[112,3,112,9],[113,3,113,9],[113,12,113,16],[115,12,116,12],[115,14,115,16],[118,1,118,9],[118,12,118,16],[119,1,122,1],[119,3,119,9],[120,3,120,9],[121,3,121,9],[122,12,123,12],[122,14,122,16],[125,12,125,16],[128,1,128,9],[129,1,132,1],[129,3,129,9],[129,12,130,12],[129,14,129,16],[130,3,130,9],[131,3,131,9],[132,12,132,16],[135,1,135,9],[136,1,139,1],[136,3,136,9],[136,12,137,12],[136,14,136,16],[137,3,137,9],[138,3,138,9],[142,1,142,9],[142,12,143,16],[143,1,146,1],[143,3,143,9],[144,3,144,9],[145,3,145,9],[149,1,149,9],[150,1,150,9]]}
[]
[]
[null,null,"title",{"$nulls":3},"status",{"$nulls":3},"login",{"$nulls":3},"username"]
[null,null,"Albuma nosaukums",{"$nulls":3},"Albuma izlaišanas status",{"$nulls":3},"login logs",{"$nulls":3},"lietotāju nosaukumu saraksts"]
[null,null,"ID","id","(int)",null,"ID","id","(int)",null,"ID","id","(int)",null,"ID","id","(int)"]
[null,null,"NAME","nosaukums","varchar(100)",null,"STATUS","Albuma status","varchar(20)",null,"USER_ID","nosaukuma id","(int)",null,"USER","nosaukums","varchar(100)"]
[null,null,"DATE_OF_PUBLISHING","izlaišanas datums","(date)",{"$nulls":5},"PASSWORD_ID","paroles id","(int)"]
[null,null,"STATUS_ID","statusa id","(int)",null,"title_genre",{"$nulls":3},"JOINED_DATE","Pievienošanās datums","(date)",null,"password"]
[null,null,"GENRE_ID","žanra id","(int)",null,"ar titulu saistītie žanri",{"$nulls":3},"IMAGE_ID","bildes id","(int)",null,"paroļu saraksts"]
[null,null,"AUTHOR_ID","autora id","(int)",null,"ID","id","(int)",{"$nulls":5},"ID","id","(int)"]
[null,null,"DESCRIPTION_ID","apraksta id","(int)",null,"TITLE_ID","albuma id","(int)",{"$nulls":5},"PASSWORD","parole","char(60)"]
[null,null,"PANEL_ID","paneļa id","(int)",null,"GENRE_ID","žanra id","(int)",null,"user_image"]
[{"$nulls":10},"lietotāju bildes"]
[null,null,"panels",{"$nulls":3},"genre",{"$nulls":3},"ID","id","(int)"]
[null,null,"priekšskatījuma paneļi",{"$nulls":3},"žanrs",{"$nulls":3},"IMAGE","lietotāju bilde","varchar(100)"]
[null,null,"ID","id","(int)",null,"ID","id","(int)"]
[null,null,"PANELS","paneļu skaits","(int)",null,"GENRE","žanrs","varchar(30)"]
[{"$nulls":10},"list"]
[null,null,"description",{"$nulls":3},"image",{"$nulls":3},"\"Favorītu\" saraksts"]
[null,null,"albuma apraksts",{"$nulls":3},"bilde",{"$nulls":3},"ID","id","(int)"]
[null,null,"ID","id","(int)",null,"ID","id","(int)",null,"MANGA_ID","albuma id","(int)"]
[null,null,"DESCRIPTION","Albuma apraksts","varchar(1500)",null,"NAME","nosaukums","varchar(40)",null,"USER_ID","lietotāja id","(int)"]
[{"$nulls":6},"SCORE","vērtējums","dec(5,2)"]
[null,null,"title_author",{"$nulls":3},"MANGA_ID","albuma id","(int)"]
[null,null,"ar titulu saistītie autori"]
[null,null,"ID","id","(int)"]
[null,null,"TITLE_ID","albuma id","(int)"]
[null,null,"AUTHOR_ID","autora id","(int)"]
[]
[null,null,"author"]
[null,null,"autori"]
[null,null,"ID","id","(int)"]
[null,null,"AUTHOR","autors","varchar(50)"]
[]
[]
[]
["Apraksts",{"$nulls":10},"Indekss",{"$nulls":6},"Relācijas"]
[]
[null,"NR.","Tabulas nosaukums","title",{"$nulls":8},"NR.","Tabulas nosaukums","title",{"$nulls":4},"NR.","Tabulas nosaukums","title"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Komentārs","Albuma nosaukums",{"$nulls":8},1,"PRIMARY","PK","Jā","ID",null,null,1,"STATUS_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,2,"kid","FK","Nē","kid",null,null,2,"GENRE_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"Albuma id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},3,"kid","FK","Nē","kid",null,null,3,"AUTHOR_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,2,"NAME","varchar(100)",null,"nosaukums","Nē",{"$nulls":5},4,"kid","FK","Nē","kid",null,null,4,"DESCRIPTION_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,3,"DATE_OF_PUBLISHING","date",null,"izlaišanas datums","Nē",{"$nulls":5},5,"kid","FK","Nē","kid",null,null,5,"PANEL_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,4,"STATUS_ID","varchar(20)",true,"vai vēl tiek izlaista","Nē",null,"FK",{"$nulls":3},6,"kid","FK","Nē","kid",null,null,"Ši tabula parāda relāciju starp title, status (STATUS_ID), genre (GENRE_ID), author (AUTHOR_ID), description (DESCRIPTION_ID) un panels (PANELS_ID)"]
[null,5,"GENRE_ID","int",true,"Zandra id","Nē",null,"FK",{"$nulls":3},"Ši tabula parāda Indeksu starp title un title_genre, title un title_author, title un status un starp title un description"]
[null,6,"AUTHOR_ID","int",true,"autora id","Nē",null,"FK"]
[null,7,"DESCRIPTION_ID","int",true,"apraksta id","Nē",null,"FK"]
[null,8,"PANEL_ID","int",true,"paneļa id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti albūma nosaukumi (NAME), izlaišanas datumi (DATE) un vai vel tiek izlaista (STATUS)",{"$nulls":17},"NR.","Tabulas nosaukums","image"]
[null,"NR.","Tabulas nosaukums","image",{"$nulls":16},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","image",{"$nulls":4},1,"MANGA_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Komentārs","Bildes",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"Ši tabula parāda relāciju starp image un title (MANGA_ID)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID"]
[null,1,"ID","int",true,"Bildes id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},2,"kid","FK","Nē","kid"]
[null,2,"NAME","varchar(40)",null,"nosaukums","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp image un title"]
[null,4,"SCORE","dec(5,2)",true,"vērtējums","Nē"]
[null,5,"MANGE_ID","int",true,"albuma id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti bilžu nosaukumi (NAME) un albūmu vērtejumi (SCORE)",{"$nulls":17},"NR.","Tabulas nosaukums","title_genre"]
[null,"NR.","Tabulas nosaukums","author",{"$nulls":16},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","title_author",{"$nulls":4},1,"GENRE_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Komentārs","Albuma autors",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"Ši tabula parāda relāciju starp title_genre un title (MANGA_ID)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID"]
[null,1,"ID","int",true,"autora id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"Ši tabula parāda Indeksu starp title un title_author"]
[null,2,"AUTHOR","varchar(50)",null,"albuma id","Nē"]
[null,"Šajā tabulā tiek glabāti autoru vārdi, uzvārdi (AUTHOR)"]
[null,"NR.","Tabulas nosaukums","genre"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","title_genre",{"$nulls":4},"NR.","Tabulas nosaukums","title_author"]
[null,null,"Komentārs","žanrs",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID",null,null,1,"AUTHOR_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,1,"ID","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"Ši tabula parāda Indeksu starp title un title_genre",{"$nulls":6},"Ši tabula parāda relāciju starp title_author un title (MANGA_ID)"]
[null,2,"GENRE","varchar(30)",null,"albuma id","Nē"]
[null,"Šajā tabulā tiek glabāti albūmu žanri (GENRE)"]
[null,"NR.","Tabulas nosaukums","status"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","status"]
[null,null,"Komentārs","žanrs",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"NR.","Tabulas nosaukums","list"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,1,"ID","int",true,"status id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"Ši tabula parāda Indeksu starp image un title",{"$nulls":6},1,"MANGA_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,2,"STATUS","varchar(30)",null,"Albuma status","Nē",{"$nulls":12},"Ši tabula parāda relāciju starp list un title (MANGA_ID)"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (STATUS)"]
[null,"NR.","Tabulas nosaukums","description"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","genre"]
[null,null,"Komentārs","apraksts",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID"]
[null,1,"ID","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},2,"kid","FK","Nē","kid",null,null,"NR.","Tabulas nosaukums","title"]
[null,2,"DESCRIPTION","varchar(250)",null,"apraksta id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title_genre un genre",{"$nulls":7},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (DESCRIPTION)",{"$nulls":10},"NR.","Tabulas nosaukums","description",{"$nulls":4},1,"USER_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,"NR.","Tabulas nosaukums","title_genre",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,2,"PASSWORD_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},1,"PRIMARY","PK","Jā","ID",null,null,3,"IMAGE_ID","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Komentārs","žanrs",{"$nulls":8},"Ši tabula parāda Indeksu starp title un description",{"$nulls":6},"Ši tabula parāda relāciju starp login, username (ID), password (ID) un user_image (ID)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"TITLE_ID","int",null,"albuma id","nē"]
[null,3,"GENRE_ID","int",null,"žanra id","Nē",{"$nulls":5},"NR.","Tabulas nosaukums","author"]
[null,"Šajā tabulā tiek albumam saistīti žanri",{"$nulls":11},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,"NR.","Tabulas nosaukums","title_author",{"$nulls":8},1,"PRIMARY","PK","Jā","ID"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"Ši tabula parāda Indeksu starp title_author un author"]
[null,null,"Komentārs","autors"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"TITLE_ID","int",null,"albuma id","nē",{"$nulls":5},"NR.","Tabulas nosaukums","panels"]
[null,3,"AUTHOR_ID","int",null,"žanra id","Nē",{"$nulls":6},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,"Šajā tabulā tiek albumam saistīti autori",{"$nulls":10},1,"PRIMARY","PK","Jā","ID"]
[null,"NR.","Tabulas nosaukums","panels",{"$nulls":8},"Ši tabula parāda Indeksu starp title un panels"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","priekšskatījuma paneļi"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"NR.","Tabulas nosaukums","list"]
[null,2,"PANELS","int",null,"paneļu skaits","Nē",{"$nulls":6},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu",{"$nulls":10},1,"PRIMARY","PK","Jā","ID"]
[null,"NR.","Tabulas nosaukums","list",{"$nulls":8},2,"kid","FK","Nē","kid"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},2,"kid","FK","Nē","kid"]
[null,null,"Komentārs","\"Favorītu\" saraksts",{"$nulls":8},"Ši tabula parāda Indeksu starp list un username"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"NR.","Tabulas nosaukums","username"]
[null,2,"MANGA_ID","int",null,"albuma id","nē",null,"FK",{"$nulls":4},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,3,"USER_ID","int",null,"lietotāja id","Nē",null,"FK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,"Šajā tabulā tiek glabāti lietotāju \"Favorīti\"",{"$nulls":10},"Ši tabula parāda Indeksu starp username un login"]
[null,"NR.","Tabulas nosaukums","login"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","login logs"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,"NR.","Tabulas nosaukums","password"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":4},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,2,"USER_ID","int",null,"nosaukuma id","Nē",null,"FK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,3,"PASSWORD_ID","int",null,"paroles id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp  password un login"]
[null,4,"JOINED_DATE","date",null,"Pievienošanās datums","Nē",null,"FK"]
[null,5,"IMAGE_ID","int",null,"bildes id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu"]
[null,"NR.","Tabulas nosaukums","username",{"$nulls":8},"NR.","Tabulas nosaukums","user_image"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,null,"Komentārs","lietotāju nosaukumu saraksts",{"$nulls":8},1,"PRIMARY","PK","Jā","ID"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,"Ši tabula parāda Indeksu starp user_image un login"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"USER","varchar(100)",null,"nosaukums","Nē"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu"]
[null,"NR.","Tabulas nosaukums","password",{"$nulls":8},"NR.","Tabulas nosaukums","login"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,null,"Komentārs","paroļu saraksts",{"$nulls":8},1,"PRIMARY","PK","Jā","ID"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,2,"kid","FK","Nē","kid"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},4,"kid","FK","Nē","kid"]
[null,2,"PASSWORD","varchar(60)",null,"parole","Nē",{"$nulls":5},6,"kid","FK","Nē","kid"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu",{"$nulls":10},"Ši tabula parāda Indeksu starplogin username, password un user_image"]
[null,"NR.","Tabulas nosaukums","user_image"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","lietotāju bildes"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"ID","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"IMAGE","varchar(100)",null,"lietotāju bilde","Nē"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu"]

{"sheet":"ERD4","index":5,"n_rows":150,"n_cols":27,"rows_kept":150,"merged":[[2,2,2,4],[2,6,2,8],[2,10,2,12],[2,14,2,16],[3,2,3,4],[3,6,3,8],[3,10,3,12],[3,14,3,16],[7,6,7,8],[7,14,7,16],[8,6,8,8],[8,14,8,16],[11,10,11,12],[12,10,12,12],[13,2,13,4],[13,6,13,8],[14,2,14,4],[14,6,14,8],[17,10,17,12],[18,2,18,4],[18,6,18,8],[18,10,18,12],[19,2,19,4],[19,6,19,8],[23,2,23,4],[24,2,24,4],[29,2,29,4],[30,2,30,4],[36,0,37,10],[36,11,37,17],[36,18,37,27],[38,1,41,1],[38,3,38,9],[38,12,39,12],[38,14,38,16],[38,19,39,19],[38,21,38,26],[39,3,39,9],[40,3,40,9],[45,19,46,26],[46,12,47,16],[50,1,50,9],[50,19,51,19],[50,21,50,26],[51,1,54,1],[51,3,51,9],[52,3,52,9],[52,12,53,12],[52,14,52,16],[53,3,53,9],[53,19,53,26],[56,12,56,16],[59,1,59,9],[59,19,60,19],[59,21,59,26],[60,1,63,1],[60,3,60,9],[61,3,61,9],[61,12,62,12],[61,14,61,16],[62,3,62,9],[62,19,62,26],[64,12,64,16],[66,1,66,9],[67,1,70,1],[67,3,67,9],[68,3,68,9],[68,12,69,12],[68,14,68,16],[68,19,69,19],[68,21,68,26],[69,3,69,9],[71,12,71,16],[71,19,71,26],[73,1,73,9],[74,1,77,1],[74,3,74,9],[75,3,75,9],[75,12,76,12],[75,14,75,16],[76,3,76,9],[76,19,77,19],[76,21,76,26],[78,12,78,16],[79,19,79,26],[80,1,80,9],[81,1,84,1],[81,3,81,9],[82,3,82,9],[82,12,83,12],[82,14,82,16],[83,3,83,9],[85,19,86,19],[85,21,85,26],[86,12,86,16],[87,1,87,9],[87,12,88,12],[87,14,87,16],[88,1,91,1],[88,3,88,9],[89,3,89,9],[90,3,90,9],[90,12,90,16],[90,19,90,26],[94,12,95,12],[94,14,94,16],[95,1,95,9],[96,1,99,1],[96,3,96,9],[97,3,97,9],[97,12,97,16],[98,3,98,9],[101,12,102,12],[101,14,101,16],[103,1,103,9],[104,1,107,1],[104,3,104,9],[104,12,104,16],[105,3,105,9],[106,3,106,9],[108,12,109,12],[108,14,108,16],[110,1,110,9],[111,1,114,1],[111,3,111,9],[112,3,112,9],[113,3,113,9],[113,12,113,16],[115,12,116,12],[115,14,115,16],[118,1,118,9],[118,12,118,16],[119,1,122,1],[119,3,119,9],[120,3,120,9],[121,3,121,9],[122,12,123,12],[122,14,122,16],[125,12,125,16],[128,1,128,9],[129,1,132,1],[129,3,129,9],[129,12,130,12],[129,14,129,16],[130,3,130,9],[131,3,131,9],[132,12,132,16],[135,1,135,9],[136,1,139,1],[136,3,136,9],[136,12,137,12],[136,14,136,16],[137,3,137,9],[138,3,138,9],[142,1,142,9],[142,12,143,16],[143,1,146,1],[143,3,143,9],[144,3,144,9],[145,3,145,9],[149,1,149,9],[150,1,150,9]]}
[]
[]
[null,null,"title",{"$nulls":3},"status",{"$nulls":3},"login",{"$nulls":3},"username"]
[null,null,"Albuma nosaukums",{"$nulls":3},"Albuma izlaišanas status",{"$nulls":3},"login logs",{"$nulls":3},"lietotāju nosaukumu saraksts"]
[null,null,"id","id","(int)",null,"id","id","(int)",null,"id","id","(int)",null,"id","id","(int)"]
[null,null,"name","nosaukums","varchar(100)",null,"status","Albuma status","varchar(20)",null,"user_id","nosaukuma id","(int)",null,"user","nosaukums","varchar(100)"]
[null,null,"date_of_publishing","izlaišanas datums","(date)",{"$nulls":5},"password_id","paroles id","(int)"]
[null,null,"status_id","statusa id","(int)",null,"title_genre",{"$nulls":3},"joined_date","Pievienošanās datums","(date)",null,"password"]
[null,null,"genre_id","žanra id","(int)",null,"ar titulu saistītie žanri",{"$nulls":3},"image_id","bildes id","(int)",null,"paroļu saraksts"]
[null,null,"author_id","autora id","(int)",null,"id","id","(int)",{"$nulls":5},"id","id","(int)"]
[null,null,"description_id","apraksta id","(int)",null,"title_id","albuma id","(int)",{"$nulls":5},"password","parole","char(60)"]
[null,null,"panel_id","paneļa id","(int)",null,"genre_id","žanra id","(int)",null,"user_image"]
[{"$nulls":10},"lietotāju bildes"]
[null,null,"panels",{"$nulls":3},"genre",{"$nulls":3},"id","id","(int)"]
[null,null,"priekšskatījuma paneļi",{"$nulls":3},"žanrs",{"$nulls":3},"image","lietotāju bilde","varchar(100)"]
[null,null,"id","id","(int)",null,"id","id","(int)"]
[null,null,"panels","paneļu skaits","(int)",null,"genre","žanrs","varchar(30)"]
[{"$nulls":10},"list"]
[null,null,"description",{"$nulls":3},"image",{"$nulls":3},"\"Favorītu\" saraksts"]
[null,null,"albuma apraksts",{"$nulls":3},"bilde",{"$nulls":3},"id","id","(int)"]
[null,null,"id","id","(int)",null,"id","id","(int)",null,"manga_id","albuma id","(int)"]
[null,null,"description","Albuma apraksts","varchar(1500)",null,"name","nosaukums","varchar(40)",null,"user_id","lietotāja id","(int)"]
[{"$nulls":6},"score","vērtējums","dec(5,2)"]
[null,null,"title_author",{"$nulls":3},"manga_id","albuma id","(int)"]
[null,null,"ar titulu saistītie autori"]
[null,null,"id","id","(int)"]
[null,null,"title_id","albuma id","(int)"]
[null,null,"author_id","autora id","(int)"]
[]
[null,null,"author"]
[null,null,"autori"]
[null,null,"id","id","(int)"]
[null,null,"author","autors","varchar(50)"]
[]
[]
[]
["Apraksts",{"$nulls":10},"Indekss",{"$nulls":6},"Relācijas"]
[]
[null,"NR.","Tabulas nosaukums","title",{"$nulls":8},"NR.","Tabulas nosaukums","title",{"$nulls":4},"NR.","Tabulas nosaukums","title"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Komentārs","Albuma nosaukums",{"$nulls":8},1,"PRIMARY","PK","Jā","ID",null,null,1,"status_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,2,"kid","FK","Nē","kid",null,null,2,"genre_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,1,"id","int",true,"Albuma id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},3,"kid","FK","Nē","kid",null,null,3,"author_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,2,"name","varchar(100)",null,"nosaukums","Nē",{"$nulls":5},4,"kid","FK","Nē","kid",null,null,4,"description_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,3,"date_of_publishing","date",null,"izlaišanas datums","Nē",{"$nulls":5},5,"kid","FK","Nē","kid",null,null,5,"panel_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,4,"status_id","varchar(20)",true,"vai vēl tiek izlaista","Nē",null,"FK",{"$nulls":3},6,"kid","FK","Nē","kid",null,null,"Ši tabula parāda relāciju starp title, status (STATUS_ID), genre (GENRE_ID), author (AUTHOR_ID), description (DESCRIPTION_ID) un panels (PANELS_ID)"]
[null,5,"genre_id","int",true,"Zandra id","Nē",null,"FK",{"$nulls":3},"Ši tabula parāda Indeksu starp title un title_genre, title un title_author, title un status un starp title un description"]
[null,6,"author_id","int",true,"autora id","Nē",null,"FK"]
[null,7,"description_id","int",true,"apraksta id","Nē",null,"FK"]
[null,8,"panel_id","int",true,"paneļa id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti albūma nosaukumi (NAME), izlaišanas datumi (DATE) un vai vel tiek izlaista (STATUS)",{"$nulls":17},"NR.","Tabulas nosaukums","image"]
[null,"NR.","Tabulas nosaukums","image",{"$nulls":16},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","image",{"$nulls":4},1,"manga_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Komentārs","Bildes",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"Ši tabula parāda relāciju starp image un title (MANGA_ID)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID"]
[null,1,"id","int",true,"Bildes id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},2,"kid","FK","Nē","kid"]
[null,2,"name","varchar(40)",null,"nosaukums","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp image un title"]
[null,4,"score","dec(5,2)",true,"vērtējums","Nē"]
[null,5,"manga_id","int",true,"albuma id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti bilžu nosaukumi (NAME) un albūmu vērtejumi (SCORE)",{"$nulls":17},"NR.","Tabulas nosaukums","title_genre"]
[null,"NR.","Tabulas nosaukums","author",{"$nulls":16},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","title_author",{"$nulls":4},1,"genre_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Komentārs","Albuma autors",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"Ši tabula parāda relāciju starp title_genre un title (MANGA_ID)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID"]
[null,1,"id","int",true,"autora id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"Ši tabula parāda Indeksu starp title un title_author"]
[null,2,"author","varchar(50)",null,"albuma id","Nē"]
[null,"Šajā tabulā tiek glabāti autoru vārdi, uzvārdi (AUTHOR)"]
[null,"NR.","Tabulas nosaukums","genre"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","title_genre",{"$nulls":4},"NR.","Tabulas nosaukums","title_author"]
[null,null,"Komentārs","žanrs",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID",null,null,1,"author_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,1,"id","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"Ši tabula parāda Indeksu starp title un title_genre",{"$nulls":6},"Ši tabula parāda relāciju starp title_author un title (MANGA_ID)"]
[null,2,"genre","varchar(30)",null,"albuma id","Nē"]
[null,"Šajā tabulā tiek glabāti albūmu žanri (GENRE)"]
[null,"NR.","Tabulas nosaukums","status"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","status"]
[null,null,"Komentārs","žanrs",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,"NR.","Tabulas nosaukums","list"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID",{"$nulls":3},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,1,"id","int",true,"status id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"Ši tabula parāda Indeksu starp image un title",{"$nulls":6},1,"manga_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,2,"status","varchar(30)",null,"Albuma status","Nē",{"$nulls":12},"Ši tabula parāda relāciju starp list un title (MANGA_ID)"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (STATUS)"]
[null,"NR.","Tabulas nosaukums","description"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"NR.","Tabulas nosaukums","genre"]
[null,null,"Komentārs","apraksts",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,1,"PRIMARY","PK","Jā","ID"]
[null,1,"id","int",true,"Žanra id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},2,"kid","FK","Nē","kid",null,null,"NR.","Tabulas nosaukums","title"]
[null,2,"description","varchar(250)",null,"apraksta id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp title_genre un genre",{"$nulls":7},"Relācijas nosaukums","Darbība uz datu dzēšanu","Darbība uz datu atjaunināšanu","Tabulas lauks","Datubāze","Saistītā tabula","Saistītās tabulas lauks"]
[null,"Šajā tabulā tiek glabāti albūmu izlaišanas status (DESCRIPTION)",{"$nulls":10},"NR.","Tabulas nosaukums","description",{"$nulls":4},1,"user_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,"NR.","Tabulas nosaukums","title_genre",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)",null,null,2,"password_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},1,"PRIMARY","PK","Jā","ID",null,null,3,"image_id","Kaskāde","no action","kid","dragrejs","klients","id"]
[null,null,"Komentārs","žanrs",{"$nulls":8},"Ši tabula parāda Indeksu starp title un description",{"$nulls":6},"Ši tabula parāda relāciju starp login, username (ID), password (ID) un user_image (ID)"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"title_id","int",null,"albuma id","nē"]
[null,3,"genre_id","int",null,"žanra id","Nē",{"$nulls":5},"NR.","Tabulas nosaukums","author"]
[null,"Šajā tabulā tiek albumam saistīti žanri",{"$nulls":11},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,"NR.","Tabulas nosaukums","title_author",{"$nulls":8},1,"PRIMARY","PK","Jā","ID"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},"Ši tabula parāda Indeksu starp title_author un author"]
[null,null,"Komentārs","autors"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"title_id","int",null,"albuma id","nē",{"$nulls":5},"NR.","Tabulas nosaukums","panels"]
[null,3,"author_id","int",null,"žanra id","Nē",{"$nulls":6},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,"Šajā tabulā tiek albumam saistīti autori",{"$nulls":10},1,"PRIMARY","PK","Jā","ID"]
[null,"NR.","Tabulas nosaukums","panels",{"$nulls":8},"Ši tabula parāda Indeksu starp title un panels"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","priekšskatījuma paneļi"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"NR.","Tabulas nosaukums","list"]
[null,2,"panels","int",null,"paneļu skaits","Nē",{"$nulls":6},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu",{"$nulls":10},1,"PRIMARY","PK","Jā","ID"]
[null,"NR.","Tabulas nosaukums","list",{"$nulls":8},2,"kid","FK","Nē","kid"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":8},2,"kid","FK","Nē","kid"]
[null,null,"Komentārs","\"Favorītu\" saraksts",{"$nulls":8},"Ši tabula parāda Indeksu starp list un username"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},"NR.","Tabulas nosaukums","username"]
[null,2,"manga_id","int",null,"albuma id","nē",null,"FK",{"$nulls":4},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,3,"user_id","int",null,"lietotāja id","Nē",null,"FK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,"Šajā tabulā tiek glabāti lietotāju \"Favorīti\"",{"$nulls":10},"Ši tabula parāda Indeksu starp username un login"]
[null,"NR.","Tabulas nosaukums","login"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","login logs"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,"NR.","Tabulas nosaukums","password"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":4},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,2,"user_id","int",null,"nosaukuma id","Nē",null,"FK",{"$nulls":3},1,"PRIMARY","PK","Jā","ID"]
[null,3,"password_id","int",null,"paroles id","Nē",{"$nulls":5},"Ši tabula parāda Indeksu starp  password un login"]
[null,4,"joined_date","date",null,"Pievienošanās datums","Nē",null,"FK"]
[null,5,"image_id","int",null,"bildes id","Nē",null,"FK"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu"]
[null,"NR.","Tabulas nosaukums","username",{"$nulls":8},"NR.","Tabulas nosaukums","user_image"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,null,"Komentārs","lietotāju nosaukumu saraksts",{"$nulls":8},1,"PRIMARY","PK","Jā","ID"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,"Ši tabula parāda Indeksu starp user_image un login"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"user","varchar(100)",null,"nosaukums","Nē"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu"]
[null,"NR.","Tabulas nosaukums","password",{"$nulls":8},"NR.","Tabulas nosaukums","login"]
[null,null,"Tabulas kodējums","utf8_unicode_ci",{"$nulls":9},"Indeksa nosaukums","Indeksa tips","Unikāls indekss","Tabulas lauks(i)"]
[null,null,"Komentārs","paroļu saraksts",{"$nulls":8},1,"PRIMARY","PK","Jā","ID"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki",null,null,2,"kid","FK","Nē","kid"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK",{"$nulls":3},4,"kid","FK","Nē","kid"]
[null,2,"password","varchar(60)",null,"parole","Nē",{"$nulls":5},6,"kid","FK","Nē","kid"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu",{"$nulls":10},"Ši tabula parāda Indeksu starplogin username, password un user_image"]
[null,"NR.","Tabulas nosaukums","user_image"]
[null,null,"Tabulas kodējums","utf8_unicode_ci"]
[null,null,"Komentārs","lietotāju bildes"]
[null,null,"Nosaukums","Tips","unsigned","komentars","Vai ir “NULL”?","Noklusējuma vērtība","indekss","Internet lapas logu lauki"]
[null,1,"id","int",true,"id","Nē","AUTO_INCREMENT","PK"]
[null,2,"image","varchar(100)",null,"lietotāju bilde","Nē"]
[null,"Šajā tabulā tiek glabāti ievadu paneļu"]

{"sheet":"presentation","index":6,"n_rows":33,"n_cols":17,"rows_kept":33,"merged":[[2,2,2,4],[2,6,2,8],[2,10,2,12],[2,14,2,16],[3,2,3,4],[3,6,3,8],[3,10,3,12],[3,14,3,16],[7,6,7,8],[7,14,7,16],[8,6,8,8],[8,14,8,16],[11,10,11,12],[12,10,12,12],[13,2,13,4],[13,6,13,8],[14,2,14,4],[14,6,14,8],[17,10,17,12],[18,2,18,4],[18,6,18,8],[18,10,18,12],[19,2,19,4],[19,6,19,8],[23,2,23,4],[24,2,24,4],[29,2,29,4],[30,2,30,4]]}
[]
[]
[null,null,"title",{"$nulls":3},"status",{"$nulls":3},"login",{"$nulls":3},"username"]
[null,null,"Albuma nosaukums",{"$nulls":3},"Albuma izlaišanas status",{"$nulls":3},"login logs",{"$nulls":3},"lietotāju nosaukumu saraksts"]
[null,null,"id","id","(int)",null,"id","id","(int)",null,"id","id","(int)",null,"id","id","(int)"]
[null,null,"name","nosaukums","varchar(100)",null,"status","Albuma status","varchar(20)",null,"user_id","nosaukuma id","(int)",null,"user","nosaukums","varchar(100)"]
[null,null,"date_of_publishing","izlaišanas datums","(date)",{"$nulls":5},"password_id","paroles id","(int)"]
[null,null,"status_id","statusa id","(int)",null,"title_genre",{"$nulls":3},"joined_date","Pievienošanās datums","(date)",null,"password"]
[null,null,"genre_id","žanra id","(int)",null,"ar titulu saistītie žanri",{"$nulls":3},"image_id","bildes id","(int)",null,"paroļu saraksts"]
[null,null,"author_id","autora id","(int)",null,"id","id","(int)",{"$nulls":5},"id","id","(int)"]
[null,null,"description_id","apraksta id","(int)",null,"title_id","albuma id","(int)",{"$nulls":5},"password","parole","char(60)"]
[null,null,"panel_id","paneļa id","(int)",null,"genre_id","žanra id","(int)",null,"user_image"]
[{"$nulls":10},"lietotāju bildes"]
[null,null,"panels",{"$nulls":3},"genre",{"$nulls":3},"id","id","(int)"]
[null,null,"priekšskatījuma paneļi",{"$nulls":3},"žanrs",{"$nulls":3},"image","lietotāju bilde","varchar(100)"]
[null,null,"id","id","(int)",null,"id","id","(int)"]
[null,null,"panels","paneļu skaits","(int)",null,"genre","žanrs","varchar(30)"]
[{"$nulls":10},"list"]
[null,null,"description",{"$nulls":3},"image",{"$nulls":3},"\"Favorītu\" saraksts"]
[null,null,"albuma apraksts",{"$nulls":3},"bilde",{"$nulls":3},"id","id","(int)"]
[null,null,"id","id","(int)",null,"id","id","(int)",null,"manga_id","albuma id","(int)"]
[null,null,"description","Albuma apraksts","varchar(1500)",null,"name","nosaukums","varchar(40)",null,"user_id","lietotāja id","(int)"]
[{"$nulls":6},"score","vērtējums","dec(5,2)"]
[null,null,"title_author",{"$nulls":3},"manga_id","albuma id","(int)"]
[null,null,"ar titulu saistītie autori"]
[null,null,"id","id","(int)"]
[null,null,"title_id","albuma id","(int)"]
[null,null,"author_id","autora id","(int)"]
[]
[null,null,"author"]
[null,null,"autori"]
[null,null,"id","id","(int)"]
[null,null,"author","autors","varchar(50)"]

{"sheet":"dokumentation","index":7,"n_rows":33,"n_cols":17,"rows_kept":33,"merged":[[2,2,2,4],[2,6,2,8],[2,10,2,12],[2,14,2,16],[3,2,3,4],[3,6,3,8],[3,10,3,12],[3,14,3,16],[7,6,7,8],[7,14,7,16],[8,6,8,8],[8,14,8,16],[11,10,11,12],[12,10,12,12],[13,2,13,4],[13,6,13,8],[14,2,14,4],[14,6,14,8],[17,10,17,12],[18,2,18,4],[18,6,18,8],[18,10,18,12],[19,2,19,4],[19,6,19,8],[23,2,23,4],[24,2,24,4],[29,2,29,4],[30,2,30,4]]}
[]
[]
[null,null,"title",{"$nulls":3},"status",{"$nulls":3},"login",{"$nulls":3},"username"]
[null,null,"Albuma nosaukums",{"$nulls":3},"Albuma izlaišanas status",{"$nulls":3},"login logs",{"$nulls":3},"lietotāju nosaukumu saraksts"]
[null,null,"id","id","(int)",null,"id","id","(int)",null,"id","id","(int)",null,"id","id","(int)"]
[null,null,"name","nosaukums","varchar(100)",null,"status","Albuma status","varchar(20)",null,"user_id","nosaukuma id","(int)",null,"user","nosaukums","varchar(100)"]
[null,null,"date_of_publishing","izlaišanas datums","(date)",{"$nulls":5},"password_id","paroles id","(int)"]
[null,null,"status_id","statusa id","(int)",null,"title_genre",{"$nulls":3},"joined_date","Pievienošanās datums","(date)",null,"password"]
[null,null,"genre_id","žanra id","(int)",null,"ar titulu saistītie žanri",{"$nulls":3},"image_id","bildes id","(int)",null,"paroļu saraksts"]
[null,null,"author_id","autora id","(int)",null,"id","id","(int)",{"$nulls":5},"id","id","(int)"]
[null,null,"description_id","apraksta id","(int)",null,"title_id","albuma id","(int)",{"$nulls":5},"password","parole","char(60)"]
[null,null,"panel_id","paneļa id","(int)",null,"genre_id","žanra id","(int)",null,"user_image"]
[{"$nulls":10},"lietotāju bildes"]
[null,null,"panels",{"$nulls":3},"genre",{"$nulls":3},"id","id","(int)"]
[null,null,"priekšskatījuma paneļi",{"$nulls":3},"žanrs",{"$nulls":3},"image","lietotāju bilde","varchar(100)"]
[null,null,"id","id","(int)",null,"id","id","(int)"]
[null,null,"panels","paneļu skaits","(int)",null,"genre","žanrs","varchar(30)"]
[{"$nulls":10},"list"]
[null,null,"description",{"$nulls":3},"image",{"$nulls":3},"\"Favorītu\" saraksts"]
[null,null,"albuma apraksts",{"$nulls":3},"bilde",{"$nulls":3},"id","id","(int)"]
[null,null,"id","id","(int)",null,"id","id","(int)",null,"manga_id","albuma id","(int)"]
[null,null,"description","Albuma apraksts","varchar(1500)",null,"name","nosaukums","varchar(40)",null,"user_id","lietotāja id","(int)"]
[{"$nulls":6},"score","vērtējums","dec(5,2)"]
[null,null,"title_author",{"$nulls":3},"manga_id","albuma id","(int)"]
[null,null,"ar titulu saistītie autori"]
[null,null,"id","id","(int)"]
[null,null,"title_id","albuma id","(int)"]
[null,null,"author_id","autora id","(int)"]
[]
[null,null,"author"]
[null,null,"autori"]
[null,null,"id","id","(int)"]
[null,null,"author","autors","varchar(50)"]