loan-backend/src/main/java/com/loan/system/domain/entity/BizRecommender.java

package com.loan.system.domain.entity;

import lombok.*;

import javax.persistence.*;
import java.math.BigDecimal;
import java.time.Instant;

@Entity
@Table(name = "biz_recommender", uniqueConstraints = {
        @UniqueConstraint(name = "recommender_code", columnNames = {"recommender_code"})
})
@Data
@AllArgsConstructor
@NoArgsConstructor
public class BizRecommender extends BaseEntity{
    private static final long serialVersionUID = 2L;

    @Column(name = "recommender_code", length = 50)
    private String recommenderCode;

    @Column(name = "recommender_name", length = 100)
    private String recommenderName;

    @Column(name = "recommender_type", length = 50)
    private String recommenderType;

    @Column(name = "phone", length = 20)
    private String phone;

    @Column(name = "channel", length = 50)
    private String channel;

    @Column(name = "id_card", length = 20)
    private String idCard;

    @Column(name = "bank_account", length = 50)
    private String bankAccount;

    @Column(name = "commission_rate", precision = 5, scale = 4)
    private BigDecimal commissionRate;

    @Column(name = "company", length = 50)
    private String company;

    @Lob
    @Column(name = "remark")
    private String remark;

    @Column(name = "create_time")
    private Instant createTime;

    @Column(name = "update_time")
    private Instant updateTime;

    @Column(name = "create_user_id")
    private Long createUserId;

    @Column(name = "update_user_id")
    private Long updateUserId;

    @Column(name = "is_delete")
    private Boolean isDelete;

}