Database Modification Discussion

[alxhrck]

I thought I'd start a thread regarding the needed modifications to the database schema. Hopefully we can consolidate the discussion to this issue.

@brianwarehime It would be helpful to create a new branch where we could commit code changes that effect the database without disrupting the master.

[alxhrck]

Table: Relationships
Columns: id, indicator_id, indicator_id

Table: Threat Actor
Columns: id, actor_name, actor_alias, comments, first_seen, last_seen, attribution, campaign_id

Table: Additional Attributes
Columns: id, attribute, attrib_value, indicator_id

Table: Indicators
Columns to add: campaign_id, source

Table: Campaigns
Columns: id, name, first_seen, last_name

[brianwarehime]

Agreed on the development branch 100%

That's something I'll be putting in place soon, we'll just have a development branch and master, and start using the git flow methodology. So, create a branch, merge to development, and if testing is good, we'll merge to master.

Regarding the database changes, I think that looks good. Definitely something we should all sit down and discuss more shortly. I apologize for my lack of updates lately, we are settling on our new house this week, and we've just been swamped with the moving process, so, hopefully in about two weeks I can get things back to normal and start development back up.