Create Table: soc_detailed

[fyliu]

Overview

We need to create the soc_detailed 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)
• 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
• Check to see if open issues in FK status below
  • If all Issues listed are closed (or there are no FKs), then skip the next 3 steps
    • comment out the code after you create it (see FK Status below for open/closed state)
    • add an action item on the open issue to uncomment the code line you commented out when that issue's table is created.
    • Provide your file and line number as a permalink under resources in that issue
• Uncomment the code related to the FK table after Create Table: soc_broad #72 is merged
  • models.py: b9ad72b#diff-8b91c5949f356665ee0f9636ea4d2144065b368bba6876f73d1a53879c61d92dR515

Resources/Instructions

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

Description

Dictionary of SOC (Standard Occupational Classification) detailed occupations. The data can be found in the PD Spreadsheet.

Data Fields

Name	Type	FK Table	FK table Issue(s)
soc_broad	int	soc_broad	#72
occ_code	varchar
title	varchar
description	textfield

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

FK status

• Create Table: soc_broad #72

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)

   • soc_broad (many-to-one) Create Table: soc_broad #72
   • user_employment_change (one-to-many) Create Table: user_employment_history #81
   • modern_job_title (one-to-many) Create Table: modern_job_title #62

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

   • None

[fyliu]

Problems:

1. Missing description
   1. I added it but need to verify it's okay
2. Missing associated tables in spreadsheet
   1. I added them