Status: In Progress

Database Hardware Location (Code Word): vP

Database Name (Code Word):  Pride

Stored Procs:

DraftPlayerInsertIntoPlayer_sp = Takes player from DraftPlayer and inserts it (hopefully) into Player table (for now) and also PlayerPotential Table.

DraftPlayerInsertIntoPlayer12s_sp = Stored Procedure in process, just have to remember to alter before I close

Tables:

Draft = Stores overall info of each draft (which league, season, draft type (Regular, Dispersal, Supplimental etc.) has DraftID, DraftDtlID 

DraftDetail = Where info on Round, Pick in round, overall pick number, team picked by (TeamAbbr) as well as Notes and PlayerDtlId is stored. 

DraftPlayer = Where 12s league draft prospects are currently

Player = Destination for drafted players from DraftPlayer

PlayerPotential = where the randomly generated potential of each draft player is inserted upon being drafted. 

Game Files and Saves: GoogleDrive\Tecmo Bowl\12s League

Name comes from the SQL data base for different leagues. This league has a primary key of "12" so I just started thinking of it in my head as "The 12's league" and never really came up with anything I liked better. 

1. DONE: Take in parameter's: DraftDetailID and TeamAbbr 

   1. MmmmHmmmmm: pretty much everything else can be grabbed from there. 

2. DONE: Create temp table to dump all of drafted players stuff in

3. DONE: Import drafted player into Player

4. DONE: Update TeamID in Player table using TeamAbbr, SeasondDtlID

5. Get random vanilla players attributes from Player table

   1. create temp table for all players at that position

   2. Fill with Vanilla PlayerIDs

   3. Fill it with Index_ids to get a range for the random variable to grab. 

   4. generate indexs via a loop

   5. get Attributes for randomly grabbed vanilla player

   6. Compare random player attributes to drafted player attributes

      1. Loaded Random and Drafted player int0 Comparison temp table

         1.  create loop to update temp table based on the following:

            1. if an attribute is higher than the drafted player it's put in the PlayerPotential table

            2. if not, it's a zero and the draft player can't increase that attribute. 

6. Insert all pertinent data into PlayerPotential table   <-- so this is the correct next step future self, and be sure to use rollback this time (it's in the SP)

   1. is Draft set up in Draft table? No. It is now:

      2. 1. DraftDtlID =7

         2. DraftID = 10

   2. SeasonDtlID = 1992 season in Season table

      2. 2. 1. 18 is the SeasonDtlID

7. Insert into DraftDetail table (round, pick number etc.)

8. Update DraftPlayer TeamAbbr so it is known that he is picked.