Hi I have a view that contains the following data.
Code:
+---------+-------------+----------+
| team_id | cust_type | count(*) |
+---------+-------------+----------+
| 2 | Account | 12 |
| 2 | Lead | 13 |
| 2 | Opportunity | 5 |
| 2 | Others | 1 |
| 2 | Partner | 16 |
| 2 | PO | 5 |
| 2 | Prospect | 8 |
| 2 | Reseller | 7 |
| 3 | Account | 25 |
| 3 | OC | 1 |
| 3 | Partner | 3 |
| 3 | Prospect | 9 |
| 4 | Account | 4 |
| 5 | Account | 6 |
| 5 | Opportunity | 1 |
| 5 | Prospect | 8 |
+---------+-------------+----------+
I want to map this to Hibernate entity. The first column 'Team_id' is not unique. Hence how can I write the mapping entries for this?
Any idea?
Thanks in advance