The design stage of Abstract Database project started on 07.07.07.
Following structure were created.
| Tables_in_AD | a_v_a |
| Tables_in_AD | akr |
| Tables_in_AD | authors |
| Tables_in_AD | fields |
| Tables_in_AD | indexes |
| Tables_in_AD | issues |
| Tables_in_AD | journals |
| Tables_in_AD | lejpt |
| Tables_in_AD | ljs |
| a_v_a |
| articles | bigint(20) | NO | | | |
| author | bigint(20) | NO | | | |
| journal | varchar(255) | NO | | | |
| article | int(11) | NO | | | |
| akr |
| id | bigint(20) | NO | PRI | | auto_increment |
| abstract | longtext | NO | | | |
| keywords | longtext | NO | | | |
| references | longtext | NO | | | |
| authors |
| author | bigint(20) | NO | PRI | | auto_increment |
| given | varchar(255) | NO | | | |
| family | varchar(255) | NO | | | |
| given1 | varchar(255) | NO | | | |
| family1 | varchar(255) | NO | | | |
| fields |
| id | tinyint(4) | NO | PRI | | auto_increment |
| field | varchar(255) | NO | | | |
| indexes |
| name | varchar(255) | NO | | | |
| index | varchar(255) | NO | | | |
| url1 | varchar(255) | NO | | | |
| url2 | varchar(255) | NO | | | |
| issues |
| issue | mediumint(9) | NO | | | |
| journal | varchar(255) | NO | | | |
| volume | varchar(255) | NO | | | |
| period | varchar(255) | NO | | | |
| year | varchar(255) | NO | | | |
| dir | varchar(255) | NO | | | |
| pdf | varchar(255) | NO | | | |
| height | varchar(255) | NO | | | |
| width | varchar(255) | NO | | | |
| alt | varchar(255) | NO | | | |
| journals |
| nick | varchar(255) | NO | | | |
| name | varchar(255) | NO | | | |
| bg | varchar(6) | NO | | | |
| tx | varchar(6) | NO | | | |
| lejpt |
| article | int(11) | NO | PRI | | auto_increment |
| year | varchar(255) | NO | | | |
| issue | varchar(255) | NO | | | |
| pages | varchar(255) | NO | | | |
| files | varchar(255) | NO | | | |
| title | varchar(255) | NO | | | |
| field | varchar(1) | NO | | | |
| akr | bigint(20) | NO | | | |
| DOAJ | mediumtext | NO | | | |
| IndexCopernicus | mediumtext | NO | | | |
| getCITED | mediumtext | NO | | | |
| ScientificCommons | mediumtext | NO | | | |
| IBICT | mediumtext | NO | | | |
| BASE | mediumtext | NO | | | |
| Scirus | mediumtext | NO | | | |
| GoogleScholar | mediumtext | NO | | | |
| ljs |
| article | int(11) | NO | PRI | | auto_increment |
| year | varchar(255) | NO | | | |
| issue | varchar(255) | NO | | | |
| pages | varchar(255) | NO | | | |
| files | varchar(255) | NO | | | |
| title | varchar(255) | NO | | | |
| field | varchar(1) | NO | | | |
| akr | bigint(20) | NO | | | |
| DOAJ | mediumtext | NO | | | |
| IndexCopernicus | mediumtext | NO | | | |
| getCITED | mediumtext | NO | | | |
| ScientificCommons | mediumtext | NO | | | |
| IBICT | mediumtext | NO | | | |
| BASE | mediumtext | NO | | | |
| Scirus | mediumtext | NO | | | |
| GoogleScholar | mediumtext | NO | | | |