Create Table: project_language_xref

[ericvennemeyer]

Dependency

• Create Table: language 😄  #54

Overview

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

Join project to language

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
   • (PK,FK) project_id - int - Record Id
   • (PK,FK) language_id - int - Record Id
   • created - timestamp
   • ended - timestamp

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)

   • language (many-to-one)
   • project (many-to-one)

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

   • None

[fyliu]

This is better done after the language table since it references it.

[AzaniaBG]

The corresponding language issue is finished, so I moved this from the Ice Box.
Availability for this week:
Saturday 6 - 7 AM
Wednesday 6 - 7:45 AM
Thursday 6 - 7:45 AM

[AzaniaBG]

Update: I haven't been able to work on this issue (really busy with work). I'm hoping to have this finished by next Thursday.

Availability:
Friday (9/14): 6 - 7 AM
Saturday 7 - 10 AM
Wednesday: 6 - 7 AM
Thursday: 6 - 7 AM

[AzaniaBG]

Update: it doesn't look like the last issue, #54, was merged to the HfLA main repo. This should be merged before I start working on #64, per Fang's comment.

[AzaniaBG]

I'm waiting to hear back on what the new xref table will be (this issue, as well as the language table may go away, per issue #202).

[AzaniaBG]

I moved this issue to the ice box, per discussion with @Neecolaa.

[Neecolaa]

• This is being replaced by Create Table: project_stack_element_xref #205