Create Table: win

[fyliu]

Dependency

• Create Table: win_type (used to be called accomplisment_type) #61

Overview

We need to create the win table so that we can update a shared data store across hackforla.org, vrms, civictechjobs, and tables (onboarding) project.

Details

A table and a model are the same thing

Action Items

• identify and document table description (see spreadsheet under Resources)
  • if not, reach out to PD leads
• compare and check off the data fields (below) against the ERD. Note any fields in the ERD that's missing from the list. (see Resources)
• compare the check off associated tables (below) against the ERD. Note any associated tables in the ERD that's missing from the list (see Resources)
• create a single model in Django (defining schema)
• write a test for the relationships this model will have with other models (e.g., creating a user and assigning them a set of permissions on a project).
• write an API end point
• write API unit tests
• document the endpoint

Resources/Instructions

• See People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• See the wiki page for instructions.

Description

Connects a win to a user

Data Fields

1. Copied from spreadsheet and checked off according to ERD. (unchecked items indicate a mismatch between ERD and spreadsheet, which requires a review)

   • (PK) id - int - Record Id
   • (FK) user_id - int - Record Id
   • practice_areas - int[] (practice_area id)
   • teams - int[] (projectID)
   • description - varchar
   • (FK) win_type_id - int
   • can_use_photo - boolean

2. In ERD only (having items here indicates a mismatch, which requires a review)

   • None

Associated Tables

1. Copied from spreadsheet and checked off according to ERD. (unchecked items indicate a mismatch between ERD and spreadsheet, which requires a review)

   • win_type (many-to-one)
   • user (many-to-one)
   • practice_area (many-to-many array of ids)
   • project (many-to-many array of ids)

2. In ERD only (having items here indicates a mismatch, which requires a review)

   • None

[joshuayhwu]

class Win(AbstractBaseModel):
	"""
	win
	"""
	id = models.IntegerField(primary_key=True)
	user_int = models.ForeignKey(User, on_delete=models.CASCADE)
	roles = models.ForeignKey(Role, on_delete=models.CASCADE)
	teams = models.ForeignKey(Project, User, on_delete=models.CASCADE)
	description = models.CharField(max_length=255)
	accomplishment_type = models.ForeignKey(Accomplishment, on_delete=models.CASCADE)
	can_use_photo = models.BooleanField()

	def __str__(self): 
		return f"{self.name}"