Create Table: url_type

[fyliu]

Overview

We need to create the url_type 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] identify and document table description (see spreadsheet under Resources)
  • [ ] if not, reach out to PD leads
• [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)
• [ ] add seed data
• [ ] 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
• [ ] Release #41 from ice box

Resources/Instructions

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

Description

Type of the URL (ReadMe, Wiki, etc.)

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] name - varchar
   • [x] description - textfield

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_url (one-to-many)

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

   • None

[fyliu]

This table's data has overlaps with some URL fields in the project table. We need to document what should go in the project table and what should go in project_url. It looks to me like the project_url is meant as a way to extend what's the project table without needing to change the db schema.

• [ ] #78

• relates to #41

[joshuayhwu]

class URL_Type(AbstractBaseModel):
    """
    user type
    """
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=255)
    description = models.CharField(max_length=255)

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

[fyliu]

• I looked at the #78 and don't see anything that blocks this issue from being worked on.

[ExperimentsInHonesty]

@fang This issue needs to be cleaned up before it goes back into the prioritized backlog. It should not have comments in the body. it makes it too hard to follow

[fyliu]

Hidden all comments.

Turns out my last comment was saying that the previous comment has been resolved but I should have marked it hidden.