search

DefensePointSecurity / threat_note

DPS' Lightweight Investigation Notebook
Apache License 2.0
421 stars 97 forks source link

Database Modification Discussion #142

Open alxhrck opened 8 years ago

alxhrck commented 8 years ago

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 commented 8 years ago

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 commented 8 years ago

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.