37328429
Description
Mind Map by Rebbecca Stanley, updated 9 months ago
|
Created by Rebbecca Stanley
over 2 years ago
|
|
Technical Proposal (continued)
- Developer
Problem
- Data
- Required Data - Food
- Field 1: id, Data Type: varchar, Data Type Length: 255,
Constraint: NOT NULL and PRIMARY KEY and UNIQUE
- Field 2: name, Data Type: varchar, Data Type
Length: 255, Constraint: NOT NULL and UNIQUE
- Field 3: tier, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 4: attack_amount, Data Type: integer, Data Type Length: 3, Constraint: NULL
- Field 5: defense_amount, Data Type: integer, Data Type Length: 3, Constraint: NULL
- Field 6: kind, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 7: description, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 8: source, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 9: commit, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 10: unicodeCodePoint, Data Type: varchar, Data Type Length: 3, Constraint: NOT NULL
- 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: 🍎
- 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: 🍯
- Field 1: id, Data Type: varchar, Data Type Length: 255,
Constraint: NOT NULL and PRIMARY KEY and UNIQUE
- Required Data - Toys
- Field 1: Attack, Data Type: integer, Data Type Length: 3, Constraint:
NULL
- Field 2: Health, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
- Field 3: Type, Data Type: integer, Data Type Length: 3, Constraint: NOT
NULL
- Field 4: Toy Type, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
- Field 5: Id, Data Type: integer, Data Type Length: 3, Constraint: PRIMARY KEY and NOT NULL
- Field 6: Name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 7: Tier, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
- Field 8: TierMax, Data Type: integer, Data Type Length: 10, Constraint: NOT NULL
- Field 9: Packs, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 10: Rollable, Data Type: Boolean, Data Type Length: 5, Constraint: NOT NULL
- Field 11: Ability_Level, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
- Field 12: Ability_About, Data Type: varchar, Data Type Length: 255, Constraint: NOT
NULL
- Field 13: PerkNote, Data Type: varchar, Data Type Length: 255, Constraint: NULL
- 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: -
- 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: -
- Field 1: Attack, Data Type: integer, Data Type Length: 3, Constraint:
NULL
- Required Data - Pets
- Field 1: id, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and PRIMARY KEY and UNIQUE
- Field 2: name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
- Field 3: baseAttack, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
- Field 4: baseHealth, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
- Field 5: tier, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 6: Level 1 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
- Field 7: Level 2 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
- Field 8: Level 3 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
- Field 9: source, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 10: commit, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
- Field 11: unicodeCodePoint, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
- 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: ðŸœ
- 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: 🦫
- Field 1: id, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and PRIMARY KEY and UNIQUE
- Required Data - Food
- Data
Want to create your own Mind Maps for free with GoConqr? Learn more.