OK, we need one more table for storing arts by author (ArtAutTable, named so as ArtCatTable), where we'll store all art's id's from main Article table and id of art's Author...
Also we need field sinhronised in Author table to mark list is sinked as we do it in Categories table;
It's realy hard to make DB for arts, that can have or not an author, and 0 or "n" categories and do it so, that we can know if art's list of author or category is in the right order (by date) if we can't simply know it's date...
mohaxspb
commented
9 years ago
OK, we need one more table for storing arts by author (ArtAutTable, named so as ArtCatTable), where we'll store all art's id's from main Article table and id of art's Author...
Also we need field sinhronised in Author table to mark list is sinked as we do it in Categories table;
It's realy hard to make DB for arts, that can have or not an author, and 0 or "n" categories and do it so, that we can know if art's list of author or category is in the right order (by date) if we can't simply know it's date...