package com.ruoyi.basic.entity; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.ruoyi.common.annotation.Excel; import com.ruoyi.common.core.domain.MyBaseEntity; import lombok.Data; /** * 供应商信息表 实体类 * * @author ruoyi * @date 2025-05-30 */ @Data @TableName("supply") public class Supply extends MyBaseEntity { private static final long serialVersionUID = 1L; /** * 供应商唯一标识,采用BIGSERIAL自增主键,确保数据唯一性 */ @TableId(value = "id", type = IdType.AUTO) private Long id; /** * 供应商全称,业务场景中唯一识别的名称, */ @TableField(value = "supplier_name") @Excel(name = "供应商") private String supplierName; /** * 供应商税务登记唯一标识(如统一社会信用代码),用于财税管理 */ @TableField(value = "taxpayer_id") @Excel(name = "税号") private String taxpayerId; /** * 供应商营业执照注册地址或主要经营场所,默认空字符串 */ @TableField(value = "business_address") @Excel(name = "注册地址") private String businessAddress; /** * 供应商收款银行账户信息,默认空字符串,用于资金往来 */ @TableField(value = "bank_account") @Excel(name = "银行账户") private String bankAccount; /** * 供应商银行账户的开户机构名称,默认空字符串, */ @TableField(value = "bank_name") @Excel(name = "银行账户") private String bankName; /** * 供应商业务对接人姓名 */ @TableField(value = "contact_person") @Excel(name = "联系人") private String contactPerson; /** * 供应商联系人的联系地址 */ @TableField(value = "contact_address") @Excel(name = "联系地址") private String contactAddress; /** * 联系人的电话 */ @TableField(value = "contact_phone") @Excel(name = "联系电话") private String contactPhone; /** * 供应商所在省份的ID(关联地址字典表),默认0 */ @TableField(value = "b_province_id") private Long BProvinceId; /** * 供应商所在城市的ID(关联地址字典表),默认0 */ @TableField(value = "b_city_id") private Long BCityId; /** * 供应商所在区县的ID(关联地址字典表),默认0,用于地址层级划分 */ @TableField(value = "b_district_id") private Long BDistrictId; /** * 联系地址 省份的ID */ @TableField(value = "c_province_id") private Long CProvinceId; /** * 联系地址所在城市的ID(关联地址字典表),默认0 */ @TableField(value = "c_city_id") private Long CCityId; /** * 联系地址所在区县的ID(关联地址字典表),默认0,用于地址层级划分 */ @TableField(value = "c_district_id") private Long CDistrictId; }