added column for switch name
renamed column for job site name
renamed column is_open to is_closed for consistency
initial commit
added columns for type code, long and short type descriptions
added foreign key to royal_item_id for interactions related to specific items
added unique constraint to interaction type_code
corrected comment on column is_closed
added column for royal_item_id, optional foreign key
removed pointless reflexive relationship
temporary, to be merged