How to organise a database

#site-feedback
#1
If I'm going to make a database for fan works, then I need some idea of what it will need to contain, how it will display it and how to organise it.

Categories is needed. every fan work must be categorised according to it's type, what the original is, who the creator is. There may need to be other categories too.

Each fan work needs it's own page where it will have particular sets of information, according to the type of media. These informations would need to be in a form that can be edited by users or where users can suggest edits and submit new items. These pages need to be capable of supporting media such as photos and videos.

Each creator of a fan work needs an individual page with various details.

Each intellectual property that fan works are based on needs it's own page with various information that can be user submitted. It must include where to buy it and support the creator.

must have review functionality so people can give props or report bad experiences. needs some further thought to figure out how to prevent abuse and resolve disputes.

potential to include user submitted journalistic articles.

There needs to be a search function with various ways to filter and sort the search results.

There needs to be a 'front-end' that can collate new reviews and new submissions and possibly news items or articles.

I think that's it....
#2
Hmm I am not sure what to suggest in terms of structuring the layout of the other segments of fan related media at the moment although they do intrigue me, as for how pages of users Fanedits could be structured maybe something like this.

(Faneditors) Could be positioned next to the Privacy Tab for easier and quicker site navigation, clicking on it could lead to a subpage showing a Faneditors gallery.
|
(Faneditor Name Gallery) This could essentially be where the Cover Art and Fanedit names are stored for that individuals Fanedit, clicking it could then lead to the database subpage.
|
(Fanedit Name Database) The info contained in said database could be arranged in the following order on a single page.
|
1: Original Media Name/Original Medias Name (If combining multiple movies or TV episodes together)

2: Original Media/Media’s Age Rating

3: Fanedit Age Rating

4: Content Warning

5: Fanedit Genre

6: Fanedit Type

7: Fanedit Running Time

8: Link to where the source was brought from/can be purchased from (Something like Amazon)

9: Editing Software Used

10: Non Spoiler Technical Cutlist (Or alternatively if the Cutlist does contain narrative spoilers it is hidden to the viewer unless they click on it)

11: Type A Review (This could lead to the review subpage for that specific edit)
#3
Thank you for this description, there are some really good points here. I hadn't considered having a page directly to fanedits or fanart or fanfiction, but that's good. Also the included information is really interesting! Age eating and software used! Brilliant!