Multiple Database Tables mapped to a Single Concrete Classes?
Greeting, Pega experts,
We have a typical Teacher-Students-Person scenario.
Let's say we have one Class called Teacher, containing Columns like TeacherID, IC No, Name, DOB, Salery, YearsOfTeaching etc.
There is another Class called Student, containing following Columns: StudentID, IC No, Name, DOB, LastScore, DateOfEnrolment, etc.
Can we store common columns,"IC No", "Name" & "DOB", into a Database table called "Person"?
Here is my thought:
Could we create a Person Class in PEGA, containing those properties incl. "IC No, Name & DOB".
Then let both Student & Teacher class inherit from it.
Then specify "External Mapping" for Student and Teacher classes.
Is it doable? How to configure the table joining?
I know that report definition can be used to form Data Pages, but when we set it as "Editable", will Pega know which table to update, and how to update?
Pegasystems Inc.
IN
Hi Paris,
Yes we can set the inheritance class structure with teacher and student both inheriting from the common parent class.
You have asked about external mapping, I wonder why it would be required if you could brief me about exact you are trying to achieve here.
Table joining can be done easily via Reports wherein you can join both the classes with appropriate condition in Report Definition to populate as required.
Thanks,
Ujjwal