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

[Christian O'Flaherty <[e-mail]>]

Hi Lisandro, 

> 
> 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

On our previous call we decided to change the name to the table that was called “Match”
I thought the name you suggested for that table was Codematch 

Is it “Project_Container” the new name for that main table in the middle of the data model?

>> 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.

I assume we’re talking about the same table

> 
>> 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.

ok

> - 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. 

I think there are cases where a single project (code) has to use definitions described in more than one document. For example, if you would like to implement and test the current proposals for BGPSEC you will “use" for your code several drafts.

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

In the current implementation, the relationship is: A “Project Container” is linked to one document.

I think we should always have at least one document linked.

I’m not sure if we need more than one document linked from the container. I thought the best way to capture the fact that an implementation needed more than one document was on the “Code Project” table referring to several “Project Containers". But I can easily change that if needed.  

Christian

> - A “CodeRequest” is an extended container, adding estimated LoE information. 
> 
> 
> 
> <codematchv5.png>
> 
> Best regards,
> 
> Lisandro
>