hongze_yb/models/tables/company_product/company_product.go

package company_product

import "time"

// CompanyProduct [...]
type CompanyProduct struct {
	CompanyProductID int       `gorm:"primaryKey;column:company_product_id;type:int(11);not null" json:"-"`
	CompanyID        int       `gorm:"uniqueIndex:idx_company_id_product_id;column:company_id;type:int(11);default:0" json:"companyId"` // 客户id
	ProductID        int       `gorm:"uniqueIndex:idx_company_id_product_id;column:product_id;type:int(11);default:0" json:"productId"` // 产品id
	ProductName      string    `gorm:"column:product_name;type:varchar(30);default:''" json:"productName"`
	CompanyName      string    `gorm:"column:company_name;type:varchar(100);default:''" json:"companyName"`                   // 客户名称
	Source           string    `gorm:"column:source;type:varchar(100);default:''" json:"source"`                              // 来源
	Reasons          string    `gorm:"column:reasons;type:varchar(255);default:''" json:"reasons"`                            // 新增理由
	Status           string    `gorm:"column:status;type:enum('试用','永续','冻结','流失','正式','潜在')" json:"status"`                  // 客户状态
	IndustryID       int       `gorm:"column:industry_id;type:int(11)" json:"industryId"`                                     // 行业id
	IndustryName     string    `gorm:"column:industry_name;type:varchar(50);default:''" json:"industryName"`                  // 行业名称
	SellerID         int       `gorm:"column:seller_id;type:int(11);default:0" json:"sellerId"`                               // 所属销售id
	SellerName       string    `gorm:"column:seller_name;type:varchar(50);default:''" json:"sellerName"`                      // 所属销售名称
	GroupID          int       `gorm:"column:group_id;type:int(11);default:0" json:"groupId"`                                 // 所属销售分组id
	DepartmentID     int       `gorm:"column:department_id;type:int(11);default:0" json:"departmentId"`                       // 所属销售部门id
	IsSuspend        int8      `gorm:"primaryKey;column:is_suspend;type:tinyint(4);not null;default:0" json:"-"`              // 1:暂停,0:启用
	SuspendTime      time.Time `gorm:"column:suspend_time;type:datetime" json:"suspendTime"`                                  // 暂停/启用时间
	TryOutTime       time.Time `gorm:"column:try_out_time;type:datetime" json:"tryOutTime"`                                   // 正式转试用时间
	RenewalReason    string    `gorm:"column:renewal_reason;type:varchar(255);default:''" json:"renewalReason"`               // 正式转试用后的续约情况说明
	FreezeTime       time.Time `gorm:"column:freeze_time;type:datetime" json:"freezeTime"`                                    // 冻结时间
	FreezeReason     string    `gorm:"column:freeze_reason;type:varchar(255);default:''" json:"freezeReason"`                 // 冻结理由
	Remark           string    `gorm:"column:remark;type:varchar(255);default:''" json:"remark"`                              // 备注信息
	StartDate        time.Time `gorm:"column:start_date;type:date" json:"startDate"`                                          // 开始日期
	EndDate          time.Time `gorm:"column:end_date;type:date" json:"endDate"`                                              // 结束日期
	ContractEndDate  time.Time `gorm:"index:idx_contract_end_date;column:contract_end_date;type:date" json:"contractEndDate"` // 合同结束日期
	CreateTime       time.Time `gorm:"column:create_time;type:datetime" json:"createTime"`                                    // 创建时间
	ModifyTime       time.Time `gorm:"column:modify_time;type:datetime" json:"modifyTime"`                                    // 修改时间
	LoseReason       string    `gorm:"column:lose_reason;type:varchar(255);default:''" json:"loseReason"`                     // 流失原因
	LossTime         time.Time `gorm:"column:loss_time;type:datetime" json:"lossTime"`                                        // 流失时间
	ApproveStatus    string    `gorm:"column:approve_status;type:enum('待审批','已审批','驳回','已撤回')" json:"approveStatus"`          // 审批状态
	CompanyType      string    `gorm:"column:company_type;type:varchar(20);default:''" json:"companyType"`                    // 客户类型:ficc,权益，合作伙伴
	FreezeStartDate  time.Time `gorm:"column:freeze_start_date;type:date" json:"freezeStartDate"`                             // 冻结开始日期
	FreezeEndDate    time.Time `gorm:"column:freeze_end_date;type:date" json:"freezeEndDate"`                                 // 冻结结束日期
	CustomType       int8      `gorm:"column:custom_type;type:tinyint(4);default:0" json:"customType"`                        // 1:合作伙伴，2：公募，3：私募
	FormalTime       time.Time `gorm:"column:formal_time;type:datetime" json:"formalTime"`                                    // 转正时间
	OpenCode         string    `gorm:"column:open_code;type:varchar(64);default:''" json:"openCode"`                          // 开放给第三方的编码，不让第三方定位我们的客户信息
}

// TableName get sql table name.获取数据库表名
func (m *CompanyProduct) TableName() string {
	return "company_product"
}

// CompanyProductColumns get sql column name.获取数据库列名
var CompanyProductColumns = struct {
	CompanyProductID string
	CompanyID        string
	ProductID        string
	ProductName      string
	CompanyName      string
	Source           string
	Reasons          string
	Status           string
	IndustryID       string
	IndustryName     string
	SellerID         string
	SellerName       string
	GroupID          string
	DepartmentID     string
	IsSuspend        string
	SuspendTime      string
	TryOutTime       string
	RenewalReason    string
	FreezeTime       string
	FreezeReason     string
	Remark           string
	StartDate        string
	EndDate          string
	ContractEndDate  string
	CreateTime       string
	ModifyTime       string
	LoseReason       string
	LossTime         string
	ApproveStatus    string
	CompanyType      string
	FreezeStartDate  string
	FreezeEndDate    string
	CustomType       string
	FormalTime       string
	OpenCode         string
}{
	CompanyProductID: "company_product_id",
	CompanyID:        "company_id",
	ProductID:        "product_id",
	ProductName:      "product_name",
	CompanyName:      "company_name",
	Source:           "source",
	Reasons:          "reasons",
	Status:           "status",
	IndustryID:       "industry_id",
	IndustryName:     "industry_name",
	SellerID:         "seller_id",
	SellerName:       "seller_name",
	GroupID:          "group_id",
	DepartmentID:     "department_id",
	IsSuspend:        "is_suspend",
	SuspendTime:      "suspend_time",
	TryOutTime:       "try_out_time",
	RenewalReason:    "renewal_reason",
	FreezeTime:       "freeze_time",
	FreezeReason:     "freeze_reason",
	Remark:           "remark",
	StartDate:        "start_date",
	EndDate:          "end_date",
	ContractEndDate:  "contract_end_date",
	CreateTime:       "create_time",
	ModifyTime:       "modify_time",
	LoseReason:       "lose_reason",
	LossTime:         "loss_time",
	ApproveStatus:    "approve_status",
	CompanyType:      "company_type",
	FreezeStartDate:  "freeze_start_date",
	FreezeEndDate:    "freeze_end_date",
	CustomType:       "custom_type",
	FormalTime:       "formal_time",
	OpenCode:         "open_code",
}