SALES DATA
unknown
java
3 years ago
4.4 kB
3
Indexable
package com.garage11.domain; import lombok.Builder; import lombok.Data; import lombok.ToString; import lombok.experimental.Tolerate; import org.hibernate.annotations.CreationTimestamp; import javax.persistence.*; import java.math.BigDecimal; import java.sql.Timestamp; @Entity @Table(name = "sales") @Data @Builder @ToString public class Sales { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id") private Long id; @Column(name = "seller_id", length = 20) private String sellerId; @Column(name = "seller_name", length = 150) private String sellerName; @Column(name = "seller_surname", length = 150) private String sellerSurname; @Column(name = "seller_email", length = 150) private String sellerEmail; @Column(name = "seller_type", length = 20) private String sellerType; @Column(name = "buyer_id", length = 20) private String buyerId; @Column(name = "buyer_name", length = 150) private String buyerName; @Column(name = "buyer_surname", length = 150) private String buyerSurname; @Column(name = "buyer_email", length = 150) private String buyerEmail; @Column(name = "buyer_type", length = 20) private String buyerType; @Column(name = "car_id", length = 100) private String carId; @Column(name = "vehicle_title", length = 200) private String vehicleTitle; @Column(name = "vehicle_year") private Integer vehicleYear; @Column(name = "vehicle_brand", length = 40) private String vehicleBrand; @Column(name = "vehicle_model", length = 40) private String vehicleModel; @Column(name = "vehicle_body_style", length = 30) private String vehicleBodyStyle; @Column(name = "vehicle_transmission_type", length = 20) private String vehicleTransmissionType; @Column(name = "vehicle_fuel_type", length = 20) private String vehicleFuelType; @Column(name = "vehicle_version", length = 200) private String vehicleVersion; @Column(name = "vehicle_kilometers") private Integer vehicleKilometers; @Column(name = "plate_number", length = 10) private String plateNumber; @Column(name = "vehicle_color", length = 20) private String vehicleColor; @Column(name = "engine_no", length = 30) private String engineNo; @Column(name = "chassis_number", length = 30) private String chassisNumber; @Column(name = "city", length = 30) private String city; @Column(name = "order_channel", length = 20) private String orderChannel; @Column(name = "payment_type", length = 30) private String paymentType; @Column(name = "payment_name", length = 50) private String paymentName; @Column(name = "payment_type_id") private Long paymentTypeId; @Column(name = "payment_method", length = 50) private String paymentMethod; @Column(name = "order_id") private Long orderId; @Column(name = "order_status", length = 30) private String orderStatus; @Column(name = "sales_type", length = 30) private String salesType; @Column(name = "gmv") private BigDecimal gmv; @Column(name = "commission_amount") private BigDecimal commissionAmount; @Column(name = "commission_percent") private BigDecimal commissionPercent; @Column(name = "commission_amount_exc_vat") private BigDecimal commissionAmountExcVat; @Column(name = "net_rev_exc_vat") private BigDecimal netRevExcVat; @Column(name = "credit_amount") private BigDecimal creditAmount; @Column(name = "amount") private BigDecimal amount; @Column(name = "created_date") @CreationTimestamp private Timestamp createdDate; @Column(name = "settlement_date") private Timestamp settlementDate; @Column(name = "settlement_status") private Integer settlementStatus = 0; @Column(name = "seller_claim_amount") private BigDecimal sellerClaimAmount; @Column(name = "sap_payment_completed_date") protected Timestamp sapPaymentCompleteddate; @Column(name = "workflow_id") protected Long workflowId; @Column(name = "campaign") private String campaign; @Tolerate public Sales() { } }
Editor is loading...