Create Table: project_url

[Neecolaa]

Dependencies

• 77

• 289

  Overview

We need to create the project_url 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

• [x] add issue link to the tables tab of the spreadsheet
• [x] identify and document table description (see spreadsheet under Resources)
• [x] 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)
• [x] 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

Collection of URLs for a project by url type

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)

   • [x] (PK) id - int - Record Id
   • [x] (FK) project_id - int - Record Id
   • [x] (FK) url_type_id - int - Record Id
   • [x] name - CharField(max_length=255)
   • [x] external_id - CharField(max_length=255)
   • [x] url - url varchar

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)

   • [x] project (many-to-one)
   • [x] url_type (many-to-one)

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

   • None

[joshuayhwu]

class Project_URL(AbstractBaseModel):
    """
    project_url
    """
    id = models.IntegerField(primary_key=True)
    project_Id = models.ForeignKey(Project, on_delete=models.CASCADE)
    url_type_id = models.ForeignKey(Project, on_delete=models.CASCADE)
    url = models.URLField(blank=True) 

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

[fyliu]

This is better done after #77 since it references that table.

[Neecolaa]

• Added name and external_id fields as noted in #78