testassets

type Comment struct {
	CommentID   int64       `db:"CommentID" json:"CommentID"`
	DateCreated int64       `db:"DateCreated" json:"DateCreated"`
	IsDeleted   int         `db:"IsDeleted" json:"IsDeleted"`
	Content     null.String `db:"Content" json:"Content"`
	ObjectType  int64       `db:"ObjectType" json:"ObjectType"`
	ObjectID    int64       `db:"ObjectID" json:"ObjectID"`
}

type Job struct {
	JobID                  int64       `db:"JobID" json:"JobID"`
	DateCreated            int64       `db:"DateCreated" json:"DateCreated"`
	LastUpdated            int64       `db:"LastUpdated" json:"LastUpdated"`
	IsDeleted              int         `db:"IsDeleted" json:"IsDeleted"`
	QuoteNumberID          int64       `db:"QuoteNumberID" json:"QuoteNumberID"`
	CustomerID             int64       `db:"CustomerID" json:"CustomerID"`
	AwardDate              int64       `db:"AwardDate" json:"AwardDate"`
	AwardDateString        string      `db:"AwardDateString" json:"AwardDateString"`
	QuoteID                int64       `db:"QuoteID" json:"QuoteID"`
	Description            string      `db:"Description" json:"Description"`
	CustomerContactID      int64       `db:"CustomerContactID" json:"CustomerContactID"`
	Notes                  null.String `db:"Notes" json:"Notes"`
	CustomerPO2SentTo      int64       `db:"CustomerPO2SentTo" json:"CustomerPO2SentTo"`
	ThirdPartyName         string      `db:"ThirdPartyName" json:"ThirdPartyName"`
	CustomerPO2Number      string      `db:"CustomerPO2Number" json:"CustomerPO2Number"`
	BillingAddressZip      string      `db:"BillingAddressZip" json:"BillingAddressZip"`
	BillingAddress         string      `db:"BillingAddress" json:"BillingAddress"`
	BillingAddressState    string      `db:"BillingAddressState" json:"BillingAddressState"`
	CustomerPO1SentTo      int64       `db:"CustomerPO1SentTo" json:"CustomerPO1SentTo"`
	ProjectCost            float64     `db:"ProjectCost" json:"ProjectCost"`
	CustomerPO1Number      string      `db:"CustomerPO1Number" json:"CustomerPO1Number"`
	ThirdPartySplitPercent float64     `db:"ThirdPartySplitPercent" json:"ThirdPartySplitPercent"`
	CommissionTypeID       int64       `db:"CommissionTypeID" json:"CommissionTypeID"`
	GrossMarginPercent     float64     `db:"GrossMarginPercent" json:"GrossMarginPercent"`
	TotalPrice             float64     `db:"TotalPrice" json:"TotalPrice"`
	IsThirdPartySplit      int         `db:"IsThirdPartySplit" json:"IsThirdPartySplit"`
	GrossProfit            float64     `db:"GrossProfit" json:"GrossProfit"`
	BillingAddressCity     string      `db:"BillingAddressCity" json:"BillingAddressCity"`
	RemainingGrossProfit   float64     `db:"RemainingGrossProfit" json:"RemainingGrossProfit"`
	IsAddFreight           int         `db:"IsAddFreight" json:"IsAddFreight"`
	JobNumberString        string      `db:"JobNumberString" json:"JobNumberString"`
	ThirdPartyCommission   float64     `db:"ThirdPartyCommission" json:"ThirdPartyCommission"`
	ShippingAddressZip     string      `db:"ShippingAddressZip" json:"ShippingAddressZip"`
	ShippingAddress        string      `db:"ShippingAddress" json:"ShippingAddress"`
	ShippingAddressCity    string      `db:"ShippingAddressCity" json:"ShippingAddressCity"`
	ShippingAddressState   string      `db:"ShippingAddressState" json:"ShippingAddressState"`
	Sales1                 string      `db:"Sales1" json:"Sales1"`
	BidTypeID              int64       `db:"BidTypeID" json:"BidTypeID"`
	Vendor1ID              int64       `db:"Vendor1ID" json:"Vendor1ID"`
	MarketID               int64       `db:"MarketID" json:"MarketID"`
	Vendor2ID              int64       `db:"Vendor2ID" json:"Vendor2ID"`
	Sales2                 string      `db:"Sales2" json:"Sales2"`
	JEFDate                int64       `db:"JEFDate" json:"JEFDate"`
	JEFDateString          string      `db:"JEFDateString" json:"JEFDateString"`
}

type JobSales struct {
	JobSalesID        int64   `db:"JobSalesID" json:"JobSalesID"`
	JobID             int64   `db:"JobID" json:"JobID"`
	UserID            int64   `db:"UserID" json:"UserID"`
	CommissionPercent float64 `db:"CommissionPercent" json:"CommissionPercent"`
	DateCreated       int64   `db:"DateCreated" json:"DateCreated"`
	IsDeleted         int     `db:"IsDeleted" json:"IsDeleted"`
	CommissionDollars float64 `db:"CommissionDollars" json:"CommissionDollars"`
	IsHouse           int     `db:"IsHouse" json:"IsHouse"`
}