let's say that I have TeX file ,,1. file". This file contains multipe bibtex references, but as you know,
,,If one reference has 5 entries like: ,,author, title, volume, year and pages", that doesn't mean that second reference must have 5 entries also.
Examples of bibtex references:
@article{Sh:1,
author = {Shelah, Saharon},
journal = {Israel Journal of Mathematics},
volume = {7},
year = {1969},
},
@article{Sh:2,
author = {Shelah, Saharon},
journal = {Journal of Combinatorial Theory},
review = {MR 39-2652},
pages = {298--300},
year = {1969},
},
@article{Sh:3,
author = {Shelah, Saharon},
journal = {Annals of Mathematical Logic},
review = {MR 44-2593},
pages = {69--118},
title = {Finite diagrams stable in power},
volume = {2},
year = {1970},
}
So in the code I already have created database file, but I don't have any idea how to create dynamic table structure to store all entries. I just need to have multiple tables like:
- main table that contain primary key ID AUTOINCREMENT and one IDENTIFIER of 1. bibtex reference but also need some dynamic tables for every entry (like author, pages, journal, year...), that contains reference on the main table.
one main table that is connected with other tables depending on the the different. Other tables are named like AUTHOR, PAGES, YEAR and so on and they contains connections with key from main table and the current text. But it is different for every reference for main table.
Does anybody know, how to solve this problem? What structure or solution to create? What columns should have main table and the rest tables? If the problem wasn't very well described, I can describe it in more details.
Aucun commentaire:
Enregistrer un commentaire