Saturday, November 29, 2008

Tables to store data in My database.

I had planed about data will store in my database and I was created tables to store my data.
My database is consists three tables in shown belong.

1. Girl data : It main table is store data about girls.
Field Deatails:
- Name [Character Name]
- Picture [Character Picture]
- Anime [The animation that character is act]
- Manga [The manga that character is act]
- Role [The role in animation or Manga]
- Characteristics [Habit or Behavior]
- Character type [ or MOE Type of Character such as Loli--very young girl]
- Creator [Creator Name that create Character]
- Weapon [Weapon or Tools that Character is usually held]
- Partner [Animal or person that usually to follow the Character]

2. Creator : It is store data about creators who are create girls.
Field Details:
- Creator[Creator Name]
- Publisher[Publisher which Creator is belonged]
- Manga [Manga Name which Creator are create]
- Anime [Anime Name which Creator are created]

3. Character type : It also called "MOE Type", is store types of character information.
Type of character such as Lolicon(very young girl),Nekomimi(girl with cat
ears);
Field Details:
- Character Type[name of Character Type]
- Type details [Commonly behavior of Character Type details]
- Type decoration[decoration details. For example Nekomimi decoration are
cat ears and cat tails. Meganemimi decoration are glasses.]


three tables are related between them in shown belong
Creator in Girl data table is relation with Creator in Creator table
Character type in Girl data table is relation with Character type in Character
type
table
***********************************************************************************



No comments: