Re: [Codematch-develop] Codematch Call Wed 13 May

[Lisandro Zambenedetti Granville <[e-mail]>]

Hello Christian

I incorporated the modifications in the data model. However, I have the following comments:

> Add to Codematch table: Creation_date

There’s no Codematch table. I believe you meant Project Container

> Add Projects table: Reputation

Done.

> Change the table name from Specification to Document

Done.

> Remove Area from Codematch table

Done, from the Project Container as above.

> The relationship between Projects and Codematch should be many to many

I didn’t do it yet because I wanted to double-check. To do so, let me “tell” the story of this version.

- A “Code Project” describes a project owned/run by a single user. Each user, however, can be the coder of many project.

- A “Project Container” is a collection of Code Projects. Each container hosts several projects, but each project is linked to a single container. I believe this is where you asked for a many to many relationship, but I think 1 to many is more correct, I guess. 

- A “Project Container” is linked to zero or more documents. Each Document is linked to zero or one container

- A “CodeRequest” is an extended container, adding estimated LoE information. 





Best regards,

Lisandro