4 ms·
> However some universities view the student id as sensitive information (kind of like a ssn in the US) and so in that scenario it should be aliased to some oth
by TeMPOraL 5y ago
> However some universities view the student id as sensitive information (kind of like a ssn in the US) and so in that scenario it should be aliased to some other key to prevent the student id from being present in multiple tables as a foreign key.
It is ironic, given that the whole reason to have a student ID is for it to be a primary key in some database somewhere.
- whatshisface 5y agoDatabases are vulnerable to a particular type of folkloric magic: https://en.m.wikipedia.org/wiki/True_name https://en.m.wikipedia.org/wiki/True_name