The design stage of Abstract Database project started on 07.07.07.
Following structure were created.
Tables_in_ADa_v_a
Tables_in_ADakr
Tables_in_ADauthors
Tables_in_ADfields
Tables_in_ADindexes
Tables_in_ADissues
Tables_in_ADjournals
Tables_in_ADlejpt
Tables_in_ADljs
a_v_a
articlesbigint(20)NO   
authorbigint(20)NO   
journalvarchar(255)NO   
articleint(11)NO   
akr
idbigint(20)NOPRI auto_increment
abstractlongtextNO   
keywordslongtextNO   
referenceslongtextNO   
authors
authorbigint(20)NOPRI auto_increment
givenvarchar(255)NO   
familyvarchar(255)NO   
given1varchar(255)NO   
family1varchar(255)NO   
fields
idtinyint(4)NOPRI auto_increment
fieldvarchar(255)NO   
indexes
namevarchar(255)NO   
indexvarchar(255)NO   
url1varchar(255)NO   
url2varchar(255)NOMUL  
issues
issuemediumint(9)NO   
journalvarchar(255)NO   
volumevarchar(255)NO   
periodvarchar(255)NO   
yearvarchar(255)NO   
dirvarchar(255)NO   
pdfvarchar(255)NO   
heightvarchar(255)NO   
widthvarchar(255)NO   
altvarchar(255)NO   
journals
nickvarchar(255)NO   
namevarchar(255)NO   
bgvarchar(6)NO   
txvarchar(6)NO   
lejpt
articleint(11)NOPRI auto_increment
yearvarchar(255)NO   
issuevarchar(255)NO   
pagesvarchar(255)NO   
filesvarchar(255)NO   
titlevarchar(255)NO   
fieldvarchar(1)NO   
akrbigint(20)NO   
DOAJmediumtextNO   
IndexCopernicusmediumtextNO   
getCITEDmediumtextNO   
ScientificCommonsmediumtextNO   
IBICTmediumtextNO   
BASEmediumtextNO   
ScirusmediumtextNO   
GoogleScholarmediumtextNO   
ljs
articleint(11)NOPRI auto_increment
yearvarchar(255)NO   
issuevarchar(255)NO   
pagesvarchar(255)NOMUL  
filesvarchar(255)NO   
titlevarchar(255)NO   
fieldvarchar(1)NO   
akrbigint(20)NO   
DOAJmediumtextNO   
IndexCopernicusmediumtextNO   
getCITEDmediumtextNO   
ScientificCommonsmediumtextNO   
IBICTmediumtextNO   
BASEmediumtextNO   
ScirusmediumtextNO   
GoogleScholarmediumtextNO