Update table relationships to use foreign keys wherever possible

YCPRadioTelescope / RT-Contracts

Back-end architecture for the Radio Telescope Senior Software Design Project for the 2018-2019 academic year

3 stars 1 forks source link

Update table relationships to use foreign keys wherever possible #101

Open lgartrell opened 3 years ago

lgartrell commented 3 years ago

Big change

This is related to tables with straight forward relationships not using foreign keys. Future work, this issue will stand as a place to write down tables that should be updated for future work

lgartrell commented 3 years ago

radio_telescope

current_orientation_id -> orientation [one to one]
calibration_orientation_id -> orientation [one to one]

thanks Patrick for this one

lgartrell commented 3 years ago

user_role

user_id -> user [one to one]

thanks pat again

pdnelson commented 3 years ago

The user ID foreign key has been added, though the other two will have to wait for a while, as the control room is not in a good place to receive that update yet. This issue will likely have to be finished next semester to aide in the many CR bug fixes.