Technical Proposal (continued)

Description

Year 11 Digital Technologies Mind Map on Technical Proposal (continued), created by Rebbecca Stanley on 14/08/2022.
Rebbecca Stanley
Mind Map by Rebbecca Stanley, updated 3 months ago
Rebbecca Stanley
Created by Rebbecca Stanley almost 2 years ago
17
0

Resource summary

Technical Proposal (continued)
  1. Developer Problem
    1. Data
      1. Required Data - Food
        1. Field 1: id, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and PRIMARY KEY and UNIQUE
          1. Field 2: name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
            1. Field 3: tier, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
              1. Field 4: attack_amount, Data Type: integer, Data Type Length: 3, Constraint: NULL
                1. Field 5: defense_amount, Data Type: integer, Data Type Length: 3, Constraint: NULL
                  1. Field 6: kind, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                    1. Field 7: description, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                      1. Field 8: source, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                        1. Field 9: commit, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                          1. Field 10: unicodeCodePoint, Data Type: varchar, Data Type Length: 3, Constraint: NOT NULL
                            1. Example 1: id: food-apple, name: Apple, tier: 1, attack_amount: 1, defense_amount: 1, kind: ModifyStats, description: Give an animal +1/+1, source: twemoji, commit: 793a6a93f303c08877dd6eb589b2fabb3d1c45ee, unicodeCodePoint: 🍎
                              1. Example 2: id: food-honey, name: Honey, tier: 1, attack_amount: -, defense_amount: -, kind: Faint, description: Give an animal Honey Bee. Summon a 1/1 Bee after fainting. , source: twemoji, commit: 793a6a93f303c08877dd6eb589b2fabb3d1c45ee, unicodeCodePoint: 🍯
                              2. Required Data - Toys
                                1. Field 1: Attack, Data Type: integer, Data Type Length: 3, Constraint: NULL
                                  1. Field 2: Health, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
                                    1. Field 3: Type, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
                                      1. Field 4: Toy Type, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
                                        1. Field 5: Id, Data Type: integer, Data Type Length: 3, Constraint: PRIMARY KEY and NOT NULL
                                          1. Field 6: Name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                                            1. Field 7: Tier, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
                                              1. Field 8: TierMax, Data Type: integer, Data Type Length: 10, Constraint: NOT NULL
                                                1. Field 9: Packs, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                                                  1. Field 10: Rollable, Data Type: Boolean, Data Type Length: 5, Constraint: NOT NULL
                                                    1. Field 11: Ability_Level, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
                                                      1. Field 12: Ability_About, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                                                        1. Field 13: PerkNote, Data Type: varchar, Data Type Length: 255, Constraint: NULL
                                                          1. Example 1: Attack: 2, Health: 3, Type: 1, ToyType: 0, Id: 479, Name: Balloon, Tier: 1, TierMax: 2147483647, Packs: [], Rollable: TRUE, Ability_Level: 1, Ability_About: Break: Give the right-most friend +1 attack and +1 health., PerkNote: -
                                                            1. Example 2: Attack: -, Health: 1, Type: 1, ToyType: 1, Id: 298, Name: Boomerang, Tier: 1, TierMax: 5, Packs: [], Rollable: TRUE, Ability_Level: 1 Ability_About: Start of battle: Deal 30 damage to the highest health friend., PerkNote: -
                                                            2. Required Data - Pets
                                                              1. Field 1: id, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and PRIMARY KEY and UNIQUE
                                                                1. Field 2: name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
                                                                  1. Field 3: baseAttack, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
                                                                    1. Field 4: baseHealth, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
                                                                      1. Field 5: tier, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                                                                        1. Field 6: Level 1 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
                                                                          1. Field 7: Level 2 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
                                                                            1. Field 8: Level 3 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
                                                                              1. Field 9: source, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                                                                                1. Field 10: commit, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
                                                                                  1. Field 11: unicodeCodePoint, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
                                                                                    1. Example 1: id: pet-ant, name: Ant, baseAttack: 2, baseHealth: 1, tier: 1, Level 1 Ability: Faint: Give a random friend +2/+1, Level 2 Ability: Faint: Give a random friend +4/+2, Level 3 Ability: Faint: Give a random friend +6/+3, source: noto-emoji, commit: e022fd6573782431ac9a65b520376b57511c31cd, unicodeCodePoint: ðŸœ
                                                                                      1. Example 2: id: pet-beaver, name: Beaver, baseAttack: 2, baseHealth: 2, tier: 1, Level 1 Ability: Sell: Give two random friends +1 health, Level 2 Ability: Sell: Give two random friends +2 health, Level 3 Ability: Sell: Give two random friends +3 health, source: noto-emoji, commit: e022fd6573782431ac9a65b520376b57511c31cd, unicodeCodePoint: 🦫
                                                                                  Show full summary Hide full summary

                                                                                  Similar

                                                                                  Statistics, Data and Area (Semester 2 Exam)
                                                                                  meg willmington
                                                                                  Mathematics
                                                                                  Corey Lance
                                                                                  Chapter 7: Investigating Data
                                                                                  Sarah L
                                                                                  Maths Summarising Data
                                                                                  Will Thorpe
                                                                                  Pokemon Data Flow Homework
                                                                                  Rebbecca Stanley
                                                                                  Technical Proposal
                                                                                  Rebbecca Stanley
                                                                                  Existing Data Exchange Methods/Systems
                                                                                  Rebbecca Stanley
                                                                                  TYPES OF DATA
                                                                                  Elliot O'Leary
                                                                                  STEM AND LEAF DIAGRAMS
                                                                                  Elliot O'Leary
                                                                                  How to Create A Mindmap
                                                                                  PatrickNoonan
                                                                                  Creating Mind Maps with GoConqr
                                                                                  Sarah Egan