title_role has nullable foreign keys and shouldn't.

sfu-dhil / wphp

Women's Print History Project database front end.

https://womensprinthistoryproject.com/

GNU General Public License v2.0

1 stars 8 forks source link

title_role has nullable foreign keys and shouldn't. #209

Closed ubermichael closed 3 years ago

ubermichael commented 3 years ago

Describe the bug The fkey relationships in title_role (and probably title_firmrole) are nullable and that doesn't make sense. How do you define a title role without including the role, or the title, or the person? All the fields should be not-null.

Luckily, the data is clean in this respect.