[HPFGU-Catalogue] STAGE TWO – the subject categories

[silmariel]

>I'd have it:

>1. Textual Analysis
>2. Characters: Beasts, Beings and Spirits
>3. SHIPs
>4. Sources and Influences
>5. The Wizarding World
>6. Predictions

>Anne



1. Textual Analysis
2. Characters: Beasts, Beings and Spirits
3. The Wizarding World
4. Interests: 
   SHIPs
   Sources and Influences
   Filks, If not let out. (*)
5. Predictions

(*) This section can be added later if a Filk lover wants to do it. I 
personally delete all Filk posts (in case they have offspring), so I really 
don't mind what do we do with them. Later it can be retrieved a plain list 
with all Filk (at Least all filks that follow the FILK convention in the 
subject) posts if anyone wants to go and review them.

Interests is there because I don't see clear S&Influences or ships as primary 
categories. I know we need somewhere to put them, but I wanted a more general 
category to include those themes that really don't add very much, as Ships or 
Alchemy. As fantastic as Alchemy discussion can be, well, I don't know what 
percentage of the population is interested in intense research about it.

Questions to Rowling? We have a lot of posts about that, what do we do with 
them? 

Carolyn:
<<If we went down the more complex database route, of course, we can 
use multiple codes, so individual posts can be linked to major 
categories in multiple ways - by character, by TBay etc.>>

Aha, I assumed that was the reason behind 6 colums for categories in the 
spreadsheet. 

The structure of the tables in the database will be:

POST:
	Post_ID
	Name
	From
	Date
	Rejection_code
	ID_Reviewer

CATEGORY:
	Name
	Category_ID
	Number
	father_ID (if father ID=0 it is a first level category)

POST_CATEGORY:
	Post_ID
	Category_ID



A post can be assigned to 1..n categories. Categories follow a tree structure 
so later will be possible to change them without catastrophes. We'll be able 
to add categories on the fly, and will help, in the future, to build the 
bridge between FP and us. 

You know, the first question that arised in my mind when I received the 
categories list was where to put Catlady's once a week posts. They need 
multiple categories.

If anyone can explain me the difference between ships, ships, and ships, I'll 
be glad to hear it. Currently I don't know whether you refer to relationSHIPs 
(the one I put in 'Interests') or SHIPs as boats. I'm very lost.

Carolina

P.S. I proudly announce I will lead chapter discussion for Snape's Worst 
Memory.