Hi!
I'm trying to map the following legacy database tables using Hibernate. One notably requirement is that when the STUDENT.STUDENT_STATUS is changed, the SUBJECTA and SUBJECTB's STUDENT_STATUS are also changed because these columns are the same.
STUDENT
STUDENT_ID (PK)
STUDENT_STATUS
SUBJECTA
STUDENT_ID (PK)
STUDENT_STATUS
SUBJECTB
STUDENT_ID (PK)
STUDENT_STATUS
How can I map these tables that when STUDENT.STUDENT_STATUS (or even any of the three tables) is updated, the rest of the STUDENT_STATUS is updated automatically?
.
|