construction_management/models/cm_tree.go

package models

import (
	"time"
)

type CmTree struct {
	Id                         int       `xorm:"not null pk autoincr comment('自增ID') INT(11)"`
	Name                       string    `xorm:"not null comment('名称') VARCHAR(64)"`
	ProjectId                  int       `xorm:"not null comment('项目ID') INT(11)"`
	Depth                      int       `xorm:"not null comment('深度') TINYINT(4)"`
	Serial                     int       `xorm:"not null comment('序号') TINYINT(4)"`
	Attribution                string    `xorm:"comment('归属') VARCHAR(32)"`
	Sort                       int       `xorm:"not null comment('排序') TINYINT(4)"`
	Isfolder                   int       `xorm:"not null comment('是否文件夹 1文件夹 0其他') TINYINT(1)"`
	BidsectionId               int       `xorm:"comment('标段ID') INT(11)"`
	ParentId                   int       `xorm:"not null comment('父级ID') INT(11)"`
	Accounts                   int       `xorm:"not null comment('账号数') TINYINT(4)"`
	Contracts                  int       `xorm:"not null comment('合同数') TINYINT(4)"`
	ContractsIncome            string    `xorm:"not null comment('合同收入总金额') DECIMAL(12,2)"`
	ContractsReturned          string    `xorm:"not null comment('合同已收总金额') DECIMAL(12,2)"`
	ContractsPay               string    `xorm:"not null comment('合同支付总金额') DECIMAL(12,2)"`
	ContractsPaid              string    `xorm:"not null comment('合同已支付金额') DECIMAL(12,2)"`
	SafeTotal                  int       `xorm:"not null comment('安全巡检总数') TINYINT(4)"`
	SafeApproval               int       `xorm:"not null comment('安全审批中') TINYINT(4)"`
	SafeClose                  int       `xorm:"not null comment('安全已关闭') TINYINT(4)"`
	SafeRectification          int       `xorm:"not null comment('安全巡检整改未') TINYINT(4)"`
	SafeRectificationIn        int       `xorm:"not null comment('安全巡检整改中') TINYINT(4)"`
	SafeRectificationFinish    int       `xorm:"not null comment('安全巡检整改完') TINYINT(4)"`
	QualityTotal               int       `xorm:"not null comment('质量总数') TINYINT(4)"`
	QualityApproval            int       `xorm:"not null comment('质量审批中') TINYINT(4)"`
	QualityClose               int       `xorm:"not null comment('质量已关闭') TINYINT(4)"`
	QualityRectification       int       `xorm:"not null comment('质量未整改') TINYINT(4)"`
	QualityRectificationIn     int       `xorm:"not null comment('质量整改中') TINYINT(4)"`
	QualityRectificationFinish int       `xorm:"not null comment('质量整改完') TINYINT(4)"`
	Isdelete                   int       `xorm:"not null comment('1删除') TINYINT(1)"`
	CreateTime                 time.Time `xorm:"comment('创建时间') DATETIME"`
	UpdateTime                 time.Time `xorm:"not null default 'CURRENT_TIMESTAMP' comment('更新时间') TIMESTAMP"`

	ContractDeductionTotal string `xorm:"not null comment('总扣款金额') DECIMAL(12,2)"`
}