Risk Assessment - Laravel Schema Designer

categories

id increments
timestamps timestamps
last_edited_by ^FK integer
locked boolean
text string
tree_id ^FK integer

risks

id increments
timestamps timestamps
last_edited_by ^FK integer
locked boolean
category_id ^FK integer
text string

attacks

id increments
timestamps timestamps
last_edited_by ^FK integer
locked boolean
risk_id ^FK integer
text string

defences

id increments
timestamps timestamps
last_edited_by ^FK integer
locked boolean
text string
type enum
existing boolean

attack_defence

attack_id ^FK integer
defence_id ^FK integer

trees

id increments
timestamps timestamps
creation_date timestamps
name string
public boolean
owner_id ^FK integer

users

id increments
creation_date timestamps
username string
password string

user_tree

user_id ^FK integer
tree_id ^FK integer
acess_type enum

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01