View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001825 | HTML & PERL | Feature Request - Database | public | 2010-06-26 16:34 | 2010-06-29 15:59 |
| Reporter | worf | Assigned To | DerIdiot | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Summary | 0001825: New ressource management system | ||||
| Description | We could use a new ressource management system to cover more ressource sites than official pages, ANN, ANFO and allcinema for anime or official pages and wikipedia for characters and so on. Ressources for anime: - Official page - AnimeNewsNetwork - AnimeNFO - Allcinema - Marumegane - AnimeMemorial - AniStaff - Wikipedia (jp) - Wikipedia (en) - MyAnimeList - AniSearch - ... Considering that there might be multiple official pages (studio, producer, tv station, ...) and that pages like ANN, Anfo or Allcinema might have more than one link for an anime on anidb we'll have to allow the addition of more than one entry per type. We could even hide ressource links like MAL or AniSearch from normal users. :p Database could look something like this: id | reltype | relid | type | link ---+---------+-------+----------+---------- 1 | anime | 1 | official | http:... 2 | char | 12 | wiki_jp | http:... ... Additionally database views could be created for each "reltype" and the data could be pulled from these views rather than from the big table. Entities this system could be implemented for: Anime, Character, Creator, Songs, Collections, ... | ||||
| Tags | No tags attached. | ||||
