Consolidating Technology, Tool, & Language - Schema Changes

[Neecolaa]

Overview

The ERD and Spreadsheet need to be updated with the new stack element tables before changes are done in Django.

Action Items

Technology (rename to stack_element)

Columns to Remove

• none

Columns to Add

• (FK) stack_element_type_id - int
  • [x] Spreadsheet
  • [x] ERD

Additional Changes

• Change name from technology to stack_element
  • [x] in table tab of spreadsheet
  • [x] in field tab of spreadsheet
  • [x] in ERD
• Add relationship between stack_element and stack_element_type
  • [x] in table tab of spreadsheet
  • [x] in ERD
• Add relationship between stack_element and project_stack_element_xref (replacing project_technology_xref)
  • [x] in table tab of spreadsheet
  • [x] in ERD

project_stack_element_xref

Data Fields

Compiled referencing #64 and #40 (unchecked items have not yet been added to the spreadsheet and/or ERD)

• (PK) id - int - Record Id
  • [x] Spreadsheet
  • [x] ERD
• (FK) project_id - int
  • [x] Spreadsheet
  • [x] ERD
• (FK) stack_element_id - int - Record Id
  • [x] Spreadsheet
  • [x] ERD

Associated Tables

New associations (unchecked items have not yet been added to the spreadsheet and/or ERD)

• stack_element (many-to-one)
  • [x] Spreadsheet
  • [x] ERD
• project (many-to-one)
  • [x] Spreadsheet
  • [x] ERD

stack_element_type

Data Fields

New fields (unchecked items have not yet been added to the spreadsheet and/or ERD)

• (PK) id - int - Record Id
  • [x] Spreadsheet
  • [x] ERD
• name - varchar
  • [x] Spreadsheet
  • [x] ERD
• description - varchar
  • [x] Spreadsheet
  • [x] ERD

Associated Tables

New associations (unchecked items have not yet been added to the spreadsheet and/or ERD)

• stack_element (one-to-many)

  • [x] Spreadsheet
  • [x] ERD

• [x] Remove dependency label and place in backlog after stack_element_type updates are done

Resources/Instructions

Entity Relationship Diagram (ERD) PD: Table and Field definitions

[Neecolaa]

• The changes relating to #206 have been completed, so the dependency label can be removed.

[Neecolaa]

All changes have been made to the spreadsheet and ERD