package models

import (
	"time"
)

type BotStockMysTrade struct {
	ClosingCost   string    `xorm:"comment('平仓手续费') DECIMAL(36,18)"`
	ClosingPrice  string    `xorm:"comment('平仓价格') DECIMAL(36,18)"`
	ClosingTime   time.Time `xorm:"comment('平仓时间') DATETIME"`
	CreateTime    time.Time `xorm:"not null comment('创建时间') DATETIME"`
	DealPrice     string    `xorm:"comment('成交价') DECIMAL(36,18)"`
	DealType      int       `xorm:"not null default 0 comment('委托方式:1限价,2市价') index(user_id) TINYINT(1)"`
	FaceValue     int       `xorm:"comment('面值') INT"`
	KeepDecimal   int       `xorm:"comment('股票保留小数位') INT"`
	LimitPrice    string    `xorm:"comment('限价') DECIMAL(36,18)"`
	MarketMoney   string    `xorm:"not null comment('市值金额') DECIMAL(36,18)"`
	MarketPrice   string    `xorm:"comment('市价') DECIMAL(36,18)"`
	NumericCode   string    `xorm:"comment('股票数字code') VARCHAR(100)"`
	OpenTime      time.Time `xorm:"comment('成交时间') DATETIME"`
	OrderId       string    `xorm:"not null comment('订单ID') index(order_id) index(user_id) VARCHAR(60)"`
	OrderMoney    string    `xorm:"not null comment('订单总金额') DECIMAL(36,18)"`
	OrderNumber   string    `xorm:"not null comment('委托数量') DECIMAL(36,18)"`
	OvernightCost string    `xorm:"comment('过夜手续费') DECIMAL(36,18)"`
	PryNum        int       `xorm:"comment('杠杆') INT"`
	ServiceCost   string    `xorm:"not null comment('持仓手续费') DECIMAL(36,18)"`
	Status        int       `xorm:"not null default 0 comment('订单状态:0-挂单(委托),1-持仓订单,2-已撤单,3-完成订单') index(order_id) index(u_s_s) index(user_id) TINYINT(1)"`
	StockId       string    `xorm:"not null comment('股票id') index(u_s_s) index(user_id) VARCHAR(100)"`
	StockName     string    `xorm:"comment('股票名称') VARCHAR(255)"`
	StopLossPrice string    `xorm:"comment('止损价') DECIMAL(36,18)"`
	StopType      int       `xorm:"not null comment('止损止盈设置：0无设置，1止损止盈') TINYINT(1)"`
	StopWinPrice  string    `xorm:"comment('止赢价') DECIMAL(36,18)"`
	TradeId       int       `xorm:"not null pk autoincr comment('自增长ID') INT"`
	TradeType     int       `xorm:"not null default 0 comment('交易类型:1买入,2卖出') index(user_id) TINYINT(1)"`
	UpdateTime    time.Time `xorm:"comment('更新时间') DATETIME"`
	UserId        int       `xorm:"not null comment('用户ID') index(u_s_s) index(user_id) INT"`
}