@Entity
@Table(name = "FB_CLIENTS")
@NamedQueries({@NamedQuery(name = "CClients.findById", query = "SELECT f FROM CClients f WHERE f.id = :id")})
 public   class  CClients  implements  java.io.Serializable{  
  @Id
  @GeneratedValue
  @Column(name = "ID")
   private  Integer id;

  @Column(name = "NAME")
   private  String name;

  @Column(name = "ACCOUNT")
   private  BigDecimal account;

  @Column(name = "CREDIT")
   private  BigDecimal credit;
  
  @OneToMany(mappedBy = "CClients")      
  @OrderBy("stopDate DESC")        
   private  List<CPromisedPaiments> objectList =  new  LinkedList<CPromisedPaiments>(); 
  
  @OneToMany(mappedBy = "CClients")   
   private  List<CClientServices> servicesList =  new  LinkedList<CClientServices>();
  
  @OneToMany(mappedBy = "CClients")   
   private  List<CClientTransactions> transactionList=  new  LinkedList<CClientTransactions>();
  

   public  Integer getId() {
     return  id;
  }
   public   void  setId(Integer id) {
     this .id = id;
  }
  
   public  String getName() {
     return  name;
  }
   public   void  setName(String name) {
     this .name = name;
  }
 public  List<CPromisedPaiments> getObjectList() {
     return  objectList;
  }
   public   void  setObjectList(List<CPromisedPaiments> objectList) {
     this .objectList = objectList;
 }    

@Entity
@Table(name = "FB_PROMISED_PAYMENTS")
 public   class  CPromisedPaiments  implements  java.io.Serializable{
   private  Integer id;  
   private  BigDecimal sumP;
   private  Date stopDate; 
   private  CClients cClients; 
 
  @Id
  @Column(name = "ID")
  @GeneratedValue 
   public  Integer getId(){ return  id;}
   public   void  setId(Integer id)
  {  
     this .id=id;      
  }  
  
  @Column(name = "SUM") 
   public  BigDecimal getSumP(){
       return  sumP;
  }
   public   void  setSumP(BigDecimal sumP){
    this .sumP=sumP;   
  }  
  
  @Column(name = "STOP_DATE")
  @Temporal(value = TemporalType.DATE)
   public  Date getStopDate(){
       return  stopDate;
  }
   public   void  setStopDate(Date stopDate){
      this .stopDate=stopDate;
  } 
  
  @ManyToOne  
  @JoinColumn(name = "CLIENT_ID", referencedColumnName = "ID")    
   public  CClients getCClients(){
         return  cClients;
  }
   public   void  setCClients(CClients cClients) {
         this .cClients  = cClients;        
  }     
}

@Entity
@Table(name = "FB_PROMISED_PAYMENTS")
 public   class  CPromisedPaiments  implements  java.io.Serializable{

  @Id
  @Column(name = "ID")
  @GeneratedValue 
   private  Integer id;  
  @Column(name = "SUM") 
   private  BigDecimal sumP;
  @Column(name = "STOP_DATE")
  @Temporal(value = TemporalType.DATE)
   private  Date stopDate; 
 
  @ManyToOne  
  @JoinColumn(name = "CLIENT_ID", referencedColumnName = "ID") 
   private  CClients cClients; 
 
  
   public  Integer getId(){ return  id;}
   public   void  setId(Integer id)
  {  
     this .id=id;      
  }    
 
   public  BigDecimal getSumP(){
       return  sumP;
  }
   public   void  setSumP(BigDecimal sumP){
    this .sumP=sumP;   
  }  
    
   public  Date getStopDate(){
       return  stopDate;
  }
   public   void  setStopDate(Date stopDate){
      this .stopDate=stopDate;
  } 
    
   public  CClients getCClients(){
         return  cClients;
  }
   public   void  setCClients(CClients cClients) {
         this .cClients  = cClients;        
  }     
}