The ProjectBDV in GreenIT is based on tblProjects, where the ProjectID is the primary key. The only constraints that we have on tbl_projectbdv is on the projectbdv_uid, which seems unnecessary, and hash_MD5. We should at least make sure that project_id has a unique constraint, but we really should just have it be the primary key. There should not be any duplicates, and if there are, we want it to throw an error.
Without constraints, we cannot use project_id as a foreign key.
The ProjectBDV in GreenIT is based on tblProjects, where the ProjectID is the primary key. The only constraints that we have on
tbl_projectbdvis on theprojectbdv_uid, which seems unnecessary, andhash_MD5. We should at least make sure thatproject_idhas a unique constraint, but we really should just have it be the primary key. There should not be any duplicates, and if there are, we want it to throw an error.Without constraints, we cannot use
project_idas a foreign key.