| Line 15... |
Line 15... |
| 15 |
*
|
15 |
*
|
| 16 |
* @author ashikali
|
16 |
* @author ashikali
|
| 17 |
*
|
17 |
*
|
| 18 |
*/
|
18 |
*/
|
| 19 |
@Entity
|
19 |
@Entity
|
| 20 |
@Table(name="dtr.retailer_address", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"retailer_id","address_id"})})
|
20 |
@Table(name="dtr.retailer_address", uniqueConstraints = {@UniqueConstraint(columnNames = {"retailer_id","address_id"})})
|
| 21 |
@NamedQueries({
|
21 |
@NamedQueries({
|
| 22 |
@NamedQuery(name="RetailerAddress.selectByRetailerId", query="select ra.addressId from RetailerAddress ra where ra.retailerId= :retailerId"),
|
22 |
@NamedQuery(name="RetailerAddress.selectByRetailerId", query="select ra.addressId from RetailerAddress ra where ra.retailerId= :retailerId"),
|
| 23 |
@NamedQuery(name="RetailerAddress.deleteByRetailerAndAddressId", query="delete from RetailerAddress ra where ra.retailerId= :retailerId and ra.addressId = :addressId"),
|
23 |
@NamedQuery(name="RetailerAddress.deleteByRetailerAndAddressId", query="delete from RetailerAddress ra where ra.retailerId= :retailerId and ra.addressId = :addressId"),
|
| 24 |
@NamedQuery(name = "RetailerAddress.selectAddressesByRetailerId", query = "select a from RetailerAddress ra join Address a on a.id = ra.addressId where ra.retailerId = :retailerId")
|
24 |
@NamedQuery(name = "RetailerAddress.selectAddressesByRetailerId", query = "select a from RetailerAddress ra join Address a on a.id = ra.addressId where ra.retailerId = :retailerId")
|
| 25 |
})
|
25 |
})
|