Technical Proposal (continued)

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
    2. Field 2: name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
    3. Field 3: tier, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    4. Field 4: attack_amount, Data Type: integer, Data Type Length: 3, Constraint: NULL
    5. Field 5: defense_amount, Data Type: integer, Data Type Length: 3, Constraint: NULL
    6. Field 6: kind, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    7. Field 7: description, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    8. Field 8: source, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    9. Field 9: commit, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    10. Field 10: unicodeCodePoint, Data Type: varchar, Data Type Length: 3, Constraint: NOT NULL
    11. 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: 🍎
    12. 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
    2. Field 2: Health, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
    3. Field 3: Type, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
    4. Field 4: Toy Type, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
    5. Field 5: Id, Data Type: integer, Data Type Length: 3, Constraint: PRIMARY KEY and NOT NULL
    6. Field 6: Name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    7. Field 7: Tier, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
    8. Field 8: TierMax, Data Type: integer, Data Type Length: 10, Constraint: NOT NULL
    9. Field 9: Packs, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    10. Field 10: Rollable, Data Type: Boolean, Data Type Length: 5, Constraint: NOT NULL
    11. Field 11: Ability_Level, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
    12. Field 12: Ability_About, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    13. Field 13: PerkNote, Data Type: varchar, Data Type Length: 255, Constraint: NULL
    14. 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: -
    15. 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: -
  3. Required Data - Pets
    1. Field 1: id, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and PRIMARY KEY and UNIQUE
    2. Field 2: name, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
    3. Field 3: baseAttack, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
    4. Field 4: baseHealth, Data Type: integer, Data Type Length: 3, Constraint: NOT NULL
    5. Field 5: tier, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    6. Field 6: Level 1 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
    7. Field 7: Level 2 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
    8. Field 8: Level 3 Ability, Data Type: varchar, Data Type Length: 255, Constraint: NULL
    9. Field 9: source, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    10. Field 10: commit, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL
    11. Field 11: unicodeCodePoint, Data Type: varchar, Data Type Length: 255, Constraint: NOT NULL and UNIQUE
    12. 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: ðŸœ
    13. 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: ðŸ¦«

Siguiente

Technical Proposal (continued)

Descripción

Resumen del Recurso

Similar

	Creado por Rebbecca Stanley hace más de 2 años