Database

DATABASE

The app will comprise of seven tables:

• Question Table
• Answer Table
• Points Table
• Avatar Table
• Scenario Table
• Clothes Table
• Hair Table
• Accessories Table

Question Table Attributes

1. QId: An Id unique to questions
2. ScenarioID: Id of the scenario
3. QDes: Description of the question

Answer Table Attributes

1. AId: An Id unique to answers
2. ADes: Answer Descriptions (Options: Eg "I am down")
3. QId: Foreign Key to Question Table
4. NextQId: Id of next question if this answer is selected
5. Points: Points earned on selecting the answer
6. Strength: Relative integer value(positive/negative) which would be added to Global Strength value.
7. Invisibility: Relative integer value(positive/negative) which would be added to Global Invisibility value.
8. Healing: Relative integer value(positive/negative) which would be added to Global Healing value.
9. Telepathy: Relative integer value(positive/negative) which would be added to Global Telepathy value.

If there are multiple options (ie multiple tuples for a particular QId in Answer Table) allow the user to select, else display the response (using ADes) and then the next question (using NextQId)

Points Table Attributes

This table would contain only two entries ie before entering the scenario and one after the scenario

1. Id: Id for the points
2. Strength: Int Strength Global value
3. Invisibility: Int Invisibility Global Value
4. Healing: Int Global Int Value
5. Telepathy: Int Global Telepathy Value

Avatar Table Attributes

This table would contain information about the avatar's current look

1. Id: Id for the avatar
2. Face: Id of face
3. Clothes: Id of clothes
4. Hair: Id of hair
5. Eyes: Id of eyes
6. Bag: Id of bag
7. Glasses: Id of glasses
8. Hat: Id of hat
9. Necklace: Id of necklace

Initially the Id for face, clothes, hair and eyes is set to 1 and the Id for bag, glasses, hat and necklace is set to 0.

Scenario Table Attributes

This table would contain information about the current scenario

1. Id: Id for the scenario
2. ScenarioName: Name of the scenario
3. Timestamp: Timestamp for the scenario
4. Asker: Name of asker in the scenario
5. Avatar: Id of the avatar
6. FirstQID: Id of the first question in the scenario
7. Completed: Boolean representing if scenario is completed or not
8. NextScenarioID: ID of the next scenario
9. Replayed: Boolean representing if scenario is replayed or not

Initially, Completed and Replayed is set to 0.

Clothes Table Attributes

This table would contain information about clothes

1. CID: Id for the cloth
2. Name: Name of the cloth
3. Points: Points required to purchase the cloth
4. Purchased: Boolean representing if cloth is purchased or not

Initially, purchased is set to 0.

Hair Table Attributes

This table would contain information about hairstyle

1. HID: Id for the hairstyle
2. Name: Name of the hairstyle
3. Points: Points required to purchase the hairstyle
4. Purchased: Boolean representing if hairstyle is purchased or not

Initially, purchased is set to 0.

Accessories Table Attributes

This table would contain information about accessories

1. AID: Id for the accessory
2. Name: Name of the accessory
3. Points: Points required to purchase the accessory
4. Purchased: Boolean representing if accessory is purchased or not

Initially, purchased is set to 0.