Foreign Key use
I've inherited a database with lots of tables. Many of the tables are linked to the main "Projects" table using a relationship such as
PROJECTS::__kp_Projectsid ---< RELATEDTABLE::_kf_projectsid
However, I'm seeing a whole lot of _kf_ fields in the Projects table, that reference other tables' ID's, even though there aren't relationships using them. Is there a point to having _kf_ fields if they're not being used in a relationship, even if that table is linked using the __kp_projectsid? Is it some sort of standard practice that I don't remember?